$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

Question:

1. Before you begin your analysis you are required to take a random sample of size 100from the 171 cases in the data file. Use the Data and Generator.xls to do this. Open this file and go to the first worksheet labelled Macro. Click on Generate and enter the number of rows of data required in the random sample. If you have repeated cases your final sample size may be less than 100. This will not be a problem. Answers to the questions below are to be based on this random sample of up to 100 cases. Make sure you keep a safe copy of your sample since you cannot use the Random Sample Generator to reproduce the first sample. 

2. Data List:Provide a printout of the data in your sample, with ID numbers in ascending order. 

3. Introduction and Variable List: Provide a summary table listing each variable with informationunder the following column headings: Variable Name, Variable Description (see the information above) and Variable Type (qualitative or quantitative). If the variable is qualitative state whether it is nominal or ordinal; if it is quantitative you need to state whether it is discrete or continuous. 

4. Descriptive statistics: Historically the company believed that average salary of male is greaterthan the average salary of female. Determine the mean, median, and standard deviation of current salary data for male and female. Explain the results in the context of the company’s believe. (10 marks)

5. Presentation of data: Draw Histogram and Boxplots for both male and female for current salary Explain the graphs. (10 marks)

PART 2:

6.Hypothesis testing: Use the above information to carry out a t-test to see the averagecurrent salary for male is significantly greater than the average current salary for female.

Explain the result in the light of the question. 

7.Comparing gender and positions:

Prepare a Pivot table that shows average current salary for males and females according to their Position within the company. Think carefully about the layout of rows and columns of your table. Place gender in row, positions in column, and current salaries in value box. Then summarise values as average. Explain the results. 

8.Comparing Departments: The head of Human Resources wants to compare the structure of thefour departments by gender within the Company.

a.Draw a Pivot table with gender in row, department in column and gender in value. 
b.Determine the joint probability for gender and department. Explain the result. 
c.Determine the marginal probability and explain the result. 
d.Determine the conditional probability by column and explain the result.
e.Determine the conditional probability by row and explain the result. 

PART 3:

9.Average salary increase per year: There have been complaints in this company that femaleemployees have been given lower salary increases than their male colleagues.

Examine the issue: Have the salary increases for females been lower?

a). Create a new column, called Length Emplwhich shows the length of time a person has been employed in the company, as of the end of December 2014. Assume that if an employee started in 2008 than they have been employed for 6 years; if they started in 1997 than they have been employed for 17 years, and so on. Create a second new column, called Avg Incr which shows the average increase in salary for each employee since the year they started work for the company.  

State the formulae you have used to produce these new columns. Print out the ID column and the new data – 3 columns. This should be in ascending order of the ID numbers.

b). Use Avg Incrto create a histogram showing the distribution of the average salary increase per year. This histogram has been created to get some idea of the distribution of the data. Comment upon the shape of this distribution: Is it symmetric? Is it skewed? If so which way? (5 marks)

c). Now provide side by side boxplots for Avg Incr, split on gender. Again, comment on what you see. Most importantly, provide your answer to the question: “Have the salary increases for females beenlower than those for males?” (10 marks)

d). Run regression analysis with Start Salaryand Current Salary for both male and female separately. Check carefully which variable will be dependent variable and which variable will be independent variable Again comment on what you see. Most importantly, provide your answer to the question:

Have the salary increases for females been lower than those for males?” Comment whether the regression analyses support or oppose the conclusion in (c). 

10.Draw a suitable conclusion based on your data analysis.

 

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2020) STA 2023 : Statistics [Online]. Available from: https://myassignmenthelp.com/free-samples/sta2023-statistics/distribution-of-the-current-salary-of-males.html
[Accessed 28 July 2021].

My Assignment Help. 'STA 2023 : Statistics' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/sta2023-statistics/distribution-of-the-current-salary-of-males.html> accessed 28 July 2021.

My Assignment Help. STA 2023 : Statistics [Internet]. My Assignment Help. 2020 [cited 28 July 2021]. Available from: https://myassignmenthelp.com/free-samples/sta2023-statistics/distribution-of-the-current-salary-of-males.html.


MyAssignmenthelp.com has become one of the leading assignment help provider in New York City and Boston. We provide top class auditing assignment help. Not only auditing, but we also cover more than 100 subjects and our writers deal with all types of assignments with utmost expertise. To make writing process faster and accurate, we have segmented our assignment experts' teams as per their expertise on writing different types of assignments. We guaranteed that students who buy our assignment online get solutions worth their investment.

Latest Management Samples

ACCFIN4051 Strategic Management Accounting

Download : 0 | Pages : 15

Answer: Task One P1: Explain management accounting The current business scenario requires the managers to make decision on a consistent basis. That involves decision relating to the day-to-day activities, planning and management of strategy. In order to make this decision the managers are required to obtain information that are reliable and based on sound or tested process (Wijaya et al. 2015). In the context of accounting, the informa...

Read More arrow Tags: Australia Loughton Management Management Accounting University of Queensland MBA 

PSCI 2702 Quantitative Research Methods In Political Science

Download : 0 | Pages : 21

Answer: Chapter i - Introducation: A) Statement of the Problem The healthy political community that is existing within the Canada boundary is directly linked to the turnouts of voters in the country. it is seen that the percentage of voters are decreasing, which is disconnecting the citizens with their respective community. This has resulted in a loss for the civic duties and the distrust of the public among the process of elections. The you...

Read More arrow Tags: Canada Toronto Management marketing&management University of Toronto 

FBLT035 Business Analytics

Download : 0 | Pages : 19

Answer: Introduction:  The automobile subsecorof UK is famous all over the globe mostly because of their ability to manufacture some of the most premium and luxury cars. They are also specialized in the manufacturing of exporting the major sports cars in the global automobile market. A significant part of the nation’s economy is also controlled by the business growth of the automobile subsector. The current turnover rate of the ove...

Read More arrow

PRS303 Public Relations Management And Tactics

Download : 0 | Pages : 14

Answer Introduction Public relations and public communication is a process the aids in building mutual relationships that are beneficial to companies, organizations, and the general public. The public relations and communication have evolved over a long time to become what it is today (Protess, and McCombs, 2016). It suffices to point that changes have occurred in the business environment that have prompted enhanced public relation and commun...

Read More arrow Tags: Australia Saint Kilda Management Public Relations Management and Tactics University of Sydney MBA 

FINC377 Investment

Download : 0 | Pages : 18

Answer: Topic: Return on Investment (In Training Field) The enumeration of the return on investment (ROI) in particularly learning as well as development can be regarded as a critical issue in the field of human resource development. For over a decade now, the measurement of the ROI is taken into account in different agendas of conference and meetings. As such, enumeration of return on investment is categorized as flawed and at the same time ...

Read More arrow Tags: Saudi Arabia Abu Dhabi Management University of Abu Dhabi Masters in Business Administration 
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?