Many college students have compact refrigerator$-$freezers in their dorm rooms. The data set provided is a partial list of energy$-$efficient models less than $3\mathrm{.}6$ cubic feet $[$cft$].$ Complete the following analysis.

We would like to compute the cost to run each model for a year. Assume that it costs $$0\mathrm{.}106$ per kilowatt$-$hour $[$kWh$].$ Create a new column, "Annual Energy Cost $[$$$/$year$),$ that calculates the annual energy cost for each refrigerator.

In Excel:

a$.$ Sort the first table by energy usage, with the model with the highest kilowatt$-$hour rating listed first. Which model appears first?

b$.$ Sort by the volume in ascending order and the annual energy cost in ascending order. Which model appears first?

c$.$ Assume we want to restrict our selection to refrigerators that can contain more than $2\mathrm{.}0$ cubic feet. Which models appear in the list?

d$.$ Assume we want to restrict our selection to refrigerators that can contain more than $2\mathrm{.}0$ cubic feet and only require between $0$ and $300$ kilowatt$-$hours per year. Which models appear in the list?