Get reliable answers to your questions at Westonci.ca, where our knowledgeable community is always ready to help. Get immediate and reliable answers to your questions from a community of experienced professionals on our platform. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

PLEASE EXPLAIN USING EXCEL


The diameter of a ball bearing was measured by 12 inspectors, each using two different kinds of calipers. The results are as follows:



Inspector
Caliper 1
Caliper 2




1
0.265
0.264


2
0.265
0.265


3
0.266
0.264


4
0.267
0.266


5
0.267
0.267


6
0.265
0.268


7
0.267
0.264


8
0.267
0.265


9
0.265
0.265


10
0.268
0.267


11
0.268
0.268


12
0.265
0.269




Is there a significant difference between the means of the population of measurements from which the two samples were selected? Use 0.05
Find the ‐value for the test in part (a).
Construct a 95 percent confidence interval on the difference in mean diameter measurements for the two types of calipers.

PLEASE EXPLAIN USING EXCEL The Diameter Of A Ball Bearing Was Measured By 12 Inspectors Each Using Two Different Kinds Of Calipers The Results Are As Follows In class=