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
A two-tailed test means that the results could be in either tail of the distribution curve. For example, if you are doing a two-tailed z-test at .05 level of significance, the critical or cutoff values to reject the null would be z = + or - 1.96. If the test statistic exceeds the critical value in either tail (+ or -), then the null is rejected in favor of the alternate hypothesis. If the test statistic does not exceed the critical value in either tail (+ or -), then the null cannot be rejected.
I hope this will help.
To perform a two-tailed hypothesis test on the intrinsic and extrinsic variables' data using a .05 significance level, follow these steps:
1. State the null and alternative hypotheses:
- Null hypothesis (H0): There is no significant difference between the variable means.
- Alternative hypothesis (Ha): There is a significant difference between the variable means.
2. Import the data into Microsoft Excel and sort it accordingly.
3. Calculate the means of the two variables using Excel's "AVERAGE" function.
4. Calculate the standard deviation of the two variables using Excel's "STDEV.S" function.
5. Determine the sample sizes of the two variables.
6. Calculate the standard error of the mean for each variable by dividing the standard deviation by the square root of the sample size.
7. Calculate the test statistic (t-value) for each variable using the formula:
t = (mean1 - mean2) /√[(SE1^2 / n1) + (SE2^2 / n2)]
8. Determine the degrees of freedom (df) using the following formula:
df = n1 + n2 - 2
9. Calculate the critical value by referring to the t-distribution table or using Excel's "T.INV.2T" function. For a two-tailed test at a .05 significance level and df degrees of freedom, use α/2 = 0.025.
10. Compare the calculated t-value with the critical value:
- If the calculated t-value is greater than the critical value, reject the null hypothesis.
- If the calculated t-value is less than the critical value, fail to reject the null hypothesis.
11. Copy and paste the results of the output in Excel, including the sample means, standard deviations, t-values, critical values, and whether the null hypothesis is rejected or not, into a Microsoft Word report.
12. Repeat the process for the extrinsic variable's data, following the same steps.
By following these steps and using Microsoft Excel for calculations, you can perform the two-tailed hypothesis test on the intrinsic and extrinsic variables' data and report the relevant results.