SSG120 Analyze Project Files

.xlsx

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