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
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.