What a negative correlation between tenure and salary

Reference no: EM132333508

EXCEL Assignment -

In this assignment, you will once again serve as an expert consultant for MPHR. Using their dataset, you will develop graphs, calculate descriptive statistics, and provide your assessment of the results.

MPHR is interested in examining the distributions for salary and its relationship with tenure. A sample has been drawn from the company with information on salary (in dollars) and tenure (in years).

Using Tab 2 of the MPHR Dataset, Dave is interested in the following questions:

1. Complete Table 1 create and copy/paste (screengrab) the mean salary line graph into your assignment document and describe the results for the line graph for salary by tenure in five-year intervals.

2. Complete Table 2 create and copy/paste (screengrab) the salary frequency distribution into your assignment document, and describe the results for the frequency distribution for salary.

3. Based on results from Tables 1 & 2, how does salary at MPHR compare to the normal distribution?

4. What is the mean and median salary at MPHR? What features of the distribution might have an impact on any differences between these statistics?

5. Based on this dataset, Dave finds a positive correlation between tenure and salary. Describe what this statistic tells us about the relationship between tenure and salary.

6. Describe what a negative correlation between tenure and salary would mean.

Instructions: This is an EXCEL assignment that has specific instructions attached in a word document. If possible, it would be great to have it completed within the deadline ASAP.

Attachment:- EXCEL Assignment Files.rar

Reference no: EM132333508

Questions Cloud

What is Euthanasia : Steps in the process: What is Euthanasia? Consult literature regarding Euthanasia. Decide on the methodology and methods for responding to needs in euthanasia

Why is a business plan important for small businesses : What is a business plan and why is a business plan important for small businesses? Substantiate your all your comments and responses. Avoid the use of Wisegeek.

Activities that are associated with the summer olympics : How does global marketing and the use of new digital marketing techniques facilitate marketing activities at the Olympics in Rio?

What are the risks involved in the business : For this assignment, you will evaluate the concepts associated with entrepreneurship. First, locate the video below in the Films on Demand database in the CSU.

What a negative correlation between tenure and salary : EXCEL Assignment - Using Tab 2 of the MPHR Dataset, Describe what a negative correlation between tenure and salary would mean

Create your own talent management model : Several models and components of talent management are presented in Chapter 1 of the Silzer and Dowell textbook. Using these as a foundation.

Contribution to holes in the ozone by cattle : Which model is Joe's best choice if he is presenting a speech on the contribution to holes in the ozone by cattle?

Selecting the appropriate candidate for a job : What would be examples of valid selection methods used by the human resource department to ensure selecting the appropriate candidate for a job.

What is the desired profit per unit : Projected sales revenue is $1770000 ($6.00 per unit) and target costs are $1563500. What is the desired profit per unit?

User Account

All Pages