Question: Open the workbook named Binding3.xlsx located in the Chapter 2 folder, and then save it as QC Binding Data Analysis 3.xlsx. The InspectionCosts worksheet contains
Open the workbook named Binding3.xlsx located in the Chapter 2 folder, and then save it as QC Binding Data Analysis 3.xlsx. The InspectionCosts worksheet contains two hours of inspection data from the QC inspectors, detailing the amount of time spent testing the bindings for each of the tests performed: Pressure and Temperature. 2. Calculate the cost to test each ski binding and the total costs for all bindings over this two-hour period. Insert the labor cost per hour above the column heading, and display the cell to include $/hr-labor following the value, centering it in the cell. If an error message regarding omitting adjacent cells is generated, instruct Excel to ignore this error. (Hint: If the error occurs for multiple adjacent cells, highlight all cells, and then click the error message adjacent to the first cell to apply the setting to all cells.) Format the first value using the Accounting Number Format, and format the remaining values using the Comma Style. Use similar cell outlining to the adjacent cells. 3. Several rows below the labor cost data, calculate the mean, median, and standard deviation of these inspection costs (Pressure, Temperature) rounded to the nearest cent. Label the rows appropriately. Format these values in Accounting Number Format. 4. On a separate worksheet named TypeSummary, summarize these values by binding type (1 to 5). Include both a count of the number of bindings inspected of that type and the averages for bindings of that type, as listed in Table 2.13. Be sure to use formulas that will automatically update if any of the binding types, values, or cost data is later updated. The formula for average pressure should work when copied down the column to determine pressure for each corresponding binding type, and across the row to determine the average temperature and average costs for each type. Format the table appropriately.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
