I need help to find the Excel formulas to calculate these questions. I used my calculator, but was instructed to use Excel only. Thanks!

The following data are the amounts that a sample of 15 customers spent for lunch($) at afast-food restaurant. Complete parts(a) through(c) below.

7.43

6.30

5.84

6.46

8.33

9.45

7.07

6.79

5.95

4.89

6.46

5.51

7.92

8.28

9.63

a. Construct a 95% confidence interval estimate for the population mean amount spent for lunch($) at afast-food restaurant.

nothing

nothing

(Round to two decimal places as needed. Do not include the$ symbol in youranswer.)

b. Interpret the interval constructed in(a). Choose the correct answer below.

A.

Conclude with 95% confidence that the mean amount in dollars spent for lunch at thefast-food restaurant for the sample is contained in the interval.

B.

95% of the sample data fall between the limits of this confidence interval.

C.

The mean amounts in dollars spent for lunch at thefast-food restaurant of 95% of all samples of the same size are contained in the interval.

D.

Conclude with 95% confidence that the population mean amount in dollars spent for lunch at thefast-food restaurant is contained in the interval.

c. What assumption must you make about the population distribution in order to construct the confidence interval estimate in(a)?

A.

The population distribution is skewed left.

B.

The population distribution is skewed right.

C.

The population distribution is normally distributed.

D.

The population distribution is uniformly distributed.