Линейные модели по переменным и параметрам :

  • Published on
    26-Jan-2016

  • View
    86

  • Download
    4

Embed Size (px)

DESCRIPTION

. :. . . . : :. - PowerPoint PPT Presentation

Transcript

  • *

    :

    . .

  • *

    :

    :

    . .

  • *

    :

    :

    : .

  • *

    () ($10,000) Y X

    11.71126.88238.25349.52459.815611.436711.097810.878912.1591010.9410 : 10 .

  • *

    .XY

    Chart1

    0

    1.705

    6.88

    8.2516666667

    9.515

    9.81

    11.4283333333

    11.0864285714

    10.87

    12.1538888889

    10.935

    Chart2

    29.1690094923

    28.5407311843

    27.9202017149

    27.3074210841

    26.702389292

    26.1051063386

    25.5155722238

    24.9337869477

    24.3597505102

    23.7934629114

    23.2349241512

    22.6841342297

    22.1410931469

    21.6058009027

    21.0782574972

    20.5584629303

    20.0464172021

    19.5421203125

    19.0455722616

    18.5567730493

    18.0757226757

    17.6024211408

    17.1368684445

    16.6790645869

    16.2290095679

    15.7867033876

    15.3521460459

    14.9253375429

    14.5062778786

    14.0949670529

    13.6914050658

    13.2955919174

    12.9075276077

    12.5272121366

    12.1546455042

    11.7898277105

    11.4327587554

    11.0834386389

    10.7418673611

    10.408044922

    10.0819713215

    9.7636465597

    9.4530706365

    9.150243552

    8.8551653061

    8.5678358989

    8.2882553304

    8.0164236005

    7.7523407092

    7.4960066567

    7.2474214427

    7.0065850675

    6.7734975309

    6.5481588329

    6.3305689736

    6.120727953

    5.918635771

    5.7242924276

    5.537697923

    5.3588522569

    5.1877554296

    5.0244074409

    4.8688082908

    4.7209579794

    4.5808565067

    4.4485038726

    4.3239000772

    4.2070451204

    4.0979390023

    3.9965817228

    3.902973282

    3.8171136798

    3.7390029164

    3.6686409915

    3.6060279053

    3.5511636578

    3.5040482489

    3.4646816787

    3.4330639472

    3.4091950542

    3.393075

    3.3847037844

    3.3840814075

    3.3912078692

    3.4060831696

    3.4287073086

    3.4590802863

    3.4972021026

    3.5430727576

    3.5966922513

    3.6580605836

    3.7271777546

    3.8040437642

    3.8886586124

    3.9810222994

    4.081134825

    4.1889961892

    4.3046063921

    4.4279654337

    4.5590733139

    4.6979300328

    4.8445355903

    4.9988899865

    5.1609932213

    5.3308452948

    5.5084462069

    5.6937959577

    5.8868945472

    6.0877419753

    6.2963382421

    6.5126833475

    6.7367772916

    6.9686200743

    7.2082116957

    7.4555521558

    7.7106414545

    7.9734795918

    8.2440665679

    8.5224023825

    8.8084870359

    9.1023205278

    9.4039028585

    9.7132340278

    10.0303140357

    10.3551428823

    10.6877205676

    11.0280470915

    11.3761224541

    11.7319466553

    12.0955196952

    12.4668415738

    12.845912291

    13.2327318468

    13.6273002413

    14.0296174745

    14.4396835463

    14.8574984568

    15.2830622059

    15.7163747937

    16.1574362202

    16.6062464853

    17.062805589

    17.5271135314

    17.9991703125

    18.4789759322

    18.9665303906

    19.4618336876

    19.9648858233

    20.4756867977

    20.9942366107

    21.5205352623

    22.0545827527

    22.5963790816

    23.1459242493

    23.7032182555

    24.2682611005

    24.8410527841

    25.4215933063

    26.0098826672

    26.6059208668

    27.209707905

    27.8212437819

    28.4405284974

    29.0675620516

    Chart3

    1.10.396025

    1.7051.49489

    6.886.989215

    8.25166666678.8206566667

    9.5159.7363775

    9.8110.28581

    11.428333333310.6520983333

    11.086428571410.9137328571

    10.8711.10995875

    12.153888888911.2625788889

    10.93511.384675

    012.48354

    f

    g

    Sheet1

    efg

    04.6186671.10.40

    11.715.46-0.5911.711.49

    26.886.31-0.240.56.886.99

    38.257.15-0.830.33333333338.258.82

    49.528.000.030.259.529.74

    59.818.84-0.380.29.8110.29

    611.439.692.190.166666666711.4310.65

    711.0910.531.030.142857142911.0910.91

    810.8711.380.240.12510.8711.11

    912.1512.222.530.111111111112.1511.26

    1010.9413.07-0.130.110.9411.38

    0.5012.48354

    -629.1718.454.493.060.970.980.180.000.140.670.22

    -6.0528.5418.024.393.000.950.960.190.000.140.680.21

    -6.127.9217.604.282.940.920.940.200.000.140.690.21

    -6.1527.3117.184.182.880.900.920.210.000.130.700.20

    -6.226.7016.774.082.830.870.900.210.000.130.710.20

    -6.2526.1116.363.982.770.850.880.220.000.120.720.19

    -6.325.5215.963.882.720.830.860.230.000.120.730.19

    -6.3524.9315.563.782.660.810.850.240.000.110.740.18

    -6.424.3615.173.692.610.780.830.250.000.110.750.18

    -6.4523.7914.783.592.550.760.810.250.000.100.760.18

    -6.523.2314.403.502.500.740.790.260.000.100.770.17

    -6.5522.6814.033.402.450.720.770.270.000.100.780.17

    -6.622.1413.653.312.400.700.760.280.000.090.790.16

    -6.6521.6113.293.222.350.680.740.290.000.090.800.16

    -6.721.0812.923.132.300.660.720.300.000.090.810.16

    -6.7520.5612.573.052.250.640.710.310.000.080.820.15

    -6.820.0512.222.962.200.620.690.320.000.080.830.15

    -6.8519.5411.872.872.150.600.670.320.000.070.840.14

    -6.919.0511.532.792.100.580.660.330.010.070.850.14

    -6.9518.5611.192.712.050.560.640.340.010.070.860.14

    -718.0810.862.622.000.540.620.350.010.070.870.13

    -7.0517.6010.532.541.960.520.610.360.010.060.880.13

    -7.117.1410.212.461.910.500.590.370.010.060.890.13

    -7.1516.689.892.391.860.490.580.380.010.060.900.12

    -7.216.239.582.311.820.470.560.390.010.050.910.12

    -7.2515.799.272.241.770.450.550.410.010.050.920.12

    -7.315.358.972.161.730.440.530.420.020.050.930.11

    -7.3514.938.672.091.690.420.520.430.020.040.940.11

    -7.414.518.382.021.640.400.500.440.020.040.950.11

    -7.4514.098.091.951.600.390.490.450.020.040.960.10

    -7.513.697.811.881.560.370.480.460.020.040.970.10

    -7.5513.307.541.811.520.360.460.470.030.030.990.10

    -7.612.917.261.741.480.340.450.480.030.031.000.09

    -7.6512.537.001.681.440.330.440.490.030.031.010.09

    -7.712.156.731.611.400.310.420.510.030.031.020.09

    -7.7511.796.481.551.360.300.410.520.040.031.030.08

    -7.811.436.231.491.320.290.400.530.040.021.040.08

    -7.8511.085.981.431.280.270.380.540.040.021.050.08

    -7.910.745.741.371.240.260.370.560.050.021.060.08

    -7.9510.415.501.311.210.250.360.570.050.021.080.07

    -810.085.271.251.170.240.350.580.050.021.090.07

    -8.059.765.041.201.130.220.340.590.060.021.100.07

    -8.19.454.821.141.100.210.320.610.060.011.110.07

    -8.159.154.601.091.060.200.310.620.060.011.120.06

    -8.28.864.391.041.030.190.300.630.070.011.130.06

    -8.258.574.180.991.000.180.290.650.070.011.150.06

    -8.38.293.980.940.960.170.280.660.070.011.160.06

    -8.358.023.780.890.930.160.270.670.080.011.170.05

    -8.47.753.590.850.900.150.260.690.080.011.180.05

    -8.457.503.400.800.870.140.250.700.090.011.190.05

    -8.57.253.220.760.840.130.240.710.090.001.210.05

    -8.557.013.050.710.810.120.230.730.090.001.220.04

    -8.66.772.870.670.780.110.220.740.100.001.230.04

    -8.656.552.710.630.750.100.210.760.100.001.240.04

    -8.76.332.540.590.720.100.200.770.110.001.260.04

    -8.756.122.390.560.690.090.190.790.110.001.270.04

    -8.85.922.240.520.660.080.180.800.120.001.280.03

    -8.855.722.090.480.640.070.180.820.120.001.290.03

    -8.95.541.950.450.610.070.170.830.130.001.310.03

    -8.955.361.810.420.590.060.160.850.130.001.320.03

    -95.191.680.380.560.060.150.860.140.001.330.03

    -9.055.021.550.350.540.050.140.880.140.001.340.03

    -9.14.871.430.320.510.040.140.890.150.001.360.02

    -9.154.721.310.300.490.040.130.910.150.001.370.02

    -9.24.581.200.270.460.030.120.920.160.001.380.02

    -9.254.451.090.250.440.030.120.940.170.001.400.02

    -9.34.320.990.220.420.030.110.960.170.001.410.02

    -9.354.210.890.200.400.020.100.970.180.001.420.02

    -9.44.100.800.180.380.020.100.990.180.001.440.02

    -9.454.000.710.160.360.020.091.010.190.001.450.01

    -9.53.900.630.140.340.010.081.020.200.001.460.01

    -9.553.820.560.120.320.010.081.040.200.001.480.01

    -9.63.740.480.100.300.010.071.060.210.001.490.01

    -9.653.670.420.090.280.010.071.070.220.011.500.01

    -9.73.610.350.070.270.000.061.090.220.011.520.01

    -9.753.550.300.060.250.000.061.110.230.011.530.01

    -9.83.500.250.050.230.000.051.130.240.011.540.01

    -9.853.460.200.040.220.000.051.140.240.011.560.01

    -9.93.430.160.030.200.000.041.160.250.011.570.01

    -9.953.410.120.020.190.000.041.180.260.011.590.00

    -103.390.090.010.170.000.041.200.270.011.600.00

    -10.053.380.060.010.160.000.031.220.270.021.610.00

    -10.13.380.040.000.150.000.031.240.280.021.630.00

    -10.153.390.020.000.130.000.031.250.290.021.640.00

    -10.23.410.010.000.120.000.021.270.300.021.660.00

    -10.253.430.000.000.110.010.021.290.300.021.670.00

    -10.33.460.000.000.100.010.021.310.310.021.690.00

    -10.353.500.000.000.090.010.011.330.320.031.700.00

    -10.43.540.010.010.080.010.011.350.330.031.710.00

    -10.453.600.020.010.070.020.011.370.340.031.730.00

    -10.53.660.040.020.060.020.011.390.340.031.740.00

    -10.553.730.070.020.050.020.011.410.350.041.760.00

    -10.63.800.090.030.050.030.001.430.360.041.770.00

    -10.653.890.130.040.040.030.001.450.370.041.790.00

    -10.73.980.160.050.030.040.001.470.380.041.800.00

    -10.754.080.210.070.030.040.001.490.390.051.820.00

    -10.84.190.260.080.020.050.001.510.400.051.830.00

    -10.854.300.310.090.020.050.001.530.410.051.850.00

    -10.94.430.370.110.010.060.001.550.410.051.860.00

    -10.954.560.430.130.010.060.001.570.420.061.880.00

    -114.700.500.140.010.070.001.590.430.061.890.00

    -11.054.840.570.160.000.080.001.610.440.061.910.00

    -11.15.000.650.180.000.080.001.630.450.071.920.00

    -11.155.160.730.210.000.090.001.660.460.071.940.00

    -11.25.330.820.230.000.100.001.680.470.071.960.00

    -11.255.510.910.260.000.110.001.700.480.081.970.00

    -11.35.691.010.280.000.120.001.720.490.081.990.00

    -11.355.891.110.310.000.120.011.740.500.082.000.00

    -11.46.091.220.340.000.130.011.760.510.092.020.01

    -11.456.301.330.370.000.140.011.790.520.092.030.01

    -11.56.511.450.400.010.150.011.810.530.092.050.01

    -11.556.741.580.430.010.160.011.830.540.102.070.01

    -11.66.971.700.460.010.170.021.850.550.102.080.01

    -11.657.211.840.500.020.180.021.880.560.112.100.01

    -11.77.461.970.530.020.190.021.900.570.112.110.01

    -11.757.712.120.570.030.200.031.920.590.112.130.01

    -11.87.972.270.610.030.220.031.950.600.122.150.01

    -11.858.242.420.650.040.230.031.970.610.122.160.01

    -11.98.522.580.690.050.240.041.990.620.132.180.02

    -11.958.812.740.730.060.250.042.020.630.132.200.02

    -129.102.910.770.060.270.042.040.640.142.210.02

    -12.059.403.080.820.070.280.052.060.650.142.230.02

    -12.19.713.260.860.080.290.052.090.660.152.250.02

    -12.1510.033.440.910.090.310.062.110.680.152.260.02

    -12.210.363.630.960.100.320.062.140.690.162.280.02

    -12.2510.693.821.010.110.330.072.160.700.162.300.03

    -12.311.034.021.060.120.350.072.190.710.172.310.03

    -12.3511.384.221.110.140.360.082.210.720.172.330.03

    -12.411.734.431.170.150.380.082.240.740.182.350.03

    -12.4512.104.641.220.160.390.092.260.750.182.360.03

    -12.512.474.861.280.180.410.102.290.760.192.380.03

    -12.5512.855.091.330.190.430.102.310.770.192.400.04

    -12.613.235.311.390.200.440.112.340.790.202.410.04

    -12.6513.635.551.450.220.460.122.360.800.202.430.04

    -12.714.035.781.510.240.480.122.390.810.212.450.04

    -12.7514.446.031.580.250.490.132.410.820.222.470.04

    -12.814.866.281.640.270.510.142.440.840.222.480.05

    -12.8515.286.531.700.290.530.142.460.850.232.500.05

    -12.915.726.791.770.300.550.152.490.860.232.520.05

    -12.9516.167.051.840.320.570.162.520.880.242.540.05

    -1316.617.321.900.340.590.172.540.890.252.550.06

    -13.0517.067.591.970.360.600.182.570.900.252.570.06

    -13.117.537.872.040.380.620.182.600.920.262.590.06

    -13.1518.008.152.120.400.640.192.620.930.262.610.06

    -13.218.488.442.190.420.660.202.650.950.272.630.07

    -13.2518.978.732.270.450.680.212.680.960.282.640.07

    -13.319.469.032.340.470.710.222.710.970.282.660.07

    -13.3519.969.332.420.490.730.232.730.990.292.680.07

    -13.420.489.642.500.520.750.242.761.000.302.700.08

    -13.4520.999.952.580.540.770.252.791.020.302.720.08

    -13.521.5210.272.660.570.790.262.821.030.312.740.08

    -13.5522.0510.602.740.590.810.272.841.040.322.750.08

    -13.622.6010.922.820.620.840.282.871.060.322.770.09

    -13.6523.1511.262.910.640.860.292.901.070.332.790.09

    -13.723.7011.592.990.670.880.302.931.090.342.810.09

    -13.7524.2711.943.080.700.910.312.961.100.352.830.10

    -13.824.8412.293.170.730.930.322.991.120.352.850.10

    -13.8525.4212.643.260.750.960.343.021.130.362.870.10

    -13.926.0113.003.350.780.980.353.051.150.372.880.11

    -13.9526.6113.363.440.811.010.363.071.160.382.900.11

    -1427.2113.733.530.841.030.373.101.180.382.920.11

    -14.0527.8214.103.630.871.060.383.131.200.392.940.12

    -14.128.4414.483.720.911.080.403.161.210.402.960.12

    -14.1529.0714.863.820.941.110.413.191.230.412.980.12

    Sheet2

    Sheet3

  • *

    . reg Y X

    Source | SS df MS Number of obs = 10---------+------------------------------ F( 1, 8) = 17.44 Model | 58.8774834 1 58.8774834 Prob > F = 0.0031Residual | 27.003764 8 3.3754705 R-squared = 0.6856---------+------------------------------ Adj R-squared = 0.6463 Total | 85.8812475 9 9.54236083 Root MSE = 1.8372

    ------------------------------------------------------------------------------ Y | Coef. Std. Err. t P>|t| [95% Conf. Interval]---------+-------------------------------------------------------------------- X | .8447878 .2022741 4.176 0.003 .378343 1.311233 _cons | 4.618667 1.255078 3.680 0.006 1.724453 7.512881------------------------------------------------------------------------------

    . X , R2 . ?Y=4,6+0,84*X

  • *

    , .XY

    Chart1

    04.618667

    1.7055.4634548

    6.886.3082426

    8.25166666677.1530304

    9.5157.9978182

    9.818.842606

    11.42833333339.6873938

    11.086428571410.5321816

    10.8711.3769694

    12.153888888912.2217572

    10.93513.066545

    Chart2

    29.1690094923

    28.5407311843

    27.9202017149

    27.3074210841

    26.702389292

    26.1051063386

    25.5155722238

    24.9337869477

    24.3597505102

    23.7934629114

    23.2349241512

    22.6841342297

    22.1410931469

    21.6058009027

    21.0782574972

    20.5584629303

    20.0464172021

    19.5421203125

    19.0455722616

    18.5567730493

    18.0757226757

    17.6024211408

    17.1368684445

    16.6790645869

    16.2290095679

    15.7867033876

    15.3521460459

    14.9253375429

    14.5062778786

    14.0949670529

    13.6914050658

    13.2955919174

    12.9075276077

    12.5272121366

    12.1546455042

    11.7898277105

    11.4327587554

    11.0834386389

    10.7418673611

    10.408044922

    10.0819713215

    9.7636465597

    9.4530706365

    9.150243552

    8.8551653061

    8.5678358989

    8.2882553304

    8.0164236005

    7.7523407092

    7.4960066567

    7.2474214427

    7.0065850675

    6.7734975309

    6.5481588329

    6.3305689736

    6.120727953

    5.918635771

    5.7242924276

    5.537697923

    5.3588522569

    5.1877554296

    5.0244074409

    4.8688082908

    4.7209579794

    4.5808565067

    4.4485038726

    4.3239000772

    4.2070451204

    4.0979390023

    3.9965817228

    3.902973282

    3.8171136798

    3.7390029164

    3.6686409915

    3.6060279053

    3.5511636578

    3.5040482489

    3.4646816787

    3.4330639472

    3.4091950542

    3.393075

    3.3847037844

    3.3840814075

    3.3912078692

    3.4060831696

    3.4287073086

    3.4590802863

    3.4972021026

    3.5430727576

    3.5966922513

    3.6580605836

    3.7271777546

    3.8040437642

    3.8886586124

    3.9810222994

    4.081134825

    4.1889961892

    4.3046063921

    4.4279654337

    4.5590733139

    4.6979300328

    4.8445355903

    4.9988899865

    5.1609932213

    5.3308452948

    5.5084462069

    5.6937959577

    5.8868945472

    6.0877419753

    6.2963382421

    6.5126833475

    6.7367772916

    6.9686200743

    7.2082116957

    7.4555521558

    7.7106414545

    7.9734795918

    8.2440665679

    8.5224023825

    8.8084870359

    9.1023205278

    9.4039028585

    9.7132340278

    10.0303140357

    10.3551428823

    10.6877205676

    11.0280470915

    11.3761224541

    11.7319466553

    12.0955196952

    12.4668415738

    12.845912291

    13.2327318468

    13.6273002413

    14.0296174745

    14.4396835463

    14.8574984568

    15.2830622059

    15.7163747937

    16.1574362202

    16.6062464853

    17.062805589

    17.5271135314

    17.9991703125

    18.4789759322

    18.9665303906

    19.4618336876

    19.9648858233

    20.4756867977

    20.9942366107

    21.5205352623

    22.0545827527

    22.5963790816

    23.1459242493

    23.7032182555

    24.2682611005

    24.8410527841

    25.4215933063

    26.0098826672

    26.6059208668

    27.209707905

    27.82124...

Recommended

View more >