HistogramWithNormalCurve

# HistogramWithNormalCurve - Normal 1 2 3 4 5 6 7 8 9 10 11...

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

Normal Page 1 MPG Bins Bins Frequency 27 5 5 0 29 10 10 1 33 15 15 2 21 20 20 4 21 25 25 4 12 30 30 2 16 35 35 2 25 40 40 1 8 45 45 1 17 More 0 24 34 38 15 19 19 41 Mean 23.47 The histogram was created using the Better Histogram a StDev 9.21 is a combination Column chart type for the vertical bars a Scatter chart type for the horizontal axis. The XY Scatter From Mean - 3*StDev originally uses two hidden data points. To show the norm to Mean + 3*StDev x and d*n*step data values replace the original two hidde in steps of StDev/100 points. The secondary Y-axis remains hidden. x density d*n*step To align the normal curve with the histogram data, I chos -4.17 0 0.04 identical Y-axis scales. (In the example, each Y-axis goe -4.08 0 0.04 5.) -3.99 0 0.04 -3.89 0 0.04 The total area of the histogram is n*step, where n = num -3.8 0 0.05 values and step = width of each vertical bar. (In the exam -3.71 0 0.05 and step = 5, so n*step = 85.) The total area of the origin -3.62 0 0.05 density is 1, so it is multiplied by n*step so that the chart -3.53 0 0.05 density function has the same total area as the histogram -3.43 0 0.05 -3.34 0 0.05 -3.25 0 0.05 -3.16 0 0.06 -3.06 0 0.06 -2.97 0 0.06 -2.88 0 0.06 -2.79 0 0.06 -2.7 0 0.07 -2.6 0 0.07 -2.51 0 0.07 -2.42 0 0.07 -2.33 0 0.07 -2.24 0 0.08 -2.14 0 0.08 -2.05 0 0.08 -1.96 0 0.08 0 5 10 0 1 2 3 4 5 Frequency A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52

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

View Full Document
Normal Page 2 -1.87 0 0.08 -1.77 0 0.09 -1.68 0 0.09 -1.59 0 0.09 -1.5 0 0.09 -1.41 0 0.1 -1.31 0 0.1 -1.22 0 0.1 -1.13 0 0.1 -1.04 0 0.11 -0.95 0 0.11 -0.85 0 0.11 -0.76 0 0.12 -0.67 0 0.12 -0.58 0 0.12 -0.48 0 0.13 -0.39 0 0.13 -0.3 0 0.13 -0.21 0 0.14 -0.12 0 0.14 -0.02 0 0.14 0.07 0 0.15 0.16 0 0.15 0.25 0 0.15 0.34 0 0.16 0.44 0 0.16 0.53 0 0.17 0.62 0 0.17 0.71 0 0.17 0.81 0 0.18 0.9 0 0.18 0.99 0 0.19 1.08 0 0.19 1.17 0 0.2 1.27 0 0.2 1.36 0 0.21 1.45 0 0.21 1.54 0 0.22 1.63 0 0.22 1.73 0 0.23 1.82 0 0.23 1.91 0 0.24 2 0 0.24 2.1 0 0.25 2.19 0 0.26 2.28 0 0.26 2.37 0 0.27 2.46 0 0.27 2.56 0 0.28 2.65 0 0.29 2.74 0 0.29 2.83 0 0.3 A B C D E F G H I 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
Page 3 2.92 0 0.31 3.02 0 0.31 3.11 0 0.32 3.2 0 0.33 3.29 0 0.33 3.39 0 0.34 3.48 0 0.35 3.57 0 0.36 3.66 0 0.36 3.75 0 0.37 3.85 0 0.38 3.94 0 0.39 4.03 0 0.4 4.12 0 0.41 4.21 0 0.41 4.31 0 0.42 4.4 0.01 0.43 4.49 0.01 0.44 4.58 0.01 0.45 4.67 0.01 0.46 4.77 0.01 0.47 4.86 0.01 0.48 4.95 0.01 0.49 5.04 0.01 0.5 5.14 0.01 0.51 5.23 0.01 0.52 5.32 0.01 0.53 5.41 0.01 0.54 5.5 0.01 0.55 5.6 0.01 0.56 5.69 0.01 0.57 5.78 0.01 0.58 5.87 0.01 0.59 5.96 0.01 0.61 6.06 0.01 0.62 6.15 0.01 0.63 6.24 0.01 0.64 6.33 0.01 0.65 6.43 0.01 0.66 6.52 0.01 0.68 6.61 0.01 0.69 6.7 0.01 0.7 6.79 0.01 0.72 6.89 0.01 0.73 6.98 0.01 0.74 7.07 0.01 0.75 7.16 0.01 0.77 7.25 0.01 0.78 7.35 0.01 0.8 7.44 0.01 0.81 7.53 0.01 0.82 7.62 0.01 0.84 A B C D E F G H I 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137

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 12/18/2010 for the course INDUSTRIAL IE221 taught by Professor Abdullaabdulla during the Spring '10 term at German University in Cairo.

### Page1 / 26

HistogramWithNormalCurve - Normal 1 2 3 4 5 6 7 8 9 10 11...

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

View Full Document
Ask a homework question - tutors are online