Math 1272 – Statistics – Fall2013 – Ganguli

Discussion

You must be logged in to reply to this topic.

  • GoogleDoc spreadsheet – Standard deviation calculation
  • September 21, 2013 at 9:02 pm #13482

    Suman Ganguli
    Participant

    Here is a link to the spreadsheet we set up in class on Wednesday.
    https://docs.google.com/spreadsheet/pub?key=0AivHNDIRxJP1dEw2WHAzYjJUYkJFWmxiQWtsQWxOb0E&output=html

    I think you will need a Google account to sign in and view the spreadsheet.

    You should click thru the cells to understand the spreadsheet formulas and how they are used to calculate the mean, the variations, the variations squared, the sum of variations squared (SS_x), the variance, and finally the standard deviation:

    September 24, 2013 at 3:07 pm #17192

    Suman Ganguli
    Participant

    This link will let you view the formulas in each cell:
    https://docs.google.com/spreadsheet/ccc?key=0AivHNDIRxJP1dEw2WHAzYjJUYkJFWmxiQWtsQWxOb0E#gid=0

    You can’t edit the spreadsheet however. If you want to do that (for example to use it with different data sets), you will need a google account. Sign in and then save a copy to your GoogleDrive (under “File -> Make a Copy…”)

    But a good exercise would be to recreate this spreadsheet yourself, which will help you understand the calculation of standard deviation.

    If you don’t have a Google account, you could recreate this spreadsheet in Excel, which is installed on campus computers.

    If you have a personal computer but don’t have Microsoft Office, a free alternative is Open Office:
    http://www.openoffice.org/

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

You must be logged in to reply to this topic.

All Topics