PLEASE PROVIDE SPECIFIC INSTRUCTIONS!!!!! HOT TO DO THE FOLLOWING ON EXCEL

1.For years 1985 to 1992, you are given monthly interest rates on bonds that pay money one year after the day theyre bought. Its often suggested that interest rates are more volatiletend to change morewhen interest rates are high. Does the data in the Intratevol-volatility.xlsx file support this statement? (Hint: PivotTables can display standard deviations.)

2. Contoso, Ltd. produces microchips. Five types of defects (labeled 15) have been known to occur. Chips are manufactured by two operators (A and B), using four machines (14). 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. Youll find this data in the Contoso.xlsx file.