T
Terry L. Robinson
Hi,
I am experimenting with statistics to learn and apply this to my job.
If K=10 df=(K-1)=9 and the alpha margin of error is .05. My hypothetical problem is did patient care increase by 15% from year 2000 to 2004. I still have to develop some numbers for hospitals 1-10 for year 2004 to complete this.
Does anyone know how to do this and is willing to work with me to understand this? I'm using the function of =CHITEST(B3:B12,C3:C12) but the result is 0. Do I have to plug in the Year 2004 data before this will work? Then the follow on question is how to chart this?
Thank you for your help in my learning how to do statistics via excel.
--
Terry L. Robinson
Year 2000
Observed Expected Total
Hospital 1 156,279 174,892 331,171
Hospital 2 196,453 203,618 400,071
Hospital 3 205,784 205,784 411,568
Hospital 4 179,520 183,629 363,149
Hospital 5 192,759 192,563 385,322
Hospital 6 298,627 300,090 598,717
Hospital 7 289,993 289,784 579,777
Hospital 8 294,865 276,592 571,457
Hospital 9 103,582 105,820 209,402
Hospital 10 274,917 314,761 589,678
Chi Square 0
I am experimenting with statistics to learn and apply this to my job.
If K=10 df=(K-1)=9 and the alpha margin of error is .05. My hypothetical problem is did patient care increase by 15% from year 2000 to 2004. I still have to develop some numbers for hospitals 1-10 for year 2004 to complete this.
Does anyone know how to do this and is willing to work with me to understand this? I'm using the function of =CHITEST(B3:B12,C3:C12) but the result is 0. Do I have to plug in the Year 2004 data before this will work? Then the follow on question is how to chart this?
Thank you for your help in my learning how to do statistics via excel.
--
Terry L. Robinson
Year 2000
Observed Expected Total
Hospital 1 156,279 174,892 331,171
Hospital 2 196,453 203,618 400,071
Hospital 3 205,784 205,784 411,568
Hospital 4 179,520 183,629 363,149
Hospital 5 192,759 192,563 385,322
Hospital 6 298,627 300,090 598,717
Hospital 7 289,993 289,784 579,777
Hospital 8 294,865 276,592 571,457
Hospital 9 103,582 105,820 209,402
Hospital 10 274,917 314,761 589,678
Chi Square 0