19 1 2021

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 16

Y X1 X2

68 78 73
75 74 76
85 82 79
94 90 96
86 87 90 a2 a1 a0
90 90 92 0.672036 0.488338 -14.50054
86 83 95 0.179283 0.232993 9.235645
68 72 69 R^2 0.88632 3.952548 #N/A
55 68 67 74.06756 19 #N/A
69 69 70 2314.261 296.83 #N/A
91 91 89
75 79 75
81 89 84
91 93 97
80 87 77
94 91 96
94 86 94
97 91 92
79 81 82
84 80 83
65 70 66
83 79 81
r2
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.941445
R Square 0.88632
Adjusted R Square 0.874353
Standard Error 3.952548
Observations 22

ANOVA
df SS MS F Significance F
Regression 2 2314.261 1157.13 74.06756 1.069E-09
Residual 19 296.83 15.62263
Total 21 2611.091

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -14.50054 9.235645 -1.570062 0.132905 -33.83097 4.82989 -33.83097 4.82989
X1 0.488338 0.232993 2.095936 0.049713 0.000679 0.975997 0.000679 0.975997
X2 0.672036 0.179283 3.748459 0.001361 0.296792 1.04728 0.296792 1.04728
Upper 95.0%
Y X1 X2 X3
21 2841 29 12
53 1876 21 8
60 2934 62 10
184 1552 18 10
263 3065 40 11 -132.8314 -9.623804 0.361459
281 3670 50 11 44.17901 4.001748 0.134556
354 2005 65 5 0.499522 255.3091 #N/A
401 3215 44 8 3.659656 11 #N/A
515 1930 17 8 715639.4 717010.4 #N/A
633 2010 70 6
677 3111 20 9
710 2882 29 9
800 1683 15 5
914 1817 14 7
997 4066 33 12
1024.182
304.2673
#N/A SUMMARY OUTPUT
#N/A
#N/A Regression Statistics
Multiple R 0.706768
R Square 0.499522
Adjusted R 0.363027
Standard E 255.3091
Observatio 15

ANOVA
df SS MS F Significance F
Regression 3 715639.4 238546.5 3.659656 0.047525
Residual 11 717010.4 65182.76
Total 14 1432650

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%
Intercept 1024.182 304.2673 3.36606 0.006296 354.4941 1693.87
X1 0.361459 0.134556 2.686309 0.021168 0.065303 0.657615
X2 -9.623804 4.001748 -2.4049 0.034928 -18.43159 -0.816016
X3 -132.8314 44.17901 -3.006662 0.011937 -230.0687 -35.59402
Lower 95.0%
Upper 95.0%
354.4941 1693.87
0.065303 0.657615
-18.43159 -0.816016
-230.0687 -35.59402
Y X1 X2 1/X1
68 78 73 0.012821
75 74 76 0.013514 a1 a2 a0
85 82 79 0.012195 -3399.605 0.642694 69.81575
94 90 96 0.011111 1432.328 0.17283 30.95504
86 87 90 0.011494 r2 0.892044 3.851743 #N/A
90 90 92 0.011111 78.49894 19 #N/A
86 83 95 0.012048 2329.208 281.8825 #N/A
68 72 69 0.013889
55 68 67 0.014706
69 69 70 0.014493
91 91 89 0.010989
75 79 75 0.012658
81 89 84 0.011236
91 93 97 0.010753
80 87 77 0.011494
94 91 96 0.010989
94 86 94 0.011628
97 91 92 0.010989
79 81 82 0.012346
84 80 83 0.0125
65 70 66 0.014286
83 79 81 0.012658
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.944481
R Square 0.892044
Adjusted R 0.88068
Standard E 3.851743
Observatio 22

ANOVA
df SS MS F Significance F
Regression 2 2329.208 1164.604 78.49894 6.544E-10
Residual 19 281.8825 14.83592
Total 21 2611.091

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept 69.81575 30.95504 2.255392 0.036095 5.026101 134.6054 5.026101 134.6054
X2 0.642694 0.17283 3.718653 0.001456 0.280957 1.00443 0.280957 1.00443
1/X1 -3399.605 1432.328 -2.373482 0.028322 -6397.502 -401.7077 -6397.502 -401.7077
Upper 95.0%
Y X1 X2 X3 1/x1 ln x2 x3^2
21 2841 29 12 0.000352 3.367296 144
53 1876 21 8 0.000533 3.044522 64 -5.502813
60 2934 62 10 0.000341 4.127134 100 2.647321
184 1552 18 10 0.000644 2.890372 100 0.368163
263 3065 40 11 0.000326 3.688879 121 2.136514
281 3670 50 11 0.000272 3.912023 121 527448
354 2005 65 5 0.000499 4.174387 25
401 3215 44 8 0.000311 3.78419 64
515 1930 17 8 0.000518 2.833213 64
633 2010 70 6 0.000498 4.248495 36
677 3111 20 9 0.000321 2.995732 81
710 2882 29 9 0.000347 3.367296 81
800 1683 15 5 0.000594 2.70805 25
914 1817 14 7 0.00055 2.639057 49
997 4066 33 12 0.000246 3.496508 144
a0
-335.976 -1783589 2808.698
166.4794 929046.4 982.9555
286.8642 #N/A #N/A
11 #N/A #N/A
905201.8 #N/A #N/A

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.606764
R Square 0.368163
Adjusted R 0.195843
Standard E 286.8642
Observatio 15

