Create or find a data set that has seasonality, deseasonalize it and make a time series...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create or find a data set that has seasonality, deseasonalize it and make a time series forecast. Show the bias and MSE of the model. Create another data set and discuss if and how that could be used for a causal forecast. Be specific, describe what your data represent and what the formulas do in a real life context, different from the spreadsheet posted on Blackboard. Do not use time of the day or day of the week as seasons, or price as a causal factor. Activity Description Duration (weeks) Immediate Predecessor(s) For the project represented on the right, assume that all activity durations are random. The numbers in weeks represent the mean of a normal distribution. All standard deviations are equal to .5. The formula to generate random numbers out of this distribution is =NORM.INV(). So, for example, to generate the duration of activity A you will type =MAX(0,NORM.INV(RAND(),4,0.5). Simulate the project for 10,000 and show the frequency distribution of the project completion time using a bar chart (histogram). The Excel formula =FREQUENCY() may be useful here. Google it and learn about array formulas before use. Process analysis Data analysis Reports design Database design Code reports Code data entry Code database System and network testing Installation and training B F. G, H Start Finish Create or find a data set that has seasonality, deseasonalize it and make a time series forecast. Show the bias and MSE of the model. Create another data set and discuss if and how that could be used for a causal forecast. Be specific, describe what your data represent and what the formulas do in a real life context, different from the spreadsheet posted on Blackboard. Do not use time of the day or day of the week as seasons, or price as a causal factor. Activity Description Duration (weeks) Immediate Predecessor(s) For the project represented on the right, assume that all activity durations are random. The numbers in weeks represent the mean of a normal distribution. All standard deviations are equal to .5. The formula to generate random numbers out of this distribution is =NORM.INV(). So, for example, to generate the duration of activity A you will type =MAX(0,NORM.INV(RAND(),4,0.5). Simulate the project for 10,000 and show the frequency distribution of the project completion time using a bar chart (histogram). The Excel formula =FREQUENCY() may be useful here. Google it and learn about array formulas before use. Process analysis Data analysis Reports design Database design Code reports Code data entry Code database System and network testing Installation and training B F. G, H Start Finish
Expert Answer:
Answer rating: 100% (QA)
First Problem Forecasting The data and the time series plot is shown as following Year Quarter Time Sales 1 1 1 148 2 2 252 3 3 273 4 4 249 2 1 5 139 2 6 221 3 7 260 4 8 260 3 1 9 141 2 10 246 3 11 29... View the full answer
Related Book For
Statistics The Art and Science of Learning from Data
ISBN: 978-0321755940
3rd edition
Authors: Alan Agresti, Christine A. Franklin
Posted Date:
Students also viewed these accounting questions
-
The table shows a small data set that has a pattern somewhat like that in Figure 3.22 in Example 14. As in that example, education is measured as the percentage of adult residents who have at least a...
-
Describe how MRP concepts could be used for the following service operations: a. Hotel b. Legal office
-
Construct a data set that has the given statistics. N = 6 = 5 2
-
What's New 14 el.alphacollege.ca 500 Alpha College E-learning of My Courses Development is informal with a loner-term focus Select one: O True O False Training is formal with a short-term focus....
-
A publisher of college textbooks conducted a study to relate profit per text y to cost of sales x over a 6-year period when its sales force (and sales costs) were growing rapidly. These...
-
Find the x- and y-intercepts of the graph of the equation algebraically. 1. y = 3x - 1 2. y = 5x + 6 3. y = 2(x 4) 4. y = 4(7x + 1)
-
Climate Change In July 2015, a poll asked a random sample of 1,236 registered voters in Iowa whether they agree or disagree that the world needs to do more to combat climate change. The results show...
-
As HR manager at Krameria, Inc., you are trying to determine whether there is a useful linear relationship between x, the years of education of a company employee, and y, the employees job...
-
(a) Explain the loop problem. Apply Spanning Tree Protocol (STP) in the following network diagram to solve the loop Problem. Find out the Root Bridge, root ports, designated bridge, designated ports,...
-
You are the Owners project manager on an electrical upgrade project. Existing overhead power lines are being buried in a duct bank to hide them from view in an area of the town that is being...
-
Background information: Sundar Pichai: Sundar Pichai is the CEO of Alphabet Inc., the parent company of Google. He was born in Chennai, India, and holds a Bachelor of Engineering degree from IIT...
-
Lets say you have a line y = 0.5x + 2.0, where 0.5 is the slope, and 2.0 is the y-intercept. Using this linear equation, we can find the (x,y) coordinates on this line. Create a new class file called...
-
What are the elements of a product offering and why do we need to identify them?
-
Within the same class file from Problem 1, print out 10 == 10. What will this print out?
-
For the girder in Figure P12.17, draw the influence lines for the reaction at \(A\), the moment at point \(C\), and the shear between points \(B\) and \(C\) in girder \(A E\). B C D 8-44-88 E
-
Why might a decision maker choose a qualitative forecasting method when extensive historical data are available?
-
A trader purchases 300 shares of stock at $40 per share. She borrows $4,000 from her broker to help pay for the purchase. The maintenance margin requirement is 30%. a) If the share price next day...
-
Refrigerant-134a enters an adiabatic compressor as saturated vapor at 120 kPa at a rate of 0.3 m3/min and exits at 1-MPa pressure. If the isentropic efficiency of the compressor is 80 percent,...
-
In 2004, New York Attorney General Eliot Spitzer filed a lawsuit against GlaxoSmithKline pharmaceutical company, claiming that the company failed to publish results of one of their studies that...
-
In December 2004, a report based on the National Survey on Drug Use and Health estimated that 20% of all Americans of ages 16 to 20 drove under the influence of drugs or alcohol in the previous year...
-
Using data from the National Survey of Families and Households, a study (from S. South and G. Spitze, American Sociological Review, vol. 59, 1994, pp. 327347) reported the descriptive statistics in...
-
After successful stretches at Target and Apple, it seemed as though Ron Johnson was a master marketer. But things went sour quickly after JC Penney hired him as its CEO. Johnsons attempt to reinvent...
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
-
Influencer marketing is a type of marketing where companies partner with influencers, who have a significant following on social media platforms, to promote their products or services. Influencers...
Study smarter with the SolutionInn App