Question
The Data on the Hospital Stay Workseet of Chpt 8-1.xls show a sample of 100 Hospital stays by sex and los. Stay> three days are
The Data on the Hospital Stay Workseet of Chpt 8-1.xls show a sample of 100 Hospital stays by sex and los. Stay> three days are coded as long; those three days or less are coded short.
a.) use the pivot table capablitiy of exceland the chi-squared to test the hypothesis of independence between sex and stay as coded long and short
b.) Use the codnitional probablitites to provide an interpretation of the results
ID
1
2
.
.
.
100
Sex LOS Stay
F 4 Long
F 8 Long
F 10 Long
M 5 Long
F 3 Short
F 2 Short
F 5 Long
M 6 Long
M 6 Long
F 14 Long
F 11 Long
M 5 Long
M 6 Long
F 3 Short
M 3 Short
F 7 Long
F 6 Long
F 3 Short
F 11 Long
F 2 Short
F 2 Short
F 2 Short
M 7 Long
F 4 Long
F 10 Long
F 6 Long
F 3 Short
F 6 Long
F 6 Long
M 1 Short
M 3 Short
F 3 Short
F 5 Long
M 5 Long
M 3 Short
M 2 Short
F 6 Long
M 1 Short
F 10 Long
F 2 Short
F 2 Short
F 2 Short
F 3 Short
M 2 Short
F 6 Long
F 4 Long
F 10 Long
F 7 Long
F 4 Long
F 1 Short
M 2 Short
F 9 Long
M 2 Short
F 3 Short
M 4 Long
F 2 Short
M 1 Short
F 5 Long
M 12 Long
F 7 Long
F 4 Long
M 4 Long
F 1 Short
F 7 Long
F 2 Short
F 4 Long
F 14 Long
F 1 Short
M 10 Long
F 2 Short
M 1 Short
M 2 Short
F 10 Long
F 3 Short
F 7 Long
M 2 Short
M 9 Long
M 3 Short
M 3 Short
F 2 Short
M 11 Long
F 16 Long
F 3 Short
M 5 Long
F 1 Short
F 8 Long
M 5 Long
F 2 Short
F 10 Long
M 9 Long
F 7 Long
F 4 Long
M 5 Long
F 2 Short
F 5 Long
F 3 Short
M 7 Long
M 9 Long
M 7 Long
M 5 Long
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Calculus Early Transcendentals
Authors: James Stewart
8th edition
1285741552, 9781305482463 , 978-1285741550
