Question

Jeff want to build a model to predict the relationship between graduate GPA and first job salary. He collected data below. Jeff want to use the regression model GPA (x) Annual Salary y xy X*x 2.8 19,815 55,482.00 7.84 3.4 23,037 78,325.80 11.56 3.2 21,963 70,281.60 10.24 3.8 25,185 95,703.00 14.44 3.2 22,396 71,667.20 10.24 3.4 24,388 82,919.20 11.56 Sum 19.8 136,784.00 454,378.80 65.88 Q27. What is the approximate intercept b0? Find the closest

Answer 1

Answer:

Approximate intercept is  4,515.33  

Step-by-step explanation:

The intercept of the GPA grades and the first job salary can be determined by using the intercept function in excel spreadsheet.

In order to ascertain the intercept,we apply the intercept formula:

=intercept(known values of y,known values of x)

known values of y are the dependent variables.The first annual salary in this scenario is dependent upon the GPA of the graduate in question

Known values of x are the independent variables upon which the dependent ones rely for their values i.e the GPA itself

As found in the attached,the intercept is  4,515.33  

Download xlsx