Solving For Coefficients

The left is the question as was given to me. The right is my work on it in Excel. I have managed to fill in all the question marks except one. I don't know how to calculate the intercept coefficient. I also am not positive I have the x coefficient right. I divided the intercept standard error by the x standard error. Help with those two things would be greatly appreciated!

Screen Shot 2019-09-30 at 11.00.08 AM.png


Active Member
Do a simple example in Excel and experiment. For example, see what you get when you multiply intercept SE x intercept t stat and look for it in the table. Then look back at the question.