Question: Gender PerformanceRating 1 3 1 3 2 3 2 4 1 4 2 3 2 3 1 3 2 3 1 3 1 3 2

Gender PerformanceRating

1 3

1 3

2 3

2 4

1 4

2 3

2 3

1 3

2 3

1 3

1 3

2 3

1 3

2 3

1 4

1 3

1 3

2 3

1 3

2 4

2 3

2 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

2 3

2 3

1 4

2 3

1 4

2 3

1 3

2 3

2 3

2 3

1 3

2 3

1 4

1 3

2 3

2 3

2 3

1 3

2 3

2 3

2 3

1 4

1 3

1 3

1 3

1 3

2 3

2 3

1 4

2 3

2 3

1 3

1 3

1 3

2 3

1 3

2 3

1 3

1 3

2 3

2 3

1 3

2 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

2 3

2 3

1 3

1 3

2 4

1 4

1 3

1 3

1 3

1 3

2 3

1 3

2 3

2 3

1 3

1 3

1 3

2 4

2 3

1 3

2 3

2 4

2 3

2 4

1 3

1 4

1 3

2 3

1 3

2 4

2 3

2 3

2 4

1 3

1 3

2 3

1 3

2 3

1 3

1 3

1 4

2 3

1 3

1 3

1 3

2 3

2 3

2 3

1 4

1 4

1 3

2 3

1 3

2 3

2 3

2 3

2 3

2 3

2 3

1 3

1 3

2 3

1 3

1 3

1 4

2 4

2 3

1 3

2 3

2 4

1 3

1 3

2 4

1 3

1 3

1 3

2 4

1 3

2 3

2 4

1 3

1 3

1 4

1 3

1 3

2 3

2 4

1 3

1 4

1 3

1 3

1 3

2 3

1 3

2 3

2 3

1 3

2 3

1 3

1 3

2 4

1 3

1 3

2 3

1 3

2 3

1 4

1 3

1 3

2 3

2 3

1 4

1 3

2 3

1 3

2 3

2 3

2 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

2 4

1 3

1 3

2 3

2 3

1 3

1 3

2 3

1 3

2 4

1 3

1 3

1 3

1 4

2 3

2 3

2 3

2 3

1 3

1 3

1 3

1 3

1 4

1 3

1 3

1 3

1 4

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

1 3

2 3

2 3

2 3

2 4

1 3

2 4

1 3

1 3

2 3

1 4

2 3

1 3

2 4

1 3

1 3

2 3

1 3

1 4

1 3

2 3

2 3

1 3

2 3

1 4

1 3

2 3

2 4

1 4

1 3

1 3

2 3

2 3

1 3

2 3

2 3

1 3

1 3

2 3

2 3

2 3

1 4

1 3

1 3

1 3

2 3

2 3

1 3

2 3

1 3

1 3

1 3

1 4

2 3

2 3

1 3

1 3

1 3

1 3

1 4

1 3

1 3

1 4

2 3

2 3

1 4

2 3

2 3

2 3

2 3

1 4

2 3

1 3

1 4

2 3

2 3

2 3

1 3

1 4

2 3

1 3

2 4

1 3

1 3

1 3

1 3

1 4

1 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

2 4

1 3

2 3

1 4

1 3

1 3

1 3

2 3

2 4

2 3

1 3

1 3

1 4

1 3

1 3

2 4

1 3

1 4

1 3

1 3

2 3

1 3

1 4

1 4

2 3

1 3

1 3

1 4

1 3

2 3

1 3

2 3

2 4

1 3

2 3

2 3

2 3

1 3

1 3

1 3

2 3

1 3

2 3

1 3

2 3

2 4

1 3

1 3

2 3

1 3

1 3

2 3

1 3

1 3

2 3

1 3

2 4

1 3

2 3

2 4

1 3

1 3

1 3

1 4

1 3

2 3

1 4

1 3

1 3

2 3

1 3

1 3

2 4

1 3

1 3

2 3

2 3

2 4

1 4

2 3

1 4

1 3

2 3

1 3

2 3

1 3

2 3

2 4

1 3

2 3

2 3

1 3

2 3

2 3

2 3

1 4

2 3

1 3

1 3

1 3

2 3

1 4

1 3

1 3

2 3

1 3

1 3

2 3

1 3

1 3

2 3

