Using the research question and two variables your learning team developed for the Week 2 Business Research Project Part 1 assignment, create a no more than 350-word inferential statistics (hypothesis test). Include: (a) The research question (b) Mock da

profilellhwk2
data_set-1.xlsx

Sheet1

Independent Variables (Data Set) Dependent Variables (Data Set)
Hands washed, Both Hands Washed, Used the Five Moments of Hand Hygiene, and Soap/Water or Alcohol-based rub used (Broken down by Clinical Department Area) Number of Staff used these practices out of 1,822 Percentage (%) of Staff Percentage (%) of Patients in Clinical Areas with Recurrent
Sleep Apnea 856 47% Infectious Pathogens after Staff Interaction of Seven Days:
Med Surg Oncology 1,102 60% Clinical Department Percentage (%) of Patients
Pediatrics 987 54% Sleep Apnea 1%
NICU 1,396 77% Med Surg Oncology 0%
General Surgery 1,629 89% Pediatrics 2%
ICU 1,741 96% NICU 4%
Medical Wound Care 714 39% General Surgery 7%
Radiology 685 38% ICU 12%
Day Treatment Clinic 589 32% Medical Wound Care 0%
Rehab 532 29% Radiology 0%
Delivery Room 1,516 83% Day Treatment Clinic 0%
Surgery, Peri OP, & Anesthesia 1,699 93% Rehab 0%
Respiratory Care 1,021 56% Delivery Room 3%
Maternal Fetal Medicine 662 36% Surgery, Peri OP, & Anesthesia 16%
Cat Scan 653 36% Respiratory Care 0%
Maternal Fetal Medicine 0%
Cat Scan 0%
IV (Percentage of Staff) Descriptive Stats DV (Percentage of Patients) Descriptive Stats
Mean 0.5766666667 Mean 0.03
Standard Error 0.0617419103 Standard Error 0.0127988095
Median 0.54 Median 0
Mode 0.36 Mode 0
Standard Deviation 0.2391253905 Standard Deviation 0.0495695759
Sample Variance 0.0571809524 Sample Variance 0.0024571429
Kurtosis -1.3938818201 Kurtosis 2.7911761035
Skewness 0.473242513 Skewness 1.8716577484
Range 0.67 Range 0.16
Minimum 0.29 Minimum 0
Maximum 0.96 Maximum 0.16
Sum 8.65 Sum 0.45
Count 15 Count 15
1st quartile 0.36 1st quartile 0
3rd quartile 0.83 3rd quartile 0.04
interquartile range 0.47 interquartile range 0.04
Histogram Bin Information Histogram Bin Information
Bin Width Intervals 10% Bin Width Intervals 4%
20% 8%
30% 12%
40% 16%
50% 20%
60%
70% Bin Frequency
80% 4% 12
90% 8% 1
100% 12% 1
16% 1
20% 0
Bin Frequency More 0
10% 0
20% 0
30% 1
40% 5
50% 1
60% 3
70% 0
80% 1
90% 2
100% 2
More 0
Scatter Plot Data (from above)
Percentage (%) of Staff Using Appropriate Hand Hygiene Practices within Clinical Departments Percentage (%) of Patients in Clinical Departments with Recurrent Infectious Pathogens after 7 days of Staff Interaction
47% 1%
60% 0%
54% 2%
77% 4%
89% 7%
96% 12%
39% 0%
38% 0%
32% 0%
29% 0%
83% 3%
93% 16%
56% 0%
36% 0% Correlation Coefficient r =
36% 0% Correlation of Determination
0.8315917172
0.6915

Percentage (%) of Patients Histogram

Frequency 4% 8% 12% 16% 20% More 12 1 1 1 0 0

Percentage (%) of Patients

Frequency

Scatterplot Percentage (%) of Staff versus Percentage (%) of Patients

y = 0.1724x - 0.0694 R = 0.8316

R² = 0.6915

0.47 0.6 0.54 0.77 0.89 0.96 0.39 0.38 0.32 0.28999999999999998 0.83 0.93 0.56000000000000005 0.36 0.36 0.01 0 0.02 0.04 7.0000000000000007E-2 0.12 0 0 0 0 0.03 0.16 0 0 0

Percentage (%) of Staff

Percentage (%) of Patients

Percentage (%) of Staff Histogram

Frequency 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% More 0 0 1 5 1 3 0 1 2 2 0

Percentage (%) of Staff

Frequency

Sheet2

Sheet3