Use the reported average loan amount of $$55,000$ by the banking industry to test to see if Society Bank loans are higher on average than the industry as a whole. Use $\backslash$alpha $=0\mathrm{.}05$

State the hypotheses. You need null and alternative hypotheses.

Use the Excel Calculator for hypothesis testing a population mean. Save your file and upload it with your report.

Write your conclusions including your p$-$value, test statistic, and level of significance.

Loan Amount $$Type$$Region

$$33,000\mathrm{.}00$Consumer$1$

$$30,500\mathrm{.}00$Commercial$1$

$$84,500\mathrm{.}00$Commercial$2$

$$110,500\mathrm{.}00$Commercial$3$

$$21,500\mathrm{.}00$Commercial$3$

$$59,500\mathrm{.}00$Commercial$4$

$$48,500\mathrm{.}00$Real Estate$1$

$$57,000\mathrm{.}00$Commercial$2$

$$116,000\mathrm{.}00$Commercial$3$

$$89,500\mathrm{.}00$Consumer$1$

$$40,000\mathrm{.}00$Consumer$1$

$$117,500\mathrm{.}00$Real Estate$1$

$$78,500\mathrm{.}00$Commercial$1$

$$76,000\mathrm{.}00$Consumer$1$

$$90,000\mathrm{.}00$Commercial$1$

$$19,000\mathrm{.}00$Commercial$1$

$$72,500\mathrm{.}00$Consumer$1$

$$57,000\mathrm{.}00$Real Estate$1$

$$102,500\mathrm{.}00$Real Estate$2$

$$36,000\mathrm{.}00$Commercial$1$

$$123,500\mathrm{.}00$Consumer$1$

$$9,000\mathrm{.}00$Consumer$1$

$$31,000\mathrm{.}00$Commercial$4$

$$5,500\mathrm{.}00$Consumer$2$

$$29,000\mathrm{.}00$Commercial$2$

$$82,000\mathrm{.}00$Real Estate$1$

$$10,500\mathrm{.}00$Consumer$4$

$$72,000\mathrm{.}00$Commercial$3$

$$67,000\mathrm{.}00$Commercial$4$

$$6,500\mathrm{.}00$Consumer$1$

$$28,500\mathrm{.}00$Commercial$4$

$$113,500\mathrm{.}00$Consumer$1$

$$99,000\mathrm{.}00$Real Estate$3$

$$93,500\mathrm{.}00$Real Estate$3$

$$102,000\mathrm{.}00$Consumer$4$

$$94,000\mathrm{.}00$Consumer$2$

$$89,500\mathrm{.}00$Commercial$1$

$$66,500\mathrm{.}00$Commercial$3$

$$22,000\mathrm{.}00$Commercial$1$

$$107,000\mathrm{.}00$Consumer$3$

$$65,000\mathrm{.}00$Commercial$1$

$$109,000\mathrm{.}00$Commercial$1$

$$118,000\mathrm{.}00$Real Estate$1$

$$5,500\mathrm{.}00$Commercial$1$

$$124,500\mathrm{.}00$Commercial$2$

$$12,000\mathrm{.}00$Commercial$2$

$$86,000\mathrm{.}00$Consumer$1$

$$113,500\mathrm{.}00$Consumer$4$

$$93,500\mathrm{.}00$Commercial$1$

$$6,000\mathrm{.}00$Commercial$1$

$$108,500\mathrm{.}00$Consumer$1$

$$63,500\mathrm{.}00$Commercial$4$

$$24,500\mathrm{.}00$Consumer$1$

$$85,500\mathrm{.}00$Commercial$1$

$$95,000\mathrm{.}00$Real Estate$3$

$$89,000\mathrm{.}00$Real Estate$3$

$$83,000\mathrm{.}00$Real Estate$3$

$$98,500\mathrm{.}00$Consumer$3$

$$98,000\mathrm{.}00$Commercial$1$

$$57,000\mathrm{.}00$Commercial$1$

$$79,000\mathrm{.}00$Commercial$3$

$$36,000\mathrm{.}00$Commercial$3$

$$78,000\mathrm{.}00$Consumer$1$

$$50,000\mathrm{.}00$Commercial$2$

$$98,000\mathrm{.}00$Consumer$2$

$$87,000\mathrm{.}00$Consumer$3$

$$22,000\mathrm{.}00$Real Estate$2$

$$70,000\mathrm{.}00$Consumer$1$

$$36,500\mathrm{.}00$Consumer$4$

$$117,000\mathrm{.}00$Real Estate$3$

$$66,000\mathrm{.}00$Commercial$2$

$$84,000\mathrm{.}00$Commercial$3$

$$118,500\mathrm{.}00$Consumer$3$

$$70,000\mathrm{.}00$Real Estate$1$

$$125,000\mathrm{.}00$Consumer$1$

$$99,000\mathrm{.}00$Commercial$3$