1 3

1 3

2 3

2 4

2 3

1 3

2 3

1 3

1 3

2 3

2 3

1 3

1 4

1 3

2 3

1 3

2 3

1 3

1 4

2 3

1 3

2 4

1 3

2 4

1 3

1 3

1 3

1 3

2 3

1 4

1 3

1 3

1 3

2 3

2 3

1 3

2 3

2 4

1 3

1 3

1 3

1 3

1 3

1 3

1 3

1 4

1 3

1 4

1 3

1 3

2 4

2 4

2 3

2 3

1 3

2 3

2 3

2 3

2 4

2 3

1 3

1 4

1 3

1 3

2 3

1 3

2 3

2 3

1 3

2 3

1 3

1 4

1 3

1 3

1 3

1 3

1 3

2 4

2 3

2 4

2 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

2 3

1 4

1 3

2 3

1 3

2 3

2 3

2 3

1 3

2 3

2 3

2 3

1 3

1 3

1 3

2 4

1 3

1 3

1 3

1 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 4

1 3

2 3

2 3

1 3

1 3

1 3

2 4

1 4

2 3

2 3

1 3

1 3

1 3

2 3

1 3

2 4

1 3

2 3

2 3

2 3

1 3

1 3

1 3

2 3

1 3

1 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

2 3

1 3

2 3

2 3

2 3

1 3

1 3

1 3

1 3

1 4

2 3

2 3

1 3

1 3

1 3

1 4

1 3

1 3

2 3

1 3

2 3

1 3

2 3

2 3

1 3

1 3

1 3

1 3

1 3

1 3

2 4

2 3

1 4

2 3

1 3

2 3

1 3

1 3

1 3

2 3

1 3

2 3

2 3

1 3

1 3

2 3

1 4

2 3

2 3

1 4

2 3

1 3

2 3

1 3

1 4

2 3

2 4

1 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

1 3

2 3

2 3

1 3

2 3

1 3

2 3

1 3

1 3

1 4

1 3

2 3

2 3

1 4

2 3

1 3

1 3

2 4

2 3

1 4

1 4

1 3

2 3

2 3

2 4

1 3

1 4

2 3

2 3

2 3

2 3

1 4

1 3

1 3

1 3

2 3

1 3

1 4

1 4

1 3

2 4

2 3

2 3

1 3

1 3

1 4

2 4

1 3

2 3

2 3

2 3

1 3

2 4

2 3

1 3

1 3

1 3

1 3

1 4

1 4

2 3

1 3

1 4

2 3

1 3

2 3

1 3

2 4

1 4

1 3

2 4

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 4

1 3

1 4

2 3

2 3

1 3

2 3

1 3

1 3

2 3

1 3

1 3

2 3

2 3

1 3

2 3

1 3

1 4

2 3

2 3

1 3

2 3

2 3

1 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

2 3

1 4

2 3

2 3

2 3

1 3

1 3

1 4

2 3

1 4

2 3

2 3

1 3

2 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

1 3

1 4

1 3

1 3

2 3

1 3

1 3

1 3

1 4

2 3

2 4

1 3

2 4

1 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

1 3

1 3

2 3

1 4

2 3

1 3

2 3

1 3

2 4

1 3

1 3

2 3

2 3

2 4

1 3

1 3

1 3

2 3

2 3

2 3

1 3

1 3

2 4

1 3

2 4

2 3

1 3

1 3

2 3

1 3

2 4

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

2 3

1 3

1 3

1 3

2 3

2 3

2 3

1 3

1 3

2 3

2 4

2 3

1 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 4

1 3

1 3

1 3

2 4

1 4

1 3

2 3

2 3

2 3

2 3

2 3

2 3

1 3

2 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

1 4

1 3

2 3

1 3

1 3

2 4

2 3

1 4

2 3

2 3

1 3

1 3

2 3

2 3

2 4

1 3

1 3

1 3

1 3

2 3

1 4

1 3

1 3

2 3

1 4

2 3

2 3

2 3

1 4

1 3

2 4

1 3

2 3

1 3

2 3

2 3

1 4

2 3

1 3

1 3

2 3

1 3

1 3

1 3

2 3

2 3

1 3

2 3

2 3

1 3

1 3

2 3

1 3

2 3

1 3

2 4

1 3

1 3

1 4

1 3

2 3

1 4

1 3

2 3

1 3

2 3

1 3

1 3

2 3

2 3

2 3

2 3

2 3

2 3

1 3

2 4

2 3

1 3

1 3

2 4

1 3

1 3

1 4

2 3

2 4

2 3

1 3

1 4

1 3

1 3

2 3

1 3

2 3

2 4

1 4

1 3

2 3

2 3

1 3

2 3

1 3

2 3

1 3

2 4

2 4

2 3

1 3

1 3

1 3

1 3

1 3

2 3

1 3

2 3

2 3

2 3

2 3

2 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

1 3

2 3

1 3

2 3

1 3

1 3

2 3

2 4

2 3

1 4

2 3

1 3

1 3

2 3

2 3

2 4

1 3

1 3

1 4

1 3

2 3

2 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

2 4

1 3

1 3

2 3

1 3

2 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

1 3

1 4

2 3

1 3

1 3

1 3

2 4

1 3

2 3

1 3

1 3

1 3

2 3

1 3

2 3

1 3

2 3

2 3

1 3

2 4

1 3

1 3

1 3

1 3

2 3

2 3

2 4

2 3

2 3

1 3

2 3

1 4

1 3

1 4

1 3

1 4

1 3

2 4

1 3

1 3

1 4

1 3

2 4

1 3

2 3

2 3

2 3

1 4

1 3

2 3

1 3

2 3

1 3

1 3

2 3

2 4

1 3

2 3

1 3

2 4

1 3

2 3

1 3

1 3

1 4

1 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

2 3

1 3

1 3

1 3

2 3

1 3

2 3

1 3

2 4

2 3

2 3

2 3

2 3

1 3

1 3

1 3

1 3

1 4

2 3

1 3

1 3

2 3

2 3

2 4

1 3

1 3

1 4

2 3

1 4

2 3

1 3

1 3

1 3

2 3

1 4

1 3

2 3

2 3

2 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

2 4

1 3

1 3

1 3

2 3

1 3

1 3

2 4

1 3

1 3

2 4

1 4

1 3

1 3

2 3

1 3

1 3

1 3

1 4

2 3

1 3

1 4

2 3

1 3

1 3

1 3

2 3

1 3

1 3

1 4

2 4

1 3

2 3

2 3

1 4

1 3

1 3

1 3

1 3

1 3

2 3

2 3

1 3

1 3

1 3

1 4

1 3

1 3

2 4

2 3

1 3

2 3

1 3

2 3

2 3

2 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

1 4

1 3

2 3

2 3

1 3

1 3

2 3

2 3

2 3

1 3

1 3

1 3

2 3

1 3

1 4

1 3

1 4

1 4

1 3

1 3

2 3

2 3

1 3

1 3

2 3

1 3

2 4

1 3

1 3

1 3

1 3

2 3

1 3

1 4

2 3

1 3

2 3

2 3

2 3

2 3

1 4

2 3

2 3

1 3

2 3

1 3

2 3

1 4

1 3

2 3

1 3

1 3

1 3

1 4

1 3

1 4

2 3

1 3

2 3

1 3

1 3

2 4

2 3

1 3

2 3

2 4

2 3

2 3

1 3

1 4

1 3

1 3

1 3

1 3

1 3

2 3

1 3

2 3

1 3

2 3

1 3

2 3

2 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

1 4

1 3

1 3

1 4

1 3

1 3

1 3

1 4

2 4

1 3

2 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

2 4

2 3

1 3

2 3

2 3

1 3

2 3

2 3

2 3

1 3

2 3

1 3

1 3

1 3

2 3

2 3

2 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

2 3

1 3

1 3

1 3

1 3

1 3

2 3

2 3

2 3

2 3

1 3

2 3

1 4

2 3

1 3

2 3

1 3

1 3

2 3

2 3

2 3

1 3

1 4

1 4

1 3

2 3

2 3

1 3

1 3

1 3

1 4

2 3

2 3

2 3

1 3

1 3

1 3

2 3

Question 1. What is the null hypothesis for comparing performance ratings by gender?

Question 2. Run a t-test on the data in the spreadsheet. Use a two-tailed, two sample equal variance test.

Seet-test tutorial(Links to an external site.)

for how to run this in excel.

What is the t-value? Round to three decimal points (e.g. 0.351)

