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

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.

Step by Step Solution

3.30 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

In the following spreadsheet we find Calculated which is labeled t Stat in cell F10 is less ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

878-E-C-E-E-C (1685).docx

120 KBs Word File

Students Have Also Explored These Related Chemical Engineering Questions!