Results 1 to 2 of 2

Math Help - Plot a standard deviation chart

  1. #1
    Newbie
    Joined
    Oct 2010
    Posts
    4

    Plot a standard deviation chart

    my first post so hi all.

    I have been tasked with finding the standard deviation of a set of data. I am no mathematician and could use some help.

    The task....
    We are changing the way the business charges for delivery.
    I have created a report of the year-to-date orders (140k lines in excel).
    I have applied the old charging and new charging to each line and then calculated the difference.
    I have the average difference (-1.03) and the standard deviation (40.25).
    I want to show (I think) how many orders (as a percentage??) fall within 1 stdDev of the mean, how many fall with in 2 stdDevs and so on.

    Can anyone please point me in the right direction.

    Thanks,
    Spin.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Oct 2010
    Posts
    4
    Not sure if my question was unclear or whether it's not possible to do what I'm attempting.

    Can I plot a chart based on the data below??

    -1.03
    s 40.25
    Max 136.95
    Min -3,495.40

    Total Lines (n) 84575 100.00%
    Between -1s and 1s 80078 94.68%
    Between -2s and 2s 83308 98.50%
    Between -3s and 3s 84573 100.00%

    Thanks,
    spin.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: January 22nd 2011, 01:07 AM
  2. How to draw standard deviation in a plot.
    Posted in the Advanced Statistics Forum
    Replies: 5
    Last Post: June 10th 2010, 07:17 AM
  3. Replies: 5
    Last Post: May 18th 2009, 05:14 AM
  4. standard deviation
    Posted in the Advanced Statistics Forum
    Replies: 3
    Last Post: May 21st 2008, 10:00 PM
  5. standard deviation and mean deviation
    Posted in the Statistics Forum
    Replies: 1
    Last Post: March 16th 2008, 06:09 AM

Search Tags


/mathhelpforum @mathhelpforum