2. Time series data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table.

Year	Demand for Fertilizer (000s of bags)
1	4
2	6
3	7
4	5
5	10
6	8
7	9.5
8	9
9	12
10	14
11	13

Enter the data carefully into your Excel file

a. Create a scatterplot of the data.

b. Interpret the scatterplot

Run the regression analysis using Excel Data Analysis/Regression function.

Use the Excel output to answer the questions below.

c. What is the value of the correlation coefficient? How would you interpret it?

d. What is the value of the coefficient of determination? How would you interpret it?

e. What are the hypotheses for the test of the slope? (write them out)

f What is the p-value for the test of the slope?

What conclusion do you make based on this p-value?

g. What is the regression formula that expresses the relationship between Year and Demand?

h. Use your regression formula to forecast Demand for Period 12.

i. Use your regression formula to forecast Demand for Period 15.