A manufacturer of flash drives for data storage operates a production facility that runs on 3 eight-hour shifts per day. The following contingency table shows the number of flash drives that were defective and not defective from each shift. Click this button to reveal the table. Click again to collapse it. Defective Not Defective Total Shift 1 5 101 106 Shift2 95 107 Shift3 73 78 Total 22 269 291 Click Download CSV to download csv file of data or copy/paste the data into Excel. After downloading the file, you may want to save it as an Excel Workbook. a. Use Excel to perform a chi-squared test for independence to test whether the shift is related to the defectiveness of items. Show all the work in the Excel file to get full points. Highlight or fill the cell with the p-value using yellow color. b. Attach the Excel file with all your use of Excel Functions to answer the above questions. I would like to see how you solve the problem using Excel functions. No work gives you no points. You have only one chance to submit this and therefore, make sure you submit the correct Excel file in the correct format (that is, .xlsx format) with all the Excel functions and your work. 12 5 A manufacturer of flash drives for data storage operates a production facility that runs on 3 eight-hour shifts per day. The following contingency table shows the number of flash drives that were defective and not defective from each shift. Click this button to reveal the table. Click again to collapse it. Defective Not Defective Total Shift 1 5 101 106 Shift2 95 107 Shift3 73 78 Total 22 269 291 Click Download CSV to download csv file of data or copy/paste the data into Excel. After downloading the file, you may want to save it as an Excel Workbook. a. Use Excel to perform a chi-squared test for independence to test whether the shift is related to the defectiveness of items. Show all the work in the Excel file to get full points. Highlight or fill the cell with the p-value using yellow color. b. Attach the Excel file with all your use of Excel Functions to answer the above questions. I would like to see how you solve the problem using Excel functions. No work gives you no points. You have only one chance to submit this and therefore, make sure you submit the correct Excel file in the correct format (that is, .xlsx format) with all the Excel functions and your work. 12 5