# Car Payment and Car Fuel Economy, Excel Analysis help

Anonymous

### 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.

### Unformatted Attachment Preview

Purchase answer to see full attachment

Ellah
School: Rice University

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

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
Review

Anonymous
Top quality work from this tutor! I’ll be back!

Anonymous
Just what I needed… fantastic!

Anonymous
Use Studypool every time I am stuck with an assignment I need guidance.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

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