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

Question:

Now we use a built-in routine in Excel for the paired t test to see if the two methods in Problem 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 Problem 4 14.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: