See attached data set files.
Using AIU's survey responses from the AIU data set attached below, complete the following requirements in the form of a report:
Perform a two-tailed hypothesis test on both the intrinsic and 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.
- Formulate null and alternative hypotheses for applications involving a single population mean, proportion, or variance.
- Use effective communication techniques.
The solution provides step-by-step methods of performing a two-tailed hypothesis test. All the steps of hypothesis testing (formulation of null and alternate hypotheses, selection of significance level, choosing the appropriate test-statistic, decision rule, calculation of test-statistic and conclusion) have been explained in detail.
The solution also provides information on when to use a t-test and when to use a z-test and why samples are used instead of populations. Formula for the calculations and interpretations of the results are also included. Excel calculations, involving descriptive statistics, mean, median, mode, standard deviation, variance, etc have also been included in separate sheets.