Areas Michigan Ohio Indiana Wisconsin 2015 601 848 555 599 2016 480 833 700 675 2017...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Areas Michigan Ohio Indiana Wisconsin 2015 601 848 555 599 2016 480 833 700 675 2017 441 760 894 720 2018 500 711 893 855 Directions: 1. Find a quarterly data set with at least four years of data. You may not use any of the data sets that I will be using for class examples, or data sets that you may have used in previous POM classes. The tabs below are for presenting your final models and discussion. These are the only tabs that I will look at for grading. You may use additional tabs, but show your final work on the tabs indicated below. 2. On the "DATA" tab, show your original data set and create a line plot of the data. Discuss the characteristics of the data, (e.g., any trends, seasonality, etc.) and suggest the types of models that would perform best in developing quarterly forecasts for the year beyond your data. Put this discussion in a box. Highlight the box in yellow. 3. On the "MOVING AVERAGE" tab, take your data and create a moving average forecast. Using this model, develop a forecast for the four quarters beyond your data. Calculate MAD and Bias using the third and fourth years of your data (8 quarterly periods). Briefly discussion the selection of the number of periods selected for your model and what the MAD and Bias indicate about your model. Put this discussion in a box. Highlight the box in yellow. 4. On the "TREND MODEL" tab, take your data and create a trend adjusted model. Using this model develop a forecast for the four quarters beyond your data. Calculate MAD and Bias using the third and fourth years of your data (8 quarterly periods). Briefly discussion the selection of start-up values for your model and what the MAD and Bias indicate about your model. Put this discussion in a box. Highlight the box in yellow. 5. On the "TREND AND SEASONAL" tab, take your data and create a model that adjusts for both a possible trend and seasonal component in your data. Using this model develop a forecast for the four quarters beyond your data. Calculate MAD and Bias using the third and fourth years of your data (8 quarterly periods). Briefly discussion the selection of start-up values for your model and what the MAD and Bias indicate about your model. Put this discussion in a box. Highlight the box in yellow. 6. On the "SUMMARY" tab, create a summary table of the MAD and Bias of each of your models. Briefly describe which models performs best and why. Finally, indicate which model you would choose and why. Put this discussion in a box. Highlight the box in yellow. Areas Michigan Ohio Indiana Wisconsin 2015 601 848 555 599 2016 480 833 700 675 2017 441 760 894 720 2018 500 711 893 855 Directions: 1. Find a quarterly data set with at least four years of data. You may not use any of the data sets that I will be using for class examples, or data sets that you may have used in previous POM classes. The tabs below are for presenting your final models and discussion. These are the only tabs that I will look at for grading. You may use additional tabs, but show your final work on the tabs indicated below. 2. On the "DATA" tab, show your original data set and create a line plot of the data. Discuss the characteristics of the data, (e.g., any trends, seasonality, etc.) and suggest the types of models that would perform best in developing quarterly forecasts for the year beyond your data. Put this discussion in a box. Highlight the box in yellow. 3. On the "MOVING AVERAGE" tab, take your data and create a moving average forecast. Using this model, develop a forecast for the four quarters beyond your data. Calculate MAD and Bias using the third and fourth years of your data (8 quarterly periods). Briefly discussion the selection of the number of periods selected for your model and what the MAD and Bias indicate about your model. Put this discussion in a box. Highlight the box in yellow. 4. On the "TREND MODEL" tab, take your data and create a trend adjusted model. Using this model develop a forecast for the four quarters beyond your data. Calculate MAD and Bias using the third and fourth years of your data (8 quarterly periods). Briefly discussion the selection of start-up values for your model and what the MAD and Bias indicate about your model. Put this discussion in a box. Highlight the box in yellow. 5. On the "TREND AND SEASONAL" tab, take your data and create a model that adjusts for both a possible trend and seasonal component in your data. Using this model develop a forecast for the four quarters beyond your data. Calculate MAD and Bias using the third and fourth years of your data (8 quarterly periods). Briefly discussion the selection of start-up values for your model and what the MAD and Bias indicate about your model. Put this discussion in a box. Highlight the box in yellow. 6. On the "SUMMARY" tab, create a summary table of the MAD and Bias of each of your models. Briefly describe which models performs best and why. Finally, indicate which model you would choose and why. Put this discussion in a box. Highlight the box in yellow.
Expert Answer:
Answer rating: 100% (QA)
1 Michigan experienced the greatest year over year growth in the first quarter of 2018 with an inc... View the full answer
Related Book For
Modern Portfolio Theory and Investment Analysis
ISBN: 978-1118469941
9th edition
Authors: Edwin Elton, Martin Gruber, Stephen Brown, William Goetzmann
Posted Date:
Students also viewed these accounting questions
-
In your recent assignment, you have approached Sulaman Emas Sdn Bhd (SESB) to establish a better understanding of the business processes and the applications of internal control procedures in the...
-
Continuing Problem 6 with the data in the file P10_18.xlsx, refer to the original multiple regression model as the reduced equation. Suppose now that the antique collector believes that the rate of...
-
Below you will find three data sets that have already been sorted. Fill in the blanks to find the upper and lower quartiles. Measurements Above and Below and Measurements Above and Below and Position...
-
A bond currently has a price of $940. The current yield to maturity on the bond is 7%. If the yield decreases by 20 basis points, the price of the bond will go up to $960. Based on this information,...
-
What alternatives are available to a taxpayer who receives a 90-day letter?
-
Suppose a product must go through an assembly line is made up of five sequential operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds and...
-
Information from the records of Powertools Pty Ltd for the year ended 30 June 2025 is given below. Required Calculate the ending work in process inventory on 30 June 2025. Factory overhead, 150% of...
-
As the newest hire to the financial analysis group at Patterson Printing Company, you have been asked to perform a basis financial analysis of the company's most recent financial statements. The 2016...
-
If the fixed manufacturing costs were $23,800 and the fixed selling and administrative expenses were $10,780, prepare an income statement according to the variable costing concept. Round all final...
-
Carrington Oil produces gas 1 and gas 2 from two types of crude oil: crude 1 and crude 2. Gas 1 is allowed to contain up to 4% impurities, and gas 2 is allowed to contain up to 3% impurities. Gas 1...
-
For the below data table, calculate the Entropy and Information Gain to determine which of X, Y and Z would be the best choice of Root node. Expectations: 1. Determine overall Entropy for the dataset...
-
Is it true that Trust is essential in any human relationship and serves as an expression of confidence in another person or group of people? This principle about human interaction has little to do...
-
Describe the forces/atmospheric conditions on a flight Envelope. a) Identify and describe the potential hazards on the aircraft and pilot arising from different manoeuvres. b) Discuss the changes of...
-
There are many factors in healthcare that contribute to cost savings, many are efficiencies within the entity, so another entity could come way under and have a much higher profit margin because...
-
What is the primary role of commercial banks? Should banks be allowed to engage in services beyond banking (insurance, for instance)?
-
write an email to my friend that's taking too much brown sugar because of his belief that Brown sugar is healthier than White sugar which is just a health myth. (must be 400 words) 1. Write an...
-
What to measure! How to measure? Why should we measure? All important questions about managerial control. I know that everyone in our class is right know going - that is the Mindset of Measurement....
-
The manager for retail customers, Katie White, wants to hear your opinion regarding one business offer she has received from an entrepreneur who is starting a mobile phone app called Easy Money. The...
-
Derive the expression for the location of all portfolios of two securities in expected return standard deviation space when the correlation between the two securities is -1.
-
Assume that the yield curve for the data of Problem 3 is 10%. Further assume that the three bonds are of equal value and the only bonds existing. Set up a single-index representation of their...
-
Assume that General Mills, a user of wheat, and wheat farmers have the same distributional assumptions about future wheat prices. Does a futures contract make economic sense from both points of view?...
-
Let \(A\) and \(B\) be disjoint events with \(P(A)=0.3\) and \(P(B)=0.45\). Determine the probabilities \(P(A \cup B), P(\overline{A \cup B}), P(\bar{A} \cup \bar{B})\), and \(P(\bar{A} \cap B)\).
-
Let \(P(A \cap \bar{B})=0.3\) and \(P(\bar{B})=0.6\). Determine \(P(A \cup B)\).
-
Check whether for 3 arbitrary random events \(A, B\), and \(C\) the following constellations of probabilities can be true: (1) \(P(A)=0.6, P(A \cap B)=0.2\), and \(P(A \cap \bar{B})=0.5\), (2)...
Study smarter with the SolutionInn App