Embed
Email

mean

Document Sample

Shared by: xiaoyounan
Categories
Tags
Stats
views:
0
posted:
12/24/2011
language:
pages:
4
A B C D E F G H I J K L M N O P Q R S T U

1 Mean reversion

2 cutoff 49.0455488 cutoff 48.59129

3 total sc 41 total sc 54

US 1 year Prediction Prediction Sign

4 rate Lag 1 Lag 2 Lag 1 Error Sign Change Lag 2 Error Change

5 Jan-88 0.0699

6 Feb-88 0.0664 0.0699 0.069632 -0.00323 SUMMARY OUTPUT

7 Mar-88 0.0671 0.0664 0.0699 0.066176 0.000924 1 0.064581 0.002519 0

8 Apr-88 0.0701 0.0671 0.0664 0.066867 0.003233 0 0.067264 0.002836 0 Regression Statistics

9 May-88 0.074 0.0701 0.0671 0.069829 0.004171 0 0.071307 0.002693 0 Multiple R 0.988431254

10 Jun-88 0.0749 0.074 0.0701 0.07368 0.00122 0 0.075569 -0.000669 1 R Square 0.976996344

11 Jul-88 0.0775 0.0749 0.074 0.074569 0.002931 0 0.07503 0.00247 1 Adjusted R Square 0.976803036

12 Aug-88 0.0817 0.0775 0.0749 0.077136 0.004564 0 0.078394 0.003306 0 Standard Error 0.002534664

13 Sep-88 0.0809 0.0817 0.0775 0.081284 -0.00038 1 0.083284 -0.002384 1 Observations 121

14 Oct-88 0.0811 0.0809 0.0817 0.080494 0.000606 1 0.080122 0.000978 1

15 Nov-88 0.0848 0.0811 0.0809 0.080691 0.004109 0 0.080794 0.004006 0 ANOVA

16 Dec-88 0.0899 0.0848 0.0811 0.084345 0.005555 0 0.086094 0.003806 0 df SS MS F Significance F

17 Jan-89 0.0905 0.0899 0.0848 0.089381 0.001119 0 0.091774 -0.001274 1 Regression 1 0.032470123 0.032470123 5054.090682 2.4839E-99

18 Feb-89 0.0925 0.0905 0.0899 0.089973 0.002527 0 0.090227 0.002273 1 Residual 119 0.000764518 6.42452E-06

19 Mar-89 0.0957 0.0925 0.0905 0.091948 0.003752 0 0.092859 0.002841 0 Total 120 0.033234641

20 Apr-89 0.0936 0.0957 0.0925 0.095108 -0.00151 1 0.096576 -0.002976 1

21 May-89 0.0898 0.0936 0.0957 0.093034 -0.00323 0 0.091993 -0.002193 0 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

22 Jun-89 0.0844 0.0898 0.0936 0.089282 -0.00488 0 0.087449 -0.003049 0 Intercept 0.000609342 0.000859195 0.709201053 0.479586897 -0.001091947 0.002310631 -0.001091947 0.002310631

23 Jul-89 0.0789 0.0844 0.0898 0.08395 -0.00505 0 0.081379 -0.002479 0 X Variable 1 0.987444997 0.013889653 71.09212813 2.4839E-99 0.959942132 1.014947861 0.959942132 1.014947861

24 Aug-89 0.0818 0.0789 0.0844 0.078519 0.003281 1 0.075923 0.005877 1 Rate =.000609+.987445*Lag Rate

25 Sep-89 0.0822 0.0818 0.0789 0.081382 0.000818 0 0.082764 -0.000564 1 mean revert to

26 Oct-89 0.0799 0.0822 0.0818 0.081777 -0.00188 1 0.081971 -0.002071 0 0.048533785

27 Nov-89 0.0777 0.0799 0.0822 0.079506 -0.00181 0 0.078427 -0.000727 0 Month t risknormal(.0006093+.987445*Month t-1,.0025)

28 Dec-89 0.0772 0.0777 0.0799 0.077334 -0.00013 0 0.076311 0.000889 1

29 Jan-90 0.0792 0.0772 0.0777 0.07684 0.00236 1 0.076626 0.002574 0 SUMMARY OUTPUT

30 Feb-90 0.0811 0.0792 0.0772 0.078815 0.002285 0 0.07978 0.00132 0

