Suburban dummy variable is $0\mathrm{.}775.$ What is the proper interpretation?

$($a$)$

$77\mathrm{.}5\%$ of the variance in DieselConsumption is explained by RouteType $=$ Suburban.

$($b$)$

RouteLength explains $22\mathrm{.}5\%$ of the variance in DieselConsumption.

$($c$)$

Suburban cannot be used as a dummy variable in a regression model.

$($d$)$

If a vehicle takes a RouteType $=$ Suburban, then DieselConsumption is predicted to increase by $0\mathrm{.}775$ gallons as compared to the base RouteType.

$($e$)$

The correlation between DieselConsumpion and RouteType is $0\mathrm{.}775.$

If you have the variable RouteType $($with values of CityCenter, Suburban, SmallTown, Rural, and Mixed$)$ in column A in Excel, what is the correct Excel formula to create the dummy variable for Suburban in column B$.$ The formula is for the first cell $($B$2),$ but can be copied down to create the dummy variable.

$($a$)$

$=$A$2^2$

$($b$)$

$=$DUMMY$($A$2)$

$($c$)$

$=$CHOOSE$($A$2,0,1)$

$($d$)$

$=$IF$($A$2=$"Suburban", $1,0)$

$($e$)$

$=$IF$($A$2=$"Suburban", $0,1)$