Data Analysis with Microsoft Excel: Updated for Office 2007

388 Statistical Methods d. Create a normal plot of the residu- als. Does your plot support a conclu- sion that the residuals are ...

Chapter 9 Multiple Regression 389 because it gives a direct measure of the energy consumption. Redo your regression model with t ...

390 Statistical Methods a. Open the Temperatures workbook from the Chapter09 folder and save it as Temperatures Regression. b. C ...

Chapter 9 Multiple Regression 391 e. Compare the parameter value for FRB_Index in the fi rst equation with that in the second. H ...

392 Chapter 10 ANALYSIS OF VARIANCE Objectives In this chapter you will learn to: Compare several groups graphically Compare the ...

Chapter 10 Analysis of Variance 393 One-Way Analysis of Variance Earlier we used the t test to compare two treatment groups, suc ...

394 Statistical Methods To answer this question, let’s look at hotel prices in four major cities: New York City, Chicago, Denver ...

Chapter 10 Analysis of Variance 395 We have to decide between two hypotheses. H 0 : The mean hotel population price is the same ...

396 Statistical Methods 7 Click OK. StatPlus generates the histograms shown in Figure 10-3. Figure 10-3 Multiple histograms of p ...

Chapter 10 Analysis of Variance 397 would cause trouble. In any case, eight observations in each group may be too few to determi ...

398 Statistical Methods The unstacked data are shown in Figure 10-5. Figure 10-5 The unstacked data STATPLUS TIPS You can use th ...

Chapter 10 Analysis of Variance 399 Figure 10-6 The Anova: Single Factor dialog box 5 Click OK. Figure 10-7 shows the resulting ...

400 Statistical Methods squares (the sum of squared deviations from the mean) into two parts: a part attributed to differences b ...

Chapter 10 Analysis of Variance 401 Note that we take each squared difference and multiply it by the number of observations in t ...

402 Statistical Methods Comparing Means The ANOVA table has led you to reject the hypothesis that the mean single- room price is ...

Chapter 10 Analysis of Variance 403 6 Click OK. Excel generates the output shown in Figure 10-9. Figure 10-9 Pairwise mean diffe ...

404 Statistical Methods are the same. Other methods are available to help you adjust the p value for multiple comparisons, inclu ...

Chapter 10 Analysis of Variance 405 Comparing Means with a Boxplot Earlier you used multiple histograms to compare the distribut ...

406 Statistical Methods the mean price in Chicago is $27.25 above the mean in San Francisco. The reason for the difference is an ...

Chapter 10 Analysis of Variance 407 variable value is 1 if the observation comes from a hotel in San Francisco or 0 if the obser ...