Find solutions to the following problems.Be sure to include a statement about significance and complete Tukey's HSD when necessary.

Subjects were interviewed about their smoking habits in cigarettes per day and were tested for their aerobic capacity.Taking cigarettes per day as the explanatory (independent) variable and aerobic capacity as the response (dependent) variable, find the correlation coefficient, the least-squares regression line, and the predicted aerobic capacity for someone who smokes 25 cigarettes a day.Also, test the null hypothesis that smoking does not affect aerobic capacity against the alternative that increased smoking decreases aerobic capacity at 5% significance.

cigarettes per day Aerobic Capacity

3 52

5 38

6 45

9 34

11 29

12 31

16 17

19 25

Please show/explain all steps/work also in excel if able