You need to calculate the Average Days on Lot based

You need to calculate the Average Days on Lot based on MSRP and/or Types using the Inventory data. n. Enter functions into the Average Days on Lot chart area that calculate the following:

• Insert a function in K10 that display the Average Days on Lot of all Types

• Insert a function in L10 that display the Average Days on Lot of all Types that have a color of Red

• Insert a function in M10 that displays the Average Days on Lot of all Types that have a GPS

• Insert a function in N10 that displays the Average Days on Lot of all Types that have a MSRP that is higher than 20000 and have a Color of White.