I need help

QUESTION 1 In this exercise we examines the relationship between a worker's height and annual earnings in a sample of 500 individuals that you can download at this M. Open the le in Excel and estimate the following linear regression model: EARNINGS = beta0 + beta1 * HEIGHT + error where the unit of EARNINGS is dollars per year and the unit of HEIGHT is inches. Answer the following questions: What is the effect of increasing HEIGHT by 10 inches on annual earnings? Earnings change by dollars per year How much do you predict the annual earnings to be for a man that is 67 inches tall?|:|; and for a woman that is 77 inches tall? Is the variable HEIGHT statistically significant at 5%? (type YES or NO) Construct a 90% condence interval for the slope coefficient of HEIGHT: between and Calculate the test statistic for the null hypothesis H0: beta1 0: t = What is the p-value for the null hypothesis that H0: beta1 0? (if the pvalue is smaller than 001 type 0.00) Test the one-sided hypothesis that H0: beta1 0. The tstatistic in this case is and we (type REJECT or DO NOT REJECT) the null hypothesis H0