Reference no: EM131760330
The purpose of this assignment is to provide students an opportunity to gain an understanding on how to compute and interpret descriptive statistics and compare results.
Assignment Steps
Resources: Microsoft® Excel®
Scenario: You are employed as a statistician for a company that makes household products, which are sold by part-time salespeople who work during their spare time. The company has four salespeople employed in a small town. Let us denote these salespeople by A, B, C, and D. The sales records (in dollars) for the past 6 weeks for these four salespeople are shown in the table below.
|
Week
|
A
|
B
|
C
|
D
|
|
1
|
1774
|
2205
|
1330
|
1402
|
|
2
|
1808
|
1507
|
1295
|
1665
|
|
3
|
1890
|
2352
|
1502
|
1530
|
|
4
|
1932
|
1939
|
1104
|
1826
|
|
5
|
1855
|
2052
|
1189
|
1703
|
|
6
|
1726
|
1630
|
1441
|
1498
|
Your supervisor has asked you to prepare a brief report comparing the sales volumes and the consistency of sales of these four salespeople.
Use the mean sales for each salesperson to compare the sales volumes.
Choose an appropriate statistical measure to compare the consistency of sales.
Make the calculations on the Microsoft® Excel® file, "Measuring Salespeople Performance Template," and write a report of 350 words comparing the sales volumes and the consistency of sales of these four salespeople.
Format your paper consistent with APA guidelines.
|
Strengths of us domestic airline
: Can you please provide me 3 strengths of US domestic airline? And briefly talk about each strength in separate paragraghs.
|
|
Calculate the completed cost of jobs
: Elite Custom Cabinetry Company produces custom cabinet order to exact measure based off CAD drawings provided by kitchen remodeling firms
|
|
Under the affordable care act
: Under the Affordable Care Act ("ACA" or "Obamacare") employers with more than 50 FTEs (full-time equivalents, e.g. 25 full-time workers,
|
|
Remembered and ultimately purchased
: In regards to marketing. Is it possible for a product's advertising to be a complete turnoff; a highly annoying and disliked advert; but still be successful.
|
|
Compare the consistency of sales
: You are employed as a statistician for a company that makes household products, which are sold by part-time salespeople who work during their spare time.
|
|
Condition of creative and new
: The condition of creative and new, are always arrived at with a thought process first. It must be seen in the mind's eye before it can be expressed.
|
|
Determine the total allocated overhead cost
: Determine the total allocated overhead cost for January, March, and August. (Do not round intermediate calculations. Round your answers to the nearest.
|
|
Describe competency models
: Describe competency models, case-based decision making, and systems thinking.
|
|
How can we evaluate the k-means model on data
: Explain why and when one would want to use k-means clustering, furthermore, give an explanation of how the algorithm works given a set of data points
|