Using the Final$-$Exam$-$Excel$-$Yourname.xIsm

Copy the information of the Tab $"$Q$1-$B$"$ to the Tab $"$Q$3"$ and calculate:

The means, median, mode, and standard deviation of Sales and COGS for Year $2$ are in columns $C$ and $D$ at the end of the data.

Calculate the $5$ th smaller number of Sales and COGS. $($Use the SMALL function$)$

Add labels and format property.

Example:

Means $=195,486\mathrm{.}7251,299\mathrm{.}51$

Median $=180,865\mathrm{.}0047,668\mathrm{.}88$

Mode $=162,359\mathrm{.}0051,361\mathrm{.}75$

Standard Deviation $=54,955\mathrm{.}0115,920\mathrm{.}79$

$5th$ smaller number $=265,366\mathrm{.}0074,800\mathrm{.}50$