Question
In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula
In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales. In cell C5, enter a formula to calculate the median annual sales for all sales associates. Use the named range AnnualSales. In cell D5, enter a formula to calculate the standard deviation for sales. This dataset is a sample of the larger population. Use the named range AnnualSales. Add a rounding function to the formula in cell D5 to round the result to two decimal places. In cell B6, enter a formula to calculate the average commission. Use the named range CommissionEarned. In cell C6, enter a formula to calculate the median commission. Use the named range CommissionEarned. In cell D6, enter a formula to calculate the standard deviation for commissions. This dataset is a sample of the larger population. Use the named range CommissionEarned. Add a rounding function to the formula in cell D6 to round
the result to two decimal places. If necessary, format cells B5:D6 with the default Accounting Number Format.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started