Unit 7: Homework Assignment 1
In a manufacturing production process, two machines are being compared. The data below show the diameters, measured in millimeters, of a sample of ball bearings produced by each machine.Machine A Machine B
1.95 2.22
2.45 2.30
2.50 2.34
2.75 2.28
2.38 2.29
2.26 2.25
2.33 2.30
2.20 2.27
2.16 2.38
2.20 2.34
Use Excel Template 6 (available in Canvas) to determine whether the variance in diameters differs between the two machines. Use a .05 level of significance.
Unit 7: Homework Assignment 2
Using Excel Template 7 (available in Canvas), find the correlation between miles driven by a sales representative for MediCap Pharmaceutical and the sales made. Part A asks you to use the “long way” of calculating, and Part B asks you to use the Data Tool to solve for the correlation.
Unit 7: Homework Assignment 3
Using Excel Template 7, find the correlation between miles driven by a sales representative, sales made, and sales calls made by using the Data Tool.