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 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
Hello, I am studying and I am a bit confused about registers. There are segments registers,...
Hello, I am studying and I am a bit confused about registers. There are segments registers, data registers, pointer registers, index registers. But I do not really understand where these are found. Are they found in 8086 architecture? For instance if I ask what type of registers are found in 8086 architecture what will be the answer? All of these or only segment registers?
(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...
Hi I am working on my chemistry homework about acids and bases and I am confused...
Hi I am working on my chemistry homework about acids and bases and I am confused on this question from a lab. We used grape juice and cranberry juice and we had to put HCl and NaOH in the test tube full of juice. 1. Referring back to procedure 1 of the experiment, which of the two juices is more useful as a general pH indicator and why? I think it is grape juice but I just don't know what...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT