Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
TESTING TWO POPULATION MEANS AND PROPORTIONS 77 of data, include the label and check the box confirming the label is in the first row or column, depending on the orientation of your data. Enter the full shown in the hypothesis test in the field labeled "Alpha." Click the output range and activate the field by clicking your mouse in that field. Identify a single cell where the beginning of the output should be placed on your spreadsheet. Click "OK" at the top of the box. Output will include means, variances, counts, df, the calculated test statistic, the one-tailed and two-tailed p- values, and the upper critical bound for both a one-tailed and a two-tailed hypothesis test. If your test has a lower-tail rejection region, you need to take the negative of the upper critical bound to find the lower critical bound that is the boundary value for the rejection region. z- Test: Two Sample for Means To access this Excel program, activate the Data Analysis toolkit on the spreadsheet with the data list and select this program. Enter the range of the data you want for the first variable as Variable 1 and the data you