For the data in the Excel file Debt and Retirement Savings, find 95% confidence intervals for the mean income, long-term debt, and retirement savings. Use the appropriate formulas and Excel functions. X✓ fx Debt and Retirement Savings A B 1 Debt and Retirement Savings 2 3 Marital Status 4 Single 5 Single A1 Name Box 6 Single 7 Married 8 Single 9 Single 10 Married 11 Single 12 Single 13 Married 14 Married 15 Married 16 Single Single 17 Single 18 Single 19 Single 20 Single 21 Single 22 Single 23 Married 24 Single 25 Single 26 Married 27 Married 28 29 30 31 32 33 34 35 PLL Age 28 29 28 29 26 23 30 30 30 28 22 32 29 29 33 29 27 27 C 30 31 Education Undergraduate Degree Graduate Degree Graduate Degree Undergraduate Degree Graduate Degree 38 38 26 Undergraduate Degree 28 28 28 28 29 29 28 20 Undergraduate Degree Undergraduate Degree raduate Undergraduate Degree Undergraduate Degree Graduate Degree Graduate Degree Graduate Degree Graduate Degree Graduate Degree Graduate Degree Undergraduate Degree Undergraduate Degree Undergraduate Degree Undergraduate Degree Graduate Degree Graduate Degree Undergraduate Degree Undergraduate Degree Graduate Degree Graduate Degree D Income $101,000 $56,000 $120,000 $63,500 $48,000 $25,200 $33,000 $42,000 $38,500 428 200 $128,200 583 500 $83,500 $52.000 $52,000 $189.000 $118,000 $36,800 $58,000 $84,000 965,000 $63,000 $138,000 190,000 $106,000 $43,000 $68,000 $53,000 $117,000 E Long Term Debt Debt Paid per Year Source of Debt SO N/A $0 $0 SO N/A $84,000 $12,000 Education Loans SO N/A SO $12,000 $21,000 $3,000 Education Loans $SO Education Loans $9.600 Education Loans SO N/A $45,000 SO $4,800 Auto/Boat Loans SO N/A SO N/A SO N/A SO N/A $18.000 Education Loans SO N/A SU NIA $2,300 Auto/Boat Loans SO N/A SO NIA $17,300 SO SO $0 SO $0 $103,000 SO SU $11,000 $0 50 30 $0 $40,000 $36,000 G $74,000 $13,000 $8,000 $24,000 $42,000 SO NIA SO N/A $4,200 Small Business Loans $7,200 Education Loans $8,000 Education Loans $3,000 Auto/Boat Loans $2,400 Auto/Boat Loans $4,100 Auto/Boat Loans $9,000 Education Loans H Retirement Savings Annual Retirement Contribution $56,000 $5,000 $23,700 $29,000 $18,700 $3,000 $4,000 $26,000 $18.000 $67.000 $67,000 $169,000 $13.500 $13,500 $16,000 $31,000 $19.800 $19,800 $32,400 $47,000 $38,000 $98.000 390,000 $6,600 $10,900 $26,500 $31,000 $76,400 $15,000 $6,720 $13,200 $5,800 $5,000 $200 $1,000 $5,000 $3,200 $17,500 $10,000 $4,500 $27,000 $13,500 $4,300 $8,000 $12,700 $7,090 $7,650 $14,300 $12,900 $3,000 $6,700 $5,200 $19,600 J K