PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND
ANSWER ALL QUESTIONS
All problems must be solved using Excel formulas to
receive credit.
Question Set 1.
You are in charge of quality control for computer monitors at
Dell. You have data on twenty-five batches of monitors, tracking
five types of defects: brightness, color, contrast, dead pixels,
and stuck pixels. These data are given in the table below.
1. For each defect type, find the average
number of defects per...