20 likes | 165 Vues
Brief presentation on data spread using sugar cube data. Also a demo of using Excel for data exploration. sug-cub-data.xls has data Show summary stats Create scatter plot, manipulate plot Draw red line for mean, dotted line for +/- 1 std dev. wikipedia.org. For normally distributed data:
E N D
Brief presentation on data spread using sugar cube data. Also a demo of using Excel for data exploration. sug-cub-data.xls has data Show summary stats Create scatter plot, manipulate plot Draw red line for mean, dotted line for +/- 1 std dev
wikipedia.org For normally distributed data: 68% of the values are within 1 standard deviation of the mean95% of the values are within two standard deviations99.7% of the values are within 3 standard deviations.