3. (5 pts) The following time series depicts US Total New Housing Units (in thousands), Jul2003...


3. (5 pts) The following time series depicts US Total New Housing Units (in thousands), Jul2003 - Dec2005

Time	Period	Housing
Jul 2003	1	175.8	a. Use Excel to calculate a simple housing index for every month, Jul2003 - Dec2005.
Aug	2	163.8	Use Jul2003 as the base.
Sep	3	171.3
Oct	4	173.5
Nov	5	153.7	b. Comment on the trend in the Housing Index from Jul 2003 to Dec 2005.
Dec	6	144.2	Explain the meaning of your Dec2005 index value.
Jan 2004	7	124.5
Feb	8	126.4
Mar	9	173.8
Apr	10	179.5
May	11	187.6
Jun	12	172.3
Jul	13	182.0
Aug	14	185.9
Sep	15	164.0
Oct	16	161.3
Nov	17	138.1
Dec	18	140.2
Jan 2005	19	142.9
Feb	20	149.1
Mar	21	156.2
Apr	22	184.6
May	23	197.9
Jun	24	192.8
Jul	25	187.6
Aug	26	192.0
Sep	27	187.9
Oct	28	180.4
Nov	29	160.7
Dec	30	136.0

Expert Solution

Kindly refer ot the solution below .

orchestra answered 2 years ago

Using the following 5 year data series, calculate the correlation between interest rates and US new...

Using the following 5 year data series, calculate the correlation between interest rates and US new home sales. Year Home sales (thousands) Interest rate (%) 1 520 8 2 673 5 3 631 3 4 581 8 5 658 10 The answer is -.263 Please show how to get there

Consider the following table for the total annual returns for a given period of time. Series...

Consider the following table for the total annual returns for a given period of time. Series Average return Standard Deviation Large-company stocks 11.7 % 20.6 % Small-company stocks 16.4 33.0 Long-term corporate bonds 5.6 9.1 Long-term government bonds 6.1 9.4 Intermediate-term government bonds 5.6 5.7 U.S. Treasury bills 3.8 3.1 Inflation 3.1 4.2 What range of returns would you expect to see 68 percent of the time for long-term corporate bonds? (A negative answer should be indicated by a minus...

In a time-series decompostion of sales (in millions of units), the following trend has been estimated:...

In a time-series decompostion of sales (in millions of units), the following trend has been estimated: CMAT=12.315+0.196(T) The seasonal indices have been found to be: Quarter Seasonal Index 1 1.27 2 1.02 3 0.73 4 0.98 For the coming year, the time index and cycle factors are: Quarter T CF 1 21 1.01 2 22 1.04 3 23 1.06 4 24 1.04 a. From this information, prepare a forecast for each quarter of the coming year. b. Actual sales for...

Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...

Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 15 11 18 13 a. Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 19 2 12 3 15 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE = b. Use a smoothing constant of α = 0.4 to compute the exponential smoothing forecasts. Week Time...

Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22...

Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22 13 18 11 19 22 14 Round your answers to two decimal places. a. Compute MSE using the most recent value as the forecast for the next period. Mean squared error is What is the forecast for month ? b. Compute MSE using the average of all data available as the forecast for the next period. Mean squared error is What is the forecast...

Consider the following time series data. t 1 2 3 4 5 6 7 yt 10...

Consider the following time series data. t 1 2 3 4 5 6 7 yt 10 9 7 8 6 4 4 a. Construct a time series plot. What type of pattern exists in the data? b. Develop the linear trend equation for this time series. c. What is the forecast for t=8?

Consider the following time series. t 1 2 3 4 5 6 7 Yt 83 61...

Consider the following time series. t 1 2 3 4 5 6 7 Yt 83 61 45 36 29 28 36 b. Develop the quadratic trend equation for the time series. Enter negative value as negative number.(to 3 decimals) Tt = ______ + _______t + ________ t2 c. What is the forecast for t = 8?

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5 7 2 0 2 6 3 5 8 10 4 5 8 10 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 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8...

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8 10 2 2 4 8 3 1 4 6 4 3 6 8 A.) 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 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...

Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...

Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 15 20 12 18 22 15 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month...

Question