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.

In the online class, participation is graded as a part of discussion. In addition to your own post (which is due by Thursday midnight of each week), you should respond to the posts of a peer each week. To be substantive, your reply should add more information to the discussion, bring a helpful resource to the discussion forum, or question the response on the merit of your own research. Posts should be at least 250 words and each reply should be at least 150 words. In order to receive full credit you'll need to reference the content of the discussion to your field of study (ex: nursing). Think about how the concept would apply to your field, how you would encounter the concept in your field, and how you would interact/experience the concept in your field of study.Instructions:Visit the following website: http://blog.minitab.com/blog/statistics-and-quality-data-analysis/large-samples-too-much-of-a-good-thing (Links to an external site.)Researchers may seem to be more often concerned with small sample sizes and tests that, as a result, lack power, yet having a very large sample can create its own set of problems. Speculate these issues by pointing out the relationships between sample size and power when the magnitude of effect is held constant. What other implications can you gain from the information?Please post your initial response by 23:59 CST Thursday the Week, and comment on the post of a classmate by 23:59 CST Sunday.Submission Instructions:Writing should be in APA format (Times New Roman size 12 font). Proofread for grammatical accuracy. Late posts will be deducted points. Late replies will not be counted. Forums will close at 23:59 CST Sunday of each week. Type your response into the forum, avoid uploading a Word document with your post. Grading Rubric Your assignment will be graded according to the grading rubric.AdvancedEmergingUnsatisfactoryPost:Addresses question210Integrates information from readings and/or experiences1.50Conveys understanding of key idea1.50Relates key idea to professional field of study1.50Appropriate length and style1.50Logical organizations, conventional, and citations1.50Response post:Addresses/considers peer’s writing1.50Reply connects, extends, or applies question to colleagues’ idea1.50Appropriate length and style1.50