# Question: Consider Intel s Revenues in Table 14 4 2 a Construct a time series plot

Consider Intel’s Revenues in Table 14.4.2.

a. Construct a time-series plot for this data set. Describe the seasonal and cyclic behavior that you see, as well as any evidence of irregular behavior.

b. Which quarter (1, 2, 3, or 4) appears to be Intel’s best in terms of sales level, based on your plot in part a?

c. Is the seasonal pattern (in your graph for part a) consistent across the entire time period?

d. Calculate the moving average (using one year of data at a time) for this time series. Construct a time-series plot with both the data and the moving average.

e. Describe the cyclic behavior revealed by the moving average.

f. Find the seasonal index for each quarter. Do these values appear reasonable compared to the time-series plot of the data?

g. Find the seasonally adjusted sales corresponding to each of the original sales values. Construct a times-eries plot of this seasonally adjusted series.

h. Do you see an overall linear long-term trend up or down in these sales data? Would it be appropriate to use a regression line for forecasting this series?

i. Intel’s revenue fell from 8.852 to 8.680 from the first to the second quarter of 2007. What happened to revenue on a seasonally adjusted basis?

a. Construct a time-series plot for this data set. Describe the seasonal and cyclic behavior that you see, as well as any evidence of irregular behavior.

b. Which quarter (1, 2, 3, or 4) appears to be Intel’s best in terms of sales level, based on your plot in part a?

c. Is the seasonal pattern (in your graph for part a) consistent across the entire time period?

d. Calculate the moving average (using one year of data at a time) for this time series. Construct a time-series plot with both the data and the moving average.

e. Describe the cyclic behavior revealed by the moving average.

f. Find the seasonal index for each quarter. Do these values appear reasonable compared to the time-series plot of the data?

g. Find the seasonally adjusted sales corresponding to each of the original sales values. Construct a times-eries plot of this seasonally adjusted series.

h. Do you see an overall linear long-term trend up or down in these sales data? Would it be appropriate to use a regression line for forecasting this series?

i. Intel’s revenue fell from 8.852 to 8.680 from the first to the second quarter of 2007. What happened to revenue on a seasonally adjusted basis?

**View Solution:**## Answer to relevant Questions

Table 14.4.3 shows the quarterly net sales of Mattel, a major designer, manufacturer, and marketer of toys. Because of seasonal gift giving, you might expect fourth-quarter sales to be much higher, generally, than those of ...a. State the hypotheses for the one-way analysis of variance. b. Is the research hypothesis very specific about the nature of any differences? Refer to the data for problem 11. Continue using the logarithms of the lengths of calls. a. Find the F statistic and its numbers of degrees of freedom. b. Find the critical value from the F table at the 5% level. c. Report ...Are prices really higher in department stores as compared to off-price stores? Kirby and Dardis examined prices of 20 items (shirts, pants, etc.) for 13 weeks and found that prices are indeed 40% higher in department ...Break down the annual salaries into three groups according to training level (A, B, or C). a.* Draw box plots to compare these three groups. Comment on what you see. b.* Find the average for each training level, and ...Post your question