31 Mar-90 0.0835 0.0811 0.0792 0.080691 0.002809 0 0.081601 0.001899 0 Regression Statistics

32 Apr-90 0.084 0.0835 0.0811 0.083061 0.000939 0 0.084199 -0.000199 1 Multiple R 0.991202265

33 May-90 0.0832 0.084 0.0835 0.083555 -0.00035 1 0.083788 -0.000588 0 R Square 0.98248193

34 Jun-90 0.081 0.0832 0.084 0.082765 -0.00176 0 0.082384 -0.001384 0 Adjusted R Square 0.982182476

35 Jul-90 0.0794 0.081 0.0832 0.080592 -0.00119 0 0.079556 -0.000156 0 Standard Error 0.00222909

36 Aug-90 0.0778 0.0794 0.081 0.079012 -0.00121 0 0.078267 -0.000467 0 Observations 120

37 Sep-90 0.0776 0.0778 0.0794 0.077433 0.000167 1 0.076694 0.000906 1

38 Oct-90 0.0755 0.0776 0.0778 0.077235 -0.00174 1 0.077162 -0.001662 1 ANOVA

39 Nov-90 0.0731 0.0755 0.0776 0.075161 -0.00206 0 0.074195 -0.001095 0 df SS MS F Significance F

40 Dec-90 0.0705 0.0731 0.0755 0.072792 -0.00229 0 0.071692 -0.001192 0 Regression 2 0.032604633 0.016302317 3280.908981 1.7537E-103

41 Jan-91 0.0664 0.0705 0.0731 0.070224 -0.00382 0 0.069041 -0.002641 0 Residual 117 0.000581354 4.96884E-06

42 Feb-91 0.0627 0.0664 0.0705 0.066176 -0.00348 0 0.064296 -0.001596 0 Total 119 0.033185988

43 Mar-91 0.064 0.0627 0.0664 0.062522 0.001478 1 0.060848 0.003152 1

44 Apr-91 0.0624 0.064 0.0627 0.063806 -0.00141 1 0.064501 -0.002101 1 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

45 May-91 0.0613 0.0624 0.064 0.062226 -0.00093 0 0.06155 -0.00025 0 Intercept 0.000949308 0.000758605 1.251387236 0.213289529 -0.000553068 0.002451685 -0.000553068 0.002451685

46 Jun-91 0.0636 0.0613 0.0624 0.06114 0.00246 1 0.060706 0.002894 1 Lagged 1 1.458274678 0.080648153 18.0819352 1.12593E-35 1.298555249 1.617994108 1.298555249 1.617994108

47 Jul-91 0.0631 0.0636 0.0613 0.063411 -0.00031 1 0.064583 -0.001483 1 Lagged 2 -0.47492628 0.080581465 -5.893740965 3.72129E-08 -0.634513637 -0.315338924 -0.634513637 -0.315338924

48 Aug-91 0.0578 0.0631 0.0636 0.062917 -0.00512 0 0.062761 -0.004961 0

49 Sep-91 0.0557 0.0578 0.0631 0.057684 -0.00198 0 0.05527 0.00043 1 Month t = .000949 +1.458*Month t-1 -.475*Month t-2

50 Oct-91 0.0533 0.0557 0.0578 0.05561 -0.00231 0 0.054724 -0.001424 1 Mean revert to 0.057010015

51 Nov-91 0.0489 0.0533 0.0557 0.05324 -0.00434 0 0.052222 -0.003322 0 Month t is risknormal(.000949+1.458*Month(t-1) -.47493*Month(t-2),.002229)

52 Dec-91

Jan-92 0.0438

0.0415 0.0489

0.0438 0.0533 0.048895 -0.00236

0.0489 0.043859 -0.0051 0 0.046945

0.041598 -0.003145

-9.78E-05 0

122 Oct-97 0.0546 0.0552 0.0556 0.055116 -0.00052 0 0.05504 -0.00044 0

123 Nov-97 0.0546 0.0546 0.0552 0.054524 7.62E-05 1 0.054355 0.000245 1

124 Dec-97 0.0553 0.0546 0.0546 0.054524 0.000776 0 0.05464 0.00066 0

125 Jan-98 0.0524 0.0553 0.0546 0.055215 -0.00282 1 0.055661 -0.003261 1

