Question

In: Math

I need to time series plot the following data. I am confused since there are multiple...

I need to time series plot the following data. I am confused since there are multiple sections (441, 442, 443, 444, 445, 452, 4521. This is just two years worth of the data.

Year Month Period 441 442,443 444 445 448 452 4521
1992 Jan 1 1.84 1.85 1.83 0.88 2.58 2.39 2.60
1992 Feb 2 1.83 1.85 1.83 0.89 2.62 2.34 2.53
1992 Mar 3 1.87 1.90 1.83 0.88 2.63 2.35 2.53
1992 April 4 1.89 1.91 1.91 0.89 2.60 2.37 2.56
1992 May 5 1.88 1.93 1.88 0.89 2.64 2.33 2.50
1992 June 6 1.88 1.90 1.90 0.89 2.61 2.37 2.54
1992 July 7 1.94 1.90 1.92 0.88 2.63 2.43 2.62
1992 Aug 8 1.95 1.92 1.90 0.87 2.62 2.36 2.54
1992 Sept 9 1.88 1.92 1.90 0.88 2.59 2.36 2.54
1992 Oct 10 1.87 1.90 1.91 0.88 2.59 2.36 2.54
1992 Nov 11 1.89 1.93 1.93 0.88 2.66 2.33 2.52
1992 Dec 12 1.91 2.00 1.90 0.88 2.65 2.27 2.47
1993 Jan 13 1.84 1.91 1.89 0.88 2.62 2.37 2.55
1993 Feb 14 1.92 1.94 1.89 0.88 2.73 2.41 2.62
1993 Mar 15 2.00 1.97 1.94 0.89 2.80 2.47 2.69
1993 April 16 1.86 1.94 1.90 0.89 2.71 2.41 2.61
1993 May 17 1.83 1.93 1.85 0.89 2.69 2.39 2.60
1993 June 18 1.85 1.96 1.87 0.89 2.69 2.39 2.59
1993 July 19 1.80 1.93 1.86 0.88 2.66 2.36 2.56
1993 Aug 20 1.76 1.95 1.86 0.88 2.70 2.37 2.56
1993 Sept 21 1.80 1.95 1.88 0.88 2.67 2.36 2.56
1993 Oct 22 1.79 1.94 1.87 0.88 2.67 2.34 2.53
1993 Nov 23 1.77 1.95 1.82 0.87 2.69 2.35 2.54
1993 Dec 24 1.76 2.02 1.80 0.87 2.69 2.33 2.53

Solutions

Expert Solution

You can also change the scaling in Excel that is represented on the Y-Axis if required.


Related Solutions

Consider the following time series.   (a) Choose the correct time series plot.     (i)...
Consider the following time series.   (a) Choose the correct time series plot.     (i) (ii) (iii) (iv)     - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1     What type of pattern exists in the data?   - Select your answer - Horizontal PatternDownward Trend PatternUpward Trend PatternItem 2     (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.       Do...
a. Which of the following is a correct time series plot for this data?
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 18 14 a. Which of the following is a correct time series plot for this data? Plot 1 Plot 2 Plot 3 What type of pattern exists in the data? Vertical Horizontal Scatter b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary). MSE The forecast for week...
I am trying to plot a difficult function in MATLAB, however I need to understand the...
I am trying to plot a difficult function in MATLAB, however I need to understand the basics first. I am trying to plot n=0 for x=0:0.01:2pi n=n+1 y(n)=sin(x) end I beleive what this says, is that I want to plot sin(x) over a full period hence from o to 2pi, and I beleive the 0.01 is the incremenation along the x-axis. I am not sure what my n is doing Could smeone please graph this for me with the MATLAB...
Construct a time series plot. What type of pattern exists in the data?
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 Construct a time series plot. What type of pattern exists in the data? The time series plot indicates a linear trend and a seasonal pattern Show the four-quarter and centered moving average values for this time series.   Compute seasonal indexes and adjusted seasonal indexes for the four quarters.
I have the problem in bold below. I am completely confused. I am hoping that I...
I have the problem in bold below. I am completely confused. I am hoping that I will see how you did this and will be able to follow it. Please remember that I have just started this so please don't use any complex features that an absolute beginner (like me) wouldn't know. Additional information:   /*This is what everyone owes before tax and tip:     Person 1: $10     Person 2: $12     Person 3: $9     Person 4: $8     Person 5: $7     Person 6:...
I am confused by average take-up and crowd-out terminology. Maybe I just need an explanation. Is...
I am confused by average take-up and crowd-out terminology. Maybe I just need an explanation. Is there a set formula for average take-up and crowd-out? Thank you!
I need the solution by Hand since I have no idea About Excel and am not...
I need the solution by Hand since I have no idea About Excel and am not allowed to use it on the exam. TIA 1. What is the beta of firm XXX over a 6 month period ? Could you please explain very thoroughly and step-by-step. I really struggle with the topic yet Average month market return: 1/1/1/-1/-1/-1 Average stock Price changes: 2/0/1/-1/0/-2
I am getting confused on finding the ethical challanges to this question. I am understanding but...
I am getting confused on finding the ethical challanges to this question. I am understanding but second guessing my answers when it come to the elements and the Ethical Code Standards. 1. Identify an ethical challenge for each element (a-d) of Dr Lux advertising plan. Which General Principles and Ethical Code Standards best help understand why these elements may create ethical problems? Explain why. Case 5. Web-Based Advertising. Dr. Lux, an applied developmental psycholgoist, has created his own community consulation...
(a) Create the correct time series plot. Which type of pattern exists in the data?
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 0 1 4 3 3 5 6 4 5 7 8 (a) Create the correct time series plot. Which type of pattern exists in the data? (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter...
Perform an analysis of the data below. A time-series plot. Comment on the underlying pattern in...
Perform an analysis of the data below. A time-series plot. Comment on the underlying pattern in the time series. Using the dummy variable approach, build the forecasting model. Show your final time series table and regression equation. Using your model, forecast sales for January through December of the fourth year. Assume that January sales for the fourth year turn out to be $295,000. What was your forecast error? What can you do to resolve the owner's uncertainty in the forecasting...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT