3 assignments

profileusa94
2IWU_Patients.xlsx
Home>Business & Finance homework help>Financial markets homework help>3 assignments

Data

Length of Stay Age Sex Principal Payer Total Chges RT Chge Imaging Charges Lab Charges Drug Charges
4 77 F CARE $ 10,258.04 $ 1,300.71 $ 480.63 $ 1,417.29 $ 1,059.41
5 74 F CARE $ 8,845.63 $ 261.32 $ 886.14 $ 872.56 $ 825.61
6 81 F CARE $ 8,561.29 $ 447.92 $ 870.07 $ 239.97 $ 1,003.32
7 87 F CARE $ 8,744.77 $ 457.42 $ 60.30 $ 1,087.94 $ 1,139.10
8 65 F CARE $ 7,473.72 $ 381.40 $ 15.82 $ 679.23 $ 397.27
9 80 F CARE $ 8,557.10 $ 463.12 $ 709.47 $ 277.08 $ 1,107.43
2 90 F CARE $ 9,017.12 $ 855.92 $ 1,468.80 $ 630.97 $ 61.44
3 66 F BC $ 8,369.42 $ 72.48 $ 157.95 $ 1,447.43 $ 691.55
4 87 F BC $ 8,371.65 $ 28.81 $ 394.24 $ 1,340.25 $ 608.35
5 77 F BC $ 7,040.53 $ 18.73 $ 357.02 $ 468.49 $ 196.29
7 74 F BC $ 9,027.60 $ 375.14 $ 438.80 $ 1,040.24 $ 1,173.42
8 81 F BC $ 8,406.36 $ 60.96 $ 601.89 $ 1,086.30 $ 657.20
9 87 F BC $ 9,576.50 $ 914.93 $ 1,489.36 $ 917.28 $ 254.93
4 65 F BC $ 8,643.63 $ 683.12 $ 892.84 $ 530.09 $ 537.57
6 80 F BC $ 9,326.02 $ 980.82 $ 144.89 $ 776.74 $ 1,423.57
5 90 F BC $ 9,343.93 $ 1,415.51 $ 270.45 $ 487.20 $ 1,170.76
6 66 F BC $ 8,878.88 $ 369.10 $ 386.02 $ 921.90 $ 1,201.85
4 87 F BC $ 9,368.94 $ 1,205.58 $ 1,134.55 $ 66.56 $ 962.25
7 72 F BC $ 8,163.33 $ 879.24 $ 15.46 $ 1,003.25 $ 265.38
8 77 F BC $ 11,054.84 $ 1,409.86 $ 1,121.31 $ 1,068.17 $ 1,455.49
4 74 F HMO $ 8,922.92 $ 25.90 $ 706.68 $ 993.93 $ 1,196.42
3 81 F HMO $ 8,549.67 $ 62.45 $ 668.80 $ 1,400.03 $ 418.38
2 87 F HMO $ 9,482.28 $ 1,096.25 $ 856.82 $ 598.43 $ 930.79
1 65 F HMO $ 8,604.37 $ 1,365.91 $ 11.50 $ 604.02 $ 622.94
5 80 F HMO $ 9,425.82 $ 1,296.19 $ 767.03 $ 393.80 $ 968.80
6 90 F HMO $ 9,544.74 $ 981.61 $ 1,477.83 $ 176.33 $ 908.97
7 66 F HMO $ 8,803.99 $ 1,124.91 $ 1,018.15 $ 356.25 $ 304.68
8 87 F HMO $ 9,022.59 $ 1,438.65 $ 682.02 $ 46.61 $ 855.30
9 76 F HMO $ 8,667.50 $ 31.82 $ 1,101.40 $ 317.30 $ 1,216.98
6 77 F CARE $ 9,600.11 $ 888.77 $ 748.72 $ 496.11 $ 1,466.52
7 74 F CARE $ 8,872.57 $ 853.22 $ 832.44 $ 1,012.88 $ 174.02
8 81 F CARE $ 9,813.57 $ 1,471.71 $ 1,384.39 $ 812.14 $ 145.33
9 87 F CARE $ 9,369.43 $ 303.87 $ 1,304.72 $ 1,312.62 $ 448.22
2 65 F OGVT $ 8,977.19 $ 127.92 $ 1,151.84 $ 433.41 $ 1,264.02
3 80 F CARE $ 8,966.71 $ 444.74 $ 1,316.78 $ 495.19 $ 709.99
4 90 F CARE $ 8,280.27 $ 295.46 $ 859.62 $ 967.58 $ 157.62
5 66 F CARE $ 8,054.88 $ 1,165.70 $ 348.65 $ 35.17 $ 505.36
7 87 F CARE $ 7,472.24 $ 115.07 $ 95.57 $ 1,142.44 $ 119.16
8 75 F CARE $ 9,063.64 $ 489.99 $ 1,009.08 $ 160.74 $ 1,403.83
9 77 F CARE $ 8,121.75 $ 415.25 $ 65.99 $ 672.54 $ 967.97
4 74 F CARE $ 8,016.12 $ 222.52 $ 375.50 $ 1,356.86 $ 61.23
6 81 F CARE $ 10,125.58 $ 991.24 $ 478.59 $ 1,252.78 $ 1,402.97
5 87 F CARE $ 8,523.48 $ 475.08 $ 637.82 $ 1,379.82 $ 30.76
6 65 F CARE $ 8,488.61 $ 432.37 $ 34.25 $ 567.26 $ 1,454.72
4 80 F CARE $ 8,984.25 $ 1,245.69 $ 414.59 $ 1,039.37 $ 284.61
7 90 F CAID $ 8,245.75 $ 217.00 $ 397.73 $ 150.78 $ 1,480.24
8 66 F CARE $ 8,950.12 $ 256.51 $ 1,440.93 $ 364.02 $ 888.65
4 87 F CARE $ 7,310.76 $ 108.79 $ 329.72 $ 866.26 $ 5.99
3 67 F CARE $ 8,150.48 $ 32.00 $ 672.60 $ 404.21 $ 1,041.68
2 77 F CARE $ 8,728.94 $ 554.95 $ 1,356.63 $ 251.79 $ 565.57
1 74 F CARE $ 8,194.86 $ 278.00 $ 986.00 $ 441.96 $ 488.89
5 81 F CARE $ 9,421.54 $ 1,437.10 $ 1,385.69 $ 56.05 $ 542.70
6 87 F INS $ 8,029.96 $ 137.22 $ 1,233.11 $ 520.75 $ 138.88
7 65 F CARE $ 9,397.74 $ 1,097.77 $ 246.22 $ 935.39 $ 1,118.36
8 80 F CARE $ 8,773.78 $ 575.31 $ 243.03 $ 518.10 $ 1,437.34
9 90 F CAID $ 9,108.45 $ 1,082.82 $ 1,451.62 $ 93.96 $ 480.05
3 66 F CARE $ 8,783.40 $ 743.42 $ 350.57 $ 831.45 $ 857.96
12 87 F CAID $ 8,432.71 $ 575.93 $ 876.24 $ 13.71 $ 966.82
2 41 F SELF $ 8,385.72 $ 354.56 $ 47.73 $ 1,040.16 $ 943.26
5 77 F SELF $ 8,286.34 $ 419.48 $ 786.40 $ 30.41 $ 1,050.05
5 74 F SELF $ 9,943.45 $ 1,243.97 $ 383.02 $ 1,189.72 $ 1,126.74
3 81 F SELF $ 7,033.06 $ 408.30 $ 299.33 $ 317.42 $ 8.00
2 87 F SELF $ 9,096.24 $ 377.78 $ 1,015.90 $ 468.55 $ 1,234.01
4 65 F SELF $ 9,176.01 $ 891.17 $ 525.96 $ 975.80 $ 783.08
3 80 F SELF $ 8,599.42 $ 417.48 $ 948.36 $ 619.67 $ 613.92
2 90 F SELF $ 9,430.03 $ 304.06 $ 1,210.43 $ 1,493.93 $ 421.61
6 66 F SELF $ 9,637.49 $ 1,403.52 $ 485.05 $ 1,043.69 $ 705.23
3 87 F SELF $ 8,049.57 $ 895.78 $ 615.58 $ 52.32 $ 485.89
3 77 F SELF $ 8,018.89 $ 218.05 $ 175.78 $ 206.60 $ 1,418.46
4 77 F SELF $ 9,326.69 $ 303.54 $ 1,141.19 $ 1,013.16 $ 868.79
5 74 F SELF $ 9,845.96 $ 1,019.80 $ 737.14 $ 652.43 $ 1,436.59
3 81 F SELF $ 9,061.25 $ 1,145.78 $ 586.23 $ 903.02 $ 426.22
7 87 F SELF $ 9,923.25 $ 1,270.85 $ 453.99 $ 794.11 $ 1,404.30
7 65 F SELF $ 7,099.61 $ 518.57 $ 413.12 $ 24.70 $ 143.23
3 80 M BC $ 9,338.71 $ 1,019.82 $ 1,392.64 $ 554.39 $ 371.86
4 90 M CARE $ 8,335.55 $ 1,190.32 $ 248.68 $ 81.49 $ 815.06
8 66 M CARE $ 9,345.08 $ 672.58 $ 906.92 $ 541.32 $ 1,224.26
2 87 M CARE $ 9,451.35 $ 1,322.53 $ 776.09 $ 282.53 $ 1,070.20
3 89 M CARE $ 9,871.65 $ 419.72 $ 1,128.89 $ 941.01 $ 1,382.04
1 77 M CARE $ 8,325.59 $ 743.22 $ 135.97 $ 425.38 $ 1,021.02
4 74 M CARE $ 8,147.57 $ 878.92 $ 126.33 $ 642.34 $ 499.99
3 81 M CARE $ 8,506.40 $ 555.21 $ 30.74 $ 789.58 $ 1,130.86
6 87 M CARE $ 9,274.45 $ 223.87 $ 1,369.62 $ 398.43 $ 1,282.52
5 65 M CARE $ 9,145.28 $ 286.31 $ 974.68 $ 943.48 $ 940.82
5 80 M BC $ 8,115.25 $ 394.66 $ 636.61 $ 12.91 $ 1,071.07
7 90 M BC $ 8,761.79 $ 506.12 $ 941.07 $ 285.44 $ 1,029.15
1 66 M CARE $ 9,178.66 $ 195.19 $ 960.45 $ 536.63 $ 1,486.39
2 87 M CARE $ 9,435.66 $ 77.49 $ 1,220.89 $ 798.40 $ 1,338.88
4 77 M CARE $ 8,202.09 $ 499.58 $ 59.78 $ 910.60 $ 732.14
11 74 M CARE $ 8,140.23 $ 637.93 $ 40.06 $ 347.87 $ 1,114.38
3 81 M CARE $ 8,603.93 $ 1,058.10 $ 121.59 $ 1,151.82 $ 272.41
2 87 M CARE $ 9,013.08 $ 1,079.14 $ 274.15 $ 1,185.80 $ 473.98
1 65 M CARE $ 8,601.44 $ 640.29 $ 338.65 $ 1,177.28 $ 445.22
4 80 M INS $ 11,006.01 $ 1,187.56 $ 1,499.19 $ 914.72 $ 1,404.54
6 90 M INS $ 8,958.02 $ 788.44 $ 121.06 $ 900.15 $ 1,148.37
8 66 M INS $ 10,214.76 $ 257.11 $ 1,496.04 $ 1,356.85 $ 1,104.77
4 87 M INS $ 8,202.77 $ 98.16 $ 547.97 $ 296.12 $ 1,260.51
2 77 M INS $ 7,789.51 $ 121.40 $ 1,015.16 $ 231.40 $ 421.55
3 74 M INS $ 10,075.00 $ 1,118.41 $ 716.75 $ 1,486.37 $ 753.47
7 81 M INS $ 8,229.70 $ 148.05 $ 504.65 $ 324.16 $ 1,252.84
7 87 M INS $ 8,117.16 $ 1,077.08 $ 817.96 $ 6.73 $ 215.40
4 65 M INS $ 10,488.90 $ 1,439.48 $ 995.75 $ 654.63 $ 1,399.04
6 80 M INS $ 9,376.32 $ 1,032.51 $ 330.41 $ 623.25 $ 1,390.14
7 90 M INS $ 8,856.67 $ 1,122.64 $ 1,076.70 $ 514.00 $ 143.33
8 66 M INS $ 8,186.44 $ 666.94 $ 639.70 $ 548.80 $ 331.01
9 87 M INS $ 10,588.48 $ 1,031.91 $ 1,067.80 $ 1,367.09 $ 1,121.68
2 77 M INS $ 8,649.17 $ 136.63 $ 1,226.54 $ 161.29 $ 1,124.71
3 74 M CAID $ 8,373.70 $ 177.05 $ 532.99 $ 887.39 $ 776.27
4 81 M CAID $ 9,088.47 $ 1,114.44 $ 347.22 $ 956.03 $ 670.78
5 87 M CAID $ 9,264.55 $ 1,292.20 $ 280.32 $ 975.48 $ 716.54
7 65 M CAID $ 9,111.66 $ 1,247.05 $ 367.60 $ 921.20 $ 575.80
8 80 M CAID $ 9,647.92 $ 874.46 $ 408.63 $ 1,114.84 $ 1,250.00
9 90 M CAID $ 8,433.90 $ 1,178.32 $ 292.74 $ 564.37 $ 398.47
4 66 M CAID $ 8,980.22 $ 452.44 $ 839.63 $ 1,288.91 $ 399.25
6 87 M CAID $ 9,986.72 $ 1,122.36 $ 857.07 $ 657.02 $ 1,350.27
5 77 M CAID $ 7,491.19 $ 217.32 $ 705.21 $ 127.95 $ 440.71
6 74 M CAID $ 10,846.04 $ 1,274.61 $ 1,310.16 $ 1,258.94 $ 1,002.32
4 81 M CAID $ 8,116.09 $ 201.43 $ 221.27 $ 1,382.62 $ 310.78
7 87 M CAID $ 8,204.69 $ 1,230.37 $ 238.84 $ 580.27 $ 155.20
8 65 M CAID $ 8,080.06 $ 262.19 $ 651.72 $ 1,027.41 $ 138.73
4 80 M CAID $ 8,444.52 $ 1,123.80 $ 965.75 $ 88.78 $ 266.19
3 90 M CAID $ 9,371.52 $ 519.99 $ 1,363.84 $ 977.55 $ 510.14
2 66 M CAID $ 10,510.78 $ 1,141.20 $ 973.84 $ 1,399.31 $ 996.43
1 87 M CAID $ 9,350.20 $ 1,026.66 $ 1,367.33 $ 725.33 $ 230.89
5 77 M CAID $ 11,055.29 $ 1,434.70 $ 770.84 $ 1,491.68 $ 1,358.07
6 74 M CAID $ 8,687.31 $ 90.04 $ 1,391.66 $ 969.45 $ 236.14
7 81 M CAID $ 8,110.83 $ 366.72 $ 418.25 $ 89.71 $ 1,236.14
8 87 M CAID $ 9,924.35 $ 936.11 $ 1,454.85 $ 539.09 $ 994.29
9 65 M CAID $ 8,202.16 $ 721.49 $ 18.38 $ 564.82 $ 897.48
3 80 M INS $ 9,200.64 $ 269.04 $ 686.72 $ 1,138.28 $ 1,106.60
4 90 M OTHR $ 8,519.16 $ 622.84 $ 1,255.84 $ 545.68 $ 94.80
4 66 M OTHR $ 10,599.23 $ 1,246.74 $ 903.76 $ 1,268.77 $ 1,179.96
5 87 M OTHR $ 8,995.15 $ 907.90 $ 990.65 $ 625.72 $ 470.88
5 80 M OTHR $ 7,682.80 $ 23.79 $ 629.95 $ 179.78 $ 849.28
5 55 M OTHR $ 8,172.84 $ 108.85 $ 296.42 $ 1,356.42 $ 411.16
5 73 M OTHR $ 8,395.52 $ 754.62 $ 950.11 $ 393.35 $ 297.44
7 67 M OTHR $ 8,403.74 $ 229.79 $ 1,024.15 $ 174.51 $ 975.29
2 75 M OTHR $ 8,795.54 $ 249.54 $ 509.59 $ 960.89 $ 1,075.51

Description

Patient Data
File: IWU_Patients.xlsx
Variable Definitions:
Length of Stay in Days
Patient's Age
Sex - M= Male, F = Female
Principal Payer - CARE = Medicare, BC = Blue Cross, HMO = Health maitenance Organization
CAID = Medicade, OGVT = Other Government Program, INS = Private Insurance, SELF = Private Pay,
OTHR = Other form of Payment
Total Charges during Hospital Stay
Total Drug Charges
Lab Charges
Imaging Charges
Respiratory Therapy Charges

DescriptiveStats

Length of Stay Age Total Chges Sex Principal Payer Descriptive Statistics
4 77 $ 10,258.04 F CARE
5 74 $ 8,845.63 F CARE Length of Stay in Days Count of Length of Stay Column Labels Column Labels
6 81 $ 8,561.29 F CARE Mean Median Stdev Row Labels 1-2 3-4 5-6 7-8 9-10 11-12 Grand Total <1000 or (blank) 6000-8500 8500-11000 11000-13500 Grand Total
7 87 $ 8,744.77 F CARE M 4.926470588235294 5.0 2.3135949701037135 F 9.0 21.0 19.0 18.0 6.0 1.0 74.0 Count of Total Chges 48.0 87.0 3.0 138.0
8 65 $ 7,473.72 F CARE F 5.314285714285714 5.0 2.3868167943807266 M 11.0 20.0 15.0 14.0 3.0 1.0 64.0
9 80 $ 8,557.10 F CARE Grand Total 20.0 41.0 34.0 32.0 9.0 2.0 138.0
2 90 $ 9,017.12 F CARE
3 66 $ 8,369.42 F BC Age
4 87 $ 8,371.65 F BC Mean Median Stdev
5 77 $ 7,040.53 F BC M 78.1029411764706 80.0 8.936157820534673
7 74 $ 9,027.60 F BC F 77.62857142857143 78.5 9.38264112344417
8 81 $ 8,406.36 F BC
9 87 $ 9,576.50 F BC
4 65 $ 8,643.63 F BC
6 80 $ 9,326.02 F BC Total Charges
5 90 $ 9,343.93 F BC Mean Median Stdev
6 66 $ 8,878.88 F BC M 8978.081690048108 8907.344198618051 885.1121554846562
4 87 $ 9,368.94 F BC F 8789.927856134098 8793.695451921707 729.070861621995
7 72 $ 8,163.33 F BC
8 77 $ 11,054.84 F BC
4 74 $ 8,922.92 F HMO Count of Age Column Labels
3 81 $ 8,549.67 F HMO Row Labels F M Grand Total Count of Total Chges Column Labels
2 87 $ 9,482.28 F HMO 35-44 1.0 1.0 Row Labels 6000-8500 8500-11000 11000-13500 Grand Total
1 65 $ 8,604.37 F HMO 55-64 1.0 1.0 F 24.0 49.0 1.0 74.0
5 80 $ 9,425.82 F HMO 65-74 25.0 21.0 46.0 M 24.0 38.0 2.0 64.0
6 90 $ 9,544.74 F HMO 75-84 26.0 21.0 47.0 Grand Total 48.0 87.0 3.0 138.0
7 66 $ 8,803.99 F HMO 85-94 22.0 21.0 43.0
8 87 $ 9,022.59 F HMO Count of Principal Payer Column Labels Grand Total 74.0 64.0 138.0
9 76 $ 8,667.50 F HMO Row Labels BC CAID CARE HMO INS OGVT OTHR SELF Grand Total
6 77 $ 9,600.11 F CARE F 13.0 3.0 31.0 9.0 1.0 1.0 16.0 74.0
7 74 $ 8,872.57 F CARE M 3.0 22.0 16.0 15.0 8.0 64.0
8 81 $ 9,813.57 F CARE Grand Total 16.0 25.0 47.0 9.0 16.0 1.0 8.0 16.0 138.0
9 87 $ 9,369.43 F CARE
2 65 $ 8,977.19 F OGVT
3 80 $ 8,966.71 F CARE
4 90 $ 8,280.27 F CARE
5 66 $ 8,054.88 F CARE
7 87 $ 7,472.24 F CARE
8 75 $ 9,063.64 F CARE
9 77 $ 8,121.75 F CARE
4 74 $ 8,016.12 F CARE BC CAID CARE HMO INS OGVT OTHR SELF
6 81 $ 10,125.58 F CARE 16.0 25.0 47.0 9.0 16.0 1.0 8.0 16.0
5 87 $ 8,523.48 F CARE
6 65 $ 8,488.61 F CARE
4 80 $ 8,984.25 F CARE
7 90 $ 8,245.75 F CAID
8 66 $ 8,950.12 F CARE
4 87 $ 7,310.76 F CARE
3 67 $ 8,150.48 F CARE
2 77 $ 8,728.94 F CARE
1 74 $ 8,194.86 F CARE
5 81 $ 9,421.54 F CARE
6 87 $ 8,029.96 F INS
7 65 $ 9,397.74 F CARE
8 80 $ 8,773.78 F CARE
9 90 $ 9,108.45 F CAID
3 66 $ 8,783.40 F CARE
12 87 $ 8,432.71 F CAID
2 41 $ 8,385.72 F SELF
5 77 $ 8,286.34 F SELF
5 74 $ 9,943.45 F SELF
3 81 $ 7,033.06 F SELF
2 87 $ 9,096.24 F SELF
4 65 $ 9,176.01 F SELF
3 80 $ 8,599.42 F SELF
2 90 $ 9,430.03 F SELF
6 66 $ 9,637.49 F SELF
3 87 $ 8,049.57 F SELF
3 77 $ 8,018.89 F SELF
4 77 $ 9,326.69 F SELF Row Labels BC CAID CARE HMO INS OGVT OTHR SELF Grand Total
5 74 $ 9,845.96 F SELF F 13.0 3.0 31.0 9.0 1.0 1.0 16.0 74.0
3 81 $ 9,061.25 F SELF M 3.0 22.0 16.0 15.0 8.0 64.0
7 87 $ 9,923.25 F SELF Grand Total 16.0 25.0 47.0 9.0 16.0 1.0 8.0 16.0 138.0
7 65 $ 7,099.61 F SELF
3 80 $ 9,338.71 M BC
4 90 $ 8,335.55 M CARE
8 66 $ 9,345.08 M CARE
2 87 $ 9,451.35 M CARE
3 89 $ 9,871.65 M CARE
1 77 $ 8,325.59 M CARE
4 74 $ 8,147.57 M CARE
3 81 $ 8,506.40 M CARE
6 87 $ 9,274.45 M CARE
5 65 $ 9,145.28 M CARE
5 80 $ 8,115.25 M BC
7 90 $ 8,761.79 M BC
1 66 $ 9,178.66 M CARE
2 87 $ 9,435.66 M CARE
4 77 $ 8,202.09 M CARE
11 74 $ 8,140.23 M CARE
3 81 $ 8,603.93 M CARE
2 87 $ 9,013.08 M CARE
1 65 $ 8,601.44 M CARE
4 80 $ 11,006.01 M INS
6 90 $ 8,958.02 M INS
8 66 $ 10,214.76 M INS
4 87 $ 8,202.77 M INS
2 77 $ 7,789.51 M INS
3 74 $ 10,075.00 M INS
7 81 $ 8,229.70 M INS
7 87 $ 8,117.16 M INS
4 65 $ 10,488.90 M INS
6 80 $ 9,376.32 M INS
7 90 $ 8,856.67 M INS
8 66 $ 8,186.44 M INS
9 87 $ 10,588.48 M INS
2 77 $ 8,649.17 M INS
3 74 $ 8,373.70 M CAID
4 81 $ 9,088.47 M CAID
5 87 $ 9,264.55 M CAID
7 65 $ 9,111.66 M CAID
8 80 $ 9,647.92 M CAID
9 90 $ 8,433.90 M CAID
4 66 $ 8,980.22 M CAID
6 87 $ 9,986.72 M CAID
5 77 $ 7,491.19 M CAID
6 74 $ 10,846.04 M CAID
4 81 $ 8,116.09 M CAID
7 87 $ 8,204.69 M CAID
8 65 $ 8,080.06 M CAID
4 80 $ 8,444.52 M CAID
3 90 $ 9,371.52 M CAID
2 66 $ 10,510.78 M CAID
1 87 $ 9,350.20 M CAID
5 77 $ 11,055.29 M CAID
6 74 $ 8,687.31 M CAID
7 81 $ 8,110.83 M CAID
8 87 $ 9,924.35 M CAID
9 65 $ 8,202.16 M CAID
3 80 $ 9,200.64 M INS
4 90 $ 8,519.16 M OTHR
4 66 $ 10,599.23 M OTHR
5 87 $ 8,995.15 M OTHR
5 80 $ 7,682.80 M OTHR
5 55 $ 8,172.84 M OTHR
5 73 $ 8,395.52 M OTHR
7 67 $ 8,403.74 M OTHR
2 75 $ 8,795.54 M OTHR

1-2 F M 9 11 3-4 F M 21 20 5-6 F M 19 15 7-8 F M 18 14 9-10 F M 6 3 11-12 F M 1 1

Primary Payer

BC CAID CARE HMO INS OGVT OTHR SELF 16 25 47 9 16 1 8 16

F 35-44 55-64 65-74 75-84 85-94 1 25 26 22 M 35-44 55-64 65-74 75-84 85-94 1 21 21 21

6000-8500 F M 24 24 8500-11000 F M 49 38 11000-13500 F M 1 2

SimpleLinearRegression

Age Drug Charges
77 $ 1,059.41
74 $ 825.61
81 $ 1,003.32
87 $ 1,139.10
65 $ 397.27
80 $ 1,107.43
90 $ 61.44 slope
66 $ 691.55 -3.8068
87 $ 608.35
77 $ 196.29
74 $ 1,173.42 r-squared
81 $ 657.20 0.0064
87 $ 254.93
65 $ 537.57
80 $ 1,423.57 y-intercept
90 $ 1,170.76 1089.5
66 $ 1,201.85
87 $ 962.25
72 $ 265.38
77 $ 1,455.49
74 $ 1,196.42
81 $ 418.38
87 $ 930.79
65 $ 622.94
80 $ 968.80
90 $ 908.97
66 $ 304.68
87 $ 855.30
76 $ 1,216.98
77 $ 1,466.52
74 $ 174.02
81 $ 145.33
87 $ 448.22
65 $ 1,264.02
80 $ 709.99
90 $ 157.62
66 $ 505.36
87 $ 119.16
75 $ 1,403.83
77 $ 967.97
74 $ 61.23
81 $ 1,402.97
87 $ 30.76
65 $ 1,454.72
80 $ 284.61
90 $ 1,480.24
66 $ 888.65
87 $ 5.99
67 $ 1,041.68
77 $ 565.57
74 $ 488.89
81 $ 542.70
87 $ 138.88
65 $ 1,118.36
80 $ 1,437.34
90 $ 480.05
66 $ 857.96
87 $ 966.82
41 $ 943.26
77 $ 1,050.05
74 $ 1,126.74
81 $ 8.00
87 $ 1,234.01
65 $ 783.08
80 $ 613.92
90 $ 421.61
66 $ 705.23
87 $ 485.89
77 $ 1,418.46
77 $ 868.79
74 $ 1,436.59
81 $ 426.22
87 $ 1,404.30
65 $ 143.23
80 $ 371.86
90 $ 815.06
66 $ 1,224.26
87 $ 1,070.20
89 $ 1,382.04
77 $ 1,021.02
74 $ 499.99
81 $ 1,130.86
87 $ 1,282.52
65 $ 940.82
80 $ 1,071.07
90 $ 1,029.15
66 $ 1,486.39
87 $ 1,338.88
77 $ 732.14
74 $ 1,114.38
81 $ 272.41
87 $ 473.98
65 $ 445.22
80 $ 1,404.54
90 $ 1,148.37
66 $ 1,104.77
87 $ 1,260.51
77 $ 421.55
74 $ 753.47
81 $ 1,252.84
87 $ 215.40
65 $ 1,399.04
80 $ 1,390.14
90 $ 143.33
66 $ 331.01
87 $ 1,121.68
77 $ 1,124.71
74 $ 776.27
81 $ 670.78
87 $ 716.54
65 $ 575.80
80 $ 1,250.00
90 $ 398.47
66 $ 399.25
87 $ 1,350.27
77 $ 440.71
74 $ 1,002.32
81 $ 310.78
87 $ 155.20
65 $ 138.73
80 $ 266.19
90 $ 510.14
66 $ 996.43
87 $ 230.89
77 $ 1,358.07
74 $ 236.14
81 $ 1,236.14
87 $ 994.29
65 $ 897.48
80 $ 1,106.60
90 $ 94.80
66 $ 1,179.96
87 $ 470.88
80 $ 849.28
55 $ 411.16
73 $ 297.44
67 $ 975.29
75 $ 1,075.51

Drug Charges

77 74 81 87 65 80 90 66 87 77 74 81 87 65 80 90 66 87 72 77 74 81 87 65 80 90 66 87 76 77 74 81 87 65 80 90 66 87 75 77 74 81 87 65 80 90 66 87 67 77 74 81 87 65 80 90 66 87 41 77 74 81 87 65 80 90 66 87 77 77 74 81 87 65 80 90 66 87 89 77 74 81 87 65 80 90 66 87 77 74 81 87 65 80 90 66 87 77 74 81 87 65 80 90 66 87 77 74 81 87 65 80 90 66 87 77 74 81 87 65 80 90 66 87 77 74 81 87 65 80 90 66 87 80 55 73 67 75 1059.4071079370719 825.61039223030809 1003.324923294425 1139.1037251995917 397.27347229550247 1107.4297041489974 61.435114320558313 691.55496793136626 608.3511229604577 196.29186693263313 1173.4229968083057 657.20474772521436 254.92599807890943 537.57248926522186 1423.5735160300837 1170.7592683099629 1201.8541288785127 962.24761920725371 265.3826776021055 1455.4891963188952 1196.4200409561956 418.38443351728205 930.7853107473511 622.94126767910211 968.80012503686919 908.96817738768834 304.68177591562068 855.2962957170439 1216.9751333794513 1466.5199556311686 174.02497743212191 145.33226041719294 448.22490150396277 1264.023211600505 709.99119721878174 157.61548067934706 505.35734101370338 119.16039145308687 1403.8338030684565 967.96814692232897 61.234133304015671 1402.9666286871577 30.762122537090264 1454.7180511949311 284.60510781193722 1480.2425144824917 888.65405855201936 5.9943541369041338 1041.6810743344629 565.57176513878392 488.89200532839936 542.69587594046061 138.87690106960309 1118.3557203804448 1437.3404899441168 480.04851518131943 857.95897551099733 966.82315335947067 943.26394718125698 1050.0530230355826 1126.7440529725818 8.0016009339891614 1234.0099988712984 783.07808074792399 613.92101055159821 421.61346865355432 705.225257660377 485.88859793885035 1418.4608056535051 868.79061697958844 1436.5931008780758 426.21530497762643 1404.3038868714921 143.22801670311404 371.86288704001095 815.06133757099656 1224.2599793027198 1070.2039527239881 1382.0396168726395 1021.0184478236007 499.98657543274055 1130.8581320320418 1282.5233097121484 940.81872716229998 1071.0748379931188 1029.1542176492399 1486.3866724258028 1338.8819888734076 732.14038003249084 1114.3760722487557 272.41458167732674 473.9832830449264 445.22398129965336 1404.5380465482117 1148.365620819136 1104.7673337548385 1260.5111960614779 421.54972934510454 753.46988234398134 1252.837224371435 215.40051979619352 1399.0424014189286 1390.1417032334223 143.32511610751379 331.00605242653916 1121.6786373111497 1124.7061939496773 776.26727390778512 670.77698383251368 716.54124214164813 575.80443247242874 1249.9974652627618 398.47232517454279 399.24523471736615 1350.2674400724943 440.70758637773912 1002.3230937993702 310.77544026029614 155.20285888812012 138.73163715760788 266.18548833320943 510.13540656498253 996.42624756045757 230.88506931401565 1358.0664455241174 236.14375442983993 1236.1446109571521 994.29351777146144 897.47651824407535 1106.5989079146837 94.796561139078193 1179.9568306028837 470.88039863778727 849.27884661307712 411.15581081707404 297.43652983170927 975.28959100287614 1075.5107199913639

