Excel_Descriptive_Statistics

# Excel_Descriptive_Statistics - Descriptive Statistics with...

This preview shows pages 1–2. Sign up to view the full content.

Descriptive Statistics with Excel Student No. Grade 1 74 Step 0 Enter the data (typically in a single column) in the worksheet 2 89 Step 1 3 56 Step 2 Specify the input range B3:B30. 4 93 Step 3 Specify cell D10 as the upper left hand corner of the output range. 5 92 6 94 Step 4 Click on Summary Statistics 7 78 8 67 Column1 9 45 10 59 Mean 78.61 11 84 Standard Error 2.33 12 74 Median 82 13 83 Mode 74 14 90 Standard Deviation 12.31 15 83 Sample Variance 151.58 16 76 Kurtosis 0.82 17 74 Skewness -0.95 18 62 Range 52 19 85 Minimum 45 20 79 Maximum 97 21 81 Sum 2201 22 97 Count 28 23 88 24 69 25 77 26 84 27 83 28 85 Histogram with Excel Conventional Histogram Student No. Grade Bounds Bounds Frequency 1 74 40 40 0 2 89 45 45 1 3 56 50 50 0 4 93 55 55 0 5 92 60 60 2 6 95 65 65 1 7 78 70 70 2 8 67 75 75 2 9 45 80 80 4 10 59 85

This preview has intentionally blurred sections. Sign up to view the full version.

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

## This note was uploaded on 10/19/2008 for the course CHE 131L taught by Professor Caenepeel during the Spring '06 term at Cal Poly Pomona.

### Page1 / 4

Excel_Descriptive_Statistics - Descriptive Statistics with...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online