Acarauctionbusinesswantsamodelthatwillprovidetheprobabilitythataparticularmodel of BMW wagon will sell at auction. The covariates are the age of the wagon (inyears)andthecondition(goodoraverage)itisin.Theresponsevariableis:

Y=1 ifwagonwassoldatauction;

0 ifwagonwasnotsoldatauction.

Thecovariateare:X₁=ageofthewagon(inyears)

2

X =1 ifwagonisingoodcondition;

0 ifwagonisinaveragecondition.

Thedataforarandomsampleof20BMWwagonsareshownbelow

Wagon	1	2	3	4	5	6	7	8	9	10
Sold	1	0	0	0	0	1	1	0	1	0
Age(yrs)	1	3	8	6	5	2	4	5	3	2
Condition	Good	Good	Avge	Avge	Avge	Good	Avge	Avge	Good	Avge
Wagon	11	12	13	14	15	16	17	18	19	20
Sold	1	1	0	1	0	0	0	1	0	1
Age(yrs)	2	2	6	3	2	5	7	6	3	5
Condition	Good	Avge	Avge	Avge	Avge	Avge	Good	Good	Avge	Good

1. Use Excel to construct an appropriate binary logistic regression model todetermine the probability that a wagon sells at auction. Give reasons why it is a goodmodelorotherwise.
2. Use the model in (a) and Excel to estimate the probability that a 4-year-oldwagoningoodconditionwillsellatauction.

Kindly show excel aswell along with explanation. Thanks :)