1. Scatter Diagram Analysis
The regional sales manager for American Toys, Inc., recently collected data on weekly sales (in dollars) for the 15 stores in his region. He also collected data on the number of salesclerk work hours during the week for each of the stores. The data are as follows:
Store
Sales
Hours
1
23,300
120
2
25,600
135
3
19,200
96
4
10,211
102
5
19,330
240
6
35,789
190
7
12,540
108
8
43,150
234
9
27,886
140
10
54,156
300
11
34,080
254
12
25,900
180
13
36,400
270
14
25,760
175
15
31,500
256
To complete this assignment:
1. Use Excel to develop a scatter diagram of the data, including dependent and independent variables on their correct axis.
2. In a Word document, analyze the relationship between sales and number of clerk hours worked.
3. Conclude, based on the scatter diagram, what adjustments the sales manager might make to address the relationship between sales and number of clerk hours worked.
4. Submit your work in a Word document with your Excel file attached.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more