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 using the COUNTIF$()$ command. 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.$