Plotting Data
Not what you're looking for?
Please see attachment for data.
a.) Plot the data in the attachment on a graph. Do you observe any trend, cycles, or random variations?
b.) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data.
c.) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year. Plot this forecast on the same graph.
d.) As you compare forecasts with the original data, which seems to give the better results?
Purchase this Solution
Solution Summary
The solution involves plotting data and comparing various data sets in Excel. Brief explanations are provided for all parts.
Purchase this Solution
Free BrainMass Quizzes
Operations Management
This quiz tests a student's knowledge about Operations Management
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.