Develop a scatter diagram of the data

Assignment Help Applied Statistics

Reference no: EM133124632

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.

Reference no: EM133124632

Questions Cloud

Greater fiscal and policy devolution : Economists have argued that increasing gaps in wealth and income amongst regions in large federal states such as India argue for greater fiscal and policy devol

Compute the cost of direct labor used for the period : Overhead is applied using a predetermined overhead rate of 55% of direct labor cost. Compute the cost of direct labor used for the period

Theoretical basis of benefit-cost techniques : Regarding the economics of education, explain some of the rudimentary notions about the theoretical basis of benefit-cost techniques.

Compute large debt to gdp ratios : With ultra-low interest rates, countries such as Canada are building up large debt to GDP ratios. Finance Minister Chrystia Freeland has said recently large deb

Develop a scatter diagram of the data : Develop a scatter diagram of the data, including dependent and independent variables on their correct axis

Journalize the entry for gps system expenditures : On December 2, Scanlon Co. paid $2,060 to repair the transmission on one of its delivery vans. Journalize the entry for GPS system expenditures

Identify key statements that it makes about its cash flows : Find online an interesting public company listed on the Australian Stock Exchange (ASX) Identify key statements that it makes about its cash flows

Tools and methods for benchmarking : What are some tools and methods for benchmarking? How are each used in data collection and performing benchmarking?

Demand-supply and covid-19 pandemic : a. Assume the UK economy was initially at the equilibrium, explain why there was a panic buying on some essential products before the first lockdown officially

User Account

All Pages