Temperature_data_ANALYSIS

Temperature_data_ANALYSIS - Sample Data for Class...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

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

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

Unformatted text preview: Sample Data for Class Demonstration of Statistics and Histograms using Excel J. M. Cimbala n 1 31.43 2 32.35 Column1 3 29.10 4 30.03 Mean 31.01 5 29.25 Standard Error 0.05 6 33.04 Median 31.02 7 32.12 Mode 30.27 8 32.77 Standard Deviation 1.49 9 32.42 Sample Variance 2.21 10 31.64 Kurtosis 0.09 11 29.36 Skewness-0.07 12 29.80 Range 9.67 13 31.69 Minimum 26.16 14 29.71 Maximum 35.83 15 30.80 Sum 31009.32 16 29.51 Count 1000 17 30.98 18 32.98 19 30.47 20 31.42 21 30.94 22 29.17 Bin Frequency 23 31.82 26.16 1 24 30.34 26.47 1 25 29.43 26.78 5 26 30.46 27.1 27 28.99 27.41 4 28 29.78 27.72 4 29 29.74 28.03 9 30 32.87 28.34 10 31 29.69 28.66 18 32 31.00 28.97 30 33 30.77 29.28 43 34 29.03 29.59 47 35 27.69 29.9 52 36 29.95 30.22 78 37 29.54 30.53 76 38 30.54 30.84 75 39 32.52 31.15 94 40 30.81 31.46 69 41 29.47 31.77 66 42 30.66 32.09 75 43 29.94 32.4 65 44 30.33 32.71 56 45 31.82 33.02 41 46 28.61 33.33 22 47 32.19 33.65 23 48 28.83 33.96 16 49 32.47 34.27 6 50 33.75 34.58 5 51 33.53 34.89 5 52 30.93 35.21 2 53 28.96 35.52 1 54 29.93 More 1 55 32.15 56 33.97 57 28.47 58 35.83 59 31.79 Here, we create our own bins, to have more control, and cleaner numbers: 60 30.01 61 28.72 Bin Frequency My bins 62 30.51 26.0 26.0 63 30.27 26.5 3 26.5 64 29.56 27.0 4 27.0 65 29.87 27.5 5 27.5 66 31.79 28.0 10 28.0 67 30.21 28.5 24 28.5 68 27.83 29.0 40 29.0 69 28.96 29.5 70 29.5 70 30.84 30.0 92 30.0 71 30.43 30.5 125 30.5 72 33.00 31.0 125 31.0 73 29.85 31.5 131 31.5 74 31.82 32.0 113 32.0 75 30.49 32.5 102 32.5 76 30.38 33.0 75 33.0 77 29.17 33.5 36 33.5 78 31.37 34.0 28 34.0 79 31.61 34.5 6 34.5 80 31.60 35.0 9 35.0 81 30.61 35.5 1 35.5 82 31.80 36.0 1 36.0 83 31.00 More T ( o C) Statistics : Use Data Analysis-Descriptive Statistics . Select Summary Statistics . Histogram : Use Data Analysis-HIstogram . Select Chart Option . Nice Histogram : Use Data Analysis-HIstogram . Select Chart Option , and enter the Bin Range . 2 6 . 1 6 2 7 . 1 2 8 . 3 2 8 . 9 7 2 9 . 9 3 . 8 4 3 1 . 7 7 3 2 . 7 1 3 3 . 6 5 3 4 . 5 8 3 5 . 5 2 10 20 30 40 50 60 70 80 90 100 Bin Frequency 26.0 26.5 27.0 27.5 28.0 28.5 29.0 29.5 30.0 30.5 31.0 31.5 32.0 32.5 33.0 33.5 34.0 34.5 35.0 35.5 36.0 More 20 40 60 80 100 120 140 Bin Frequency 84 31.10 85 28.39 86 31.72 87 32.16 88 29.42 89 30.62 90 29.52 91 28.25 92 29.95 Bin Frequency Mid value Probability 93 32.23 26.0 94 29.65 26.5 3 26.25 0.01 95 31.54 27.0 4 26.75 0.01 96 31.42 27.5 5 27.25 0.01 0.01 97 31.12 28.0 10 27.75 0.01 0.02 98 29.83 28.5 24 28.25 0.02 0.05 99 30.89 29.0 40 28.75 0.04 0.08 100 30.20 29.5 70 29.25 0.07 0.14 101 34.79 30.0 92 29.75 0.09 0.18 102 28.81 30.5 125 30.25 0.13 0.25 103 32.09 31.0 125 30.75 0.13 0.25 104 29.07 31.5 131 31.25 0.13 0.26 105 32.02 32.0 113 31.75 0.11 0.23 106 31.54 32.5 102 32.25 0.1 0.2 107 31.05 33.0 75 32.75 0.08 0.15 108 31.13 33.5 36 33.25 0.04 0.07 109 30.15 34.0 28 33.75 0.03 0.06 110 32.80 34.5 6 34.25 0.01 0.01 111 29.33 35.0 9 34.75 0.01 0.02 112 33.34 35.5 1 35.25 113 30.27 36.0 1 35.75 114...
View Full Document

Page1 / 12

Temperature_data_ANALYSIS - Sample Data for Class...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online