solution

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

1 232 9 313 17 374
2 254 10 340 18 370
3 256 11 345 19 359
4 260 12 354 20 382
5 267 13 349 21 386
6 288 14 365 22 402
7 394 15 371 23 402

8

306

16

354

24

404

  1. Develop a linear trend line for the data. (Round your answer to 2 decimal places, the tolerance is +/-0.01.)
    Sales =__________________________+_________________________________(month)
  2. 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__________________________. It indicates_____________ A. a strong, positive. B. no. C. a moderate, positive.
    linear relationship. (Use not rounded amounts to answer this question.)
  3. 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.)
    Forecast for month 25 =________________________
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"