The data given below represent the time (in minutes) need to finish their banking process by 50 sample customers in a private bank.

57 55 71 59 58 50 65 47 49 64

56 55 67 58 67 57 58 59 71 55

54 60 50 52 55 72 66 65 58 51

69 64 46 48 54 53 65 43 68 62

58 68 51 63 49 59 57 57 62 58

(a) Calculate the mean, median, mode (Check your answers using Excel functions), first quartile, third quartile and interpret your answers.

(b) Find the range, standard deviation and comment on time (in minutes) need to finish the banking process by customers. Check your answers using Excel functions.

(c) Construct a frequency distribution having the class limits 40-45, 45-50, 50- 55 and so on using Pivot table.

(d)Construct a cumulative frequency distribution.

(i) What percent of the customers needed to finish their process less than 50 minutes?

(ii) What percent of the customers needed to finish their process between 60 and 70 minutes?

(iii)What percent of the customers needed to finish their process more than 65 minutes?