Thread: Plot a standard deviation chart

1. 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.

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.

2. 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.