Solution-Analyze relationship between sales and number of

Analyze relationship between sales and number of clerk

Assignment Help Business Management

Reference no: EM133040797

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.
Submit your work in a Word document with your Excel file attached.

Reference no: EM133040797

Questions Cloud

Golf strategic plan : 1. A mission statement expressing the focus of club, it's purpose and the ultimate vision of what your club will look like as you fulfill the organization's mis

Determine how much money the Van Dusens will have available : Renting a 2-bedroom apartment for $1800 a month, including all utilities. Determine how much money the Van Dusens will have available each month for savings

Different types of resumes formats : 1. At the end of the year 2021, I am ready to find a job, the question is: how do I find a prospective employer?

Importance of giving and receiving constructive feedback : Explain the importance of giving and receiving constructive feedback. Why should you actively seek feedback?

Analyze relationship between sales and number of clerk : 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

What would be impact of not protecting michelles workplace : Review organisational procedures for managing internal disputes and for managing external customer conflicts and follow those procedures to deal with staff

Prepare extracts from burge ltd financial statements : Prepare extracts from Burge Ltd's financial statements for the year ended 30 April 2021 showing the effect of the lease

Phase of the five es : What phase of the five Es was most beneficial, and why? Were any of them not beneficial? If so, explain why.

Comment on the validity of reference checking : Many organizations will conduct a reference check before making an employment offer to the candidate. Typically, employers will ask the candidate for three name

User Account

All Pages

Analyze relationship between sales and number of clerk

Reference no: EM133040797

Reference no: EM133040797

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Caselet on michael porter’s value chain management

Mountain man brewing company

Mountain man brewing company

Analysis of the case using the doing ethics technique

Affiliations and partnerships

Innovation-friendly regulations

Effect of regional and corporate cultural issues

Structure of business plan

Identify the purposes of different types of organisations

Entrepreneur case study for analysis

Forecasting and business analysis

Educational instructional leadership

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT