Hello, I am looking for some help on my econometrics homework. The information below is the homework and the attached spreadsheet contains the data set that is used. I would greatly appreciate help so that I can see how to solve each problem. Thank you.

Instructions: Please print out and complete the following assignment writing your answers clearly and showing your work directly on the assignment. Please keep a log of your work in STATA and print out and attach all of your results.

1. The data set footballcoach.xlsx contains data on football coaches and whether or not they were fired. The variable firedcoach is a dummy variable equal to 1 if the football coach was fired during or after the season and the variable winpct is the winning percentage of the coach?s team.

Estimate the linear probability model: firedcoach = f(winpct) in STATA. (Include your STATA work).

a. Report the values of the coefficient and pvalue for winpct: (4 points)

b. Let?s say a coach?s winning percentage increases by 0.10. In words, express what the beta coefficient for ?winpct? means for this change using the value estimated by STATA. (4 points)

c. In STATA, create a scatter for the observed data in this dataset and include the line of best fit. (Hint: See page 95 of the coursepack). (4 points)

d. What is the R² estimated from the linear probability model? (3 points)

e. Using the method shown in class, calculate R_p². (Show the work that you do in STATA) (5 points)

2. In this next model, replace winpct with wins (number of wins in the season). Now estimate the logit model: firedcoach = f(wins) in STATA. (Include your STATA work)

a. Report the values of the coefficient and pvalue for ?wins?: (4 points)

b. In words, express what the beta coefficient for ?wins? means using the ?rough estimate of 0.25? approach using the values estimated by STATA. (4 points)

