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

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 variables

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!