bus stat

bus_stat_2_excel.xlsx

Data

A local bank recorded the number of customers to use a downtown ATM during the noon hour on 60 consecutive workdays.
Use the Excel functions to find each of the following as it relates to the "Number" of customers using the ATM:
Express each answer with 1 decimal place. (20 total points)
Number of Customers			Mean
25			Median
37			Mode
23			Variance
26			Standard Deviation
30			85th Percentile
40			1st Quartile
25			Maximum
26			Minimum
39			Range
32
21
26
19
27
32
25
18
26
34
18
31
35
21
33
33
9
16
32
35
42
15
24
26
19
27
32
25
18
26
31
35
21
33
33
9
16
25
37
23
26
30
40
25
26
39
21
26
19
27
32
WA	Seaview	Shoalwater	Shelburne Inn	43	86