Problem $2$:

The following data give the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade$-$point average $($GPA$),$ and major $($business or other$)$ are provided.

SALARY: $$29,500,$$$46,000,$ $$39,800,$ $$36,500,$$$42,000,$ $$31,500,$ $$36,200$

GPA : $3\mathrm{.}1,3\mathrm{.}5,3\mathrm{.}8,2\mathrm{.}9,3\mathrm{.}4,2\mathrm{.}1,2\mathrm{.}5$

Major : Other $,$Business $,$Business $,$Other $,$Business $,$Other $,$Business

Using excel, develop a regression model that could be used to predict starting salary based on GPA and major. Answer the questions below.

Question $8$

The dependent variable is:

Group of answer choices

Salary

GPA

Major

Question $9$

The sample intercept:

Question $10$

The coefficient of GPA:

Question $11$

The coefficient of the Major:

Question $12$ : Using this model the starting salary for a business major with a GPA of $3\mathrm{.}0$ is:

Question $13$

The starting salary for business majors tends to be about $$\_\_\_\_\_\_\_\_\_$ higher than non$-$business majors in this sample, even after adjusting for variations in GPA.

Question $14$

The coefficient of determination :

Question $15$

The model is useful in predicting starting salary. And the model is significant at the $0\mathrm{.}10$ level, and $69\%$ of the variability in starting salary is explained by GPA and major.

Group of answer choices

True

False