Q$1.$ Excel Pivot Tables $(20$pt$)$

Daisy's Delicious Donuts is a Las Cruces breakfast and pastry shop. Daisy is working on her Excel and wants you create a dashboard based on a spreadsheet she generates based on daily sales of her donuts. The excel spreadsheet is attached to this test file.

What are the categorical variables in the data?

$q,$

What are the numerical $/$ continuous variables in the data spreadsheet?

What variable doesn't give much information and can be removed? Why?

Leact favorte flavor, ity$-$the same all the way.

Create a pivot table that organizes the data by variety first and most popular second. Place values data by sum of sales first, and average unsold donuts second. Paste your pivot table below.

$(20$pts$)$ Rocket $($my other Australian Shepherd$)$ wants to buy a doghouse using a mortgage for pets. Create a contingency table for a house with a purchase price of $$3000$ with a loan time of five years. Rocket wants to know what happens to the monthly payment when you change the interest rate from $3\%$ to $5\%$ by increments of $0\mathrm{.}5\%.$ On the other axis, he wants to know how the monthly payment changes when going from $$0$ down to $$500$ down payment in increments of $$100.$ Paste the contingency table below.