High School

Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six-week lag between fertilizer sales and mower sales. The pertinent data are as follows:

| Period | Fertilizer Sales (tons) | Mowers Sold (six-week lag) | Period | Fertilizer Sales (tons) | Mowers Sold (six-week lag) |
|--------|-------------------------|----------------------------|--------|-------------------------|----------------------------|
| 1 | 1.6 | 10 | 8 | 1.3 | 7 |
| 2 | 1.3 | 8 | 9 | 1.7 | 10 |
| 3 | 1.8 | 11 | 10 | 1.2 | 6 |
| 4 | 2.0 | 12 | 11 | 1.9 | 11 |
| 5 | 2.2 | 12 | 12 | 1.4 | 8 |
| 6 | 1.6 | 9 | 13 | 1.7 | 10 |
| 7 | 1.5 | 8 | 14 | 1.6 | 9 |

a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables that will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.)

\[ r = \] ___, it appears that a (select one) negative/positive relationship exists between these variables.

b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.)

\[ Y = \] ___ + ___ \( X_i \)

c. Predict the expected lawn mower sales for the first week in August, given fertilizer sales six weeks earlier of 2 tons. (Round your answer to the nearest whole number.)

Expect ___ mowers to be sold in the first week of August.

Answer :

Regression analysis is a statistical method for connecting a dependent variable to one or more independent (explanatory) variables.

How to calculate the regression equation?

a. Track down the graph attachment.

b.

Mowers for Fertilizer

x y

1.4 9 1.96 81 12.6

1 7 1 49 7

1.5 10 2.25 100 15

1.8 12 3.24 144 21.6

2.1 13 4.4 116 27.3

1.5 7 2.25 49 10.5

1.35 5 1.69 25 6.5

1.2 5 1.44 25 6

1.6 8 2.56 64 12.8

1.3 7 1.69 49 9.1

1.6 11 2.56 121 17.6

1.3 9 1.69 81 11.7

1.4 10 1.96 100 14

1.8 12 3.24 144 21.6

Σ =20.8 125 31.94 1201 193.3

x = 1.486

y = 8.929

193.3 EXY-nXY (149.486 -1.486)

7.31405 is the result of using the formula b = 9 = 31.94 - (14 * 1. 486 * 1 A86)

X2 - 7.31405

Excel was used to calculate the result: a =Y - bX = 8.929 - 7.31405 *1.486 = -1.938017

Y = a + bx = -1.93802 + 7.31405x

Utilizing the formula, c

Y = a + bx = -1.58678 + 7.033058x

= 14.8843

Forecasting in Excel

14.58926 was predicted.

To learn more about regression refer to:

https://brainly.com/question/28178214

#SPJ4