Scribd
Upload
8 views11 pages

Age vs Cost of Treatment Analysis

The document presents a statistical analysis of treatment costs correlated with age, including regression statistics, ANOVA results, and residual outputs. It provides key metrics such as mean, median, standard deviation, and confidence intervals for both age and treatment costs. Additionally, it includes probability outputs and various plots to visualize the data distribution and regression fit.

Uploaded by

tanushree.bhattacharya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views11 pages

Age vs Cost of Treatment Analysis

The document presents a statistical analysis of treatment costs correlated with age, including regression statistics, ANOVA results, and residual outputs. It provides key metrics such as mean, median, standard deviation, and confidence intervals for both age and treatment costs. Additionally, it includes probability outputs and various plots to visualize the data distribution and regression fit.

Uploaded by

tanushree.bhattacharya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Cost of

[Link] AGE
Treatment
1 22 125966
2 26 128045
3 26.5 128104
4 27.7 128584
5 30 128699
6 31.2 130443
7 8.1 120773 Cost
160000
8 9 121293
9 10 121981 140000
10 12 122339 120000
11 7 122550 100000
12 14 123472
80000
13 11 124223
14 17 125592 AGE Cost of Treatment 60000

15 21 125683 40000
16 32 112346 Mean 28.68333 Mean 128855.1 20000
17 18 121345 Standard E 3.212687 Standard E 1601.32726080801
0
18 45 113290 Median 26 Median 128074.5 0 10 20
19 61 141785 Mode 26 Mode #N/A
20 26 125098 Standard D 17.59661 Standard D 8770.83062692508
21 71 152198 Sample Var 309.6407 Sample Var 76927469.8862069
22 7 130484 Kurtosis -0.269117 Kurtosis 0.78720656718732
23 24 131346 Skewness 0.741327 Skewness 0.611589368105189
24 18 133026 Range 64 Range 39852
25 45 134243 Minimum 7 Minimum 112346
26 39 134648 Maximum 71 Maximum 152198
27 57 135778 Sum 860.5 Sum 3865653
28 40 137693 Count 30 Count 30
29 51 139067 Confidence 6.570683 Confidence 3275.08198055972
30 54 145559
Cost of Treatment
0

0
0 10 20 30 40 50 60 70 80

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.878500223741418
R Square 0.771762643113722
Adjusted R 0.737279884493032
Standard E 62751.9141788538
Observatio 30

ANOVA
df SS
Regression 1 386143721246.803
Residual 29 114196279260.197
Total 30 500340000507

Coefficients Standard Error


Intercept 0 #N/A
AGE 3386.93744710217 342.026428200871

RESIDUAL OUTPUT
Observation
Predicted Cost of Treatment Residuals
1 74512.6238362478 51453.3761637522
2 88060.3736246565 39984.6263753435
3 89753.8423482076 38350.1576517924
4 93818.1672847302 34765.8327152698
5 101608.123413065 27090.8765869348
6 105672.448349588 24770.5516504122
7 27434.1933215276 93338.8066784724
8 30482.4370239196 90810.5629760804
9 33869.3744710217 88111.6255289783
10 40643.2493652261 81695.7506347739
11 23708.5621297152 98841.4378702848
12 47417.1242594304 76054.8757405696
13 37256.3119181239 86966.6880818761
14 57577.9366007369 68014.0633992631
15 71125.6863891456 54557.3136108544
16 108381.99830727 3964.00169273047
17 60964.8740478391 60380.1259521609
18 152412.185119598 -39122.1851195978
19 206603.184273233 -64818.1842732325
20 88060.3736246565 37037.6263753435
21 240472.558744254 -88274.5587442543
22 23708.5621297152 106775.437870285
23 81286.4987304522 50059.5012695479
24 60964.8740478391 72061.1259521609
25 152412.185119598 -18169.1851195978
26 132090.560436985 2557.43956301524
27 193055.434484824 -57277.4344848238
28 135477.497884087 2215.50211591308
29 172733.809802211 -33666.8098022108
30 182894.622143517 -37335.6221435173
AGE Residual Plot
150000

100000

50000
Residuals

0
0 10 20 30 40 50 60 70 80
-50000

-100000
AGE

MS F Significance F
386143721246.803 98.06070731 1.194198618576E-10
3937802733.11023

t Stat P-value Lower 95% Upper 95%Lower 95.0%


Upper 95.0%
#N/A #N/A #N/A #N/A #N/A #N/A
9.90256064397761 8.237749E-11 2687.41485775298 4086.46 2687.415 4086.46

PROBABILITY OUTPUT
Percentile Cost of Treatment
1.666666667 112346
5 113290
8.333333333 120773
11.66666667 121293
15 121345
18.33333333 121981
21.66666667 122339
25 122550
28.33333333 123472
31.66666667 124223
35 125098
38.33333333 125592
41.66666667 125683
45 125966
48.33333333 128045
51.66666667 128104
55 128584
58.33333333 128699
61.66666667 130443
65 130484
68.33333333 131346
71.66666667 133026
75 134243
78.33333333 134648
81.66666667 135778
85 137693
88.33333333 139067
91.66666667 141785
95 145559
98.33333333 152198
AGE Line Fit Plot
300000
Cost of Treatment

