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

2. Run a t-test on the data in the spreadsheet. Use a two-tailed, two sample equal variance test. What is the t-value? Round to three decimal points (e.g. 0.351)

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

a. Yes b. No

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

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)

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:

r= the correlation co-efficient

n= the number of observations

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.

a. no b. yes

Looking for solution of this Assignment?


We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay