Sample_basic_statistics_data

# Sample_basic_statistics_data - variance = 0.02(square of...

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

Sample length data for basic statistics lecture J. M. Cimbala Column1 1 12.1 -0.18 0.18 0.03 2 12.3 0.02 0.02 0 Mean 12.28 3 12.2 -0.08 0.08 0.01 Standard Error 0.04 4 12.2 -0.08 0.08 0.01 Median 12.25 5 12.4 0.12 0.12 0.01 Mode 12.2 6 12.3 0.02 0.02 0 Standard Deviation 0.12 7 12.2 -0.08 0.08 0.01 Sample Variance 0.02 8 12.4 0.12 0.12 0.01 Kurtosis -0.54 9 12.2 -0.08 0.08 0.01 Skewness 0.47 10 12.5 0.22 0.22 0.05 Range 0.4 Averages: 12.28000 0.00000 0.10000 0.01360 Minimum 12.1 Maximum 12.5 Sum 122.8 Count 10 Manual calculations: 12.28000 m (simple average, use Excel's AVERAGE function) 0.10000 m (average of magnitude of deviations) 0.12 m (calculate by its direct definition) 0.12 m (use Excel's STDEV function)
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: variance = 0.02 (square of the sample standard deviation) mode = 12.2 m (4 out of 10 measurements) median = 12.25 m (get this by arranging the values in order) Statistics : Office 2003 : Use Tools-Data Analysis-Descriptive Statistics . Select Summary Statistics . Office 2007 : Instead of Tools , click on the Data tab , and then in the Analysis area-Data Analysis . measurement number x i (m) d i = x i- x avg (m) δ = | d i | (m) d i 2 (m 2 ) x avg = | d i | avg = S = OR, S = m 2...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online