The following data were collected from samples of call lengths (in minutes) overserved for two (2) different cell phone users.
Excel:
D E
1
2 i) ii)
3 2 2
4 2 25
5 44 31
6 2 44
7 2 29
8 2 14
9 2 22
10 11
11 40
a. What is the Excel formula, including inputs, used to calculate the MAX of i), the first data set?
b. Calculate the Range of i), the first data set.
[hint: copy and paste into Excel; use =MAX(cell:cell)-MIN(cell:cell)]
c. Calculate the Range of ii), the second data set.
d. Between the two data sets, which is less dispersed?