200000 Cost of Treatment


Predicted Cost of
100000 Treatment
0
0 10 20 30 40 50 60 70 80
AGE

160000
140000
120000
100000
80000
60000
40000
20000
0
0 20 40 60 80 100 120
Cost of
AGE Treatmen
t
22 125966
26 128045 Cost of Treatment
26.5 128104 Cost of Treatment
27.7 128584 Mean 128855.1 Mean #DIV/0! 160000
30 128699 Standard E 1601.327 Standard E 0
140000
31.2 130443 Median 128074.5 Median #NUM!
8.1 120773 Mode #N/A Mode #N/A 120000

9 121293 Standard D 8770.831 Standard D #DIV/0! 100000


10 121981 Sample Var76927470 Sample Var #DIV/0! 80000
12 122339 Kurtosis 0.787207 Kurtosis #DIV/0!
60000
7 122550 Skewness 0.611589 Skewness #DIV/0!
40000
14 123472 Range 39852 Range 0
11 124223 Minimum 112346 Minimum 0 20000
17 125592 Maximum 152198 Maximum 0 0
0 10 20 30 40 50
21 125683 Sum 3865653 Sum 0
32 112346 Count 30 Count 0
18 121345 Confidence 3275.082 Confidence #NUM!
45 113290
61 141785
26 125098 Normal Probability Plot
71 152198
200000
7 130484
150000
24 131346
100000
18 133026
Y

50000
45 134243
0
39 134648 0 20 40 60 80 100 120
57 135778 Sample Percentile
40 137693
51 139067
54 145559

X Variable 1 Line Fit Plot


200000
150000
100000 Y
Predicted Y
Y

50000
0
0 10 20 30 40 50 60 70 80
X Variable 1
Cost of Treatment

30 40 50 60 70 80
Normal Probability Plot
200000
150000
100000
Y

50000
0
0 20 40 60 80 100 12
SUMMARY OUTPUT Sample Percentile

Regression Statistics
Multiple R 0.699296
R Square 0.489014
Adjusted R 0.470765
Standard E 6380.653
Observatio 30

ANOVA
df SS MS F Significance F
Regression 1 1.09E+09 1.09E+09 26.79605 1.712E-05
Residual 28 1.14E+09 40712727
Total 29 2.23E+09

Coefficients
Standard Error t Stat P-value Lower 95%
Intercept 118857.4 2255.505 52.69657 1.465E-29 114237.2
X Variable 348.5559 67.33441 5.17649 1.712E-05 210.6276
RESIDUAL OUTPUT PROBABILITY OUTPUT

ObservationPredicted Y Residuals Percentile Y


1 126525.6 -559.5847 1.666667 112346
2 127919.8 125.1917 5 113290
3 128094.1 9.91371 8.333333 120773
4 128512.4 71.64663 11.66667 121293
5 129314 -615.0319 15 121345
6 129732.3 710.701 18.33333 121981
7 121680.7 -907.6578 21.66667 122339
8 121994.4 -701.3581 25 122550
9 122342.9 -361.914 28.33333 123472
10 123040 -701.0258 31.66667 124223
11 121297.2 1252.754 35 125098
12 123737.1 -265.1376 38.33333 125592
13 122691.5 1531.53 41.66667 125683
14 124782.8 809.1947 45 125966
15 126177 -494.0289 48.33333 128045
16 130011.1 -17665.14 51.66667 128104
17 125131.4 -3786.361 55 128584
18 134542.4 -21252.37 58.33333 128699
19 140119.3 1665.735 61.66667 130443
20 127919.8 -2821.808 65 130484
21 143604.8 8593.176 68.33333 131346
22 121297.2 9186.754 71.66667 133026
23 127222.7 4123.303 75 134243
24 125131.4 7894.639 78.33333 134648
25 134542.4 -299.3704 81.66667 135778
26 132451 2196.965 85 137693
27 138725 -2947.041 88.33333 139067
28 132799.6 4893.409 91.66667 141785
29 136633.7 2433.294 95 145559
30 137679.4 7879.627 98.33333 152198
X Variable 1 Residual Plot
15000
bability Plot 5000
Residuals

-5000 0 10 20 30 40 50 60 70 80
-15000
-25000
X Variable 1
0 60 80 100 120
le Percentile

X Variable 1 Residual Plot


15000
5000
Residuals

-5000 0 10 20 30 40 50 60 70 80
-15000
-25000
X Variable 1
Significance F

Upper 95%Lower 95.0%


Upper 95.0%
123477.5 114237.2 123477.5
486.4842 210.6276 486.4842 X Variable 1 Line Fit Plot
200000
150000
100000 Y
Predicted Y
Y

50000
0
0 10 20 30 40 50 60 70 80
X Variable 1
X Variable 1 Line Fit Plot
200000
150000
100000 Y
ITY OUTPUT Predicted Y

Y
50000
0
0 10 20 30 40 50 60 70 80
X Variable 1

You might also like