ANOVA
df SS MS F Significance F
Regression 3 527448 175816 2.136514 0.153529
Residual 11 905201.8 82291.07
Total 14 1432650

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 2808.698 982.9555 2.857401 0.015589 645.2276 4972.169 645.2276 4972.169
1/x1 -1783589 929046.4 -1.919806 0.081179 -3828407 261228.1 -3828407 261228.1
ln x2 -335.976 166.4794 -2.018124 0.068637 -702.3948 30.44269 -702.3948 30.44269
x3^2 -5.502813 2.647321 -2.078634 0.061844 -11.32953 0.323902 -11.32953 0.323902
Upper 95.0%
factor 30 40 50 60 70
m1 5.23 5.11 5.28 5.23 5.3
m2 5.1 5.19 5.19 5.16 5.29 a 0.0061
m3 5.09 5 5.32 5.12 5.23 b 0.0396
m4 5.15 5.1 5.14 5.01 5.18 V 1000
m5 4.99 5.26 5.26 5.03 5.12
m6 5.02 5.14 5.14 5.07 5.14
m7 5.22 5.01 5.33 5.28 5.29
m8 5.18 5.13 5.13 5.19 5.16
OD1 0.745 0.354 0.537 0.536 0.536
OD2 0.549 0.539 0.537 0.535 0.535
OD3 0.583 0.538 0.535 0.534 0.534
OD4 0.545 0.643 0.537 0.537 0.537
OD5 0.55 0.603 0.537 0.598 0.598
OD6 0.582 0.538 0.607 0.574 0.574
OD7 0.597 0.588 0.6 0.535 0.535
OD8 0.595 0.538 0.535 0.572 0.572
y1 2.211077 1.00863 1.544337 1.555967 1.535416
y2 1.637416 1.577435 1.571117 1.573898 1.53522
y3 1.750137 1.634098 1.526562 1.582992 1.549698 n 3
y4 1.608786 1.939569 1.5864 1.627565 1.57415 qtra 0.97
y5 1.676796 1.755906 1.550209 1.8199 1.78791
y6 1.771276 1.58959 1.809657 1.72794 1.704408
y7 1.750518 1.794444 1.723618 1.538127 1.53522
y8 1.757706 1.592688 1.583102 1.68167 1.691447
ytb 1.770464 1.611545 1.611875 1.638507 1.614183
S 0.188122 0.274619 0.100275 0.097856 0.099087
RSD 10.62559 17.04072 6.220986 5.972237 6.138493
Ya 2.211077 1.00863 1.809657 1.8199 1.78791
Qcal 0.730214 0.611001 0.303923 0.326363 0.330452
Qtra 0.526 0.526 0.526 0.526 0.526
y1' 1.544337 1.555967 1.535416
y2' 1.637416 1.577435 1.571117 1.573898 1.53522
y3' 1.750137 1.634098 1.526562 1.582992 1.549698
y4' 1.608786 1.939569 1.5864 1.627565 1.57415
y5' 1.676796 1.755906 1.550209 1.8199 1.78791
y6' 1.771276 1.58959 1.809657 1.72794 1.704408
y7' 1.750518 1.794444 1.723618 1.538127 1.53522
y8' 1.757706 1.592688 1.583102 1.68167 1.691447
y'tb 1.707519 1.697676 1.611875 1.638507 1.614183
4 5 6 7 8 9 10
0.829 0.71 0.625 0.568 0.526 0.493 0.466
factor 30 40 50 60 70 Vm 5
v1 2.5 3.4 5.9 6.1 6.2 k 0.006
v2 2.4 3.5 5.8 6.2 6.3
v3 2.3 3.4 5.7 6.3 6.3
v4 2.5 3.2 5.8 6.2 6.5
v5 2.4 3.3 5.9 6.1 6.4
v6 2.3 3.4 6 6.3 6.4
v7 2.5 3.5 5.8 6.1 6.3
v8 2.4 3.6 5.9 6.4 6.3
TA1 3 4.08 7.08 7.32 7.44
TA2 2.88 4.2 6.96 7.44 7.56
TA3 2.76 4.08 6.84 7.56 7.56
TA4 3 3.84 6.96 7.44 7.8
TA5 2.88 3.96 7.08 7.32 7.68
TA6 2.76 4.08 7.2 7.56 7.68
TA7 3 4.2 6.96 7.32 7.56
TA8 2.88 4.32 7.08 7.68 7.56
Tatb 2.895 4.095 7.02 7.455 7.605
S 0.100143 0.149571 0.111098 0.135119 0.109935
RSD 3.459163 3.652523 1.582598 1.812461 1.445563
Taa 2.76 3.84 7.2 7.68 7.8
Qcal -0.92 0.25 -12.46667 -13.32 -13.53333

You might also like