Conduct a Descriptive and Inferential Analysis Based on Variables

Descriptive Analysis

Suppose you were provided with the provider training and patient satisfaction scores for seven hospitals in your locality (as shown below). To summarize this data, provide a descriptive analysis and narrative that includes the mean, median, mode, Variance and standard deviation for both the provider training and patient satisfaction scores. For guidance, reference pages 86-90 in your Analyzing Healthcare Datatext.

Provider ID	Provider Training	Patient Satisfaction
Hospital 1	28	20
Hospital 2	42.8	34.4
Hospital 3	30.9	25.6
Hospital 4	38.4	24.4
Hospital 5	22	16.3
Hospital 6	15.5	12.6
Hospital 7	48.6	33.1

Inferential Statistics

Using the data in table 1 (below), investigate the relationship between average score for provider training and patient satisfaction by hospitals in your locality. There are seven hospitals with average scores for both provider training and patient satisfaction. Use Pearson correlation to measure the strength and direction of the relationship between the two scores.

Provider ID	Provider Training	Patient Satisfaction
Hospital 1	28	20
Hospital 2	42.8	34.4
Hospital 3	30.9	25.6
Hospital 4	38.4	24.4
Hospital 5	22	16.3
Hospital 6	15.5	12.6
Hospital 7	48.6	33.1

For this assignment, review pages 128-130 in the Analyzing Healthcare Datatext for guidance. Show your calculation and results by producing tables and charts similar to those see on pages 128-130.

FOR THIS ASSIGNMENT, THE STEPS NEED TO BE EXPLAINED TO SHOW HOW YOU CAME ABOUT THE INFORMATION