This recalculates the Multiple Regression and also obtains Confidence Intervals for the Yhat(i), using a VBA macro.
The information in this immediate block gives basic data details, and the addresses of input and out information used by the VBA Macro
NumObns
53
XYStartPosn
B9
ANOVAStartPosn
U9
NumPars
15
BStartPosn
B70
NumFcasts
6
CIStartPosn
R9
Data Anal
ysed
t
DEOM
AAA
3to4
D3to4
D1
D2
D3
D4
D5
D6
D7
D8
D9
D10
D11
Yhat
CILower
CIUpper
SE(Yhat)
ANOVA
SS
DF
MS
F Ratio
P(>F)
1
1.146
5.94
5.31
0.29
1
0
0
0
0
0
0
0
0
0
0
1.839074
1.146
1.146
Regressio
n
443.4056
14
31.67183
21.27109
9.39E-14
2
-2.443
6
5.6
-0.11
0
1
0
0
0
0
0
0
0
0
0
-2.1411
-2.443
-2.443
Error
56.58052
38
1.488961
3
1.497
6.08
5.49
0.31
0
0
1
0
0
0
0
0
0
0
0
0.89819
1.497
1.497
Total
499.9861
52
4
-0.132
6.17
5.8
-0.19
0
0
0
1
0
0
0
0
0
0
0
-0.6291
-0.132
-0.132
RSquared
0.886836
5
2.025
6.14
5.61
-0.33
0
0
0
0
1
0
0
0
0
0
0
1.803174
2.025
2.025
BHat
SEofBHat
Tvalue
P(>|t|)
Variable
6
0.737
6.09
5.28
-0.09
0
0
0
0
0
1
0
0
0
0
0
0.474739
0.737
0.737
-2.19831
1.989379
-1.10502
0.276097
b0
7
-1.023
5.87
5.19
-0.01
0
0
0
0
0
0
1
0
0
0
0
-0.81216
-1.023
-1.023
3.298838
0.324754
10.15796
2.2E-12
AAA
8
-0.956
5.84
5.18
0.12
0
0
0
0
0
0
0
1
0
0
0
-2.09505
-0.956
-0.956
-2.75244
0.228893
-12.025
1.6E-14
3to4
9
0.385
5.99
5.3
-0.07
0
0
0
0
0
0
0
0
1
0
0
1.2265
0.385
0.385
-1.73077
0.553477
-3.12708
0.00338
D3to4
10
0.983
6.12
5.23
0.41
0
0
0
0
0
0
0
0
0
1
0
0.409482
0.983
0.983
-0.44032
0.821148
-0.53623
0.594926
D1
11
5.092
6.42
5.64
-0.02
0
0
0
0
0
0
0
0
0
0
1
4.932941
5.092
5.092
-4.51252
0.83224
-5.42214
3.53E-06
D2
12
3.649
6.48
5.62
0.05
0
0
0
0
0
0
0
0
0
0
0
3.622897
3.649
3.649
-1.31299
0.855084
-1.53551
0.132944
D3
13
2.703
6.52
5.67
0.16
1
0
0
0
0
0
0
0
0
0
0
2.98652
2.703
2.703
-3.1493
0.837743
-3.75927
0.000573
D4
14
-0.271
6.64
5.83
-0.3
0
1
0
0
0
0
0
0
0
0
0
-0.33406
-0.271
-0.271
-1.38333
0.82691
-1.67289
0.102563
D5
15
2.055
6.75
5.53
0.23
0
0
1
0
0
0
0
0
0
0
0
3.136775
2.055
2.055
-3.03975
0.86746
-3.50419
0.001191
D6
16
-0.714
6.73
5.76
0.33
0
0
0
1
0
0
0
0
0
0
0
0.428348
-0.714
-0.714
-3.71016
0.86499
-4.28926
0.000119
D7
17
0.653
6.89
6.09
0.43
0
0
0
0
1
0
0
0
0
0
0
1.640749
0.653
0.653
-4.69661
0.863954
-5.43618
3.38E-06
D8
18
-0.034
6.98
6.52
0.16
0
0
0
0
0
1
0
0
0
0
0
-0.43501
-0.034
-0.034
-1.86844
0.863371
-2.16412
0.036806
D9
19
-1.058
6.98
6.68
0.39
0
0
0
0
0
0
1
0
0
0
0
-1.9439
-1.058
-1.058
-2.47621
0.88324
-2.80355
0.007916
D10
20
-2.051
7.1
7.07
0.05
0
0
0
0
0
0
0
1
0
0
0
-3.01947
-2.051
-2.051
1.44187
0.869402
1.658462
0.105458
D11
21
1.451
7.19
7.12
0.13
0
0
0
0
0
0
0
0
1
0
0
-0.17049
1.451
1.451
22
-0.989
7.29
7.25
0.6
0
0
0
0
0
0
0
0
0
1
0
-1.61966
-0.989
-0.989
23
1.358
7.65
7.85
0.17
0
0
0
0
0
0
0
0
0
0
1
2.57877
1.358
1.358
24
0.746
7.75
8.02
-0.15
0
0
0
0
0
0
0
0
0
0
0
1.552714
0.746
0.746
25
1.855
7.72
7.87
-0.73
1
0
0
0
0
0
0
0
0
0
0
2.430136
1.855
1.855
26
-1.894
7.67
7.14
0.06
0
1
0
0
0
0
0
0
0
0
0
-1.16503
-1.894
-1.894
27
0.781
7.66
7.2
0.39
0
0
1
0
0
0
0
0
0
0
0
1.265217
0.781
0.781
28
-0.161
7.89
7.59
0.15
0
0
0
1
0
0
0
0
0
0
0
-0.47043
-0.161
-0.161
29
2.233
8.14
7.74
-0.23
0
0
0
0
1
0
0
0
0
0
0
2.365073
2.233
2.233
30
2.425
8.21
7.51
-0.05
0
0
0
0
0
1
0
0
0
0
0
1.2611
2.425
2.425
31
2.169
8.05
7.46
-0.37
0
0
0
0
0
0
1
0
0
0
0
0.754337
2.169
2.169
32
0.982
7.94
7.09
-0.27
0
0
0
0
0
0
0
1
0
0
0
0.250347
0.982
0.982
33
4.708
7.88
6.82
-0.6
0
0
0
0
0
0
0
0
1
0
0
4.194898
4.708
4.708
34
6.063
7.79
6.22
-0.61
0
0
0
0
0
0
0
0
0
1
0
4.959006
6.063
6.063
35
9.382
7.41
5.61
-0.13
0
0
0
0
0
0
0
0
0
0
1
8.471748
9.382
9.382
36
9.304
7.18
5.48
-0.7
0
0
0
0
0
0
0
0
0
0
0
7.615499
9.304
9.304
37
10.69
7.15
4.78
-0.64
1
0
0
0
0
0
0
0
0
0
0
8.899074
10.69
10.69
38
6.531
7.27
4.14
0.5
0
1
0
0
0
0
0
0
0
0
0
5.011224
6.531
6.531
39
7.873
7.37
4.64
0.88
0
0
1
0
0
0
0
0
0
0
0
6.50673
7.873
7.873
40
3.882
7.54
5.52
0.43
0
0
0
1
0
0
0
0
0
0
0
3.587916
3.882
3.882
41
4.96
7.58
5.95
0.25
0
0
0
0
1
0
0
0
0
0
0
4.613826
4.96
4.96
42
1.301
7.62
6.2
-0.17
0
0
0
0
0
1
0
0
0
0
0
3.128176
1.301
1.301
43
1.154
7.58
6.03
-0.43
0
0
0
0
0
0
1
0
0
0
0
3.243721
1.154
1.154
44
0.116
7.48
5.6
-0.34
0
0
0
0
0
0
0
1
0
0
0
2.955174
0.116
0.116
45
4.928
7.35
5.26
-0.3
0
0
0
0
0
0
0
0
1
0
0
6.221093
4.928
4.928
46
2.53
7.19
4.96
0.32
0
0
0
0
0
0
0
0
0
1
0
4.838167
2.53
2.53
47
8.425
7.19
5.28
0.09
0
0
0
0
0
0
0
0
0
0
1
8.273541
8.425
8.425
48
5.291
7.11
5.37
0.16
0
0
0
0
0
0
0
0
0
0
0
6.198891
5.291
5.291
49
5.192
7.16
5.53
0.19
1
0
0
0
0
0
0
0
0
0
0
5.431196
5.192
5.192
50
0.257
7.22
5.72
0.32
0
1
0
0
0
0
0
0
0
0
0
0.808962
0.257
0.257
51
4.402
7.36
6.04
-0.38
0
0
1
0
0
0
0
0
0
0
0
4.801088
4.402
4.402
52
3.173
7.34
5.66
0.09
0
0
0
1
0
0
0
0
0
0
0
3.131267
3.173
3.173
53
5.104
7.3
5.75
0.07
0
0
0
0
1
0
0
0
0
0
0
4.552178
5.104
5.104
54
2.700508
7.30493591
5.812940161
0.092128127
0
0
0
0
0
1
0
0
0
0
0
2.700508
0.440862
4.960153
1.373728
55
2.18555
7.307684166
5.743955826
0.117252066
0
0
0
0
0
0
1
0
0
0
0
2.18555
-0.08696
4.458064
1.381552
56
1.354563
7.310432422
5.674971491
0.142376006
0
0
0
0
0
0
0
1
0
0
0
1.354563
-0.92108
3.630207
1.383455
57
4.33819
7.313180677
5.605987156
0.167499945
0
0
0
0
0
0
0
0
1
0
0
4.33819
2.050192
6.626188
1.390965
58
3.885878
7.315928933
5.537002821
0.192623884
0
0
0
0
0
0
0
0
0
1
0
3.885878
1.630023
6.141732
1.371423
59
7.959415
7.318677189
5.468018487
0.217747823
0
0
0
0
0
0
0
0
0
0
1
7.959415
5.690099
10.22873
1.379607