Data Analysis with Microsoft Excel: Updated for Office 2007

468 Statistical Methods 5 Click the Categories button and select Month from the list of range names. Click OK. 6 Click the Outpu ...

Chapter 11 Times Series 469 To create a line plot of liquor sales: 1 Return to the Liquor Sales worksheet. 2 Click Manipulate Co ...

470 Statistical Methods The line plot in Figure 11-26 demonstrates the seasonal nature of the data and also allows you to observ ...

Chapter 11 Times Series 471 The autocorrelation holds between adjacent months but the highest autocorrelation exists for sales t ...

472 Statistical Methods 5 Click OK. Excel generates the adjusted sales values shown in Figure 11-29. Figure 11-29 Liquor sales a ...

Chapter 11 Times Series 473 is provided and shows a profi le very similar to the one you saw earlier with the boxplot. A chart i ...

474 Statistical Methods index values of the previous period. The recursive equation for Tn is identi- cal to the recursive equat ...

Chapter 11 Times Series 475 7 Click the Forecast checkbox and enter 12 in the Units ahead box. This will forecast the next year ...

476 Statistical Methods The output does not give the month for each forecast, but you can easily confi rm that observation 145 i ...

Chapter 11 Times Series 477 The standard error of the forecast is 72.60194, indicating that the typical forecasting error in the ...

478 Statistical Methods From the rescaled plot, you would conclude that exponential smoothing has done a good job of modeling th ...

Chapter 11 Times Series 479 Optimizing the Exponential Smoothing Constant (optional) As you’ve seen in this chapter, the choice ...

480 Statistical Methods You now have everything you need to use Solver. To open Solver: 1 Click the Offi ce button and then clic ...

Chapter 11 Times Series 481 4 Type F1 in the By Changing Cells text box to indicate that you want to change the value of F1, the ...

482 Statistical Methods It’s possible to set up similar spreadsheets for two-parameter and three- parameter exponential smoothin ...

Chapter 11 Times Series 483 c. Insert a trend line smoothing the batting average using a ten-year moving average. d. Calculate t ...

484 Statistical Methods c. Create two line plots, one showing the visitation at Exit Glacier plotted against year with different ...

Chapter 11 Times Series 485 g. Save your changes to the workbook and write a report summarizing your conclusions. The NFP workb ...

486 Statistical Methods a. Open the Oil workbook from the Chapter11 folder and save it as Oil Forecasts. b. Restructure the data ...

487 Chapter 12 QUALITY CONTROL Objectives In this chapter you will learn to: Distinguish between controlled and uncontrolled var ...