Chapter

$8$

$-$

$$Activity

$2$

: PLEASE NOTE I Dont have access to excel so please do not send answers for me to reference excel I need straighforward answers. A few I have already answered but stuck on part B

$.$

$$Many thanks!!!

Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy they have been able to increase their annual revenue by approximately $

$1$

$0$

$$million over the past

$1$

$0$

$$years$.$ But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous

$1$

$0$

$$years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add

$-$

in manually from the home ribbon. Screenshot of ToolPak

Open spreadsheet

Choose the correct time series plot for the data.

A

$.$

$$

B

$.$

$$

C

$.$

$$

D

$.$

$$

The correct time series plot is

plot B

Comment on the appropriateness of a linear trend.

A linear trend is not appropriate

Develop a quadratic trend equation that can be used to forecast revenue

$($

to

$4$

$$decimals

$)$

$.$

Using the trend equation developed in part

$($

b

$)$

$,$

$$forecast revenue in year

$1$

$1$

$($

to

$2$

$$decimals

$)$

$.$

$1$

$7$

$.$

$5$

$6$

$6$

$5$

Excel Chart:

Year Year

$2$

$$Revenue

$($

$ millions

$)$

$$

$1$

$8$

$.$

$4$

$6$

$$

$2$

$1$

$0$

$.$

$8$

$0$

$$

$3$

$1$

$2$

$.$

$5$

$1$

$$

$4$

$1$

$4$

$.$

$5$

$9$

$$

$5$

$1$

$6$

$.$

$0$

$1$

$$

$6$

$1$

$7$

$.$

$0$

$7$

$$

$7$

$1$

$7$

$.$

$9$

$8$

$$

$8$

$1$

$8$

$.$

$0$

$5$

$$

$9$

$1$

$8$

$.$

$6$

$2$

$$

$1$

$0$

The correct time series plot is plot B

Comment on the appropriateness of a linear trend.

A linear trend is not appropriate

b$.$ Develop a quadratic trend equation that can be used to forecast revenue $($to $4$ decimals$).$

$T_t=b_0+b_{1}t+b_2{t}^2$

$b_0$:

$b_1$:$,$

$b_2$:$,$

c$.$ Using the trend equation developed in part $($b$),$ forecast revenue in year $11($to $2$ decimals$).$

$1$

$7$

$.$

$9$

$3$After reading these instructions delete all text in this shaded area.

Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis.

After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area $($H$19).$