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?
Group of answer choices:
No
Yes
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. See Correlation in Excel for how to do this analysis in Excel. 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:
t = r × n − 2 1 − r 2
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.
Group of answer choices:
No
Yes
Looking for a solution written from scratch with No plagiarism and No AI?
WHY CHOOSE US?
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 |