four months. This is shown. Mop and Broom Manufacturing has tracked the number o
ID: 3366570 • Letter: F
Question
four months. This is shown. Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past twenty- Month Sales Month Sales Month Sales 378 373 374 382 397 390 396 403 301 235 243 248 266 272 276 393 301 17 18 19 20 21 10 356 12 13 14 15 16 352 362 352 37223 24 a. Develop a linear trend line for the data. (Round your answer to 2 decimal places, the tolerance is +-0.01) (month) Sales - Round your answer to 2 decimal places, the tolerance is +/-QOL) b Compute a correlation coefficient for the data and evaluate the strength of the linear relationship It indicates linear relationship. (Use not rounded amounts to answer this question.) Correlation coefficienit is 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.) Forecast for month 25Explanation / Answer
(a) Linear trend line data
Sales= 251.43 + 6.95 (Month)
(b)Correlation coefficint is 0.90
Comment:- Sales and month is Strong positve linear relationship (highly positive correlation.)
(c) Forcasting for monnth 25 is
yhat= 251.438 +(25* 6.948)
yhat =425.138
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.