What is the mean savings? What is the standard deviation of education? What is the median of education? AutoSave OFF GARSHome InsertXB51234Paste56789101112131415161718192021222324252627282930AVariableApp NumIncomeEducationAgeResidenceEmploySavingsDebtCredit caCredit cards313233343536373839404142434445ACDraw Page LayoutescArialB I U •X V fx The age of the applicant4 ▶Data DictionaryReady Accessibility: InvestigateSheet1✓11DescriptionThe identification number for the applicant.The income of the applicant, in US dollarsThe education level of the applicant, in yearsThe age of the applicant!138***The length of time that the applicant has lived at the current residence, in yearsThe length of time that the applicant has worked for the current employer, in yearsThe amount of savings that the applicant has, in US dollarsThe amount of debt that the applicant has, in US dollarsThe number of credit cards that the applicant hasF1CFormulas Data Review ViewA Α' Α΄2V1UA-F2+BWEME#380F3E54$000ODDF4VERAutomate Tell me475%Wrap Text vMerge & Center vCLoanApp.xlsx - Read-OnlyF5TDGeneralA$%96EMacBook AirFF6YA bank requires eight pieces of information from loan applicants: income,education level, age, length of time at current residence, length of time withcurrent employer, savings, debt, and number of credit cards. A bankadministrator wants to analyze this data to determine the best way to groupand report it. The administrator collects this information for 30 loanapplicants.&←8987GHJaF7✓ E DConditional Format -CellFormatting as Table Styles* 008UIDIIJF8(9K1DDVF9$xLo AutoSave OFF A B C ...Insert Draw Page LayoutXLGHome✩A212Paste34567389101112AApp Num6403459819152627807co310849sk39020%929729resP9238257851314 51515 101516 58717 53418 28619 59672541135123 73720212224415334256753142826229 10213073731 100432333435363738394041424344

Question

What is the mean savings? What is the standard deviation of education? What is the median of education? AutoSave OFF GARSHome InsertXB51234Paste56789101112131415161718192021222324252627282930AVariableApp NumIncomeEducationAgeResidenceEmploySavingsDebtCredit caCredit cards313233343536373839404142434445ACDraw Page LayoutescArialB I U •X V fx The age of the applicant4 ▶Data DictionaryReady Accessibility: InvestigateSheet1✓11DescriptionThe identification number for the applicant.The income of the applicant, in US dollarsThe education level of the applicant, in yearsThe age of the applicant!138***The length of time that the applicant has lived at the current residence, in yearsThe length of time that the applicant has worked for the current employer, in yearsThe amount of savings that the applicant has, in US dollarsThe amount of debt that the applicant has, in US dollarsThe number of credit cards that the applicant hasF1CFormulas Data Review ViewA Α' Α΄2V1UA-F2+BWEME#380F3E54$000ODDF4VERAutomate Tell me475%Wrap Text vMerge & Center vCLoanApp.xlsx - Read-OnlyF5TDGeneralA$%96EMacBook AirFF6YA bank requires eight pieces of information from loan applicants: income,education level, age, length of time at current residence, length of time withcurrent employer, savings, debt, and number of credit cards. A bankadministrator wants to analyze this data to determine the best way to groupand report it. The administrator collects this information for 30 loanapplicants.&←8987GHJaF7✓ E DConditional Format -CellFormatting as Table Styles* 008UIDIIJF8(9K1DDVF9$xLo AutoSave OFF A B C ...Insert Draw Page LayoutXLGHome✩A212Paste34567389101112AApp Num6403459819152627807co310849sk39020%929729resP9238257851314 51515 101516 58717 53418 28619 59672541135123 73720212224415334256753142826229 10213073731 100432333435363738394041424344< ▶Calibri (Body)B I U vXfx 640escBCIncome Education5000072000161861000010001810680008800091100311004510013:00362005020041000400002000032000320002900023000212405870041000387208824040000346002980056400398005420042650622007220026530365004000041200500002020Sheet118101414142412221616161212141616161816121614161614161216161216!DAge28353625F13538114129343230282638293638394027302931274034302629Data DictionaryReady Accessibility: Investigate3435✓11VEResidence21064-8156982122951113714123538512358(@+F2Formulas• Α' Α'AvFEmploy285491458724293411126123123210422246GSavings5000120001500040000980-200004000039009900100400Data300050001900016000210010045003002450013600160003400010030002500142005200100001200003100190010004500#20F3EHDebt1200540010001100o09220007000200176055046001001078001000054081001300100100001200900800Review View100070040012000800130012001400E$Credit cards2432423322I24-4F233212622525321235E000000F4JAutomateab Wrap Text v%Merge & Center ✓F5LoanApp.xlsx - Read-OnlyTell meKL+<<GeneralF6$ % 9VMacBook AirMN&7F70.00*

Accepted Answer

The data is given in the Excel sheet whose name is LoanApp.The data contains 9 variables.Sample size…