Standard Deviation $(10$ points$)$

Juan and Ana sell office supplies. Below are their monthly sales numbers for the year.

$\backslash$table$[[$Juan$,15,000,14,500,15,000,14,500,13,000,14,500,14,000,15,500,14,500,14,500,14,000,14,500],[$Ana$,12,000,15,000,12,750,11,250,18,000,18,500,12,500,12,000,17,000,11,250,12,750,13,000]]$

For this population, find the mean and standard deviation, then answer the question below.

Look at all the data to determine the overall Mean and Standard Deviation using formulas. $(2$ pts each$)$

a$)$ Mean

b$)$ Std Deviation

$\backslash$table$[[$HINT:$,],[=$ A$1+$A$2,$Add cells A$1$ and A$2],[=$ C$3-$C$8,$Subtracts C$8$ from C$3],[=$ E$7/$J$4,$Divides cell E$7$ from J$4],[=$ N$10*1\mathrm{.}05,$Multiplies cell N$10$ by $1\mathrm{.}05],[=$ R$5^2,$Finds the square of R$5],[=$ SQRT$($C$5),$Finds square root of C$5]]$

Take all the individual data points from above and complete the chart using Excel formulas as indicated in table heading. $(2$ pts $C$$3$ Remains static if cells are copied

$\backslash$table$[[$Sales$,(x-\stackrel{}{x}),(x-\stackrel{}{x}{)}^2$

For number two it goes all the way down to $36$