Question

In: Statistics and Probability

Develop the best logistic regression model that can predict the wage by using the combination of...

Develop the best logistic regression model that can predict the wage by using the
combination of any following variables: total unit (X2), constructed unit (X3), equipment
used (X4), city location (X5) and total cost of a project (X6). Make sure that you partition
your data with 60% training test, 40% validation test, and default seed of 12345 before
running the logistic regression (15 points)

Wage - X1 Total Unit - X2 Contracted Units - X3 Equipment Used - X4 City Location - X5 Total Cost - X6
0 50 5 2 1 83680
1 25 2 3 1 73604
0 55 1 2 1 101562
0 68 3 2 1 91055
1 35 3 2 1 41790
0 24 2 2 1 75770
1 12 2 4 1 37420
0 20 1 2 1 58000
1 48 2 2 1 97800
0 36 2 3 1 73960
0 40 1 2 1 98720
1 39 4 2 1 54190
0 26 1 1 1 67800
1 25 1 4 1 66760
0 70 3 3 2 88055

Solutions

Expert Solution

The attach images details solution solved in R-software given below.

Output:

1.

2

2.

3.

4.

The model is not well fitted because all the explonatory variables are insignificant at 5% of level of significance. i.e(p-value > alpha value)


Related Solutions

One can use a fitted logistic regression model to predict the probability/odd of an interest of...
One can use a fitted logistic regression model to predict the probability/odd of an interest of choice represented by an dependent variable given a set of the values of the independent variables in the model. True or False
1.Develop a multiple linear regression model to predict the price of a house using the square...
1.Develop a multiple linear regression model to predict the price of a house using the square feet of living area, number of bedrooms, and number of bathrooms as the predictor variables     Write the reqression equation.      Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence. Discuss the statistical significance of the coefficient for each independent variable using the appropriate regression statistics at a 95% level of confidence....
A multivariate logistic regression model has been built to predict the propensity of shoppers to perform...
A multivariate logistic regression model has been built to predict the propensity of shoppers to perform a repeat purchase of a free gift that they are given. The descriptive features used by the model are the age of the customer, the socio-economic band to which the customer belongs (a, b, or c), the average amount of money the customer spends on each visit to the shop, and the average number of visits the customer makes to the shop per week....
define the logistic regression model.
define the logistic regression model.
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel Births 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel(y) Births(x) 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below: Sales (units) Price ($) Advertising ($) Holiday 500 100 50 Yes 480 120 40 Yes 485 110 45 No 510 103 55 Yes 490 108 40 No 488 109 30 No 496 106 45 Yes Compile a spreadsheet for the data and determine the predicted number of units sold if the watch is sold...
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below: Sales (units) Price ($) Advertising ($) Holiday 500 100 50 Yes 480 120 40 Yes 485 110 45 No 510 103 55 Yes 490 108 40 No 488 109 30 No 496 106 45 Yes Compile an excel spreadsheet for the above data and determine the regression equation Answer (a) X3 = 1 if...
A university would like to develop a regression model to predict the point differential for games...
A university would like to develop a regression model to predict the point differential for games played by its men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win for the university's team and a negative differential is a loss. For a random sample of games, the point differential (y) was calculated, along with the number of assists (x1), rebounds (x2), turnovers (x3) and personal fouls...
A business statistics professor at a college would like to develop a regression model to predict...
A business statistics professor at a college would like to develop a regression model to predict the final exam scores for students based on their current GPAs, the number of hours they studied for the exam, the number of times they were absent during the semester, and their genders. Use the accompanying data to complete parts a through c below. Score   GPA   Hours   Absences   Gender 68   2.55   3.00   0   0 69   2.22   4.00   3   0 70   2.60   2.50   1   0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT