We would like to understand by department whether there is a significant pay difference between men...

We would like to understand by department whether there is a significant pay difference between men and women in 2017 (average gross salary by gender per pay period).

The gender is coming from the employee_info as 'M' and 'F'
AND the gross salary is coming from the payroll_register.

What would be the query?

Solutions

Expert Solution

calculation of gross salary for gender per pay period

from pay-roll registry salary of two genders M ,F shall be taken into two separate considerations.

Gross salary of that specific group can be obtained by multiplying salaries to employees worked ( if they are under common amount of pay scale) other wise compounding can be used for different pay- scales.

By above method total gross salary of separate gender can be obtained.

average salary employee per pay period

average salary

average salary of such specific group can be caluculated by dividing total gross salary to number of employed o that group.

[Total gross salary ÷no. of employees]

average salary per employee per pay period

average salary per employee per period can be obtained by dividing average salary to pay period.

=( average salary ÷ pay period)

NOTE: pay period may be monthly or yearly basis as may be followed

Deviation in pay scale can be obtained by comparing both the amounts of average gross salary per employee per pay period.

with regards

Thank you

Please do like the answer if it is satisfactory.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

3. UTRGV researchers would like to determine if there is a significant difference between the grades...

3. UTRGV researchers would like to determine if there is a significant difference between the grades achieved in the fall versus spring semester. Grades were recorded for a group of 7 students in both semester and are listed below (α = .05). Participant Fall Spring 1 85 89 2 68 84 3 76 79 4 77 82 5 89 90 6 93 91 7 90 90 a. Will we need a one- or two-tailed hypothesis test? b. State your null...

A researcher would like to know whether there is a significant relationship between Verbal skills and...

A researcher would like to know whether there is a significant relationship between Verbal skills and Math skills in population of high school students. A sample of n = 200 students is randomly selected and each student is given a standardized Verbal skills test and a standardized Math skills test. Based on the test results, students are classified as High or Low in Verbal skills and Math skills. The results are summarized in the following frequency distribution table (i.e., the...

A researcher would like to know whether there is a significant relationship between Verbal skills and...

You would like to know whether there is a difference between the rate of cooling of...

You would like to know whether there is a difference between the rate of cooling of freshly killed corpses versus those that were reheated (to determine if you could fool a coroner about time of death). You tested several rats for their cooling constant, both when the rat was freshly killed and after the same rat was reheated. Assuming the distribution ofn differences is normal, is there any difference in the cooling constants between freshly killed and reheated rats? Test...

A researcher wants to determine if there is a significant difference between men and women in...

A researcher wants to determine if there is a significant difference between men and women in terms of guilty/non guilty pleas submitted by a sample of 50 defendants. Knowing that there are 25 women and 25 men in this sample and that 15 men entered guilty pleas [and 10 no guilty pleas] and 5 women entered guilty pleas [and 20 no guilty pleas]… [Hint: Calculated Chi-Sq. = 8.33] Formulate the null and research/alternative hypotheses. Create a contingency table with 2...

QUESTION 10 A researcher finds that there is a statistically significant difference between men and women...

QUESTION 10 A researcher finds that there is a statistically significant difference between men and women when it comes to hours a day they spend on social media. Specifically, men spend more time on social media than women. What does "statistical significance" mean in this case? The difference in number of hours spent on social media between men and women is not random The results of the study will make a significant contribution to existing research on the use of...

Is there a statistically significant difference in weight between men and women? (Conduct an independent t...

Is there a statistically significant difference in weight between men and women? (Conduct an independent t test.) Identify the independent and dependent variables. Write a null hypothesis. Write an alternative non-directional (2-tail) hypothesis. Interpret your results. Guidelines for interpreting independent t tests can be found in What to Include When Writing Up Independent t Test Results (PDF).

in order to determine whether or not there is a significant difference between the hourly wages...

in order to determine whether or not there is a significant difference between the hourly wages of the two companies the following data has been calculated. company A company B sample size 80 60 sample mean $16.75 $16.25 standard deviation $1.00 $0.95 A) what is the point estimate for the difference between the two means? B) the standard error of x1 - x2 is C)what is the 95% confidence interval for the difference between the...

A financial advisor wants to know whether there is a significant difference between the NYSE and...

A financial advisor wants to know whether there is a significant difference between the NYSE and NASDAQ markets in the annual dividend rates for preferred stocks. A sample of 30 returns is selected from each market. Assume the two samples are random and independent. Test the claim that there is no difference in the annual dividend rates for the two markets. Use α = 0.05. Expaln how you computed the sample means and standard deviations. Suggestion: use Excel NASDAQ 2.00...

A coffee shop in Victoria wants to know whether there is a significant difference between the...

A coffee shop in Victoria wants to know whether there is a significant difference between the number of lattes sold per day at their Yates St. location and their Johnson St. location. A sample of 31 days at their Yates St. location reveals an average of 22 lattes sold per day with a standard deviation of 5 lattes. A sample of 31 days at their Johnson St. location reveals an average of 19 lattes sold per day with a standard...

Subjects