Question

An auto transmission manufacturer receives ball bearings from two different suppliers. The ball bearings must have a specified diameter of 16.30 mm with a tolerance of plus or minus±0.1 mm. Recent shipments from the two suppliers had ball bearings with the following diameters. Complete parts (a) through (c). Supplier A: 16.2316.23 16.2616.26 16.3216.32 16.3316.33 16.3616.36 16.4216.42 16.4516.45 Open in StatCrunch + Copy to Clipboard + Open in Excel + Supplier B: 16.1816.18 16.2216.22 16.2516.25 16.3316.33 16.3816.38 16.4116.41 16.4516.45 a. Find the mean and standard deviation for each of the two data sets. Find the mean and standard deviation for the diameters of the ball bearings from Supplier A. meanequals= nothing sequals= nothing (Round to the nearest hundredth as needed.)

Answer 1

Enter the supplier A data into excel sheet from cell A2 to A8 and supplier B data from cell C2 to C8

Use excel function AVERAGE and STDEV.S to find mean and sample standard deviation respectively

Formulation for supplier A in excel

= AVERAGE(A2:A8)

= 16.34

and

= STDEV.S(A2:A8)

= 0.08

Formulation for supplier B in excel

= AVERAGE(C2:C8)

= 16.32

and

= STDEV.S(C2:C8)

= 0.10

(all values are rounded to 2 decimal places)