# Question: Consider PepsiCo s quarterly net sales as shown in Table 14 4 5 a

Consider PepsiCo’s quarterly net sales as shown in Table 14.4.5.

a. Draw a time-series plot for this data set. Describe any trend and seasonal behavior that you see.

b. Plot the moving average values on the same graph as the original data. Comment on what you see.

c. Find the seasonal index for each quarter. Which is generally the best quarter for PepsiCo? About how much larger are net sales in this quarter, as compared to a typical quarter?

d. Plot the seasonally adjusted series with the original data.

e. Find the regression equation to predict the long-term trend in seasonally adjusted sales for each time period, using 1, 2,…for the X variable.

f. Does PepsiCo show a significant trend (either up or down) over this time period as indicated by the regression analysis in the previous part of this problem?

QUESTION CONTINUE TO NEXT PAGE……

a. Draw a time-series plot for this data set. Describe any trend and seasonal behavior that you see.

b. Plot the moving average values on the same graph as the original data. Comment on what you see.

c. Find the seasonal index for each quarter. Which is generally the best quarter for PepsiCo? About how much larger are net sales in this quarter, as compared to a typical quarter?

d. Plot the seasonally adjusted series with the original data.

e. Find the regression equation to predict the long-term trend in seasonally adjusted sales for each time period, using 1, 2,…for the X variable.

f. Does PepsiCo show a significant trend (either up or down) over this time period as indicated by the regression analysis in the previous part of this problem?

QUESTION CONTINUE TO NEXT PAGE……

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

Based on past data, your firm’s sales show a seasonal pattern. The seasonal index for November is 1.08, for December it is 1.38, and for January it is 0.84. Sales for November were $285,167. a. Would you ordinarily expect ...Table 14.4.7 shows basic computer results from a Box– Jenkins analysis of the daily percentage changes in the Dow Jones Industrial stock market index from July 31 to October 9, 1987, prior to the crash of 1987. a. What ...Consider the Walt Disney Company’s quarterly revenues as shown in Table 14.4.1. a. Draw a time-series plot for this data set. Describe any trend and seasonal behavior that you see. b. Find the moving average values and ...Describe and give a formula for each of the following quantities, which are used in performing a one-way analysis of variance: a. Total sample size, n. b. Grand average, . c. Between-sample variability and its degrees of ...Table 15.5.4 shows the average quality scores for production, averaged according to which supplier (A, B, or C) provided the materials and which shift (day, night, or swing) was active at the time the part was produced; this ...Post your question