----- Need Detailed functions for the given screenshot please -----
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
File Home Insert Page Layout Formulas Data Review View Help Share Comme Calibri AA 11 HI General PA Normal Bad Good Neutral AY X Cut LECopy Format Painter 3 == ab Wrap Text Es Merge & Center AutoSum Fill Clear
Paste BIU $ %, -20 Check Cell Explanatory... Input Insert Delete Format Conditional Format as Calculation Formatting Table Ideas Sensitivity Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity L6 X C G H K L M N 0 P 0 R S T B D E F 1 VIN Search 2 69716460 Arrival Date Raffle Eligi Special Notes 6/18/2017 3 Search Criteria Arrival Date VIN # Color GPS MSRP Days on Lot Special Notes Year Type 2018 Sedan Yes 4 5 Summary Data Count Min MSRP Max MSRP Ave Days on Lot 6 7 8 Average Days On Lot Color:Red w/GPS 9 Overall Combined 10 11 12 Gray GPS 13 14 GPS 15 16 17 18 19 Yes Yes Yes Yes Yes Yes 20 21 22 23 24 25 26 27 28 Year Type Color 2018 Sedan Red 2017 Coupe Red 2017 Coupe White 2017 Truck White 2018 SUV 2018 Coupe Blue 2018 SUV White 2017 Sedan Red 2018 Van Red 2018 Sedan Black 2017 Truck Black 2018 Van Black 2018 Sedan Red 2017 Truck White 2017 SUV Blue 2017 Van White 2017 Truck Red 2018 Truck Black 2017 SUV Black 2018 Sedan 2018 Coupe Red 2018 Van Gray 2017 SUV Blue 2017 Sedan White 2018 Van Black 2017 Van Black 2018 Coupe Red 2018 Truck Gray 2018 Sedan Black 2018 Coupe White 2017 Sedan Gray 2018 Sedan Red Inventory Loan GPS Yes NO No No Yes No No Yes Yes Yes Yes No No No No No No No Yes No Yes Yes No No Yes NO Yes Yes Yes No Yes NO Inventory Arrival Date 6/18/2017 11/16/2017 12/23/2017 10/9/2017 9/4/2017 3/15/2017 2/20/2017 2/8/2017 7/15/2017 1/21/2017 10/3/2017 8/25/2017 8/7/2017 12/10/2017 4/4/2017 5/24/2017 8/21/2017 3/4/2017 7/25/2017 1/20/2017 6/14/2017 9/16/2017 7/23/2017 4/18/2017 6/17/2017 2/13/2017 2/27/2017 1/1/2017 8/27/2017 7/4/2017 12/20/2017 5/16/2017 MSRP Days on Lot Special Notes $ 24,989 197 Raffle Eligible $ 35,903 46 $ 23,623 9 $ 22,848 84) $ 19,841 119 S 24,463 292 Bonus Eligible $ 30,946 315 Bonus Eligible $ 19,918 327 Bonus Eligible $ 34,718 170 Raffle Eligible $ 17,511 345 Bonus Eligible $ 24,452 901 $ 37,516 129 Raffle Eligible $ 33,695 147 Raffle Eligible $ 26,057 22 $ 26,534 272 Bonus Eligible $ 31,193 222 Bonus Eligible $ 21,916 133 Raffle Eligible $ 17,702 303 Bonus Eligible $ 35,004 160 Raffle Eligible $ 26,548 346 Bonus Eligible $ 33,197 201 Bonus Eligible $ 31,443 107 $ 28,285 162 Raffle Eligible $ 26,751 258 Bonus Eligible $ 38,433 198 Raffle Eligible $ 20,257 322 Bonus Eligible $ 31,604 308 Bonus Eligible $ 31,686 365 Bonus Eligible $ 27,818 127 Raffle Eligible $ 26,781 181 Raffle Eligible $ 21,504 12 $ 38,427 230 Bonus Eligible VIN # VIN # 69716460 24948740 51210965 55320488 25856260 120408951 63178024 17516090 96152231 23686693 44261695 947581561 48675320 96934792 Year Type Year Type 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan Yes Color Color Red Black Black Blue Black Gray Gray Black Blue White Red Gray Black Red Search Results Arrival Date Arrival Date 6/18/2017 1/21/2017 8/27/2017 5/12/2017 11/5/2017 |5/18/2017 3/7/2017 7/15/2017 7/3/2017 2/17/2017 1/23/2017 3/7/2017 6/17/2017 2/3/2017 MSRP MSRP 24,989 17,511 27,818 21,929 24,985 37,251 37,141 29,530 38,807 36,340 24,559 35,272 37,195 30,544 $ $ $ $ $ $ $ $ $ $ $ $ $ $ Days on Lot Special Notes Days on Lot Special Notes 197 Raffle Eligible 345 Bonus Eligible 127 Raffle Eligible 234 Bonus Eligible 57 228 Bonus Eligible 300 Bonus Eligible 170 Raffle Eligible 182 Raffle Eligible 318 Bonus Eligible 343 Bonus Eligible 300 Bonus Eligible 198 Raffle Eligible 332 Bonus Eligible Yes Yes Yes Yes Black Yes Yes Yes 29 30 31 32 33 34 35 36 37 38 Activate Windows Go to Settings to activate Windows + @ File Home Insert Page Layout Formulas Data Review View Help Share Comme Calibri AA 11 HI General PA Normal Bad Good Neutral AY X Cut LECopy Format Painter 3 == ab Wrap Text Es Merge & Center AutoSum Fill Clear Paste BIU $ %, -20 Check Cell Explanatory... Input Insert Delete Format Conditional Format as Calculation Formatting Table Ideas Sensitivity Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity L6 X C G H K L M N 0 P 0 R S T B D E F 1 VIN Search 2 69716460 Arrival Date Raffle Eligi Special Notes 6/18/2017 3 Search Criteria Arrival Date VIN # Color GPS MSRP Days on Lot Special Notes Year Type 2018 Sedan Yes 4 5 Summary Data Count Min MSRP Max MSRP Ave Days on Lot 6 7 8 Average Days On Lot Color:Red w/GPS 9 Overall Combined 10 11 12 Gray GPS 13 14 GPS 15 16 17 18 19 Yes Yes Yes Yes Yes Yes 20 21 22 23 24 25 26 27 28 Year Type Color 2018 Sedan Red 2017 Coupe Red 2017 Coupe White 2017 Truck White 2018 SUV 2018 Coupe Blue 2018 SUV White 2017 Sedan Red 2018 Van Red 2018 Sedan Black 2017 Truck Black 2018 Van Black 2018 Sedan Red 2017 Truck White 2017 SUV Blue 2017 Van White 2017 Truck Red 2018 Truck Black 2017 SUV Black 2018 Sedan 2018 Coupe Red 2018 Van Gray 2017 SUV Blue 2017 Sedan White 2018 Van Black 2017 Van Black 2018 Coupe Red 2018 Truck Gray 2018 Sedan Black 2018 Coupe White 2017 Sedan Gray 2018 Sedan Red Inventory Loan GPS Yes NO No No Yes No No Yes Yes Yes Yes No No No No No No No Yes No Yes Yes No No Yes NO Yes Yes Yes No Yes NO Inventory Arrival Date 6/18/2017 11/16/2017 12/23/2017 10/9/2017 9/4/2017 3/15/2017 2/20/2017 2/8/2017 7/15/2017 1/21/2017 10/3/2017 8/25/2017 8/7/2017 12/10/2017 4/4/2017 5/24/2017 8/21/2017 3/4/2017 7/25/2017 1/20/2017 6/14/2017 9/16/2017 7/23/2017 4/18/2017 6/17/2017 2/13/2017 2/27/2017 1/1/2017 8/27/2017 7/4/2017 12/20/2017 5/16/2017 MSRP Days on Lot Special Notes $ 24,989 197 Raffle Eligible $ 35,903 46 $ 23,623 9 $ 22,848 84) $ 19,841 119 S 24,463 292 Bonus Eligible $ 30,946 315 Bonus Eligible $ 19,918 327 Bonus Eligible $ 34,718 170 Raffle Eligible $ 17,511 345 Bonus Eligible $ 24,452 901 $ 37,516 129 Raffle Eligible $ 33,695 147 Raffle Eligible $ 26,057 22 $ 26,534 272 Bonus Eligible $ 31,193 222 Bonus Eligible $ 21,916 133 Raffle Eligible $ 17,702 303 Bonus Eligible $ 35,004 160 Raffle Eligible $ 26,548 346 Bonus Eligible $ 33,197 201 Bonus Eligible $ 31,443 107 $ 28,285 162 Raffle Eligible $ 26,751 258 Bonus Eligible $ 38,433 198 Raffle Eligible $ 20,257 322 Bonus Eligible $ 31,604 308 Bonus Eligible $ 31,686 365 Bonus Eligible $ 27,818 127 Raffle Eligible $ 26,781 181 Raffle Eligible $ 21,504 12 $ 38,427 230 Bonus Eligible VIN # VIN # 69716460 24948740 51210965 55320488 25856260 120408951 63178024 17516090 96152231 23686693 44261695 947581561 48675320 96934792 Year Type Year Type 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan Yes Color Color Red Black Black Blue Black Gray Gray Black Blue White Red Gray Black Red Search Results Arrival Date Arrival Date 6/18/2017 1/21/2017 8/27/2017 5/12/2017 11/5/2017 |5/18/2017 3/7/2017 7/15/2017 7/3/2017 2/17/2017 1/23/2017 3/7/2017 6/17/2017 2/3/2017 MSRP MSRP 24,989 17,511 27,818 21,929 24,985 37,251 37,141 29,530 38,807 36,340 24,559 35,272 37,195 30,544 $ $ $ $ $ $ $ $ $ $ $ $ $ $ Days on Lot Special Notes Days on Lot Special Notes 197 Raffle Eligible 345 Bonus Eligible 127 Raffle Eligible 234 Bonus Eligible 57 228 Bonus Eligible 300 Bonus Eligible 170 Raffle Eligible 182 Raffle Eligible 318 Bonus Eligible 343 Bonus Eligible 300 Bonus Eligible 198 Raffle Eligible 332 Bonus Eligible Yes Yes Yes Yes Black Yes Yes Yes 29 30 31 32 33 34 35 36 37 38 Activate Windows Go to Settings to activate Windows + @
