I

Click into the box next to Variable 1, then take your mouse and highlight all of the data in column A. For this example the box now has a $A$1z$A$5, which means the data is in cell A1 to A5. Then click into the box next to Variable 2, take your mouse and highlight the zeros in column B. For this example the box now has a $B$lz$B$5, which means the data is in cell B1 to B5. Click into the box next to Hypothesized Mean Difference, and enter the hypothesized mean, for this example 750. Make sure that alpha is set to the same level of signicance for your problem, in this example it was 0.05. Then click on OK and you should get a similar table to the one below. I have highlighted the test statistic 0.1024 and the appropriate p-value 0.4617, notice that it gives you both the one-tailed and two-tailed results. 700 t-Test: Paired Two Sampiecg Variable I 799 Mean 747.8 800 Variance 2306.7 725 Observations 5 715 Pearson Correlation #DIWO! H pothesized Mean Difference 750 _1:_ 0.102426 0.4616738 t Critical one-tail 2.1313455 P(T