(20 points) Find the 99% confidence interval for the variable Age in the Pelican.xls data using Excel. Open the data file. Select Tools > Data Analysis > Descriptive Statistics. For the Input Range, highlight the data including the labels. Check the Labels in first row box (Make sure you highlighted the label in the input range. Check the box Summary statistics, Confidence Level for Mean and change to 99.

Then click OK. You now need to subtract and add the confidence level at the bottom of the table from the mean to

find the two values for the confidence interval. To do this click on an empty cell below the table, type = then click on the cell where the mean is then type -, then click on the cell where the confidence level value is, then hit enter. For example =D3-D16. Repeat in the cell next to the lower bound you just found, but this time add the two values for the upper bound. For example =D3+D16. Format to 8 decimal places. Then type in the confidence interval in interval notation below the table. Copy the table and your confidence interval to the original excel lab.

Here's the pelican xls data :

Method of Payment	Items	Discount	Sales	Gender	Marital Status	Age
Discover	1	0.00	39.50	Male	Married	32
Proprietary Card	1	25.60	102.40	Female	Married	36
Proprietary Card	1	0.00	22.50	Female	Married	32
Proprietary Card	5	121.10	100.40	Female	Married	28
Mastercard	2	0.00	54.00	Female	Married	34
Mastercard	1	0.00	44.50	Female	Married	44
Proprietary Card	2	19.50	78.00	Female	Married	30
Visa	1	0.00	22.50	Female	Married	40
Proprietary Card	2	22.48	56.52	Female	Married	46
Proprietary Card	1	0.00	44.50	Female	Married	36
Proprietary Card	1	0.00	29.50	Female	Married	48
Proprietary Card	1	7.90	31.60	Female	Married	40
Visa	9	103.60	160.40	Female	Married	40
Visa	2	24.50	64.50	Female	Married	46
Visa	1	0.00	49.50	Male	Single	24
Proprietary Card	2	12.60	71.40	Male	Single	36
Proprietary Card	3	53.00	94.00	Female	Single	22
Discover	3	0.00	54.50	Female	Married	40
Mastercard	2	19.00	38.50	Female	Married	32
Proprietary Card	6	32.20	44.80	Female	Married	56
Proprietary Card	1	7.90	31.60	Female	Single	28
Proprietary Card	4	29.67	70.82	Female	Married	38
American Express	7	66.50	266.00	Female	Married	50
Proprietary Card	2	0.00	74.00	Female	Married	42
Visa	2	14.50	39.50	Male	Married	48
Proprietary Card	1	9.48	30.02	Female	Married	60
Proprietary Card	1	0.00	44.50	Female	Married	54
Proprietary Card	5	48.20	192.80	Female	Single	42
Proprietary Card	3	37.30	71.20	Female	Married	32
Proprietary Card	1	4.50	18.00	Female	Married	70
Mastercard	2	15.80	63.20	Female	Married	28
Proprietary Card	1	0.00	75.00	Female	Married	52
Proprietary Card	3	15.80	63.20	Female	Married	44
Proprietary Card	1	0.00	40.00	Female	Married	34
Mastercard	5	10.00	105.50	Female	Married	56
Mastercard	1	0.00	29.50	Male	Single	36
Visa	2	0.00	102.50	Female	Single	42
Proprietary Card	6	14.50	117.50	Female	Married	50
Proprietary Card	5	25.02	13.23	Female	Married	44
Proprietary Card	2	0.00	52.50	Female	Married	58
Proprietary Card	13	62.70	198.80	Female	Married	42
Visa	4	16.50	19.50	Female	Married	46
Proprietary Card	2	0.00	123.50	Female	Married	48
Proprietary Card	1	15.60	62.40	Female	Married	54
Proprietary Card	2	35.20	23.80	Female	Married	38
Proprietary Card	2	19.40	39.60	Female	Married	60
Mastercard	1	0.00	25.00	Female	Married	46
Proprietary Card	3	20.11	63.64	Female	Married	30
Proprietary Card	1	4.68	14.82	Female	Married	32
Mastercard	9	94.30	145.20	Female	Married	46
Proprietary Card	6	58.88	176.62	Female	Married	38
Proprietary Card	5	51.70	118.80	Male	Married	68
Discover	1	0.00	58.00	Female	Single	78
Visa	2	0.00	74.00	Female	Single	20
Mastercard	2	0.00	49.50	Female	Married	32
Proprietary Card	3	35.40	141.60	Female	Married	38
Proprietary Card	6	56.40	123.10	Female	Married	54
Proprietary Card	2	20.10	80.40	Female	Married	48
Mastercard	4	28.30	65.20	Female	Married	46
Proprietary Card	4	19.50	113.00	Female	Single	50
Proprietary Card	1	19.20	108.80	Female	Married	46
Proprietary Card	3	91.48	59.91	Female	Single	30
Proprietary Card	5	37.40	53.60	Female	Married	54
Proprietary Card	1	7.90	31.60	Female	Single	42
Proprietary Card	2	9.50	49.50	Female	Married	48
Proprietary Card	1	9.90	39.60	Female	Married	62
Proprietary Card	2	29.50	59.50	Female	Married	34
Proprietary Card	5	36.70	146.80	Female	Married	28
Proprietary Card	2	11.80	47.20	Male	Married	46
Proprietary Card	8	18.95	95.05	Female	Married	54
Proprietary Card	5	57.18	155.32	Female	Married	30
Mastercard	4	10.00	58.00	Female	Married	32
Proprietary Card	1	0.00	69.00	Female	Single	22
Proprietary Card	2	15.50	46.50	Female	Married	32
Proprietary Card	2	14.28	45.22	Female	Married	74
Proprietary Card	4	46.26	84.74	Female	Married	62
Proprietary Card	2	0.00	39.00	Female	Married	42
Proprietary Card	4	35.11	111.14	Female	Married	28
Proprietary Card	3	31.20	86.80	Female	Married	38
Discover	2	0.00	89.00	Female	Married	54
Mastercard	2	19.50	78.00	Female	Married	68
Proprietary Card	6	29.31	53.20	Female	Single	30
Visa	4	14.50	58.50	Female	Married	36
Proprietary Card	3	19.50	46.00	Female	Married	44
Visa	2	0.00	37.50	Female	Married	44
Proprietary Card	1	5.20	20.80	Female	Married	62
Mastercard	6	0.00	144.00	Female	Single	48
Proprietary Card	4	0.00	107.00	Female	Married	36
Proprietary Card	1	7.90	31.60	Female	Single	20
Proprietary Card	6	46.40	57.60	Female	Married	42
Proprietary Card	4	158.30	95.20	Female	Married	54
Proprietary Card	1	7.08	22.42	Female	Married	54
Proprietary Card	5	0.00	159.75	Female	Married	72
Proprietary Card	17	33.00	229.50	Female	Married	30
American Express	3	0.00	66.00	Female	Married	46
Mastercard	1	0.00	39.50	Female	Married	44
Proprietary Card	9	82.75	253.00	Female	Married	30
Proprietary Card	10	18.00	287.59	Female	Married	52
Proprietary Card	2	31.40	47.60	Female	Married	30
Proprietary Card	1	11.06	28.44	Female	Married	44