Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data set 2presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. Use Excels
Data set 2presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. Use Excels 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.
Week | #Flashdrives | |
1 | 6 | |
2 | 7 | |
3 | 6 | |
4 | 5 | |
5 | 7 | |
6 | 5 | |
7 | 6 | |
8 | 6 | |
9 | 8 | |
10 | 9 | |
11 | 9 | |
12 | 7 | |
13 | 5 | |
14 | 6 | |
15 | 8 | |
16 | 8 | |
17 | 9 | |
18 | 7 | |
19 | 6 | |
20 | 8 | |
21 | 5 | |
22 | 7 | |
23 | 6 | |
24 | 8 | |
25 | 10 | |
26 | 9 | |
27 | 7 | |
28 | 8 | |
29 | 7 | |
30 | 6 |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started