Question

A manufacturing plant produces custom hardware for specific applications in construction. One particular kind of bolt that is intended to have a length of 84mm is produced by two different machines, A and B. Tristan is an employee in the department that produces this bolt. He randomly selects samples of 100 bolts from each machine and measures the length of each one. The lengths of the bolts, in millimeters, are shown in the table below. Each machine produced a bolt that has a length of 84.05mm.Use Excel to calculate each machine's z-score for producing a bolt that has a length of 84.05mm.Round your answers to two decimal places.Machine A Machine B84.017 83.97183.999 83.9984.011 84.00284.007 84.01884.008 83.9884.016 83.99384 83.98884.026 84.00484.009 83.99184.031 83.95584.017 84.01584.022 83.96684.03 83.99584.07 83.97584.018 83.94484.05 83.9384.049 83.99984.026 83.98283.999 83.94884.002 83.95284.057 83.98483.991 84.00284.016 83.98684.006 84.0183.987 83.98384.034 84.01984.035 83.95884.006 83.99284.021 83.98784.022 83.97484.028 83.99684.004 83.98584.032 83.97884.02 83.98684.026 83.96284.041 83.9784.035 84.00483.996 84.00784.034 83.97784.042 83.96984.002 83.97384.019 83.97484.029 83.99184.016 83.97484.014 84.00284.014 83.97884.018 83.99584.014 8484.032 83.99284.042 83.99483.999 84.00284.003 83.95884.045 83.96584.024 83.98984.033 83.98384.031 83.99784.014 83.96183.983 83.97384.055 83.98384.024 83.96584.035 83.95684.052 83.98484.041 83.9584.029 83.97584.017 83.95784.006 83.97884.013 83.98484.013 83.94384.039 83.93984.008 83.99784.029 83.9984.02 83.98384.046 83.95784.004 84.00384.036 83.98984.013 83.97284.025 84.00683.979 83.98884.015 83.9784.01 84.00984.026 83.99184.016 83.9684.024 83.94584.024 83.99684.018 83.97384.006 83.96384.039 83.95984.004 84.01983.992 83.95784.007 84.00184.04 84.01383.999 8484.007 83.98484.009 83.96784.031 83.94884.003 83.98584.01 83.98884.011 83.96384.051 83.98584.002 84.001Provide your answer below: The z-score for machine A is___ and the z​ -score for machine B is ____

Answer 1

Answer:

The formula calculated the Z-score for all data points

Step-by-step explanation:

I have taken out time to prepare the raw file as a CSV file (comma separated variable) please see attached the excel format.

Z-SCORE= (DataPoint-AVERAGE(DataSet))/STDEV(DataSet)    

IN EXCEL,

AVERAGE, an excel function that calculates the Average of data set

STDEV.S: calculates the standard deviation while treating the data as a ‘sample’ of a population.

STDEV.P: This function calculates the standard deviation while treating the data as the entire population.

kindly find attached the excel sheet, with calculations done

Kindly let me know if you need more information,

Download pdf