Question: Problem 23 Your answer is partially correct. Try again. Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop

Problem 23 Your answer is partially correct. Try
Problem 23 Your answer is partially correct. Try
Problem 23 Your answer is partially correct. Try again. Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past twenty- four months. This is shown. Month Sales Month Sales Month Sales 17 18 19 20 1 2 3 4 5 6 7 8 246 241 257 262 272 273 393 310 9 10 11 12 13 14 15 16 309 327 347 351 362 360 375 353 362 372 359 382 395 401 414 408 21 22 23 24 a. Develop a linear trend line for the data. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) 251.77 7.16 Sales = (month) b. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Correlation coefficient is 0.89 It a strong, postive cates linear relationship. (Use not rounded amounts to answer this question.) 408 353 24 16 8 310 a. Develop a linear trend line for the data. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) 251.77 7.16 (month) Sales = b. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) 0.89 Correlation coefficient is It indicates a strong, postive linear relationship. (Use not rounded amounts to answer this question.) c. Using the linear trend line equation, develop a forecast for the next period, month 25. (Round your answer to 2 decimal places, the tolerance is +/-0.01. Do not round intermediate results used to achieve this answer.) 430.77 Forecast for month 25 =

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!