Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    4 12 4

    Uploaded by

    trangtran.091103

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    4 12 4

    Uploaded by

    trangtran.091103
    7 views4 pages

    Original Title

    4.12.4

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    7 views4 pages

    4 12 4

    Uploaded by

    trangtran.091103

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    Sample item Number Y X X1 X2 X3 X4 X5 X6

    1 67.2 1 19.7 60.5 70.3 65.7 69.3 65.7


    2 69.1 1 19.6 64.9 70.4 62.6 69.6 64.6
    3 67 1 19.4 65.4 65.8 66.2 68.8 64
    4 72.4 1 19.4 63.4 71.9 60.7 68 64.9
    5 63.6 1 19.7 65.1 65.1 65.5 65.5 61.8
    6 72.7 1 19.6 65.2 71.1 63.5 66.2 67.3
    7 68.5 1 19.8 64.3 67.9 62.4 71.4 63.4
    8 69.7 1 19.7 65.3 68.8 61.5 66 62.4
    9 68.4 1 19.7 64.5 68.7 63.9 68.8 62.3
    10 70.4 1 19.9 63.4 70.3 65.9 69 63.7
    11 67.5 1 18.9 63.3 70.4 63.7 68.2 66.2
    12 73.3 1 20.8 66.2 70.2 65.4 66.6 61.7
    13 70 1 20.3 64.9 68.8 65.2 70.2 62.4
    14 69.8 1 19.7 63.5 70.3 63.1 64.4 65.1
    15 63.6 1 19.9 62 65.5 64.1 67.7 62.1
    16 64.3 1 19.6 63.5 65.2 63.9 70 64.2
    17 68.5 1 21.3 66.1 65.4 64.8 68.4 66.4
    18 70.5 1 20.1 64.8 70.2 65.3 65.5 63.7
    19 68.1 1 20.2 62.6 68.6 63.7 69.8 66.7
    20 66.1 1 19.2 62.2 67.3 63.6 70.9 63.6

    X chuyển vị
    1 1 1 1 1 1 1 1 1
    19.7 19.6 19.4 19.4 19.7 19.6 19.8 19.7 19.7
    60.5 64.9 65.4 63.4 65.1 65.2 64.3 65.3 64.5
    70.3 70.4 65.8 71.9 65.1 71.1 67.9 68.8 68.7
    65.7 62.6 66.2 60.7 65.5 63.5 62.4 61.5 63.9
    69.3 69.6 68.8 68 65.5 66.2 71.4 66 68.8
    65.7 64.6 64 64.9 61.8 67.3 63.4 62.4 62.3
    67.3 66.4 69.4 67.1 70.9 68.6 69.4 67.7 68.8

    X^T.X
    20 396.5 1281.1 1372.2 1280.7 1364.3 1282.2 1350.6
    396.5 7866.03 25404.18 27199.86 25394.91 27045.48 25418.18 26775.67
    1281.1 25404.18 82102.11 87890.65 82037.71 87372.58 82120.71 86525.33
    1372.2 27199.86 87890.65 94237.82 87849.96 93588.2 87993.43 92639.38
    1280.7 25394.91 82037.71 87849.96 82052.01 87362.06 82098.17 86485.55
    1364.3 27045.48 87372.58 93588.2 87362.06 93138.33 87469.59 92126.27
    1282.2 25418.18 82120.71 87993.43 82098.17 87469.59 82258.14 86600.31
    1350.6 26775.67 86525.33 92639.38 86485.55 92126.27 86600.31 91270.78
    MatrixC= (X^T.X)^-1
    721.671 -1.493897 -2.019689 -2.062407 -2.279163 -2.029595 -0.556588 -1.496427
    -1.493897 0.269123 -0.047293 0.010882 -0.026724 -0.000925 -0.013543 0.016051
    -2.019689 -0.047293 0.039407 -0.002841 0.003892 0.00656 0.009773 -0.010296
    -2.062407 0.010882 -0.002841 0.018311 0.005505 0.005016 -0.009336 0.010014
    -2.279163 -0.026724 0.003892 0.005505 0.029277 0.001907 0.001378 0.001315
    -2.029595 -0.000925 0.00656 0.005016 0.001907 0.016807 -0.002331 0.002435
    -0.556588 -0.013543 0.009773 -0.009336 0.001378 -0.002331 0.025837 -0.011046
    -1.496427 0.016051 -0.010296 0.010014 0.001315 0.002435 -0.011046 0.023819
    X7
    67.3 SUMMARY OUTPUT
    66.4
    69.4 Regression Statistics
    67.1 Multiple R 0.9576326197
    70.9 R Square 0.9170602343
    68.6 Adjusted R Square 0.8686787043
    69.4 Standard Error 1.0036640216
    67.7 Observations 20
    68.8
    65.1 ANOVA
    68.5 df SS MS F
    64 Regression 7 133.6574023815 19.0939146 18.954758866
    67 Residual 12 12.08809761846 1.00734147
    67 Total 19 145.7455
    66.5
    64.5 Coefficients Standard Error t Stat P-value
    70.8 Intercept -78.268377791 26.9623650997 -2.90287508 0.0132553407
    66.9 X1 1.3718162171 0.520671589245 2.63470534 0.0217856493
    68 X2 0.7824229175 0.199239064746 3.92705576 0.0020093351
    66.7 X3 1.0514126519 0.135813162543 7.74161084 5.2534754E-06
    X4 -0.1199140253 0.171732690727 -0.69825975 0.4983232426
    X5 0.091436164 0.130116618358 0.70272472 0.4956342626
    X6 0.0883431364 0.161326816207 0.54760354 0.5940033069
    X7 -0.1017429667 0.154898103311 -0.65683804 0.523682534

    1 1 1 1 1 1 1
    19.9 18.9 20.8 20.3 19.7 19.9 19.6
    63.4 63.3 66.2 64.9 63.5 62 63.5
    70.3 70.4 70.2 68.8 70.3 65.5 65.2
    65.9 63.7 65.4 65.2 63.1 64.1 63.9
    69 68.2 66.6 70.2 64.4 67.7 70
    63.7 66.2 61.7 62.4 65.1 62.1 64.2
    65.1 68.5 64 67 67 66.5 64.5
    Significance F
    1.349937E-05

    Lower 95% Upper 95% Lower 99.0% Upper 99.0%


    -137.0143248 -19.5224308 -160.6259894 4.0892338294
    0.237370278 2.506262156 -0.218595765 2.9622281995
    0.348318287 1.216527548 0.1738393065 1.3910065285
    0.755501191 1.347324113 0.6365659702 1.4662593337
    -0.494087415 0.254259365 -0.644478328 0.4046502773
    -0.192063593 0.374935921 -0.306010198 0.488882526
    -0.263157801 0.439844073 -0.404436011 0.5811222833
    -0.439236941 0.235751008 -0.574885356 0.3713994222

    1 1 1 1
    21.3 20.1 20.2 19.2
    66.1 64.8 62.6 62.2
    65.4 70.2 68.6 67.3
    64.8 65.3 63.7 63.6
    68.4 65.5 69.8 70.9
    66.4 63.7 66.7 63.6
    70.8 66.9 68 66.7

    You might also like