Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions

Question

What do their students end up doing when they graduate?

Answered: 1 week ago