Develop linear trend line for the data

Assignment Help Operation Management

Reference no: EM131128341

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 234 9 319 17 362 2 246 10 340 18 379 3 261 11 348 19 363 4 257 12 358 20 380 5 268 13 352 21 396 6 285 14 359 22 393 7 385 15 379 23 407 8 304 16 354 24 411 Develop a linear trend line for the data. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Sales = + (month) 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 linear relationship. (Use not rounded amounts to answer this question.) 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 =

Reference no: EM131128341

Questions Cloud

What does diseconomies of scale? mean : What does diseconomies of scale? mean?

Discuss the role of information systems in an organization : Discuss the role of information systems in an organization. Compare and contrast various approaches to organizing information system resources. Describe the responsibilities associated with collecting data, designing information systems, and using in..

With the heallthcare environment changing so rapidly : With the heallthcare environment changing so rapidly, is budgeting a thing of the past? Why is it important for healthcare firms to create and monitor budgets? Are there better ways for heallthcare leaders to monitor and control costs?

Products and services to customers on wholesale basis : Bakery sellsproducts to both customers on a retail basis and products and services to customers on a wholesale basis. Since Lorry was originally a marketing major, she wants to be able to track and contact customers and people interested in Bakery an..

Develop linear trend line for the data : 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 234 9 319 17 362 2 246 10 340 18 379 3 261 11 348 19 363 4 257 12 358 20..

For both alpha values enter exponential smoothing forecasts : The manager of a small health clinic would like to use exponential smoothing to forecast demand for emergency services in the facility. However, she is not sure whether to use a high or low value of α. For both alpha values, enter exponential smoothi..

Future of work will be important in the future job market : Drucker, Reich, Friedman and Rifkin's ideas of the future of work will be important in the future job market. What interest, skills, and values do you possess that will be relevant in the emerging global economy? What steps can you take to improve yo..

Decided the optimum assignment : There are three project managers that have to be assigned to four projects. All project managers have to assign to at least one project. Therefore, at the end two project managers will be assigned to one project each, and one project manager to two p..

What resonant issues does the scene or character represent : Focus on film Apocalypse Now elements in a specific scene (or scenes) and analyze how the film represents a resonant issue, image, or idea in that specific scene (see the doc. "Studying Film" for advice on this). What resonant issues does the scene o..

User Account

All Pages