Question

In: Statistics and Probability

Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...

Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010.

Date Return
Jan-06 5.12
Feb-06 4.14
Dec-10 5.47
Date Return
ene-06 5.12
feb-06 4.14
mar-06 4.68
abr-06 5.25
may-06 5.35
jun-06 3.64
jul-06 4.68
ago-06 4.65
sep-06 3.55
oct-06 3.55
nov-06 4.3
dic-06 3.54
ene-07 3.8
feb-07 3.98
mar-07 4.33
abr-07 4.69
may-07 5.37
jun-07 4.74
jul-07 5.17
ago-07 3.22
sep-07 4.97
oct-07 5.13
nov-07 3.35
dic-07 3.86
ene-08 4.06
feb-08 4.64
mar-08 4.83
abr-08 5.06
may-08 5.46
jun-08 5.22
jul-08 4.29
ago-08 4.79
sep-08 5.45
oct-08 4.85
nov-08 3.54
dic-08 4.9
ene-09 3.6
feb-09 4.48
mar-09 3.51
abr-09 3.72
may-09 4.24
jun-09 4.36
jul-09 5.17
ago-09 3.25
sep-09 4.74
oct-09 5.03
nov-09 5.44
dic-09 3.55
ene-10 4.21
feb-10 5.27
mar-10 5.07
abr-10 3.7
may-10 4.65
jun-10 4.21
jul-10 4.38
ago-10 4.29
sep-10 4.93
oct-10 4.48
nov-10 3.32
dic-10 5.47

Estimate a linear trend model with seasonal dummy variables to make forecasts for the first three months of 2011. (Round intermediate calculations to at least 4 decimal places and final answers to 2 decimal places.)

Year Month yˆt
2011 Jan
2011 Feb
2011 Mar

Solutions

Expert Solution

Soln

We will be calculating the seasonality of each Month (ie Jan – Dec) and use it to predict Revenue for 2011 (Jan – Dec)

Steps:

  1. First we calculate 4 Period(Months) moving Average.
  2. Then we calculate Centred Average of these 4 Period moving Average.
  3. Then % Average ie Return/Centred Average
  4. Then we table the % Average for each Month (1-12) for the five years and calculate mean for each Month. (As Shown in Table 2)
  5. 1200%/The total of these 12 Period (Months) mean will be the x Adjustment Factor
  6. Seasonality Index for each Month will be X Adj Factor * Month’s Mean ie Seasonality Index for Jan = 93.5%*1 = 0.93
  7. Then we calculate ∑X, ∑Y, ∑XY, ∑X2 and using these values we calculate the regression equation.
  8. Regression Equation will be: Y = 4.4392 + 0.0005*X
  9. Using this equation and Seasonality Index, we calculate value for Predicted Revenue for next Year. Eg: Jan (2011) Return = (4.4392 + 0.0005*61)*0.93

Table 1

Table 2

Season

2006

2007

2008

2009

2010

Mean

X ADJ Factor

SEASONAL INDEX

Cumulative Indx

2011 Return (Predicted)

Regression Equation: Y = a + bX

Jan

97.2%

97.5%

87.2%

92.1%

93.5%

1.00

                           0.93

61

                                         4.18

n

60

Feb

98.1%

103.2%

112.7%

116.0%

107.5%

1.00

                           1.07

62

                                         4.80

b

0.0005

Mar

97.0%

98.5%

100.2%

89.8%

109.8%

99.0%

1.00

                           0.99

63

                                         4.42

a

4.4392

Apr

109.5%

100.1%

99.8%

93.6%

81.5%

96.9%

1.00

                           0.97

64

                                         4.33

May

113.1%

109.9%

107.6%

101.8%

107.6%

108.0%

1.00

                           1.08

65

                                         4.82

∑ XY

        8,159

Jun

78.2%

98.6%

105.0%

101.1%

97.7%

96.1%

1.00

                           0.96

66

                                         4.29

∑ X2

     73,810

Jul

107.5%

113.0%

86.9%

119.7%

99.2%

105.2%

1.00

                           1.05

67

                                         4.70

∑ X

        1,830

Aug

112.9%

70.4%

97.9%

72.8%

95.6%

89.9%

1.00

                           0.90

68

                                         4.02

∑ Y

           267

Sep

87.4%

113.1%

114.7%

103.5%

112.4%

106.2%

1.00

                           1.06

69

                                         4.75

Oct

91.6%

120.8%

103.8%

108.1%

101.8%

105.2%

1.00

                           1.05

70

                                         4.70

Nov

114.2%

79.5%

79.5%

117.7%

97.7%

1.00

                           0.98

71

                                         4.37

Dec

91.9%

95.6%

117.3%

77.4%

95.6%

1.00

                           0.95

72

                                         4.27

Total

1200.9%

Final Predicted Values:

Season

2011 Return (Predicted)

Jan

4.18

Feb

4.80

Mar

4.42

Apr

4.33

May

4.82

Jun

4.29

Jul

4.70

Aug

4.02

Sep

4.75

Oct

4.70

Nov

4.37

Dec

4.27

PS: If Images are not visible, Right click on image and select open image in new tab option.


