The dataset to the left provices a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed$-$and$-$breakfast inn during one month. Guests staying for seven days or more receive a $10\%$ discount.

a$.$ Create a new variable Length of Stay beginning in cell J$3$ that calculates the number of days the guests stayed.

b$.$ Create a new variable Discount beginning in cell K$3$ that is Yes if guests stayed seven days or longer and No otherwise.

c$.$ Count the number of Yes and No responses found in part b$.$ Type your answer in cells M$4$ and M$5.$

d$.$ Use the VLOOKUP function to find the room and room type that customers $5,12,$ and $19$ stayed in$.$ Type your answers in cells M$9$ through N$11.$