Excel Link:https://docs.google.com/spreadsheets/d/1Lq9lFZ1SB1sjhxay07GH5H5e2WSHW_5X/edit?usp=sharing&ouid=111846680843393654433&rtpof=true&sd=true

The file P10_02.xlsx contains midterm and final exam scores for 96 students in a corporate finance course. Each row contains the two exam scores for a given student, so you might expect them to be positively correlated.

Find the trend line equation. Let X represent the midterm. Round your answers to three decimal places, if necessary. 7= Q. Q Find the R? value. Round your answer to three decimal places, if necessary. Q What does this equation indicate in terms of predicting a student's final exam score from his or her midterm score? Be specific. Round your answer to three | places, if necessary. When the & exam increases by 8 point, the & exam is expected to increase by 8 c. Run a regression to confirm the trend-line equation from part b. Let X represent the midterm. Round your answers to three decimal places, if necessary. - Q. Q x What does the standard error of estimate say about the accuracy of the prediction requested in part b? If necessary, round your standard error answer to tw digits. The standard error indicates that about of the predictions of the exam score, made only from the score, \\ 0 points of the actual exam score