Grantham University Descriptive Statistics Performance Analysis Review Data Set 2 and complete the analysis for each of the raw data provided. Your results

Grantham University Descriptive Statistics Performance Analysis Review Data Set 2 and complete the analysis for each of the raw data provided. Your results should be similar to the sheets that are marked Complaints2, etc. For these and future assignments, Copy and Paste the required charts or graphs onto a .doc as well as provide a brief explanation of the data. Be sure you label charts and graphs (x- and y-axis, chart title, chart legend, etc.). A sample will be posted in a Course Update.Assignment #3…there appears to be some confusion on Assignment #3. For this assignment you are to replicate the histogram; descriptive statistics, and frequency distribution found in the Complaints2, etc spreadsheets. Then copy and paste your charts/tables in a short memo explaining what the data shows # of Complaints
20
25
23
17
26
26
22
33
31
19
29
13
23
25
26
26
25
28
28
33
14
31
21
24
Range
20
25
30
Range
20
25
23
17
26
26
22
33
31
19
29
13
23
25
26
26
25
28
28
33
14
31
21
24
Range
More
20
25
30
Frequency Cumulative %
20
5
20.83%
25
8
54.17%
30
7
83.33%
4
100.00%
Number of Complaint
9
8
7
6
Frequency
# of Complaints
5
4
3
2
1
0
20
Number of Complaints
120.00%
100.00%
80.00%
60.00%
40.00%
20.00%
0.00%
25
30
Range
Frequency
Cumulative %
More
Response Time (in minutes)
2
5
4
2
3
6
5
12
5
3
5
4
7
19
4
5
6
4
3
4
Response Time (in minutes)
2
5
4
2
3
6
5
12
5
3
5
4
7
19
4
5
6
4
3
4
Response Time (in minutes)
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
5.4
0.862676374
4.5
5
3.85800603
14.88421053
8.362866468
2.722529718
17
2
19
108
20
This year
Last year
Two years
Total
Traffic Accidents in City (per 1000 population)
Fatal
Serious
Not Serious
Total
3
6
12
4
7
15
3
10
13
Proportion
This year
Last year
Two years
Total
Traffic Accidents in City (per 1000 population)
Fatal
Serious
Not Serious
Total
3
6
12
4
7
15
3
10
13
10
23
40
Proportion
21 0.28767123
26 0.35616438
26 0.35616438
73

Purchase answer to see full
attachment