Dave & Buster's manager, Ms. Christy wants to estimate the mean age of customers who spend $90

or more in its branches. To get a reliable estimate, she was able to sample her customers who spend

$90 or more in her store as well as their ages.

a) Construct 96% confidence interval for the population mean age of customers who spend $90 or more.

b) Would it be reasonable for the manager to conclude that the mean age is 32?

c) Would it be reasonable for the manager to conclude that the mean age is 46?

d) What range of age will 95% of all ages of all customers sampled by the manager fall into?

Below is the sample data collected by the manager

Age of customers

18

25

43

15

24

23

20

56

46

40

50

26

47

35

70

23

58

28

25

48

38

55

54

58

28

27

49

58

38

Please show excel formulas used to solve these problems.