Related Solutions

Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date Return Jan-06 4.12 Feb-06 4.44 Mar-06 4.02 Apr-06 4.79 May-06 4.01 Jun-06 3.65 Jul-06 4.07 Aug-06 4.3 Sep-06 5.49 Oct-06 3.6 Nov-06 4.71 Dec-06 3.83 Jan-07 4.14 Feb-07 3.53 Mar-07 3.68 Apr-07 4.19 May-07 3.34 Jun-07 3.51 Jul-07 3.48 Aug-07 3.68 Sep-07 4.96 Oct-07 3.42 Nov-07 4.17 Dec-07 4.25 Jan-08 5.05 Feb-08 3.23 Mar-08 5.34 Apr-08 5.15 May-08 4.58 Jun-08 4.61 Jul-08 4.25 Aug-08...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date Return Jan-06 3.13 Feb-06 4.15 ⋮ ⋮ Dec-10 4.48 Source: Federal Reserve Bank of Dallas. Estimate a linear trend model with seasonal dummy variables to make forecasts for the first three months of 2011. (Round answers to 2 decimal places.) Year Month yˆty^t 2011 Jan 2011 Feb 2011 Mar DATA: Index Month Year Return 1 Jan 2006 3.13 2 Feb 2006 4.15 3 Mar...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Index...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Index Month Year Return 1 Jan 2006 3.34 2 Feb 2006 3.13 3 Mar 2006 4.67 4 Apr 2006 3.51 5 May 2006 3.8 6 Jun 2006 5.42 7 Jul 2006 4.6 8 Aug 2006 4.69 9 Sep 2006 4.62 10 Oct 2006 4.28 11 Nov 2006 5.08 12 Dec 2006 3.34 13 Jan 2007 3.91 14 Feb 2007 5.02 15 Mar 2007 3.91 16...
Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007...
Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 Price 3.34 3.56 3.61 4.06 4.25 4.37 4.68 4.59 4.81 a. Compute the simple price index using 2002 as the base year. (Round your answers to 2 decimal places.) Year Price index 2002 2003 2004 2005 2006 2007 2008 2009 2010 b. Update the index numbers with a base year revised from 2002 to 2005. (Round your answers to 2 decimal...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for two of Vanguard’s mutual funds: the Vanguard Energy Fund and the Vanguard Healthcare Fund. [You may find it useful to reference the t table.] Date Energy Healthcare Jan-10 -4.89 -0.11 Feb-10 1.6 0.54 Mar-10 2.27 1.37 Apr-10 2.99 -3.84 May-10 -11.6 -5.16 Jun-10 -5.77 -0.52 Jul-10 8.69 1.52 Aug-10 -6.02 -1.08 Sep-10 10.2 8.24 Oct-10 3.85 2.3 Nov-10 2.82 -2.5 Dec-10 5.55 2 Jan-16...
The following shows a portion of the monthly returns data (in percent) for 2010-2016 for two...
The following shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the Vanguard Healthcare Fund. [You may find it useful to reference the t table.] DATE : ENERGY : HEALTHCARE : (Jan-10, -4.95, -0.19); (Feb-10, 1.8, 0.39); (Mar-10, 2.47, 1.18); (Apr-10, 3.14, -3.8); (May-10, -11.5, -5.09); (Jun-10, -5.95, -0.63); (Jul-10, 8.83, 1.47); (Aug-10, -5.84, -1.1); (Sep-10, 10.13, 8.32); (Oct-10, 3.98, 2.37); (Nov-10, 2.81, -2.41); (Dec-10, 5.71,...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for two of Vanguard’s mutual funds: the Vanguard Energy Fund and the Vanguard Healthcare Fund. [You may find it useful to reference the t table.] Date Energy Healthcare Jan-10 −4.86 −0.08 Feb-10 1.90 0.56 ⋮ ⋮ ⋮ Dec-16 0.10 −5.30 SOURCE: www.finance.yahoo.com. Click here for the Excel Data File a. Calculate the sample correlation coefficient rxy. (Round intermediate calculations to at least 4 decimal places...
You have monthly data on gasoline prices in two cities—Vancouver and Toronto, for the years 2006–2010....
You have monthly data on gasoline prices in two cities—Vancouver and Toronto, for the years 2006–2010. In each month of each year, you observe the average price of gasoline in each city. Prices in Vancouver are usually higher than in Toronto, but the cities follow similar price trends, as prices rise in the summer months and respond similarly to demand and cost shocks. However, there are month-to-month fluctuations for various reasons. Starting from January 1, 2008, Vancouver imposed a carbon...
Given the following information: Settlement date: 13 August 2001 Treasury bond maturity date: 25/11/2010 Treasury bond...
Given the following information: Settlement date: 13 August 2001 Treasury bond maturity date: 25/11/2010 Treasury bond coupon rate: 6.25 percent, paid semiannually Treasury bond quoted price: 110.20 Futures quoted price: 115.94 Futures expiry date: 28/09/2001 Repo rate: 4.9 percent Assume that the bond has a $100 million face value, and futures contract has a $1 million nominal amount. a) What is the implied repo rate? Interpret your finding. b) What is cash and carry arbitrage trade? Explain the process. c)...
THe Golfing Statistics provides data for a portion of the 2010 professional season for the top...
THe Golfing Statistics provides data for a portion of the 2010 professional season for the top 25 golfers. A) Find the best multiple regression model for predicting earnings/event as a function of the remaining variables. B) Find the best multiple regression model for predicting average score as a function of the other variables except earning sand events. Golfing Statistics Earnings/Event Events Avg. Score GIR (%)* Driving Distance Driving Accuracy (%) Putts/Round $239,493.68       22           70.37       67.9                 288.4...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT