THIS NEEDS TO BE DONE BY HAND USING THE EQUATION FOR CORRELATION. I AM GETTING A DIFFERENT R ON EXCEL THEN WHEN I DO IT BY HAND! THANK YOU

Question 4: Relationship between GDP and education spending [20 marks] I have randomly selected 10 states to analyze the relationship between the GDP and the education spending. We can assume that the GDP is the explanatory variable and the edu- cation spending the response variable. Table 3: GDP (in $billions) and education spending (in $billions) for different locations States GDP Education Nevada 161.5 3.1 Oregon 248.9 11.7 Nebraska 122.9 6.3 Connecticut 283.6 4.4 Arkansas 128.7 9.3 Pennsylvania 777.5 7.6 Utah 171.7 7.3 New Jersey 626.9 13.5 Washington 517.8 2.6 Maryland 409.3 41.2 a. Measure the direction and the strength of the linear relationship between GDP and edu- cation spending. Comment on your result. Why do we have to be careful with this measure? Show all of your steps. [7 marks]