The solution to Hypothesis Testing: Intrinsic & Extrinsic Job satisfaction

Please us the data set and key provided in attached file.

Using AIU's survey responses from the AIU data set, complete the following requirements in the form of a report:

Perform a two-tailed hypothesis test on the intrinsic variable AND a two-tailed hypothesis test on the extrinsic variable's data using a .05 significance level.

Begin by creating a null and an alternate statement. Use Microsoft Excel to process your data. 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. Repeat the steps for the 2nd two-tailed hypothesis test.

In a separate paragraph, provide some information on when to use a t-test and when to use a z-test and why. Also, provide some information about 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.

For the purpose of simplicity, please test the two separate claims: 1) the average level of intrinsic job satisfaction of American workers is 5; 2) the average level of extrinsic job satisfaction of American workers is 5. You will use the sample data of 25 workers that we have since unit 1. Show all the steps (H0 and H1 hypothesis, the error margin (also called the level of significance), the test-statistic, the critical t-value, and the conclusion about H0). So, you need two t-tests; one for the intrinsic and the other for extrinsic.