The data in "M8-Assignment" Excel file provides yields for aone-year certificate of deposit(CD) and afive-year CD for 25 banks.

1. Construct a 90% confidence interval estimate for the mean yield ofone-year CDs.
2. The data in "M8-Assignment" Excel file provides yields for aone-year certificate of deposit(CD) and afive-year CD for 25 banks.

Bank	One-Year CD	Five-Year CD
1	0.5	4.85
2	0.85	5
3	0.95	5.1
4	0.25	3.25
5	0.4	3.95
6	0.25	4
7	0.6	3.65
8	1.9	4.35
9	0.85	4.7
10	0.6	4.15
11	0.45	4.45
12	0.6	3.45
13	0.3	4.15
14	0.6	5.1
15	1.75	4.25
16	0.95	4.2
17	1.4	4.9
18	2.15	4.65
19	0.9	4.95
20	0.95	4.6
21	0.5	4.45
22	0.55	4
23	0.35	3.55
24	1.2	4.45
25	1.9	4.1