SSG120 Analyze Project Files
.xlsx
keyboard_arrow_up
School
Villanova University *
*We aren’t endorsed by this school
Course
120
Subject
Health Science
Date
Jan 9, 2024
Type
xlsx
Pages
15
Uploaded by MajorSummer12908
1. Create a Stem and Leaf Plot that were captured from the patient wait times in the waiting rooms. (SEE AP
2. Calculate the Measures of Central Tendency and Measures of Disperions from the data in Appendix D.
What can you interpret from these measures? Please document a conclusion.
3. T- Test: Two individual staff members were being observed performing identical activities in the Doctor
Medical Assistant #1 has been with Dr. Deasley for several years. Medical Assistant #2 is a new employee an
We want to determine how Medical Assistant #2 performs when compared to Medical Assistant #1 since sh
Assume this is a one-sided t-test and the historical average of Medical Assistant #1 is .0126
Please provide the following information based on your analysis of the two Medical Assistants
• Medical Assistant #2 Average
• Medical Assistant #2 Standard Deviation
• Null Hypothesis
• Alternative Hypothesis
• T-Test Statistic
• Critical Value
• Statistical Conclusion for the null and alternative hypothesis.
PPENDIX D in this file for data set)
r’s office. 25 random samples were taken. One of the Medical Assistants is a new employee. nd has been with this medical practice for 9 months.
he is a new employee. (SEE APENDIX Ein this file for data set)
Project:
Dr Deasley
Deliverable:
Stem & Leaf
Reynosa
9
5
8
0
2
7
1
5
6
3
4
5
5
0
0
0
1
1
2
8
4
4
4
5
6
6
7
7
7
3
2
5
7
8
2
0
0
0
0
1
1
2
6
1
0
1
3
4
5
5
6
6
0
6
Is it reasonably normally distributed?
If it is not normal, what shape is it? (Use the correct name for this shape, not a de
Based on this analysis, what is the next thing you would do?
Student last name:
7
7
7
7
8
8
8
8
8
8
6
6
6
7
7
7
7
7
7
8
No
escription.)
Bimodal Distribution
9
9
9
8
9
The data is in Appendix D in this file. Measures of Central Tendency
Mean
37.528571
Hint: Use the AVERAGE function
Median
44.5
Hint: Use the MEDIAN function
Mode
48
Hint: Use the MODE function
Measures of Dispersion Standard Deviation
20.14780272
Range 89
Hint: Use the RANGE function
Hint: use STDEV.S function. The .S is because this is a
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help