FiredCoachWinPct wins 1 0.125 1 0.313 0 0.5 0 0.438 0 0.313 0 0.688 0 0.5 0 0.75 0 0.563 0 0.313 1 0.375 0 0.375 0 0.438 0 0.875 0 0.688 0 0.688 0 0.563 0 0.25 0 0.688 1 0.125 0 0.625 0 0.875 0 0.75 0 0.813 0 0.75 0 0.875 0 0.75 0 0.75 0 0.625 1 0.375 0 0.625 0 0.813 0 0.188 1 0.188 0 0.563 0 0.563 0 0.375 0 0.563 1 0.375 0 0.5 0 0.813 0 0.625 0 0.5 0 0.25 0 0.313 0 0.75 0 0.688 2 5 8 7 5 11 8 12 9 5 6 6 7 14 11 11 9 4 11 2 10 14 12 13 12 14 12 12 10 6 10 13 3 3 9 9 6 9 6 8 13 10 8 4 5 12 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0.438 0.813 0.813 0.5 0.5 0.5 0.438 0.75 0.625 0.375 0.563 0.5 0.5 0.375 0.125 0.438 0.313 0.25 0.375 0.5 0.688 0.563 0.563 0.25 0.625 0.25 0.625 0.375 0.563 0.625 0.563 0.5 0.75 0.563 0.063 0.188 0.438 0.375 0.438 0.438 0.688 0.063 0.375 0.563 0.25 0.625 0.563 0.688 7 13 13 8 8 8 7 12 10 6 9 8 8 6 2 7 5 4 6 8 11 9 9 4 10 4 10 6 9 10 9 8 12 9 1 3 7 6 7 7 11 1 6 9 4 10 9 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0.688 0.563 0.625 0.563 0.5 0.563 0.75 0.813 0.875 0.625 0.688 1 0.75 0.625 0.875 0.875 0.563 0.688 0.313 0.5 0.563 0.625 0.688 0.375 0.375 0.375 0.25 0.375 0.438 0.438 0.438 0.313 0.563 0.375 0.5 0.188 0.5 0.688 0.625 0.375 0.625 0.625 0.5 0.75 0.75 0.563 0.75 0.625 11 9 10 9 8 9 12 13 14 10 11 16 12 10 14 14 9 11 5 8 9 10 11 6 6 6 4 6 7 7 7 5 9 6 8 3 8 11 10 6 10 10 8 12 12 9 12 10 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0.5 0.688 0.938 0.375 0.656 0.813 0.563 0.375 0.438 0.688 0.625 0.688 0.313 0.25 0.313 0.313 0.25 0.625 0.25 0.375 0.25 0.313 0.563 0.438 0.188 0.125 0.625 0.75 0.75 0.563 0.688 0.313 0.813 0.375 0.563 0.625 0.438 0.625 0.75 0.5 0.375 0.406 0.25 0.625 0.563 0.25 0.625 0.281 8 11 15 6 10 13 9 6 7 11 10 11 5 4 5 5 4 10 4 6 4 5 9 7 3 2 10 12 12 9 11 5 13 6 9 10 7 10 12 8 6 6 4 10 9 4 10 4 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1 1 0 1 0 0 0 0 0 1 1 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0.438 0.5 0.688 0.5 0.5 0.125 0.375 0.25 0.25 0.188 0.438 0.5 0.438 0.25 0.5 0.5 0.313 0.313 0.25 0.125 0.25 0.313 0.25 0.688 0.625 0.75 0.5 0.5 0.25 0.438 0.5 0.813 0.5 0.25 0.5 0.5 0.438 0.563 0.813 0.625 0.625 0.563 0.5 0.688 0.375 0.875 0.75 0.813 7 8 11 8 8 2 6 4 4 3 7 8 7 4 8 8 5 5 4 2 4 5 4 11 10 12 8 8 4 7 8 13 8 4 8 8 7 9 13 10 10 9 8 11 6 14 12 13 0 1 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 1 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0.5 0.125 0.438 0.625 0.25 0.125 0.25 0.563 0.625 0.438 0.813 0.5 0.375 0.438 0.563 0.438 0.813 0.563 0.813 0.438 0.5 0.563 0.813 0.5 0.688 0.875 0.563 0.75 0.25 0.5 0.313 0.063 0.5 0.313 0.25 0.5 0.563 0.25 0.5 0.625 0.688 0.594 0.5 0.625 0.375 0.813 0.75 0.75 8 2 7 10 4 2 4 9 10 7 13 8 6 7 9 7 13 9 13 7 8 9 13 8 11 14 9 12 4 8 5 1 8 5 4 8 9 4 8 10 11 9 8 10 6 13 12 12 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0 0 0.688 0.688 0.313 0.188 0.406 0.625 0.625 0.563 0.563 0.625 0.5 0.75 0.625 0.5 0.688 0.375 0.25 0.625 0.438 0.75 0.438 0.5 0.656 0.375 0.313 0.625 0.313 0.375 0.25 0.5 0.563 0.313 0.625 0.375 0.313 0.438 0.5 0.5 0.625 0.375 0.531 0.563 0.375 0.5 0.5 0.375 0.688 0.563 11 11 5 3 6 10 10 9 9 10 8 12 10 8 11 6 4 10 7 12 7 8 10 6 5 10 5 6 4 8 9 5 10 6 5 7 8 8 10 6 8 9 6 8 8 6 11 9 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0.813 0.563 0.563 0.375 0.625 0.313 0.313 0.313 0.5 0.625 0.375 0.625 0.75 0.688 0.938 0.625 0.688 0.375 0.813 0.5 0.25 0.625 0.625 0.75 0.75 0.563 0.5 0.688 0.813 0.813 0.688 0.625 0.188 0.375 0.75 0.625 0.5 0.375 0.563 0.5 0.563 0.375 0.313 0.688 0.625 0.938 0.563 0.563 13 9 9 6 10 5 5 5 8 10 6 10 12 11 15 10 11 6 13 8 4 10 10 12 12 9 8 11 13 13 11 10 3 6 12 10 8 6 9 8 9 6 5 11 10 15 9 9 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 1 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0.5 0.625 0.5 0.688 0.438 0.563 0.438 0.813 0.688 0.313 0.438 0.25 0.813 0.313 0.375 0.25 0.25 0.438 0.563 0.25 0.625 0.375 0.125 0 0.438 0.188 0.313 0.375 0.313 0.188 0.125 0.563 0.5 0.313 0.563 0.313 0.625 0.438 0.25 0.625 0.188 0.563 0.563 0.25 0.688 0.313 0.438 0.75 8 10 8 11 7 9 7 13 11 5 7 4 13 5 6 4 4 7 9 4 10 6 2 0 7 3 5 6 5 3 2 9 8 5 9 5 10 7 4 10 3 9 9 4 11 5 7 12 1 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0.563 0.625 0.688 0.5 0.625 0.375 0.438 0.813 0.625 0.813 0.563 0.688 0.25 0.438 0.5 0.688 0.313 0.594 0.438 0.25 0.313 0.875 0.438 0.188 0.563 0.438 0.813 0.688 0.813 0.5 0.438 0.625 0.188 0.5 0.5 0.563 0.438 0.625 0.188 0.375 0.375 0.188 0.438 0.438 0.375 0.125 0.5 0.75 9 10 11 8 10 6 7 13 10 13 9 11 4 7 8 11 5 9 7 4 5 14 7 3 9 7 13 11 13 8 7 10 3 8 8 9 7 10 3 6 6 3 7 7 6 2 8 12 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 1 0 0 0 1 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0.438 0.5 0.688 0.438 0.688 0.438 0.063 0.438 0.5 0.25 0.438 0.75 0.438 0.719 0.813 0.375 0.5 0.438 0.313 0.438 0.25 0.125 0.438 0.625 0.75 0.375 0.25 0.75 0.813 0.75 0.688 0.469 0.125 0.438 0.063 0.125 0.188 0.5 0.375 0.5 0.75 0.438 0.875 0.625 0.813 0.25 0.313 0.375 7 8 11 7 11 7 1 7 8 4 7 12 7 11 13 6 8 7 5 7 4 2 7 10 12 6 4 12 13 12 11 7 2 7 1 2 3 8 6 8 12 7 14 10 13 4 5 6 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 1 0.438 0.688 0.438 0.438 0.313 0.25 0.625 0.563 0.813 0.563 0.625 0.438 0.563 0.375 0.563 0.5 0.5 0.438 0.5 0.313 0.5 0.313 0.625 0.563 0.5 0.313 0.313 0.375 0.25 0.313 0.438 0.188 0.375 0.563 0.25 0.438 0.25 7 11 7 7 5 4 10 9 13 9 10 7 9 6 9 8 8 7 8 5 8 5 10 9 8 5 5 6 4 5 7 3 6 9 4 7 4 Hi. I'm glad to work on your question and will be done soon. May I request that you kindly send me the attached files to econstatsguru(at)gmail(dot)com. I am having trouble downloading the files from course hero and I need them saved on my computer so that I can work more efficiently. Thanks. Hi. I'm glad to work on your question and will be done soon. May I request that you kindly send me the attached files to econstatsguru(at)gmail(dot)com. I am having trouble downloading the files from course hero and I need them saved on my computer so that I can work more efficiently. Thanks