Standard Deviation and Outliers (Statistics)

profileGatornc
Project_2_Spreadsheet1.xls

Sheet1

Data Data
x x
1 0.5 5 0.5
2 0.5 10 0.5
3 0.5 SD 1.58 15 0.5 SD 12.25
4 0.5 Mean 3.00 20 0.5 Mean 22.50
5 0.5 Median 3.00 25 0.5 Median 22.50
0.5 30 0.5
0.5 35 0.5
0.5 40 0.5
1 1
Data
x
2 0.5
2 0.5
2 0.5 SD 1.07
2 0.5 Mean 3.00
4 0.5 Median 3.00
4 0.5
4 0.5
4 0.5
1
As you enter your numbers into one of the data columns, the chart next to it will automatically adjust the x-axis scale to match the values that have been entered.
SD = Standard Deviation

Sheet1

Sheet2

Sheet3