Data Analysis with Microsoft Excel: Updated for Office 2007

428 Statistical Methods g. Save your changes to the workbook and write a report summarizing your results. The Honda12 workbook ...

Chapter 10 Analysis of Variance 429 c. Examine the ANOVA table. What factors are signifi cant in the analysis of variance? What ...

430 Statistical Methods of the Octel fi lter were at least equal to those of standard silencers. a. Open the Noise workbook from ...

431 Chapter 11 TIME SERIES Objectives In this chapter you will learn to: Plot a time series Compare a time series to lagged valu ...

Time Series Concepts A time series is a sequence of observations taken at evenly spaced time in- tervals. The sequence could be ...

Chapter 11 Times Series 433 To open the Global Temperature workbook: 1 Open the Global Temperature workbook from the Chapter11 d ...

5 Remove the legend and gridlines from the chart. 6 Change the chart title to Average Global Temperature. Change the x axis titl ...

Chapter 11 Times Series 435 5 Click the General tab and click the Columns option button to dis- play the statistics by columns r ...

436 Statistical Methods 4 Remove the legend from the chart. 5 Add the chart title Average Global Temperature. Set the x axis tit ...

Chapter 11 Times Series 437 3 Select the range E3:E129 (not E2:E129). 4 Type =D3-D2 in cell E3; then press Enter. 5 Press the Fi ...

438 Statistical Methods There does not appear to be any trend in the change in mean annual temperature over the 128 years repres ...

Chapter 11 Times Series 439 To create a scatterplot of temperature versus one-year lagged temperatures: 1 Select the range D1:E1 ...

440 Statistical Methods three, or more years earlier. To discover the relationship between a time series and other lagged values ...

Chapter 11 Times Series 441 The average of the values is 5, y 1 is 6, y 2 is 4, y 3 is 8, and so forth, through yn, which is equ ...

442 Statistical Methods 5 Click the Output button, and send the output to a new sheet named Temperature ACF. Click OK twice to c ...

Chapter 11 Times Series 443 surprising that high temperatures are correlated with the high temperatures of the previous year. In ...

444 Statistical Methods temperature). The length of the cycle in this example is 12, indicated in the ACF by the large positive ...

Chapter 11 Times Series 445 Figure 11-9 ACF for the change in the annual temperature 5 Enter 20 in the Calculate ACF up through ...

446 Statistical Methods For example, if you calculate the average change for each of the last fi ve years and you do this every ...

Chapter 11 Times Series 447 Figure 11-10 The Format Trendline dialog box 5 Click the Close button and then click outside the cha ...