Expected Loss (Y) vs. Insured Value (X3)
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.880409749
R Square 0.775121327
Adjusted R Square 0.756381437
Standard Error 10097910.68
Observations 14
ANOVA
  df SS MS F Significance F
Regression 1 4.2176E+15 4.2176E+15 41.36211 3.24852E-05
Residual 12 1.22361E+15 1.01968E+14
Total 13 5.44122E+15      
  Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 3652037.556 4978606.76 0.733546097 0.477313 -7195414.54 14499489.65
Insured Value 0.368429276 0.057286568 6.431337943 3.25E-05 0.24361257 0.493245983
RESIDUAL OUTPUT
Observation Predicted Expected Loss Residuals
1 4122051.81 -3144337.133
2 8188190.754 -2445445.67
3 15521617.44 129750.999
4 16350760.71 -1776245.881
5 17154064.57 -4345259.39
6 23621224.68 4223549.533
7 27543198.72 13544565.12
8 30577497.87 17827578.83
9 32434541.69 -13398412.53
10 38626134.21 -6632884.853
11 43839500.03 -11489406.7
12 49965566.11 10682619.87
13 58288230.93 8207269.534
14 61588460.12 -11383341.73