# Car Payment and Car Fuel Economy, Excel Analysis help

*label*Science

*timer*Asked: Jun 13th, 2016

*account_balance_wallet*$10

### Question Description

1. Car Payment Assignment:

This assignment is to help you get more familiar with excel. This is a very challenging Excel analysis problem as it summarizes everything you have learned up to this point and even introduces you to a new built-in function called the "pmt" function. This will test your ability to understand how to input the correct data so that the built-in functions work properly. It will also test your ability to think logically about what your columns and rows of data actually mean in a worksheet.

2. Car Fuel Economy:

This assignment is to help you get more familiar with excel. This also helps you practice finding differences between reliable and non-reliable sources on the internet. You will be creating graphs to analyze data. You'll find that Excel makes a very powerful calculator.

## Tutor Answer

Car Make and Model

Ford Focus

Dodge Charger

Subaru Impreza

Ford F150 2WD

Ford F150 4WD

Mazda CX 5

Honda Odyssey

Subaru Outback

Chevy Equinox

Kia Optima Hybrid

Curb Weight (lbs)

2907

3961

2911

5073

5375

3291

4470

3423

3777

2483

Highway MPG (mi/gal)

37

31

34

22

21

32

28

30

32

40

Task 1

Uhaul (Linear)

MPG=-22.473

Curb weight=12,600

Uhaul (Exponential)

MPG=5.27

Curb weight=12,600

Highway MPG

Curb weight vs.Highway MPG

45

40

35

30

25

20

15

10

5

0

Curb weight Vs Highway

MPG

y = -0.006x + 53.127

Linear (Curb weight Vs

Highway MPG)

0

2000

4000

6000

Curb weight

45

40

Curb weight vs Highway MPG

35

MPG

30

25

20

y = 65.506e-2E-04x

Curb weight vs MPG

MPG

25

Curb weight vs MPG

y = 65.506e-2E-04x

20

15

Expon. (Curb weight vs

MPG)

10

5

0

0

2000

4000

6000

Curb weight

45

40

35

30

25

20

15

10

5

0

3000

35000

30000

25000

20000

15000

10000

5000

3500

Curb weight

0

4000

Cost

MPG

Curb weight vs MPG and Cost

Curb weight vs MPG and

Cost

Cost

Cost of the Vehicle

$17,170

$27,995

$18,195

$23,403

$32,486

$21,545

$28,975

$24,895

$22,120

$25,990

45

Curb weight vs Highway MPG

40

Highway MPG

35

30

Curb weight vs

Highway MPG

25

20

Linear (Curb weight vs

Highway MPG)

15

Expon. (Curb weight vs

Highway MPG)

10

5

0

0

2000

4000

6000

Curb weight

40

35

MPG

30

25

Curb weight vs MPG

and Cost

35000

30000

25000

20000

Cost

45

Curb weight vs MPG and

Cost

25

20000

20

15000

15

10000

10

5000

5

0

0

2000

4000

Curb weight

0

6000

Cost

MPG

30

Curb weight vs MPG and

Cost

Cost

Name__________________________________

Car Fuel Economy

Objectives:

1.

2.

3.

4.

5.

6.

7.

8.

Create a chart of important values

Determine what type of graph best fits the available data (exponential, linear, logarithmic, polynomial… etc)

Create a plot using the correct values and determine which variable goes on which axis

Fit a line to the graph and show equation

Use the equation to predict a future value

Use the ...

*flag*Report DMCA

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors