I am unsure how to calculate the values for the ANOVA table (without using Excel). Is it possible to solve this question without using Excel?

If so, can you please advise on how to go about answering (if solvable without using Excel):

Production Rate and Quality Control. In a manufacturing process the assembly line speed (feet per minute) was thought to affect the number of defective parts found during the inspection process. To test this theory, managers devised a situation in which the same batch of parts was inspected visually at a variety of line speeds. They collected the following data:

Line Speed

20

20

40

30

60

40

Number of Defective Parts Found

21

19

15

16

14

17

b. At a .05 level of significance, determine whether line speed and number of defective parts found are related.