Please step-by-step explain how to solve the question using data analysis in excel.

I could not attach all of the data so please explain what needs to be done. The question is the first photo and the data is the second photo.

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; 0 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=B0+B1FTUG+B2FTGR+B3FTEF+B4CF+B5FTST+B6PRIVATE+& bo= b1 = b2= b3= b4= b5= b6= Home Insert Draw Page Layout Formulas Data Queries & Connections = -ra Properties Get Data (Power Refresh Organization Data from Picture Query) All Edit Links N14 + X fx A B C D E F G H I 1 INSTNM YEAR FTUG 2245 14.456 2 Claremont 1989 FTGR FTEF 0.355 0.458 FTST PRIVATE 0.052 0.964 4.148 12.223 1 3 Claremont 1991 77935 0.457 19.98 9.769 0 1 4 Claremont 1999 37933 0 0.533 1.91 1 6.881 0 0.466 5 Claremont 2002 2623 15.52 1.656 0.386 1 2005 25506 4.925 1 0 1987 44290 14.49 1.004 4.471 10.738 1 6.148 15.058 1 1 1 1 6.759 1 3.151 11.243 1 1.156 6.105 1 0.884 9.596 1 6 Claremont 1.639 4.962 7 University: 3.161 8.939 8 University: 1991 57742 13.991 6.005 11.24 9 University 1999 56613 14.705 5.439 10.185 4.758 13.661 10 University 2002 103321 3.806 10.843 18.994 8.517 25.355 11 University 2005 59024 16.072 12.751 11.199 5.085 12.84 12 University 1987 28631 2.68 1.114 7.158 1.375 13 University 1989 55450 0 1.437 13.441 14 University 1991 26413 2.725 2.395 6.648 15 University 1999 27880 3.209 1.836 5.773 16 University 2002 68245 2.839 12.497 4.67 25.016 17 University 2005 33533 3.139 7.877 1.41 9.187 18 Yale Univer 1987 92957 3.981 18.407 11.354 17.473 1989 20.863 1991 5.465 21.809 1999 132960 4.31 25.655 17.475 27.538 2002 151039 5.274 5.905 27.471 18,462 32.884 2005 174784 5.35 5.926 24.844 11.347 31.694 2.844 0.966 2.98 0.949 1 0 4.431 5.165 1 1 107866 5.185 4.063 12.961 1 19.51 14.16 21.148 105493 5.183 1 19 Yale Univer 20 Yale Univer 21 Yale Univer 22 Yale Univer 23 Yale Univer 5.413 1 1 1 24 Catholic Ur 1987 25630 7.935 1 1989 29976 5.544 1 1 25 Catholic Ur 26 Catholic Ur 27 Catholic Ur 28 Catholic Ur 1991 27702 2.681 1999 33752 2.335 2002 8.605 1.009 8.99 0.814 1.676 9.692 0.455 5.243 0.716 10.287 0.667 8.581 1.363 10.194 0.353 12.555 1.41 9.334 0.36 9.874 2.515 8.802 3.336 1 35488 2.467 1 29 Catholic Un 2005 35607 2.802 1 30 George Wa 1987 52713 6.026 15.26 1 1 TC CF | Review View Analytic Solver > Stocks J K Data Mining 24 Y A Sort Filter L M Acrobat Clear Reapply Advanced 0 N Tell me Text to = Columns P Q A THE What-If Analysis R S Group ZE Ungroup Subtotal T Share +3 3 U Comments Analysis Tools Data Analysis 2, Solver V W