InstructionsData set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. Use Excel's Analysis ToolPak (or any statistical package that you are comfortable with) to compute the regression equation for predicting the number of defective flash drives over time (in weeks), the correlation coefficient r and the coefficient of determination R2. Submit your statistical output from Excel, which should include values for a slope, y-intercept, regression equation, r, and R2, and a one-page Word document in which you present an analysis of your results. Must complete the Excel requirements and submit along with the one page Word document. Formatting must meet the APA standards and requires 1 to 2 references.

Complete the Module Eight problem set in MyStatLab. See Instructor Tips in MyStatLab for video solutions for select problems. In the Module Eight problem set, video solutions are available for problem numbers 3, 6, and 7.Click on the MyStatLab link on the left-side navigation to access this resource. You are allowed unlimited attempts to complete this assignment.

The purpose of this assignment is to have students demonstrate mastery of the foundational concepts that set the stage for the remainder of the course. Students apply those concepts to business research questions or problem situations to focus their thinking on statistical literacy for use in business decision-making. Assignment Steps Resources: Week 1 Readings; Statistics Lab Tutorial help on Excel® and Word functions can be found on the Microsoft® Office® website. There are also additional tutorials via the web that offer support for office products. Develop a 1,050-word response addressing each of the following prompts: Define statistics with citation and reference.Contrast quantitative data and qualitative data. Use two peer reviewed references.Evaluate tables and charts used to represent quantitative and qualitative data.Describe the levels of data measurement.Describe the role of statistics in business decision-making.Provide at least two business research questions, or problem situations, in which statistics was used or could be used.Use two peer reviewed references. Format your assignment consistent with APA guidelines.