See attached data set.
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 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.© BrainMass Inc. brainmass.com June 3, 2020, 11:42 pm ad1c9bdddf
The solution provides step-by-step methods of performing a Wilcoxon Signed Rank Hypothesis Test. The calculations have been performed in Excel and the statistical analysis has been shown in details.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.