Question
Using excel, look at the data below and provide regression model, forecasting, and or decision analysis model (at least two)--focus is using vehicle appraisal details(choose
Using excel, look at the data below and provide regression model, forecasting, and or decision analysis model (at least two)--focus is using vehicle appraisal details(choose whatever variables you want and explain please) to predict the price point for thecar they will buy.
price | appraisal_offer | online_appraisal_flag | model_year | mileage | make | model | trim_descrip | body | color | engine | cylinders | mpg_city | mpg_highway | horsepower | fuel_capacity | model_year_appraisal | mileage_appraisal | make_appraisal | model_appraisal |
$20k to $25k | $0k to $5k | 1 | 2014.0 | 15k to 20k miles | HDT | HDT_12 | Premium | E | Red | 2.0L | 4 | 27 | 33 | 152 | 16 | 2001.0 | 200k+ miles | AIH | AIH_32 |
$15k to $20k | $0k to $5k | 0 | 2006.0 | 100k+ miles | KQZ | KQZ_23 | Premium | E | Silver | 3.5L | 6 | 19 | 27 | 285 | 18 | 1996.0 | 0 to 10k miles | KQZ | KQZ_3 |
$30k to $35k | $35k to $40k | 1 | 2014.0 | 5k to 10k miles | CZV | CZV_10 | Premium | E | Black | 2.5L | 4 | 24 | 30 | 187 | 15 | 2014.0 | 10k to 20k miles | CIP | CIP_16 |
$35k to $40k | $5k to $10k | 1 | 2014.0 | 15k to 20k miles | IZA | IZA_19 | Premium | F | Silver | 2.0L | 4 | 25 | 34 | 255 | 15 | 2006.0 | 100k to 110k miles | IZA | null |
$30k to $35k | $15k to $20k | 1 | 2011.0 | 35k to 40k miles | HDT | HDT_8 | Premium | F | Blue | 2.5L | 4 | 17 | 23 | 305 | 15 | 2011.0 | 20k to 30k miles | LTX | LTX_20 |
$15k to $20k | $5k to $10k | 0 | 2013.0 | 35k to 40k miles | OFW | OFW_11 | Not Premium | F | White | 2.4L | 4 | 25 | 35 | 185 | 18 | 2009.0 | 160k to 170k miles | FJE | FJE_10 |
$35k to $40k | $40k+ | 0 | 2013.0 | 20k to 25k miles | LTX | LTX_21 | Premium | B | Blue | 6.2L | 8 | 16 | 25 | 455 | 19 | 2012.0 | 30k to 40k miles | LTX | LTX_27 |
$15k to $20k | $5k to $10k | 0 | 2012.0 | 30k to 35k miles | LTX | LTX_30 | Not Premium | E | Black | 1.4L | 4 | 24 | 30 | 138 | 14 | 2010.0 | 80k to 90k miles | HXQ | HXQ_8 |
$30k to $35k | $20k to $25k | 0 | 2013.0 | 35k to 40k miles | FVQ | FVQ_4 | Premium | E | Black | 3.6L | 6 | 18 | 25 | 310 | 19 | 2010.0 | 60k to 70k miles | FVQ | FVQ_4 |
$20k to $25k | $0k to $5k | 0 | 2015.0 | 45k to 50k miles | ARU | ARU_4 | Not Premium | E | Gray | 2.5L | 4 | 26 | 33 | 170 | 14 | 2003.0 | 200k+ miles | CFK | CFK_8 |
$30k to $35k | $5k to $10k | 1 | 2014.0 | 15k to 20k miles | HXQ | HXQ_14 | Premium | F | Blue | 2.0L | 4 | 23 | 34 | 252 | 14 | 2002.0 | 110k to 120k miles | CIP | CIP_3 |
$45k to $50k | $0k to $5k | 0 | 2012.0 | 70k to 75k miles | BDP | BDP_11 | null | E | Burgundy | 6.2L | 8 | 15 | 20 | 420 | 31 | 2001.0 | 100k to 110k miles | JDZ | JDZ_101 |
$20k to $25k | $0k to $5k | 0 | 2014.0 | 20k to 25k miles | HXQ | HXQ_8 | Not Premium | F | Gray | 2.0L | 4 | 30 | 38 | 158 | 12 | 1998.0 | 70k to 80k miles | CIP | CIP_114 |
$20k to $25k | $0k to $5k | 0 | 2014.0 | 25k to 30k miles | CFK | CFK_10 | Premium | E | Black | 3.2L | 6 | 22 | 31 | 271 | 15 | 2008.0 | 110k to 120k miles | ARU | ARU_19 |
$20k to $25k | $10k to $15k | 1 | 2015.0 | 0 to 5k miles | ARU | ARU_14 | Not Premium | E | White | 2.0L | 4 | 24 | 30 | 141 | 14 | 2011.0 | 30k to 40k miles | ARU | ARU_4 |
$15k to $20k | $0k to $5k | 0 | 2013.0 | 10k to 15k miles | CZV | CZV_6 | Premium | null | Red | 2.5L | 4 | 27 | 36 | 184 | 13 | 2008.0 | 90k to 100k miles | OFW | OFW_7 |
$15k to $20k | $0k to $5k | 0 | 2010.0 | 80k to 85k miles | KQZ | KQZ_23 | Not Premium | E | Gray | 2.0L | 4 | 20 | 28 | 245 | 18 | 2005.0 | 190k to 200k miles | KQZ | KQZ_23 |
$25k to $30k | $0k to $5k | 0 | 2009.0 | 45k to 50k miles | CIP | CIP_3 | null | F | White | 3.5L | 6 | 21 | 31 | 268 | 17 | 1998.0 | 150k to 160k miles | CIP | CIP_108 |
$20k to $25k | $5k to $10k | 0 | 2013.0 | 35k to 40k miles | LTX | LTX_20 | Not Premium | E | White | 1.5L | 4 | 24 | 30 | 170 | 15 | 2009.0 | 90k to 100k miles | BGZ | BGZ_17 |
$35k to $40k | $5k to $10k | 0 | 2014.0 | 35k to 40k miles | LTX | LTX_9 | Not Premium | D | White | 4.3L | 6 | 16 | 21 | 285 | 24 | 2006.0 | 140k to 150k miles | KQZ | KQZ_3 |
$20k to $25k | $20k to $25k | 0 | 2012.0 | 45k to 50k miles | CFK | CFK_6 | Not Premium | E | Red | 2.4L | 4 | 22 | 30 | 180 | 12 | 2013.0 | 70k to 80k miles | FJE | FJE_5 |
$15k to $20k | $5k to $10k | 1 | 2010.0 | 65k to 70k miles | LTX | LTX_6 | Not Premium | F | Gray | 2.5L | 4 | 25 | 36 | 196 | 18 | 2005.0 | 150k to 160k miles | LTX | LTX_9 |
$15k to $20k | $5k to $10k | 1 | 2012.0 | 100k+ miles | HXQ | HXQ_8 | Not Premium | B | Black | 2.0L | 4 | 30 | 39 | 158 | 12 | 2006.0 | 110k to 120k miles | CFK | CFK_2 |
$25k to $30k | $5k to $10k | 0 | 2012.0 | 15k to 20k miles | HXQ | HXQ_10 | Premium | E | Blue | 1.5L | 4 | 28 | 34 | 190 | 14 | 2008.0 | 120k to 130k miles | CZV | CZV_4 |
$35k to $40k | $15k to $20k | 1 | 2014.0 | 30k to 35k miles | AIH | AIH_27 | Premium | E | White | 2.5L | 4 | 41 | 38 | 219 | 14 | 2014.0 | 40k to 50k miles | BGZ | BGZ_6 |
$15k to $20k | $0k to $5k | 0 | 2012.0 | 75k to 80k miles | JHO | JHO_4 | Not Premium | E | White | 2.0L | 4 | 20 | 24 | 200 | 16 | 2001.0 | 160k to 170k miles | JJQ | JJQ_7 |
$20k to $25k | $20k to $25k | 1 | 2012.0 | 55k to 60k miles | LTX | LTX_3 | Not Premium | E | White | 3.6L | 6 | 15 | 22 | 281 | 22 | 2015.0 | 20k to 30k miles | BGZ | BGZ_5 |
$15k to $20k | $5k to $10k | 1 | 2013.0 | 50k to 55k miles | ARU | ARU_4 | Not Premium | E | Gray | 2.5L | 4 | 25 | 32 | 170 | 14 | 2002.0 | 140k to 150k miles | CFK | CFK_5 |
$20k to $25k | $5k to $10k | 1 | 2013.0 | 30k to 35k miles | LTX | LTX_20 | Not Premium | E | Gold | 1.5L | 4 | 26 | 32 | 170 | 14 | 2008.0 | 100k to 110k miles | AIH | AIH_20 |
$25k to $30k | $0k to $5k | 1 | 2014.0 | 55k to 60k miles | HXQ | HXQ_10 | Premium | E | Blue | 1.5L | 4 | 28 | 34 | 190 | 14 | 2009.0 | 160k to 170k miles | KQZ | KQZ_23 |
$15k to $20k | $0k to $5k | 0 | 2012.0 | 85k to 90k miles | OFW | OFW_11 | null | F | Blue | 2.4L | 4 | 25 | 36 | 185 | 18 | 2009.0 | 130k to 140k miles | BGZ | null |
$20k to $25k | $20k to $25k | 0 | 2014.0 | 10k to 15k miles | BGZ | BGZ_6 | Not Premium | F | Silver | 2.0L | 4 | 30 | 40 | 147 | 14 | 2013.0 | 10k to 20k miles | GUK | GUK_8 |
$20k to $25k | $0k to $5k | 1 | 2014.0 | 40k to 45k miles | LTX | LTX_20 | Not Premium | E | Black | 1.5L | 4 | 26 | 32 | 170 | 14 | 2008.0 | 80k to 90k miles | ARU | ARU_18 |
$20k to $25k | $5k to $10k | 0 | 2015.0 | 5k to 10k miles | HDT | HDT_12 | null | E | Silver | 2.0L | 4 | 27 | 33 | 152 | 16 | 2005.0 | 140k to 150k miles | HXQ | null |
$35k to $40k | $10k to $15k | 0 | 2012.0 | 75k to 80k miles | AIH | AIH_8 | Premium | D | Silver | 5.7L | 8 | 13 | 17 | 381 | 38 | 2004.0 | 90k to 100k miles | LTX | LTX_9 |
$25k to $30k | $25k to $30k | 0 | 2011.0 | 40k to 45k miles | CIP | CIP_24 | null | F | Black | 3.5L | 6 | 19 | 26 | 255 | 17 | 2013.0 | 40k to 50k miles | IZA | null |
$30k to $35k | $10k to $15k | null | 2014.0 | 40k to 45k miles | HDT | HDT_6 | Premium | E | White | 2.4L | 4 | 21 | 27 | 260 | 19 | 2009.0 | 110k to 120k miles | HXQ | null |
$20k to $25k | $5k to $10k | 1 | 2012.0 | 40k to 45k miles | JHO | JHO_10 | null | F | Red | 2.0L | 4 | 24 | 33 | 210 | 14 | 2007.0 | 90k to 100k miles | JHO | JHO_10 |
$40k to $45k | $15k to $20k | 0 | 2014.0 | 25k to 30k miles | KQZ | KQZ_15 | Premium | E | Black | 3.5L | 6 | 16 | 22 | 365 | 18 | 2011.0 | 60k to 70k miles | ARU | ARU_16 |
$15k to $20k | $0k to $5k | 0 | 2011.0 | 50k to 55k miles | HXQ | HXQ_8 | Not Premium | B | Gray | 2.0L | 4 | 30 | 41 | 158 | 12 | 2000.0 | 140k to 150k miles | KQZ | KQZ_19 |
$0 to $15k | $0k to $5k | 0 | 2014.0 | 35k to 40k miles | AIH | AIH_25 | Not Premium | F | White | 1.8L | 4 | 28 | 36 | 132 | 13 | 2000.0 | 170k to 180k miles | HXQ | HXQ_14 |
$20k to $25k | $15k to $20k | 0 | 2013.0 | 15k to 20k miles | LTX | LTX_20 | Not Premium | E | Brown | 1.5L | 4 | 24 | 30 | 170 | 15 | 2013.0 | 20k to 30k miles | LTX | LTX_20 |
$35k to $40k | $0k to $5k | 1 | 2014.0 | 20k to 25k miles | FVQ | FVQ_8 | Premium | E | Blue | 2.0L | 4 | 22 | 28 | 252 | 14 | 2006.0 | 170k to 180k miles | BDP | null |
$40k to $45k | $5k to $10k | null | 2016.0 | 5k to 10k miles | FJE | FJE_5 | Premium | B | White | 5.7L | 8 | 15 | 23 | 375 | 18 | 2006.0 | 130k to 140k miles | CIP | CIP_31 |
$30k to $35k | $0k to $5k | null | 2016.0 | 5k to 10k miles | HDT | HDT_3 | null | E | Silver | 2.5L | 4 | 26 | 33 | 182 | 16 | 2005.0 | 100k to 110k miles | KDM | KDM_3 |
$25k to $30k | $0k to $5k | 0 | 2015.0 | 25k to 30k miles | OFW | OFW_14 | Not Premium | E | White | 2.4L | 4 | 22 | 29 | 185 | 18 | 2002.0 | 190k to 200k miles | BDP | BDP_11 |
$45k to $50k | $20k to $25k | 0 | 2012.0 | 20k to 25k miles | MBN | MBN_3 | null | E | Black | 2.0L | 4 | 20 | 25 | 252 | 19 | 2012.0 | 40k to 50k miles | HXQ | null |
$20k to $25k | $5k to $10k | 0 | 2011.0 | 45k to 50k miles | JJQ | JJQ_3 | Not Premium | E | Gray | 2.0L | 4 | 20 | 26 | 240 | 18 | 2011.0 | 80k to 90k miles | OFW | OFW_3 |
$20k to $25k | $5k to $10k | 0 | 2013.0 | 20k to 25k miles | NHY | NHY_9 | null | E | White | 3.5L | 6 | 20 | 28 | 279 | 16 | 2009.0 | 60k to 70k miles | AIH | AIH_13 |
$20k to $25k | $0k to $5k | 0 | 2010.0 | 65k to 70k miles | FJE | FJE_5 | Not Premium | B | Gray | 3.6L | 6 | 19 | 30 | 305 | 18 | 2011.0 | 80k to 90k miles | BGZ | BGZ_6 |
$25k to $30k | $5k to $10k | 0 | 2012.0 | 40k to 45k miles | NKR | NKR_9 | Premium | E | White | 3.6L | 6 | 15 | 22 | 288 | 22 | 2007.0 | 80k to 90k miles | JHO | JHO_10 |
$25k to $30k | $5k to $10k | 0 | 2013.0 | 20k to 25k miles | LTX | LTX_20 | Not Premium | E | Black | 1.5L | 4 | 24 | 30 | 170 | 15 | 2007.0 | 90k to 100k miles | ARU | ARU_4 |
$20k to $25k | $15k to $20k | 1 | 2015.0 | 50k to 55k miles | GUK | GUK_1 | Not Premium | E | Black | 2.4L | 4 | 24 | 29 | 166 | 15 | 2013.0 | 20k to 30k miles | CFK | CFK_6 |
$0 to $15k | $0k to $5k | 0 | 2007.0 | 100k+ miles | LTX | LTX_16 | Not Premium | F | White | 1.8L | 4 | 25 | 36 | 138 | 15 | 1995.0 | 200k+ miles | KQZ | KQZ_6 |
$55k to $60k | $30k to $35k | 0 | 2016.0 | 5k to 10k miles | IZA | IZA_39 | null | E | Black | 3.0L | 6 | 21 | 27 | 382 | 17 | 2013.0 | 30k to 40k miles | IZA | null |
$25k to $30k | $15k to $20k | null | 2015.0 | 20k to 25k miles | KQZ | KQZ_4 | Not Premium | E | White | 1.5L | 3 | 27 | 33 | 180 | 14 | 2011.0 | 50k to 60k miles | OFW | OFW_20 |
$15k to $20k | $20k to $25k | 0 | 2013.0 | 15k to 20k miles | JHO | JHO_10 | Not Premium | F | Black | 1.4L | 4 | 28 | 38 | 150 | 14 | 2012.0 | 40k to 50k miles | KQZ | KQZ_13 |
$20k to $25k | $5k to $10k | 1 | 2013.0 | 45k to 50k miles | HXQ | HXQ_10 | Not Premium | E | Black | 2.4L | 4 | 26 | 32 | 184 | 14 | 2005.0 | 110k to 120k miles | FVQ | FVQ_4 |
$15k to $20k | $0k to $5k | 0 | 2011.0 | 45k to 50k miles | ARU | ARU_12 | Not Premium | F | Gray | 2.5L | 4 | 27 | 39 | 182 | 18 | 2001.0 | 130k to 140k miles | ARU | ARU_12 |
$15k to $20k | $0k to $5k | 0 | 2011.0 | 50k to 55k miles | AIH | AIH_28 | Not Premium | F | Silver | 3.5L | 6 | 21 | 30 | 268 | 17 | 2000.0 | 200k+ miles | LTX | LTX_118 |
$15k to $20k | $15k to $20k | 0 | 2013.0 | 30k to 35k miles | BGZ | BGZ_16 | Not Premium | F | Brown | 2.4L | 4 | 25 | 36 | 185 | 18 | 2013.0 | 50k to 60k miles | LTX | LTX_6 |
$40k to $45k | $0k to $5k | 1 | 2011.0 | 20k to 25k miles | LTX | LTX_24 | Not Premium | E | Burgundy | 5.3L | 8 | 16 | 23 | 355 | 26 | 2002.0 | 150k to 160k miles | KQZ | KQZ_26 |
$20k to $25k | $5k to $10k | 0 | 2013.0 | 35k to 40k miles | LTX | LTX_20 | Not Premium | E | Brown | 1.5L | 4 | 24 | 30 | 170 | 15 | 2009.0 | 80k to 90k miles | LTX | LTX_16 |
$35k to $40k | $35k to $40k | 0 | 2013.0 | 25k to 30k miles | HXQ | HXQ_4 | Premium | G | Brown | 3.5L | 6 | 19 | 28 | 280 | 19 | 2013.0 | 40k to 50k miles | FJE | FJE_9 |
$25k to $30k | $10k to $15k | 0 | 2011.0 | 25k to 30k miles | LYP | LYP_8 | Premium | E | Black | 2.0L | 4 | 20 | 28 | 220 | 19 | 2010.0 | 60k to 70k miles | FPH | null |
$25k to $30k | $0k to $5k | 0 | 2015.0 | 45k to 50k miles | AIH | AIH_13 | Not Premium | F | Silver | 2.5L | 4 | 28 | 39 | 203 | 16 | 2001.0 | 150k to 160k miles | AIH | AIH_13 |
$35k to $40k | $10k to $15k | 1 | 2013.0 | 15k to 20k miles | HDT | HDT_8 | Premium | F | Blue | 2.5L | 4 | 16 | 22 | 305 | 15 | 2009.0 | 70k to 80k miles | LYP | null |
$25k to $30k | $30k to $35k | 0 | 2013.0 | 40k to 45k miles | IZA | IZA_19 | Premium | F | Black | 2.0L | 4 | 23 | 33 | 248 | 15 | 2011.0 | 40k to 50k miles | KQZ | KQZ_11 |
$20k to $25k | $0k to $5k | 1 | 2014.0 | 15k to 20k miles | LTX | LTX_20 | Not Premium | E | White | 1.5L | 4 | 25 | 30 | 170 | 15 | 2007.0 | 110k to 120k miles | JHO | JHO_10 |
$20k to $25k | $5k to $10k | 1 | 2012.0 | 30k to 35k miles | JHO | JHO_11 | Premium | F | White | 1.8L | 4 | 23 | 34 | 170 | 18 | 2007.0 | 120k to 130k miles | FVQ | FVQ_8 |
$15k to $20k | $0k to $5k | 0 | 2012.0 | 35k to 40k miles | ARU | ARU_18 | Not Premium | F | Silver | 1.8L | 4 | 29 | 37 | 124 | 13 | 2001.0 | 200k+ miles | HXQ | HXQ_14 |
$30k to $35k | $20k to $25k | 1 | 2011.0 | 40k to 45k miles | FJE | FJE_5 | null | B | Blue | 5.7L | 8 | 15 | 23 | 375 | 18 | 2013.0 | 80k to 90k miles | HXQ | null |
$25k to $30k | $15k to $20k | 0 | 2013.0 | 5k to 10k miles | HXQ | HXQ_14 | Premium | F | Silver | 1.5L | 4 | 29 | 35 | 192 | 14 | 2009.0 | 80k to 90k miles | CFK | CFK_8 |
$20k to $25k | $15k to $20k | 0 | 2016.0 | 0 to 5k miles | AIH | AIH_17 | Not Premium | null | White | 2.0L | 4 | 32 | 41 | 169 | 13 | 2013.0 | 30k to 40k miles | AIH | AIH_19 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started