measuring salespeople performance

profileHomework1
Wk3MeasuringSalespeoplePerformanceTemplate.xlsx
Home>Mathematics homework help>Statistics homework help>measuring salespeople performance

Sheet1

Measuring & Interpreting Salespeople Performance
A. Interpretations Excel Function Old Excel Example
Week A B C D Min MIN(array) 99.00
1 1808 1507 1295 1665 Interpretation Salesperson A Max MAX(array) 234.00
2 1890 2352 1502 1530 Median MEDIAN(array) 149.00
3 1932 1939 1104 1826 Sample Mean AVERAGE(array) 150.00
4 1855 2052 1189 1703 Sample Std Dev STDEV.S(array) STDEV(Array) 30.00
5 1778 2165 1274 1580 CV* Sample Standard Deviation ÷ Sample Mean x 100 9
6 1860 2139 1183 1748 1st Quartile QUARTILE.INC(array,1) QUARTILE(Array,1)
3rd Quartile QUARTILE.INC(array,3) QUARTILE(Array,3)
Min Interpretation Salesperson B IQR Q3 - Q1
Max Count COUNT(Array) 100
Median Sum SUM(Array)
Mean
Std Dev Interpretation Examples
CV* Example of interpreting descriptive statistics in everyday language.
1st Quartile One hundred subjects were randomly selected. Their body weight was observed as more than 99 and under 234 pounds. Their average subject weight was 150 pounds, with a variation of plus or minus 30 pounds. One-half of the subjects' weight was 149 pounds or greater. The weight relative variation around the average was 9.
3rd Quartile Interpretation Salesperson C
IQR
Count
Sum
* Coefficient of Variation
Explanation:
The number of samples collected.
Interpretation Salesperson D One hundred subjects were randomly selected.
The minimum and maximum values.
Their body weight was observed as more than 99 and under 234 pounds.
The median.
One-half of the subjects' weight was 149 pounds or greater.
B. Which Salesperson had highest salse? The mean and standard deviation.
Their average subject weight was 149 pounds, with a variation of plus or minus 30 pounds.
C. Which Salesperson had the most consistent sales? Explain. Coefficient of Variation
The weight relative variation around the average was 9.