Now we use a built-in routine in Excel for the paired t test to see if the two methods

Chapter 4, Problem 4-15

(choose chapter or problem)

Now we use a built-in routine in Excel for the paired t test to see if the two methods in 4-14 produce significantly different results. Enter the data for Methods 1 and 2 into two columns of a spreadsheet. For Excel 2007, find Data Analysis in the Data ribbon. In earlier versions of Excel, find Data Analysis in the Tools menu. If Data Analysis does not appear, follow the instructions at the beginning of Section 4-5 to load this software. Select Data Analysis and then select t-Test: Paired Two Sample for Means. Follow the instructions of Section 4-5, and the routine will print out information including tcalculated (labeled t Stat) and ttable (labeled t Critical two-tail). You should reproduce the results of 4-14.