Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 231 9 17 369 2 247 10 333 18 369 3 249 11 340 19 365 4 256 12 351 20 387 S 27: 13 356 21 400 6 277 22 387 7 15 378 23 3 313 401 361 24 402 370 404 a. Develop a linear trendline for the data. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Sales (month) + b. Compute a correlation coefficient for the data and evaluate the strength of the near relationship (Round your answer to 2 decimal places, the tolerance Is +/-0.01.) Correlation coefficient is It Indicates linear relationship. (use not rounded amounts to answer this question.) c. Uning the linear trendline 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 =

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

How much of this is in your direct control?

Answered: 1 week ago

Question

7. Where Do We Begin?

Answered: 1 week ago