MAT1372 – Statistics – Spring 2016

Discussion

You must be logged in to reply to this topic.

  • Google spreadsheet - blood cholesterol example
  • February 9, 2016 at 1:14 pm #35005

    Suman Ganguli
    Participant

    Here is the spreadsheet we created yesterday in class (using the data from Example on pp32-34 of the textbook):
    https://docs.google.com/spreadsheets/d/1emGb8TpOHpCC71CzGfjuZy6-dyqL_-jLSOw2Zsryd5g/edit?usp=sharing

    February 9, 2016 at 8:07 pm #35013

    A. Uddin
    Participant

    I have a question regarding the x-axis of the Histogram, I am not too sure as to how to set the bin to be that on google docs. Would you be able to show that in class/explain in a post or give a link explaining it?

    February 9, 2016 at 9:18 pm #35017

    Suman Ganguli
    Participant

    I think you are asking how to label the x-axis of a histogram with the class intervals, as I did in the blood cholesterol spreadsheet. I figured out how to do that today, and I will show how to do that in class tomorrow, but here is the trick:

    Select both the columns containing the class intervals and the corresponding frequencies (in my blood cholesterol spreadsheet, this is F10:G15). Then click on the “Insert chart..” button to bring up dialog box, make sure bar graph is selected, but then go to the “Chart Types” tab”–there is a option there for “Use column F as labels”–this will use the that column’s entries as labels on the horizontal axis, which is precisely what we want.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

All Topics