Question 3. Is there a significant difference in performance ratings by gender?

Question 4. What is the null hypothesis for determining if there is arelationship between Job Level and Performance Ratings?

Question 5. Run an analysis to determine if there is a correlation between Job Level and Performance Rating.

What is the correlation co-efficient? Round to two decimal points (e.g. 0.04)

This requires running a correlation in Excel. Here is a tutorial:

Question 6. What is the t-value for this relationship?Round to two decimal points (e.g. 0.04)

To answer this question, you have to covert the correlation co-efficient to a t value, using the following formula:

t=rn2

1r

2

t=rn21r2

r= the correlation co-efficient

n= the number of observations

Question 7. Is the relationship between Job Level and Performance Ratings significant?

To answer this question, you can convert the t-value to a p-value in excel using the following command.

=t.dist.2t(t, degrees of freedom)

t.dist.2t is the command in excel for a two-tailed Student's T output

The t in the parenthesis is the value you calculated above (if this is negative, covert it to a positive number by multiplying it by -1)

The degrees of freedom = (number of observations - 2)

If the value you find is less than 0.05, then the relationship is significant.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

12/3/2017 BUS 8013 Research Methods Stats Sheet 5 40 Points Fill in the yellow cells on the Regression tab. Be sure to show your work. Academic Performance of Portuguese Students Dependent (outcome)...

Q:

pls provide the full and correct answers Consider the accompanying set of dependent and independent variables. The variable X3 is qualitative with M = Male and F = Female. Complete parts a and b...

Q:

Country Gini10 Dem_level Dem_rank1Dem_scoreLifeEx_F LifeEx_M Literacy Oil Pop_0_14 Afghanista 29.40 4 151.00 2.77 45.25 44.79 28.10 0.00 42.30 Albania 33.00 3 88.00 5.67 80.30 74.82 #NULL! 5400.00...

Q:

Manhattan Brooklyn Queens The Bronx Staten Island Education Marital Status 3 3 4 4 4 3 4 4 4 2 4 4 4 3 2 1 2 4 2 3 4 1 4 3 2 4 2 3 4 4 4 4 2 3 4 4 1 2 4 2 2 2 4 2 1 2 3 5 5 5 5 5 2 4 4 5 5 5 3 2 2 5...

Q:

I need help with this please!!! Part 2 - . Access the data set House Price. Select two comparable college towns (DO NOT USE AMES IOWA) and: . Develop a model that predicts the sale price of a house...

Q:

Distributive property in PYTHON I need help with the code and has to pass the assertion tests ### Exercise: Implement `apply_distributive` def apply_distributive(e): """Applies the distributive...

Q:

QUESTION 1: Carol Read, the owner of the Readilunch Restaurant, a downtown, quick service restaurant, was concerned about the loss of several regular customers. She measured the number of empty lunch...

Q:

python question A sudoku is a popular puzzle that involves using the digits from 1 to 9 in various ways. For this assignment, we will consider only what we call a simplified sudoku. A simplified...

Q:

Philco Diamonds buys diamonds from the Canadian Arctic and sells them in Dubai. Management has been confused by the prices they must pay for the diamonds they buy.Sometimes the price seems too high,...

Q:

1 Product Numt Product Categc Product Nam Classic 109 Elegant 210 Runroad 1000 1 2 mano AAAAAAAAAA 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Record 1 of 24 1 Road 2 Road 3 Road 4 Mtn. 5...

Q:

A put option in finance allows you to sell a share of stock at a given price in the future. There are different types of put options. A European put option allows you to sell a share of stock at a...

Q:

The spin-state wavefunction of a particle is given by 1 |x) = -2i 3i [In standard basis] If a beam of No such particle is sent through a Stern-Gerlach apparatus with a magnetic field alongz-axis,...

Q:

The optimal nisky portiolio can be isentified by finding: The minimum variance poent on the efficient fronter The maximum retum point on the efficient fromier and the minimum - warance point on the...

Q:

Which of the following work practices are closely associated with low-cost outsourced manufacturing? a. Rights of workers to join independent trade unions b. Excessive hours of work that threaten...

Q:

Pay him, do not wait until I sign

Q:

Tell what you mean without sounding too dominant, i.e. show authority without sounding instructive

Q:

Speak clearly and distinctly with moderate energy