Transcribed image text: Refer to the CollegeCost dataset. In this question, we explore some of the factors predicting costs at American universities. Let TC = Real ($2008) total cost per student FTUG = Number of full-time undergraduate students (in 1000s) FTGR = Number of full-time graduate students (in 1000s) FTEF = Number of full-time faculty per 100 students CF = Number of contract faculty per 100 students FTST = Number of full-time nonacademic staff per 100 students PRIVATE; = 1 if i is a private school; O if i is a public school. Estimate the linear regression of TC on the above variables and report the estimated coefficients, use the output from Excel with 2 decimals or 4 decimals for very small numbers (example: 653.47 or 0.0345), this is Model 1 Yhat = Bo+B1FTUG+B2FTGR+B3FTEF+B4CF+B5FTST+B6PRIVATE+E bo= b1= b2= b3= b4= b5= b6= QUESTION 11 How many variables (slope coefficients) were statistically significant in this model (Model1)? QUESTION 12 What is the predicted effect of an increase in graduate students on total cost per student (TC) in dollars? Use the original scale of the the variables to answer this question. Increase or decrease Effect in dollars QUESTION 13 Report what percentage of the variation in TC = Real total cost per student is explained by the model (R-squared). Report the value with 4 decimals and in the format found in the regression output (for example 0.3456). Transcribed image text: Refer to the CollegeCost dataset. In this question, we explore some of the factors predicting costs at American universities. Let TC = Real ($2008) total cost per student FTUG = Number of full-time undergraduate students (in 1000s) FTGR = Number of full-time graduate students (in 1000s) FTEF = Number of full-time faculty per 100 students CF = Number of contract faculty per 100 students FTST = Number of full-time nonacademic staff per 100 students PRIVATE; = 1 if i is a private school; O if i is a public school. Estimate the linear regression of TC on the above variables and report the estimated coefficients, use the output from Excel with 2 decimals or 4 decimals for very small numbers (example: 653.47 or 0.0345), this is Model 1 Yhat = Bo+B1FTUG+B2FTGR+B3FTEF+B4CF+B5FTST+B6PRIVATE+E bo= b1= b2= b3= b4= b5= b6= QUESTION 11 How many variables (slope coefficients) were statistically significant in this model (Model1)? QUESTION 12 What is the predicted effect of an increase in graduate students on total cost per student (TC) in dollars? Use the original scale of the the variables to answer this question. Increase or decrease Effect in dollars QUESTION 13 Report what percentage of the variation in TC = Real total cost per student is explained by the model (R-squared). Report the value with 4 decimals and in the format found in the regression output (for example 0.3456)