David B. answered 02/23/22
Math and Statistics need not be scary
You didn't name the first variable. I assume it is the other half of the bi-variate data. I will call the first variable AST as the values would fit.
There are several ways to do a regression and calculate R2 , you should look into them as they are straight forward with such a small dataset as this.
Follow this link: https://www.statology.org/calculate-r-squared-by-hand/
This is the purpose of the homework, learning by doing. Take the data, create the necessary table in excel and then do the calculations by row. Finally follow the formula to calculate the R2 hint: it has to do with the sum of the square of the errors and the total sum of the square.
That being said, I used R to solve the linear equation
The results were as follows. (use to check your own hand work)
Call:
lm(formula = GPA ~ AST)
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 2.623616 0.122041 21.50 6.61e-07 ***
AST. 0.047767 0.008179 5.84 0.00111 **
Residual standard error: 0.153 on 6 degrees of freedom
Multiple R-squared: 0.8504, Adjusted R-squared: 0.8255
David B.
you could also use excel to answer this. Just create an x-y chart and add a regression line with equations. R2 is one of the terms reported. Good Luck02/23/22
Gia K.
Thanks02/23/22