assignment 4 week 5 1
Assignments must be completed on MindTap AND a completed workbook with your full completed solutions must be submitted via Sakai. You must submit both in order to receive any credit.
Hardcopies or copies emailed will not be graded.
There is no option for late submissions in MindTap. Failure to submit your submit your assignment on MindTap before the due date will result in zero credit.
Submit your worked data in one single MS Excel Workbook. Start your solution set by using the assignment shell provided on Sakai. Use appropriately labeled worksheets for each problem/section of a problem.
Pay very close attention to the final presentation of your work and make sure it is print-ready. Prepare all spreadsheets so that they are clear, attractive and easy for the untrained eye to follow and understand. While accurate content and precise execution of the techniques is critical, formatting, typographical and grammatical acuteness is also very important. General sloppiness and inconsistent formatting will lower your grade.
Note: Ignore MindTap warning about text-based answers. All open ended questions will be graded as well. In fact, your grade will depend equally on the accuracy of your analytical techniques and your interpretation of the results.
Assignment files should be named as follows:
- e.g. Assignment 1 for Michael Phelps would be named Asg1_MPhelps.xlsx
Question 1. 50 points
The data contain 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 scatterplot 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 scatterplot.
Find the trend line equation by using the option to display the equation. Let X represent the midterm.
Find the R2 value by using the option to display the R2value.
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. Let X represent the midterm.
What does the standard error of estimate say about the accuracy of the prediction requested in Part B?
Question 2. 50 points
The data is for the 50 top graduate programs in the United States, according to a recent U.S. News & World Report survey. Columns B, C, and D contain ratings: an overall rating, a rating by peer schools, and a rating by recruiters. The other columns contain data that might be related to these ratings.
A.Find a table of correlations between all of the numerical variables.
From these correlations, which variables in columns Eâ€“L are most highly correlated with the various ratings?
B.For the Overall rating, run (four separate) simple regressions using it as the dependent variable and GMAT, Accept Rate, Salary, and Enrollment as independent variables.
Interpret these equations.
Could you have guessed the value of R2 before running the regression?
What does the standard error of estimate indicate?
C.Repeat Part B with the Peers rating as the dependent variable.
D.Repeat Part B again with the Recruiters rating as the dependent variable.
E.Discuss any differences among the three sets of regressions.