Data Analysis with Microsoft Excel: Updated for Office 2007

188 Fundamentals of Statistics Notice the two horizontal scroll bars below the chart. You’ll use these to set the range boundari ...

Chapter 5 Probability Distributions 189 Because the area under the curve is equal to 0.6827, the probability of a value falling ...

190 Fundamentals of Statistics and a continuous random variable comes from a continuous probability distribution. Random variabl ...

Chapter 5 Probability Distributions 191 In this worksheet, you can click the Shoot button to generate a ran- dom sample of shots ...

192 Fundamentals of Statistics The xy coordinate system on the target shows the bull’s eye, located at the origin (0, 0). The di ...

Chapter 5 Probability Distributions 193 Figure 5-8 compares the distribution of the random sample after 50 shots and after 500 s ...

194 Fundamentals of Statistics CONCEPT TUTORIALS The Normal Distribution To explore the normal distribution: 1 Open the fi le Di ...

Chapter 5 Probability Distributions 195 2 Click the down spin button next to the mu box to change the value of m back to 0. 3 Cl ...

196 Fundamentals of Statistics Because normally distributed data appear so often in statistical studies, these benchmarks are an ...

Chapter 5 Probability Distributions 197 NORMSDIST(y) Returns the probability of Y # y for the standard normal distribution. NORM ...

198 Fundamentals of Statistics 2 Click Create Data from the StatPlus menu and then click Random Numbers. The Random Numbers comm ...

Chapter 5 Probability Distributions 199 Because these are randomly generated values, your numbers will look different. EXCEL TIP ...

200 Fundamentals of Statistics To create a histogram of the random sample: 1 Click Single Variable Charts from the StatPlus menu ...

Chapter 5 Probability Distributions 201 The Normal Probability Plot To check for normality, statisticians compute normal scores ...

202 Fundamentals of Statistics The points follow a general straight line trend fairly well, but with some departures at the left ...

Chapter 5 Probability Distributions 203 5 Click the Normal Curve checkbox. 6 Click the Output button and send the histogram to a ...

204 Fundamentals of Statistics 3 Click the Data Values button and select AV G from the list of range names. Click the OK button. ...

Chapter 5 Probability Distributions 205 2.812, this translates into an expected batting average of 2.812 3 0.022529 1 0.275528 5 ...

206 Fundamentals of Statistics size, xand s will estimate the true values of m and s to whatever degree of precision is required ...

Chapter 5 Probability Distributions 207 From those random values, we’ll create a new column of data containing the average of ea ...