Bill Amount

$34\mathrm{.}65$

$65\mathrm{.}00$

$45\mathrm{.}40$

$41\mathrm{.}42$

$48\mathrm{.}99$

$47\mathrm{.}12$

$55\mathrm{.}33$

$29\mathrm{.}89$

$46\mathrm{.}91$

$55\mathrm{.}68$

$17\mathrm{.}50$

$34\mathrm{.}87$

$44\mathrm{.}50$

$26\mathrm{.}38$

$47\mathrm{.}66$

$47\mathrm{.}10$

$63\mathrm{.}75$

$48\mathrm{.}54$

$54\mathrm{.}37$

$74\mathrm{.}60$

$57\mathrm{.}22$

$45\mathrm{.}06$

$98\mathrm{.}20$

$52\mathrm{.}38$

$46\mathrm{.}40$

$46\mathrm{.}00$

$60\mathrm{.}34$

$49\mathrm{.}16$

$48\mathrm{.}87$

$46\mathrm{.}00$

$48\mathrm{.}20$

$47\mathrm{.}87$

$22\mathrm{.}90$

$40\mathrm{.}23$

$28\mathrm{.}75$

$24\mathrm{.}13$

$56\mathrm{.}30$

$95\mathrm{.}00$

$38\mathrm{.}17$

$47\mathrm{.}47$

$46\mathrm{.}05$

$43\mathrm{.}00$

$45\mathrm{.}21$

$19\mathrm{.}70$

$64\mathrm{.}17$

a$.$ Provide the Descriptive Statistics.

b$.$ Create a NORMAL PROBABILITY PLOT.

c$.$ Create a BOXPLOT and calculate the five$-$number summary using the correct Excel functions.

d$.$ Compare: mean$/$median$,$ range$/$SD$,$ IQR$/$SD$,$ and state if the data are approximately normally distributed. Hint: Also look at the normal probability plot and the Histogram.

e$.$ Construct a $95\%$ Confidence Interval for the population mean for bill amount assuming normal distribution and interpret its meaning.

f$.$ Assuming a normal distribution, what is the probability that the average bill of the sample is between $$30$ and $$38?$

Please solve this in excel step by step and explain it$.$ I need to solve this question MS excel only, please do not use statcrunch. please send step by step in MS excel only. If possible please send a video solving the question, especially create normal pobability distribution and boxplot. Please send the video link for this question.