Saturday, February 16, 2013

yogi_Count Reading Comprehension By Band And Chart the Results


                                          Google Spreadsheet   Post  #1030
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 16, 2013
user freyj said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/UoGqc0N-J5U)
Chart a series of text or numeric scores
I am trying to find the p
ercentage of each unique text value (and sometimes a range of text values) and then graph the results. For example, how many students have a reading level of "G" in column F, how many students have a reading level of "H-J". Then, have a pie chart that graphs each scoring band (G, H-J, K-L, M-Q, etc.) by percentage. Here's a shortcut to my open doc: http://goo.gl/G8FiZ

-----------------------------------------------------------------------------------------------
following is a solution to the problem

3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. That's almost it! How would you graph the bands containing a range of letters (one bar for the total number that scored a D, E, or F?

    ReplyDelete
  3. Hi Joel:

    I have added Sheet2 where I have combined counts for Bands D,E, and F, and then charted for bands DEF,G,H,I,J, and K.

    Please check it out how it works for you.

    Make It A Great One.
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete