It is believed that at least half of all loans are classified as commercial. Use this list of $350$ as a sample of all banking loans from last year $($think all banks$).$

Is the n$=350$ sample size less than $5\%$ of the population of all loans of all banks?

Is n$*$p$>5$ and n$*(1-$p$)>5?$

Can you use the normal distribution based on $1$ and $2$ above?

Compute the sample proportion of loans classified as commercial loans out of the $350$ listed in the file.

Compute the probability of getting your sample proportion of commercial loans or something smaller in Excel using the normal distribution. TIP: Use the Sample Proportion Probability Distribution Download Sample Proportion Probability Distribution.

Loan Amount Type Region

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

$