1. PF Contest - Win "Conquering the Physics GRE" book! Click Here to Enter
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Standard deviation calculators on the Internet are not for grouped data

  1. Nov 11, 2012 #1


    User Avatar
    Gold Member

    1. The problem statement, all variables and given/known data

    I teach a class of statistics with students who often do not have the types of calculators that can calculate standard deviation and who do not know how to program Excel, but do have access to the Internet. Googling "standard deviation calculator" on the Internet gives me calculators which are not for grouped data, so cannot be used to calculate if the data is in a frequency table with a large amount of data points in each category. Any alternatives?, short of programming it myself? (once in Windows Excel, once in Mac Excel)?

    2. Relevant equations

    For example,

    3. The attempt at a solution
    I have tried to find ways to "tweak" the input, but e.g. multiplying all the data by something gives me a sort of "uncertainty principle": I could get the mean right, but that would throw off the s.d.
  2. jcsd
  3. Nov 11, 2012 #2


    User Avatar
    Homework Helper
    Gold Member

  4. Nov 11, 2012 #3


    User Avatar
    Gold Member

    Looks great, thanks. This is for a sample standard deviation. Anything similar for a population standard deviation?
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Standard deviation calculators Date
Statistics, standard deviation help! Jul 17, 2011
Need help with standard deviation C++ program Jul 6, 2011
Standard Deviation Question Apr 22, 2010
Standard Deviation (bell graph) in excel Feb 19, 2010
Standard Deviation C++ Program Mar 31, 2007