IntroductionDescriptive statistics play an important role in analyzing data. It numerically summarizes key characteristics of variables. Measures of central tendency (mean, median, and mode) and dispersion (variance, standard deviation, and range) characterize the probability distribution. A histogram visualizes the distribution of numerical data, indicating the number of data points that lie within a range of values. For this assignment, you will perform descriptive statistics and create a histogram for selected variables in a data set.Preparation Download Assignment 1 Data Set [XLSX]. The data set contains the following variables:Utilization (average number of patient days per month).Satisfaction (patient satisfaction scores percentile rank).Readmissions (readmission rate per month).Nursing home administration has the objectives of higher utilization, higher patient satisfaction, and lower readmissions. Select one of the three variables to analyze to create a plan of action for improvement. Provide a rationale for your selection. Base your analysis on average performance over the past 70 months.For this assignment, create a descriptive statistics table and histogram for one of the three variables in the Assignment 1 Data Set [XLSX]. Write your recommendation and plan of action in a Word document and insert the table and histogram graphic into this document. See the Sbmit both the Word document and the Excel file that shows the descriptive statistics output. You only need to create the descriptive statisics and histogram for one (1) variable.
utilization satisfactionreadmissions
74.27057
100 0.084485
63.99188
16 0.177423
98.59192
31 0.164667
83.83318
3 0.178409
102.6872
89 0.007154
67.99378
22 0.150899
46.14154
19 0.044172
43.72361
29 0.048756
57.88714
79 0.165101
67.59221
59 0.142432
86.79082
70 0.020972
97.85154
26 0.064269
65.94915
22 0.126403
68.7699
51 0.160362
73.48808
10 0.143454
44.06588
52 0.117126
21.39799
8 0.096196
63.73128
6 0.058184
60.3591
21 0.122917
104.9315
35 0.124026
44.06642
19 0.068038
74.79688
19 0.094528
73.80654
12 0.147442
74.13603
7 0.098442
53.15719
45 0.207075
37.7386
71 0.036068
56.67985
6 0.104524
34.09113
62 0.118022
82.18294
57 0.207321
117.4468
55 0.145666
72.63796
69 0.089209
66.48575
99 0.101125
60.31853
78 0.075609
97.4345
60 0.150218
55.71568
74 0.124018
78.65189
37 0.124208
101.5713
15 0.187252
65.80222
11 0.026605
76.79661
11 0.10254
73.13039
96 0.075294
44.72086
29 0.056506
98.73114
96 0.048891
33.8434
83 0.174334
84.88798
78 0.131844
52.40842
96 0.167126
57.31398
81 0.112467
52.43385
65.57764
83.33311
43.04142
37.8057
74.8687
69.84653
65.56504
60.51123
71.25343
54.01618
51.56944
66.47474
110.626
35.71084
107.777
73.49521
96.69419
105.5554
64.83288
61.43368
69.81598
114.9896
87.70982
70
99
96
91
58
38
59
79
88
38
13
54
35
63
56
22
90
28
8
94
78
7
27
50
0.061826
0.131735
0.081496
0.099062
0.073216
0.144065
0.042271
0.030994
0.119027
0.180316
0.08865
0.106493
0.022939
0.162756
0.098004
0.078145
0.065701
0.119516
0.103598
0.015921
0.123979
0.114584
0.081302
0.10172