. 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 det

profilebarakadeni
data_set_2.xlsx
Home>Business & Finance homework help>. 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 det

Sheet1

Week #Flashdrives Number of Defective Flashdrives for 30 Weeks
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