HypothesisTest

Total Chges
$ 10,258.04
$ 8,845.63 t Test for the Hypothesis of the Mean Test the claim that the mean is $10,000
$ 8,561.29 Data
$ 8,744.77 Null Hypothesis m= 10000.0
$ 7,473.72 Level of Significance 0.05
$ 8,557.10 Sample Size 138.0 8882.641339512016
$ 9,017.12 Sample Mean 8882.64 812.2557683183189
$ 8,369.42 Sample Standard Deviation 812.26
$ 8,371.65
$ 7,040.53 Intermediate Calculations
$ 9,027.60 Standard Error of the Mean 69.1442
$ 8,406.36 Degrees of Freedom 137.0
$ 9,576.50 t Test Statistic -16.1599
$ 8,643.63
$ 9,326.02 Two-Tail Test
$ 9,343.93 Lower Critical Value -1.9774
$ 8,878.88 Upper Critical Value 1.9774
$ 9,368.94 p-Value 0.0000
$ 8,163.33 Reject the null hypothesis
$ 11,054.84
$ 8,922.92
$ 8,549.67
$ 9,482.28
$ 8,604.37
$ 9,425.82
$ 9,544.74
$ 8,803.99
$ 9,022.59
$ 8,667.50
$ 9,600.11
$ 8,872.57
$ 9,813.57
$ 9,369.43
$ 8,977.19
$ 8,966.71
$ 8,280.27
$ 8,054.88
$ 7,472.24
$ 9,063.64
$ 8,121.75
$ 8,016.12
$ 10,125.58
$ 8,523.48
$ 8,488.61
$ 8,984.25
$ 8,245.75
$ 8,950.12
$ 7,310.76
$ 8,150.48
$ 8,728.94
$ 8,194.86
$ 9,421.54
$ 8,029.96
$ 9,397.74
$ 8,773.78
$ 9,108.45
$ 8,783.40
$ 8,432.71
$ 8,385.72
$ 8,286.34
$ 9,943.45
$ 7,033.06
$ 9,096.24
$ 9,176.01
$ 8,599.42
$ 9,430.03
$ 9,637.49
$ 8,049.57
$ 8,018.89
$ 9,326.69
$ 9,845.96
$ 9,061.25
$ 9,923.25
$ 7,099.61
$ 9,338.71
$ 8,335.55
$ 9,345.08
$ 9,451.35
$ 9,871.65
$ 8,325.59
$ 8,147.57
$ 8,506.40
$ 9,274.45
$ 9,145.28
$ 8,115.25
$ 8,761.79
$ 9,178.66
$ 9,435.66
$ 8,202.09
$ 8,140.23
$ 8,603.93
$ 9,013.08
$ 8,601.44
$ 11,006.01
$ 8,958.02
$ 10,214.76
$ 8,202.77
$ 7,789.51
$ 10,075.00
$ 8,229.70
$ 8,117.16
$ 10,488.90
$ 9,376.32
$ 8,856.67
$ 8,186.44
$ 10,588.48
$ 8,649.17
$ 8,373.70
$ 9,088.47
$ 9,264.55
$ 9,111.66
$ 9,647.92
$ 8,433.90
$ 8,980.22
$ 9,986.72
$ 7,491.19
$ 10,846.04
$ 8,116.09
$ 8,204.69
$ 8,080.06
$ 8,444.52
$ 9,371.52
$ 10,510.78
$ 9,350.20
$ 11,055.29
$ 8,687.31
$ 8,110.83
$ 9,924.35
$ 8,202.16
$ 9,200.64
$ 8,519.16
$ 10,599.23
$ 8,995.15
$ 7,682.80
$ 8,172.84
$ 8,395.52
$ 8,403.74
$ 8,795.54

