Perform the following two-tailed hypothesis test, using a .05 significance level

Perform the following two-tailed hypothesis test, using a .05 significance level


SURVEY GenderAgeDepartmentPositionTenureJob SatisfactionIntrinsicExtrinsicBenefits 111135.55.55.55.4 133114.95.24.66.2KEY TO SURVEY 112215.55.35.72.3 113115.24.75.64.5Demographics 133114.95.24.66.2 122115.24.75.64.5Gender 121125.24.75.64.51Male 133125.55.45.65.42Female 122135.93.75.56.2Age 113214.95.24.66.2116 - 21 111133.25.55.53.5222 - 49 133114.95.24.66.2350 - 65 112215.55.35.72.3Department 113135.24.75.64.51Human Resources 122135.55.55.55.42Information Technology 133114.95.24.66.23Administration 122115.24.75.64.5Position 122135.55.45.65.41Hourly Employee (Overtime Eligible) 111133.25.54.66.22Salaried Employee (No Overtime) 121125.24.75.64.5Tenure With Company 133114.95.25.76.21Less than 2 years 111125.55.35.65.422 to 5 years 111125.55.35.65.43Over 5 Years 221235.55.35.72.3 223114.95.25.62.3Four Survey Measures 233115.55.35.64.5 222235.24.75.55.4SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7) 222215.55.44.66.21 = Least Satisfied 222115.25.55.44.57 = Most Satisfied 221114.94.66.22.3SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7) 233225.55.64.54.51= Least Satisfied 213225.55.65.44.57= Most Satisfied 233115.24.75.55.4SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7) 223115.55.44.66.21 = Least Satisfied 222235.46.25.76.27 = Most Satisfied 232213.25.25.64.5SURVEY MEASURE #4 BENEFITS (Scale 1-7) 232125.55.35.65.41= Least Satisfied 223214.94.75.56.27= Most Satisfied 222115.55.55.55.4 213114.95.24.66.2 231113.92.15.72.3 232125.24.75.64.5 223125.55.45.65.4 221235.55.35.72.3 Using AIU’s 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. The report should be well written and should flow well with no grammatical errors. It should include proper citation in APA formatting in both the in-text and reference pages and include a title page, be double-spaced, and in Times New Roman, 12-point font. APA formatting is necessary to ensure academic honesty. Be sure to provide references in APA format for any resource you may use to support your answers.