Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise. Patients in a hospital are classified as surgical or medical. A record is kept of the number of times patients require nursing service during the night and whether or not these patients are on Medicare. The data are presented here: The evidence Medicare Yes P-value = i No Patient Category Surgical Medical 52 46 36 Test the hypothesis (using a = 0.40) that calls by surgical-medical patients are independent of whether the patients are receiving Medicare. Find to 2 decimal places the P-value for this test. sufficient to claim that surgical-medical patients and Medicare status are dependent. 43
Find attached
![Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise.
Patients in a hospital are classified as surgical or medical. A record is kept of the number of times patients require nursing service during the night and whether or not these patients are on Medicare. The data are presented here:
| Patient Category | Surgical | Medical |
|------------------|----------|---------|
| Medicare Yes | 46 | 52 |
| Medicare No | 36 | 43 |
Test the hypothesis (using \( \alpha = 0.40 \)) that calls by surgical-medical patients are independent of whether the patients are receiving Medicare. Find to 2 decimal places the P-value for this test.
The evidence [dropdown menu] sufficient to claim that surgical-medical patients and Medicare status are dependent.
P-value = [text box]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0fea1cc5-2b25-43ff-974f-07cd43569663%2F4d01a448-c336-4ff2-8a17-2e6e3c499596%2Fcl633kr_processed.png&w=3840&q=75)

Check whether the calls by surgical-medical patients are independent of whether the patients are receiving Medicare.
The hypotheses are given below:
Null hypothesis:
: The calls by surgical-medical patients are independent of whether the patients are receiving Medicare.
Alternative hypothesis:
: The calls by surgical-medical patients are not independent of whether the patients are receiving Medicare.
Rejection Rule:
If p-value (=0.40), then reject the null hypothesis.
The test statistic and the p-value is obtained by using Excel.
EXCEL (PH STAT in Add-Ins) procedure:
Step 1: Choose PH Stat > Multiple-Sample Tests > Chi-Square Test.
Step 2: In Data, enter the values of Level of Significance, Number of Rows as 2, and Number of Columns as 2.
Step 3: In Output Options, Select the appropriate Title.
Step 4: Click OK.
Step by step
Solved in 3 steps with 4 images









