Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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:
- Use Excel to develop a scatter diagram of the data, including dependent and independent variables on their correct axis.
- In a Word document, analyze the relationship between sales and number of clerk hours worked.
- 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.
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