ChiSquare

Age Principal Payer Sex
77 CARE F
74 CARE F
81 CARE F
87 CARE F
65 CARE F
80 CARE F
90 CARE F Count of Sex Column Labels
66 BC F Row Labels F M Grand Total
87 BC F 25-49 1.0 1.0
77 BC F 50-74 25.0 22.0 47.0
74 BC F 75-100 48.0 42.0 90.0
81 BC F Grand Total 74.0 64.0 138.0
87 BC F
65 BC F
80 BC F Age F M Grand Total
90 BC F <75 26.0 22.0 48.0
66 BC F >=75 48.0 42.0 90.0
87 BC F 74.0 64.0 138.0
72 BC F
77 BC F
74 HMO F
81 HMO F
87 HMO F
65 HMO F
80 HMO F
90 HMO F
66 HMO F
87 HMO F
76 HMO F
77 CARE F
74 CARE F
81 CARE F
87 CARE F
65 OGVT F
80 CARE F
90 CARE F
66 CARE F
87 CARE F
75 CARE F
77 CARE F
74 CARE F
81 CARE F
87 CARE F
65 CARE F
80 CARE F
90 CAID F
66 CARE F
87 CARE F
67 CARE F
77 CARE F
74 CARE F
81 CARE F
87 INS F
65 CARE F
80 CARE F
90 CAID F
66 CARE F
87 CAID F
41 SELF F
77 SELF F
74 SELF F
81 SELF F
87 SELF F
65 SELF F
80 SELF F
90 SELF F
66 SELF F
87 SELF F
77 SELF F
77 SELF F
74 SELF F
81 SELF F
87 SELF F
65 SELF F
80 BC M
90 CARE M
66 CARE M
87 CARE M
89 CARE M
77 CARE M
74 CARE M
81 CARE M
87 CARE M
65 CARE M
80 BC M
90 BC M
66 CARE M
87 CARE M
77 CARE M
74 CARE M
81 CARE M
87 CARE M
65 CARE M
80 INS M
90 INS M
66 INS M
87 INS M
77 INS M
74 INS M
81 INS M
87 INS M
65 INS M
80 INS M
90 INS M
66 INS M
87 INS M
77 INS M
74 CAID M
81 CAID M
87 CAID M
65 CAID M
80 CAID M
90 CAID M
66 CAID M
87 CAID M
77 CAID M
74 CAID M
81 CAID M
87 CAID M
65 CAID M
80 CAID M
90 CAID M
66 CAID M
87 CAID M
77 CAID M
74 CAID M
81 CAID M
87 CAID M
65 CAID M
80 INS M
90 OTHR M
66 OTHR M
87 OTHR M
80 OTHR M
55 OTHR M
73 OTHR M
67 OTHR M
75 OTHR M