A marketing study of $800$ aduts in the $18\mathrm{.}34$ age group reported the following information:

Spent less than $$100$ cn chidren's ciothing per year $50$ responses

Spent $$100-$$$499\mathrm{.}99$ on children's dothing per year $260$ responses

Spent $$500-$$$99999$ cn chidren's clothing per year: $185$ responses

Spent nothing: the remainder

Develop a spreadsheet to estimate the sample mean and sample standard deviation of spending or children's clothing for this age group using the following formulas, where $k$ is the number of groups and $M$ is the midpoint of group i$.$

$[$i$]$ Click the icon to view the formulas.

Complete the table below.

$($Round to the nearest whole number as needed.$)$

$\backslash$table$[[$Money Spent,Midpoint,Frequency,$f_1{M}_1,f_1(M_1-x)$