# Question: The file P02 10 xlsx contains midterm and final exam scores for

The file P02_10.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.

a. Create a scatter plot of the final exam score (Y) versus the midterm score (X). Based on the visual evidence, would you say that the scores for the two exams are strongly related? Is the relationship a linear one?

b. Superimpose a trend line on the scatter plot, and use the option to display the equation and the R2 value. What does this equation indicate in terms of predicting a student’s final exam score from his or her midterm score? Be specific.

c. Run a regression to confirm the trend-line equation from part b. What does the standard error of estimate say about the accuracy of the prediction requested in part b?

a. Create a scatter plot of the final exam score (Y) versus the midterm score (X). Based on the visual evidence, would you say that the scores for the two exams are strongly related? Is the relationship a linear one?

b. Superimpose a trend line on the scatter plot, and use the option to display the equation and the R2 value. What does this equation indicate in terms of predicting a student’s final exam score from his or her midterm score? Be specific.

c. Run a regression to confirm the trend-line equation from part b. What does the standard error of estimate say about the accuracy of the prediction requested in part b?

**View Solution:**## Answer to relevant Questions

A company produces electric motors for use in home appliances. One of the company’s production managers is interested in examining the relationship between inspection costs in a month (X) and the number of motors produced ...The file P10_08.xlsx contains data on the top 200 professional golfers in 2009. a. Create a new variable, Earnings per Round, and the ratio of Earnings to Rounds. Then create five scatter plots and corresponding ...If you haven’t already done Problem 6 on 2006–2007 movies, do it now. The scatter plots of Total US Gross versus 7-day Gross or 14-day Gross indicate some possible outliers at the right—the movies that did great during ...The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The entire data set appears in the file P10_23.xlsx.a. Estimate a ...Suppose that an operations manager is trying to determine the number of labor hours required to produce the ith unit of a certain product. Consider the data provided in the file P10_32.xlsx. For example, the second unit ...Post your question