04 Aug Which statistical test will you use to test this hypothesis?
Your goal in this exercise is to build and test hypotheses using inferential statistics in EXCEL. In the file, you will find information from 96 cases (individuals). This dataset includes three new variables for this assignment. •Salary(k)
- PreTest: Critical thinking test before a training
- PostTest: Critical Thinking test after a training
You will have four questions to answer. Please write your answer in a Word file. Copy and paste the result table from the Excel analysis.
1. An HR manager in SHU. CO. believes there is a relationship between gender and job performance. Using data, he wants to explore whether a female’s job performance is greater than a male’s job performance.
1)Verbally and mathematically state the null and research hypothesis.
2)Which statistical test will you use to test this hypothesis?
3)Use inferential statistics in EXCEL to test the hypotheses. Copy and paste your output here.
4)Briefly discuss your results.
2. An HR manager in SHU. CO. also believes there is a relationship between job level and job satisfaction. Using data, he wants to explore whether the job satisfaction level of the above manager level is greater than the job satisfaction level of non-manager level employees. He uses multiple items for job satisfaction.
1)Verbally and mathematically state the null and research hypothesis.
2)Which statistical test will you use to test this hypothesis?
3)Use inferential statistics in EXCEL to test the hypotheses. Copy and paste your output here.
4)Briefly discuss your results.
3. An HR manager in SHU. CO. also believes there is a relationship between employment type and job satisfaction. Using data, he wants to explore whether the job satisfaction level of full-time employees is greater than the job satisfaction level of part-time employees. He uses a single item for job satisfaction.
1)Verbally and mathematically state the null and research hypothesis.
2)Which statistical test will you use to test this hypothesis?
3)Use inferential statistics in EXCEL to test the hypotheses. Copy and paste your output here.
4)Briefly discuss your results.
4. A Training program director in SHU. CO. wants to test whether HR employees have increased critical thinking skills after taking critical thinking training. 96 HR employees took a critical thinking test before taking the training, then after taking the course, the same employees took the same test again.
1)Verbally and mathematically state the null and research hypothesis
2)Which statistical test will you use to test this hypothesis?
3)Use inferential statistics in EXCEL to test the hypotheses. Copy and paste your output here.
4)Briefly discuss your results.
