Using survey responses from the AIU data set, complete the following requirements in the form of a 2-page report: TEST #1 Perform the following two-tailed hypothesis test, using a .05 significance level: • Intrinsic by Gender • State the null and an alternate statement for the test • Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test. Copy and paste the results of the output to your report in Microsoft Word. • Identify the significance level, the test statistic, and the critical value. • State whether you are rejecting or failing to reject the null hypothesis statement. • Explain how the results could be used by the manager of the company. TEST #2 Perform the following two-tailed hypothesis test, using a .05 significance level: • Extrinsic variable by Position Type • State the null and an alternate statement for the test • Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test. • Copy and paste the results of the output to your report in Microsoft Word. • Identify the significance level, the test statistic, and the critical value. • State whether you are rejecting or failing to reject the null hypothesis statement. • Explain how the results could be used by the manager of the company. GENERAL ANALYSIS (Research Required) Using your textbook or other appropriate college-level resources: • Explain when to use a t-test and when to use a z-test. Explore the differences. • Discuss why samples are used instead of populations Data: Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits 1 1 1 1 3 4.9 6.4 5.5 5.4 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 2 2 1 4.9 5.3 5.7 2.3 1 1 3 1 1 5.2 4.7 5.6 4.5 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 2 1 2 6.9 5.4 4.1 4.8 1 1 1 1 3 6.8 6.4 4.8 4.7 1 1 2 1 2 2.2 4.7 4.7 4.7 1 1 1 1 3 3.4 5.2 5.4 5.4 1 2 2 1 2 6.5 5.3 2.9 3.7 1 2 1 1 3 4.8 5.3 5.5 5.2 1 2 2 1 3 3.8 6.4 3.9 6.4 1 2 1 1 2 5.2 5.2 5.8 5.2 1 2 2 1 2 3.4 5.2 5.2 5.3 1 3 1 1 1 5.5 6.4 5.8 4.7 1 3 2 1 1 2.4 5.2 5.9 6.4 1 3 3 1 1 3.5 5.3 6.4 5.2 1 3 3 1 2 6.9 4.7 5.7 4.7 1 3 3 1 2 5.5 6.4 5.8 5.4 1 3 3 1 2 5.2 5.2 5.6 6.4 1 3 3 1 2 5.7 1.2 5.4 4.7 1 1 3 1 2 5.5 2.4 2.3 5.2 1 1 1 1 2 4.9 5.3 5.6 5.4 1 1 1 1 3 4.9 6.4 5.5 5.4 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 2 2 1 4.9 5.2 4.6 4.2 1 1 3 1 1 5.2 6.4 5.5 3.5 1 3 3 1 1 4.9 5.2 4.6 4.2 1 2 2 1 1 5.2 5.3 5.7 2.3 1 2 1 1 2 5.2 4.7 5.6 4.5 1 3 3 1 2 4.9 6.4 5.5 5.4 1 2 2 1 3 5.9 5.2 4.6 4.2 1 1 3 2 1 4.9 4.7 5.6 4.5 1 1 1 1 3 3.2 5.4 5.6 5.4 1 3 3 1 1 4.9 6.4 4.6 4.2 1 1 3 2 1 4.9 4.7 5.6 4.5 1 1 3 1 3 5.2 5.2 5.7 4.2 1 2 3 1 3 4.9 5.2 4.6 4.2 1 3 2 1 1 4.9 6.4 5.5 3.5 1 2 2 1 1 5.2 4.7 5.6 4.5 1 2 2 2 3 4.9 5.4 5.6 5.4 1 1 3 2 3 4.9 5.2 4.6 4.2 1 2 2 1 2 5.2 6.4 5.5 3.5 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 1 1 2 5.2 5.3 5.7 2.3 1 3 2 1 1 5.2 4.7 5.6 4.5 1 1 3 1 2 4.9 6.4 5.5 5.4 1 2 1 2 3 5.9 5.2 4.6 4.2 1 2 1 1 1 4.9 4.7 5.6 4.5 1 1 1 2 3 4.9 6.4 5.5 5.4 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 2 2 1 4.9 5.3 5.7 2.3 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 1 1 3 4.9 6.4 5.5 5.4 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 2 2 1 4.9 5.3 5.7 2.3 1 1 3 1 1 5.2 4.7 5.6 4.5 1 3 3 1 1 4.9 5.2 4.6 4.2 1 1 2 1 2 6.9 5.4 4.1 4.8 1 1 1 1 3 6.8 6.4 4.8 4.7 1 1 2 1 2 2.2 4.7 4.7 4.7 1 1 1 1 3 3.4 5.2 5.4 5.4 1 2 2 1 2 6.5 5.3 2.9 3.7 1 2 1 1 3 4.8 5.3 5.5 5.2 1 2 2 1 3 3.8 6.4 3.9 6.4 1 2 1 1 2 5.2 5.2 5.8 5.2 1 2 2 1 2 3.4 5.2 5.2 5.3 1 3 1 1 1 5.5 6.4 5.8 4.7 1 3 2 1 1 2.4 5.2 5.9 6.4 1 3 3 1 1 3.5 5.3 6.4 5.2 1 3 3 1 2 6.9 4.7 5.7 4.7 1 3 3 1 2 5.5 6.4 5.8 5.4 1 3 3 1 2 5.2 5.2 5.6 6.4 1 3 3 1 2 5.7 1.2 5.4 4.7 1 1 3 1 2 5.5 2.4 2.3 5.2 1 1 1 1 2 4.9 5.3 5.6 5.4 1 1 1 1 3 4.9 6.4 5.5 5.4 1 1 2 1 2 2.2 4.7 4.7 4.7 1 1 1 1 3 3.4 5.2 5.4 5.4 1 2 2 1 2 6.5 5.3 2.9 3.7 1 2 1 1 3 4.8 5.3 5.5 5.2 1 2 2 1 3 3.8 6.4 3.9 6.4 1 2 1 1 2 5.2 5.2 5.8 5.2 1 2 2 1 2 3.4 5.2 5.2 5.3 1 3 1 1 1 5.5 6.4 5.8 4.7 1 3 2 1 1 2.4 5.2 5.9 6.4 1 3 3 1 1 3.5 5.3 6.4 5.2 1 3 3 1 2 6.9 4.7 5.7 4.7 1 3 3 1 2 5.5 6.4 5.8 5.4 1 3 3 1 2 5.2 5.2 5.6 6.4 1 3 3 1 2 5.7 1.2 5.4 4.7 1 2 2 1 3 4.9 6.4 5.5 5.4 1 3 3 1 1 4.9 5.2 4.6 4.2 2 2 2 1 1 5.2 4.7 5.6 4.5 2 2 2 1 3 4.9 5.4 5.6 5.4 2 1 1 1 3 3.2 6.4 4.6 4.2 2 2 1 1 2 5.2 4.7 5.6 4.5 2 3 3 1 1 4.9 5.2 5.7 4.2 2 1 3 2 1 4.9 5.2 4.6 4.2 2 1 1 1 3 3.2 6.4 5.5 3.5 2 2 2 1 1 5.2 4.7 5.6 4.5 2 2 2 1 3 4.9 5.4 5.6 5.4 2 2 1 1 2 5.2 4.7 5.6 4.5 2 3 3 1 2 4.9 6.4 5.5 5.4 2 2 2 1 3 5.9 5.2 4.6 4.2 2 1 3 2 1 4.9 4.7 5.6 4.5 2 1 1 1 3 3.2 5.4 5.6 5.4 2 3 3 1 1 4.9 6.4 4.6 4.2 2 1 3 2 1 4.9 4.7 5.6 4.5 2 1 3 1 3 5.2 5.2 5.7 4.2 2 2 3 1 3 4.9 5.2 4.6 4.2 2 3 2 1 1 4.9 6.4 5.5 3.5 2 2 2 1 1 5.2 4.7 5.6 4.5 2 2 2 2 3 4.9 5.4 5.6 5.4 2 1 3 2 3 4.9 5.2 4.6 4.2 2 2 2 1 2 5.2 6.4 5.5 3.5 2 3 3 1 1 4.9 5.2 4.6 4.2 2 1 1 1 2 5.2 5.3 5.7 2.3 2 3 2 1 1 5.2 4.7 5.6 4.5 2 1 3 1 2 4.9 6.4 5.5 5.4 2 2 1 2 3 5.9 5.2 4.6 4.2 2 2 1 1 1 5.7 4.7 6.9 6.7 2 2 1 1 1 5.1 5.4 6.8 2.1 2 3 2 1 1 3.1 6.4 2.2 2.5 2 2 2 2 3 2.3 4.7 3.4 3.1 2 2 2 2 1 2.8 6.4 6.5 5.5 2 1 2 2 1 6.9 5.2 6.9 5.7 2 1 2 2 1 6.8 4.7 6.8 4.8 2 3 3 1 1 2.2 5.4 2.2 4.6 2 2 3 1 1 3.4 6.4 3.4 2.2 2 2 3 1 1 6.5 4.7 6.5 2.5 2 2 3 1 2 4.8 5.2 5.5 2.6 2 2 3 1 2 3.8 4.7 2.4 2.8 2 1 1 1 3 5.2 4.7 3.5 2.9 2 1 1 2 1 3.4 5.4 6.9 5.4 2 3 1 2 3 5.7 6.4 5.5 3.1 2 2 1 2 1 5.1 5.3 5.2 2.5 2 2 1 2 1 3.1 2.3 5.7 3.8 2 3 1 2 3 2.3 4.5 5.5 3.4 2 2 2 2 3 2.8 5.4 2.8 3.6 2 1 3 2 3 4.9 5.2 4.6 4.2 2 2 2 1 2 5.2 6.4 5.5 3.5 2 3 3 1 1 4.9 5.2 4.6 4.2 2 1 1 1 2 5.2 5.3 5.7 2.3 2 3 2 1 1 5.2 4.7 5.6 4.5 2 1 3 1 2 4.9 6.4 5.5 5.4 2 2 1 2 3 5.9 5.2 4.6 4.2 2 2 1 1 1 5.7 4.7 6.9 6.7 2 2 1 1 1 5.1 5.4 6.8 2.1 2 3 2 1 1 3.1 6.4 2.2 2.5 2 2 2 2 3 2.3 4.7 3.4 3.1 2 2 2 2 1 2.8 6.4 6.5 5.5 2 1 2 2 1 6.9 5.2 6.9 5.7 2 1 2 2 1 6.8 4.7 6.8 4.8 2 3 3 1 1 2.2 5.4 2.2 4.6 2 2 3 1 1 3.4 6.4 3.4 2.2 2 2 3 1 1 6.5 4.7 6.5 2.5 2 2 3 1 2 4.8 5.2 5.5 2.6 2 1 2 2 1 6.9 4.2 3.4 2.5 2 1 2 2 1 6.8 4.5 3.9 6.6 2 3 2 2 3 2.2 3.1 2.2 6.8 2 1 2 1 3 3.4 3.5 5.4 6.5 2 2 1 1 1 5.7 4.7 6.9 6.7 2 2 1 1 1 5.1 5.4 6.8 2.1 2 3 2 1 1 3.1 6.4 2.2 2.5 2 2 2 2 3 2.3 4.7 3.4 3.1 2 2 2 2 1 2.8 6.4 6.5 5.5 2 1 2 2 1 6.9 5.2 6.9 5.7 2 1 2 2 1 6.8 4.7 6.8 4.8 2 3 3 1 1 2.2 5.4 2.2 4.6 2 2 3 1 1 3.4 6.4 3.4 2.2 2 2 3 1 1 6.5 4.7 6.5 2.5 2 2 3 1 2 4.8 5.2 5.5 2.6 2 2 3 1 2 3.8 4.7 2.4 2.8 2 1 1 1 3 5.2 4.7 3.5 2.9 2 1 1 2 1 3.4 5.4 6.9 5.4 2 3 1 2 3 5.7 6.4 5.5 3.1 2 2 1 2 1 5.1 5.3 5.2 2.5 2 2 1 2 1 3.1 2.3 5.7 3.8 2 3 1 2 3 2.3 4.5 5.5 3.4 2 2 2 2 3 2.8 5.4 2.8 3.6 2 1 3 2 3 4.9 5.2 4.6 4.2 2 2 2 1 2 5.2 6.4 5.5 3.5 2 3 3 1 1 4.9 5.2 4.6 4.2 2 1 1 1 2 5.2 5.3 5.7 2.3 2 3 1 2 3 5.7 6.4 5.5 3.1  |
