Sample_Excel_histograms

Sample_Excel_histograms - Sample data - how to create...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sample data - how to create histograms in Excel: Direct calculation of statistics: J. M. Cimbala mean = 1.03 or use STDEV function: st. dev = 0.07 or st. dev = 0.07 number x deviation dev squared 1 1.1 0.08 0.01 2 1.2 0.18 0.03 3 0.95-0.07 0.01 4 1.04 0.02 5 1.06 0.04 Column1 6 0.95-0.07 0.01 7 0.97-0.05 Mean 1.03 8 1.03 0.01 Standard Error 0.02 If first time using the Analysis ToolPak, do this: 9 1.01-0.01 Median 1.02 10 0.94-0.08 0.01 Mode 0.95 11 0.99-0.03 Standard Deviation 0.07 12 1.02 Sample Variance 13 1.03 0.01 Kurtosis 1.36 14 0.97-0.05 Skewness 1.06 15 1.08 0.06 Range 0.26 16 1.11 0.09 0.01 Minimum 0.94 17 1.01-0.01 Maximum 1.2 18 0.99-0.03 Sum 18.45 Count 18 Bin Frequency 0.94 1 1.01 6 1.07 7 1.14 3 More 1 Modifications to the chart to make it more "engineering-like": First, copy and paste to the right Make it bigger (drag corner with mouse) If gray background, double click on it & select white In same options box, change x axis title to "x" Make the histogram areas filled in completely without gaps -...
View Full Document

Ask a homework question - tutors are online