Question: WOULD you please solve it by Excel and provide detailed Excel's step how to get r ? Thank you. Lovely Lawns, Inc., intends to use

WOULD you please solve it by Excel and provide detailed Excel's step how to get r ? Thank you.
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: Fertilizer Sales Period (tons) 1 1.6 2 1.3 3 1.8 4 2.0 5 2.2 6 1.6 7 1.5 Number of Fertilizer Mowers Sold Sales (six-week lag) Period (tons) 10 8 1.3 8 9 1.7 11 10 1.2 12 11 1.9 12 12 1.4 9 13 1.7 8 14 1.6 Number of Mowers Sold (six-week lag) 7 10 6 11 8 10 9 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) r= 0.959 it appears that a positive relationship exists between these variablesStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
