MBADM 813: Mid-Term 1 3. The file CDRate.savcontainsyieldsforaone-year certificate of deposit (CD) anda five-yearCD for 25 banks in the United States as of April 15, 2015. For questions (a)- (c) run the appropriate analysis and have you output ready with the answers. In the exam. You will have spaces to enter your responses. a) Construct 95% and 99% confidence interval estimates for the mean yield of one-year CDs. (7points) b) Construct 95% and 99% confidence interval estimate for the mean yield of five-years CDs. (7points) c) If you want your estimate to be within o.1% (for one-year CDs) and +0.15% for five- year CDs, what sample size is required in each case (calculate for both 95% and 99% confidence intervals)? (6 points) All relevant output for this should be saved in the SPSS viewer file .spv. Note: You can use the "Edit > Copy ' menu to copy contents from one .spy file, then use 'Edit > Paste After' to paste to another .spy file If you use Excel for Part (c) Please use Sheets of .xIsx