(See Solution) It is argued that the age of physician has a correlation with the patient satisfaction. Using Excel and Physician D ata (found in the data
Question: It is argued that the age of physician has a correlation with the patient satisfaction. Using Excel and Physician D ata (found in the data folder) , you are asked to compare the average patient satisfaction ( Patient_Satisfaction ) by age categories of physician to assess where that argument holds. Hint: You must create a new variable from the physician age variable indicating which age group the physician belongs to Group1 (<40), Group2 (41-60), and Group 3 (>61). You would like to know if there is a statistically significant difference in patient satisfaction between different age group of physician.
- State the null and alternative hypotheses for the problem.
- What is the mean patient satisfaction for the different age group of physician
- Run an ANOVA to test for a significant difference in the mean patient satisfaction between the age groups. What are the results? Write up the results as if you were presenting it in a publication.
- Use this data to ask an appropriate question where you will use a one-way ANOVA. State the null and alternative hypotheses and report the results. Write up the results as if you were presenting it in a publication. Bonus points if you have to create a new variable to answer your question!
Deliverable: Word Document 