a)
Claim: There is a difference in the length of stay of patients
with different categories of diagnosis.
The null and alternative hypothesis is:
![HO :μι = μ2 = μ3](https://latex.codecogs.com/gif.latex?H0%3A%5Cmu1%3D%5Cmu2%3D%5Cmu3)
H1: At least one of the mean is different.By using excel we can
solve this question easily.
First, enter all data into excel.
Click on Data -------> Data Analysis--------> Anova:
Single-Factor-----> Input Data -------> Select all data
-------> Output Range : Select any empty cell -------->
ok
We get
![- x New Microsoft Office Excel Worksheet - Microsoft Excel Team o - X E show Detail Data Analysis Clear Reapply Advanced HEEG](//img.homeworklib.com/questions/29b21e80-a5d8-11ea-9e5b-47716fed9fe3.png?x-oss-process=image/resize,w_560)
b)
DFs for groups/Between = 2
DFs for error/within = 24
DFs for total = 26
Critical F = 3.403
c)
Calculate F = 20.890
d)
Level of significance = 0.05
P-value = 0.00000556
P-value < 0.05 we reject null hypothesis.
e)
Calculated F > Critical F we reject null hypothesis.
Conclusion:
At one of the mean is different.
HO :μι = μ2 = μ3
- x New Microsoft Office Excel Worksheet - Microsoft Excel Team o - X E show Detail Data Analysis Clear Reapply Advanced HEEG... 41 41 3 = Home Insert Page Layout Formulas Data Review View Connections 2 AZ Properties From From From From Other Existing Refresh At Sort Access Web Text Sources Sources Connections Connections All Edit Links Get External Data Connections 010 - fi A B C D E Hide Detail - Group Ungroup Subtotal Filter Text to Remove Data Consolidate What If Columns Duplicates Validation Analysis Data Tools Sort & Filter Outline Analysis J K L M N P Q R S Affective Congnitivi Drug-Related 12 8 10 Anova: Single Factor Count SUMMARY Groups Affective Congnitive Drug-Related Sum Average Variance 54 1.5 96 10.66667 3.5 100 11.11111 5.361111 9 5 9 9 df ANOVA Source of Variation Between Groups Within Groups SS 144.2963 82.88889 MS 2 72.14815 24 3.453704 F P-value Fcrit 20.89008 5.56E-06 3.402826 Total 227.1852 26 24 25 Ke Ready Activate Windows Go to PC settings to activate Windows Sheet1 Sheet2 Sheet30 O 100% e o 29 ® © EA x 01 102 - JDOOR 9.10 persons 0 11:35 PM 10/06/2019