The data set presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks

profileEducator2
 (Not rated)
 (Not rated)
Chat

 

The data set 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.

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

    • 9 years ago
    The data set presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      9181441.xlsx