4-1 Data Set Homework: Correlation And Regression On Data Se

4-1 Data Set Homework: Correlation and Regression on Data Set 2Southern New Hampshire UniversityQSO-510 Quantitative Analysis 02:33:38 GMT -05:004-1 Data Set Homework: Correlation and Regression on Data Set 2The data used for this analysis is a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks shown in Figure 1.Figure 1Week #Flashdrives1 6273 6455 7657 6869 810911 912713 514615 816817 918719 620821 522723 624825 1026927 728829 7306 02:33:38 GMT -05:00MethodologyThe sample of defective flash drives was entered into a Microsoft Excel sheet. Thesample was then analyzed using the “data analysis” feature within Excel’s ToolPak. By selecting “Regression” to analyze the data, a window appears to select the options desired for this analysis. I highlighted the number of flash drives data for the Y range and week for the X range, then I selected labels as well as all four residuals’ options. A summary output was displayed in a new tab named “Output” and the data was analyzed.AnalysisThe