Question

1.) Use Excel to plot the dependent vs the independent variable. Show the regression equation from the computer output.

1. Lannie Karner- GPA 3.6 Income 75k
2. Courtney Sheperd Gpa 3.3 Income 74K
3. Zenobia Roussel- GPA 2.9 Income 66K
4. Elaine Doody- GPA 3.8 Income 80k
5. Maudie Hocker-GPA 3.1 Income 65k
6. Rick Hoover-GPA 3.2 Income 53k
7. Franinca Ortez-GPA 2.7 Income 65k
8. Li Kinder-GPA 3.3 Income 71k
9. Brad Clem-GPA 3.8 Income 80k
10. Soon Nettleton-GPA 4.0 Income 95k
11. Vertie Yousesef-GPA 3.9 Income 110k
12. Love Au-GPA 3.7 Income 85k
13. Joselyn Reinhart-GPA 2.9 Income 55k
14. Thora Spradley-GPA 3.3 Income 65k
15. Melvin Sheth-GPA 3.0 Income 65k
16. Nathan Helfrich-GPA 2.7 Income 59k
17. Wayne Convger-GPA 2.9 Income 58k
18. Hayden Stovall-GPA 3.0 Income 62k
19. Lindsay Broussard-GPA 2.9 Income 57k
20. Otto Reiley-GPA 3.5 Income 74k
21. Glen Augustine-GPA 3.7 Income 84k
22. Jessie Hinchman-GPA 3.4 Income 80k
23. Clemente Baumgardner-GPA 3.1 Income 75k
24. Daren Ewart-GPA- 3.5 Income 92k
25. Emory Gilbride-GPA 2.8 Income 67k
26. Kurt Mcglone-GPA 4.0 Income 112k
27. Minh Wurth-GPA-3.9 Income 103k
28. Ronny Wimmer-GPA 3.5 Income 94k
29. Hong Kilday-GPA 2.9 Income 59k
30. Jarrod Jeanpierre-GPA 3.9 Income 102k

Interpret b1 (and b0 if possible) including units, and r2.

Test for significance of β1 at α = 0.05 and at α = 0.01 using the t value from the computer output, and the appropriate values from the t table. State clearly the null and alternate hypotheses. Show the computer table with the t values. State the table [tcritical] and calculated [tSTAT] values of t and your conclusion.

Answer 1