Excel- Contoso, Ltd
1-Contoso, Ltd. produces microchips. Five types of defects (labeled 1–5) have been known to occur. Chips are manufactured by two operators (A and B), using four machines (1–4). You are given data about a sample of defective chips, including the type of defect, the operator, machine number, and day of the week the defect occurred. Use this data to chart a course of action that would lead, as quickly as possible, to improved product quality.
You should use a PivotTable to stratify the defects with respect to type of defect, day of the week, machine used, and operator working. You might even want to break down the data by machine, operator, and so on. Assume that each operator and machine made an equal number of products. You’ll find this data in the Contoso.xlsx file.
2- Students at the School of Fine Art apply to study either English or Science. You have been assigned to determine whether the School of Fine Art discriminates against women in admitting students to the school of their choice. You are given the following data on the School of Fine Art’s students:
1-Female or male
2-Major applied for: English (Eng) or Science (Sci)
3-Admit? Yes or No
Assuming that women are as qualified for each major as men are, does this data indicate that the college discriminates against women? Be sure you use all available information. The data is in the Finearts.xlsx file.
3- The Makeupdb.xlsx file contains information about the sales of makeup products. For each transaction, you are given the following information:
1-Name of salesperson
2-Date of sale
3-Product sold
4-Units sold
5-Transaction revenue
4- For years 1985 to 1992, you are given monthly interest rates on bonds that pay money one year after the day they’re bought. It’s often suggested that interest rates are more volatile—tend to change more—when interest rates are high. Does the data in the Intratevol-volatility.xlsx file support this statement? (Hint: PivotTables can display standard deviations.)