126 Feb-98 0.0531 0.0524 0.0553 0.052351 0.000749 1 0.051099 0.002001 1

127 Mar-98 #NAME?

128 Apr-98 #NAME?

129 May-98 #NAME?

130 Jun-98 #NAME?

131 Jul-98 #NAME?

132 Aug-98 #NAME?

German

1-year FIBOR

Jan-88 0.0372

Feb-88 0.0355

Mar-88 0.0358

Apr-88 0.0369

May-88 0.0401

Jun-88 0.0434

Jul-88 0.052

Aug-88 0.0566

Sep-88 0.0542

Oct-88 0.0522

Nov-88 0.0503

Dec-88 0.0549

Jan-89 0.0597

Feb-89 0.0676

Mar-89 0.07

Apr-89 0.069

May-89 0.0727

Jun-89 0.0715

Jul-89 0.0705

Aug-89 0.0704

Sep-89 0.0754

Oct-89 0.0803

Nov-89 0.0827

Dec-89 0.0826

Jan-90 0.086

Feb-90 0.09

Mar-90 0.0918

Apr-90 0.0897

May-90 0.0896

Jun-90 0.0886

Jul-90 0.0869

Aug-90 0.0862

Sep-90 0.0888

Oct-90 0.0891

Nov-90 0.0902

Dec-90 0.0921

Jan-91 0.0946

Feb-91 0.0905

Mar-91 0.0912

Apr-91 0.0932

May-91 0.0916

Jun-91 0.0916

Jul-91 0.0941

Aug-91 0.0947

Sep-91 0.0937

Oct-91 0.0939

Nov-91 0.0939

Dec-91 0.0948

Jan-92 0.0928

Feb-92 0.0935

Mar-92 0.0956

Apr-92 0.0962

May-92 0.0966

Jun-92 0.0963

Jul-92 0.0969

Aug-92 0.0983

Sep-92 0.0934

Oct-92 0.0822

Nov-92 0.08

Dec-92 0.0805

Jan-93 0.0757

Feb-93 0.0742

Mar-93 0.0685

Apr-93 0.0688

May-93 0.0673

Jun-93 0.0677

Jul-93 0.0652

Aug-93 0.0604

Sep-93 0.0598

Oct-93 0.059

Nov-93 0.0554

Dec-93 0.0532

Jan-94 0.0528

Feb-94 0.0535

Mar-94 0.0547

Apr-94 0.0535

May-94 0.0507

Jun-94 0.0516

Jul-94 0.0507

Aug-94 0.0523

Sep-94 0.0553

Oct-94 0.0568

Nov-94 0.0559

Dec-94 0.0577

Jan-95 0.0579

Feb-95 0.0568

Mar-95 0.0547

Apr-95 0.0496

May-95 0.0474

Jun-95 0.0456

Jul-95 0.0466

Aug-95 0.0444

Sep-95 0.0416

Oct-95 0.0404

Nov-95 0.039

Dec-95 0.0373

Jan-96 0.0342

Feb-96 0.0336

Mar-96 0.034

Apr-96 0.0335

May-96 0.0333

Jun-96 0.0355

Jul-96 0.0359

Aug-96 0.0341

Sep-96 0.0327

Oct-96 0.032

Nov-96 0.0327

Dec-96 0.0323

Jan-97 0.0317

Feb-97 0.0318

Mar-97 0.0333

Apr-97 0.0334

May-97 0.033

Jun-97 0.0324

Jul-97 0.033

Aug-97 0.0355

Sep-97 0.0364

Oct-97 0.0401

Nov-97 0.0408

Dec-97 0.04

Jan-98 0.0381

Feb-98 0.0373



Related docs
Other docs by xiaoyounan
uses chart
Views: 2  |  Downloads: 0
least_squares_fit_manual
Views: 0  |  Downloads: 0
ENTERING_THE_ROADWAY_AND_BACKING_NOTES
Views: 0  |  Downloads: 0
FFaith presentation
Views: 0  |  Downloads: 0
Ward_Nutritioin
Views: 1  |  Downloads: 0
0604477_Goldburg
Views: 0  |  Downloads: 0
salary-delegation-authority-summary-temporary
Views: 0  |  Downloads: 0
August 2011 _excel format_
Views: 19  |  Downloads: 0
1350 Tally FINANCE
Views: 1  |  Downloads: 0
Ch. 6.3.Martinez
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!