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.
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 111135.55.55.55.4 133114.95.24.66.2Four Survey Measures 112215.55.35.72.3 113115.24.75.64.5SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7) 133114.95.24.66.21 = Least Satisfied 122115.24.75.64.57 = Most Satisfied 121125.24.75.64.5SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7) 133125.55.45.65.41= Least Satisfied 122135.93.75.56.27= Most Satisfied 113214.95.24.66.2SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7) 111133.25.55.53.51 = Least Satisfied 133114.95.24.66.27 = Most Satisfied 113215.55.35.72.3SURVEY MEASURE #4 BENEFITS (Scale 1-7) 113135.24.75.64.51= Least Satisfied 123135.55.55.55.47= Most Satisfied 132114.95.24.66.2 122115.24.75.64.5 122135.55.45.65.4 113133.25.54.66.2 122125.24.75.64.5 133115.55.25.76.2 111125.25.35.65.4 132114.95.25.76.2 113125.25.35.65.4 121235.25.35.72.3 121115.55.25.62.3 133115.95.35.64.5 223234.94.75.55.4 222213.25.44.66.2 222114.95.55.44.5 212215.55.35.72.3 213115.24.75.64.5 233114.95.24.66.2 222115.24.75.64.5 221125.24.75.64.5 233125.55.45.65.4 222135.93.75.56.2 213214.95.24.66.2 211133.25.55.53.5 233114.95.24.66.2 212215.55.35.72.3 213135.24.75.64.5 222135.55.55.55.4 233114.95.24.66.2 222115.24.75.64.5 222135.55.45.65.4 211133.25.54.66.2 221125.24.75.64.5 233114.95.25.76.2 211125.55.35.65.4 211125.55.35.65.4 211135.55.55.55.4 233114.95.24.66.2 212215.55.35.72.3 213115.24.75.64.5 233114.95.24.66.2 222115.24.75.64.5 221125.24.75.64.5 233125.55.45.65.4 211133.25.55.53.5 233114.95.24.66.2 212215.55.35.72.3 213135.24.75.64.5 222135.55.55.55.4 233114.95.24.66.2 222115.24.75.64.5 222135.55.45.65.4 211133.25.54.66.2 221125.24.75.64.5 222135.55.55.55.4 233114.95.24.66.2 222115.24.75.64.5 222135.55.45.65.4 211133.25.54.66.2 213115.24.75.64.5 233114.95.24.66.2 222115.24.75.64.5