Question: can you please add what options to select on excel? i am not familiar with excel and need help navigating to get the answers 1.


1. Develop a simple linear regression equation for starting salaries using an independent variable that has the closest relationship with the salaries. Explain how you chose this variable. (5+5=10 points) 2. Present the simple lincar regression equation. identify and explain the coefficient of determination, intercept and regression coefficient, and significance of F-test. Based on this analysis, is your regression equation "good for use"? Explain. (2+2+2+2+2=10 points) 3. Provide a numeric example of how this regression cquation may be used to predict students' starting salaries. ( 5 points) 4. Develop a multiple regression equation for starting salaries using School Ranking, GPA, and Experience as independent variables, Is this regression equation "good for use"? Explain. (7+3=10 points) 5. If the multiple regression equation in the previous question is not "good for use", how would you suggest improving this multiple regression equation? Present the improved multiple regression equation. Give a numeric example of how this improved multiple regression equation may be used to predict students' starting salarics. (5+5+5=15 points) \begin{tabular}{|c|c|c|c|c|c|} \hline 1 & Student & School_Ranking & GPA & Experience & Salary \\ \hline 2 & 1 & 78 & 2.92 & 3 & 73,590 \\ \hline 3 & 2 & 56 & 3.84 & 9 & 87,000 \\ \hline 4 & 3 & 23 & 3.04 & 6 & 76,970 \\ \hline 5 & 4 & 67 & 3.20 & 6 & 79,320 \\ \hline 6 & 5 & 56 & 3.61 & 7 & 79,530 \\ \hline 7 & 6 & 78 & 2.99 & 5 & 71,040 \\ \hline 8 & 7 & 68 & 3.78 & 8 & 82,050 \\ \hline 9 & 8 & 89 & 3.20 & 5 & 78,890 \\ \hline 10 & 9 & 37 & 3.42 & 7 & 82,170 \\ \hline 11 & 10 & 67 & 3.05 & 5 & 76,120 \\ \hline 12 & 11 & 48 & 3.12 & 4 & 77,500 \\ \hline 13 & 12 & 78 & 3.56 & 7 & 83,920 \\ \hline 14 & 13 & 56 & 3.01 & 5 & 71,800 \\ \hline 15 & 14 & 25 & 3.15 & 6 & 77,000 \\ \hline 16 & 15 & 68 & 3.05 & 7 & 79,000 \\ \hline 17 & 16 & 36 & 3.24 & 5 & 77,800 \\ \hline 18 & 17 & 76 & 3.25 & 6 & 80,600 \\ \hline 19 & 18 & 78 & 3.78 & 9 & 87,000 \\ \hline 20 & 19 & 67 & 3.12 & 4 & 78,450 \\ \hline 21 & 20 & 67 & 3.24 & 8 & 80,600 \\ \hline 22 & 21 & 15 & 2.98 & 5 & 74,900 \\ \hline 23 & 22 & 29 & 3.24 & 6 & 79,200 \\ \hline 24 & 23 & 49 & 3.08 & 4 & 77,000 \\ \hline 25 & 24 & 67 & 3.00 & 6 & 77,900 \\ \hline 26 & 25 & 39 & 2.95 & 4 & 76,950 \\ \hline 27 & 26 & 81 & 3.01 & 5 & 76,800 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
