81 see ms excel file examplesxlsx worksheet mpg

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ing raw data can set up worksheet for specific case or template for any case can use Data Analysis Tools:—tTest:Two-Sample Assuming Unequal Variances summary statistics can set up worksheet for specific case or template for any case can set up worksheet for specific case or template for any case Using MS Excel… Data Analysis Tools:—t-Test:Two-Sample Assuming Unequal Variances Hypothesis Tests Using MS Excel… Data Analysis Tools:—t-Test:Two-Sample Assuming Unequal Variances Select 2 ranges of data Hypothesis Tests Using MS Excel… Data Analysis Tools:—t-Test:Two-Sample Assuming Unequal Variances Enter value (usually 0) Hypothesis Tests Using MS Excel… Data Analysis Tools:—t-Test:Two-Sample Assuming Unequal Variances Hypothesis Tests If labels were selected in variable ranges above, check this box Using MS Excel… SAFETY CHECK: When selecting the data, include the column labels and check this box—in this way, the output provided by MS Excel will be Data Analysis Tools:—t-Test:Two-Sample Assuming clearly labelled for you. Unequal Variances Hypothesis Tests If labels were selected in variable ranges above, check this box Using MS Excel… Data Analysis Tools:—t-Test:Two-Sample Assuming Unequal Variances Hypothesis Tests Enter level of significanc e Using MS Excel… Data Analysis Tools:—t-Test:Two-Sample Assuming Unequal Variances Hypothesis Tests Specify location for output Example—Using Template Specific Motors of Detroit has developed a new automobile known as the M car. 24 M cars and 28 J cars (from Japan) were road tested to compare mpg performance. The sample statistics are: M Cars J Cars Hypothesis Tests n x 24 28 29.8 27.3 s 2.56 1.81 see MS Excel file Examples.xlsx, worksheet MPG Example Hypothesis Tests The president of a company that manufactures automobile air conditioners is considering switching his supplier of condensers, Supplier A, who prices its product 5% higher than supplier B. Because the president wants to maintain his company’s reputation for quality, he wants to be sure that supplier B’s condensers last at least as long as supplier A’s. He decides to retain supplier A if there is sufficient statistical evidence that supplier A’s condensers last longer on average than supplier B’s. In an experiment, 30 midsize cars were equipped with air conditions using type A condensers while another 30 midsize cars were equipped with type B condensers. The number of miles (in thousands) driven by each car before the condenser broke down was recorded. x Should the president retain supplier A? Example Hypothesis Tests The president of a company that manufactures automobile air conditioners is considering switching his supplier of condensers, Supplier A, who prices its product 5% higher than supplier B. Because the president wants to maintain his company’s reputation for quality, he wants to be sure that supplier B’s condensers last at least as long as supplier A’s. He decides to retain supplier A if there is sufficient s...
View Full Document

This document was uploaded on 03/05/2014.

Ask a homework question - tutors are online