You need to calculate the Average Days on Lot based on MSRP and/or Types using the...

 

 

Transcribed Image Text:

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