Solved by verified expert: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.task:follow instuction and fill out the yello boxes

excel_homework_4___fuel_economy.docx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on

Expert answer:Fuel Economy Homework

Just from $10/Page

Car Fuel Economy

Objectives

1. Create a chart of important values

2. Determine what type of graph best fits the available data (exponential, linear, logarithmic,

polynomial… etc)

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

4. Fit a line to the graph and show equation

5. Use the equation to predict a future value

6. Use the equation editor to display equations

7. Plot on a secondary axis

8. Change the bounds of an axis to take a closer look

Your task:

You want to determine whether the curb weight of the vehicle has any impact on the Highway

MPG of the vehicle. You also want to find out if there is any relationship between the Highway

MPG, curb weight and the cost of the vehicle.

Manually input the following information into excel to do an analysis of car fuel economy.

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

Cost of the Vehicle

$17,170

$27,995

$18,195

$23,403

$32,486

$21,545

$28,975

$24,895

$22,120

$25,990

On Excel, record the make, model and year of the vehicle, the curb weight, and the highway MPG (Miles

per gallon).

General note: Whenever you create a graph, label the X-axis and the Y-axis. Give the graph an

appropriate title and include units for the axes. Use the Equation Editor to type answers as equations.

1.

2.

3.

4.

Create/insert a scatter plot of the Curb weight (X-axis) vs. Highway MPG (Y-axis).

Select the data points and add a linear trendline for the 10 cars you currently have. Make it

a solid green line.

Select to display the equation on the chart. What is the equation? _______________

Using your equation, predict the MPG of a Uhaul that has a curb weight of 12,600lbs:

_______________.

Does that answer make sense? Why or why not?

___________________________________________________________________________

___________________________________________________________________________

5.

6.

7.

8.

9.

10.

11.

12.

13.

According to the Uhaul website, a typical truck will get about 10 MPG. Create another

scatter plot (do not delete the original one) that shows the same data, but is fitted with an

exponential trendline, but don’t include the Uhaul in your second or third graph (dashed red

line).

Select to display the equation on the chart. What is the equation? ___________________

Using your equation, predict the MPG of a Uhaul that has a curb weight of 12,600lbs:

___________________.

Does that answer make sense? Why or why not? Is this prediction better or worse than the

first equation?

___________________________________________________________________________

___________________________________________________________________________

__________________________________________________________________________

Now create a third scatter plot of curb weight and highway MPG. Add both a linear and

exponential trendline. Make the linear trendline a solid green line and the exponential

trendline a dashed red line (just like the two previous graphs). Again, don’t include Uhaul

here.

Now create a 4th scatter plot of Highway MPG and the Cost of the vehicle, both as functions

of the curb weight (do not plot the UHAUL).

a. Select curb weight and highway MPG to plot first.

b. Right click on the graph and click “select data.”

c. “Add” a new set of data by selecting curb weight as the x-axis and cost as the y-axis.

Name it “Cost”

d. Plot the data

e. Right click on the data points and format data series

f. Select to plot on a secondary axis

g. Insert an arrow from the insert tab at the top (in “shapes”). Draw it from your curb

weight vs MPG data to the proper y-axis. The purpose of this is to show which data

set on your graph goes to which axis. Do the same for the Cost data set to the

secondary axis on the right. Format the arrow so that it’s the same color as the data

set.

h. Analyze the data. Can you see any trends? What is the relationship between curb

weight and MPG? What is the relationship between curb weight and cost? Are there

any outliers? What is causing them to be an outlier?

Let’s take a closer look at the graph. Copy the graph by clicking on the 4th graph and press

ctrl + C.

a. Change this 5th graph so that the x-axis is now from 3000 to 4000.

b. Right click on the x-axis and click format axis”

c. Change the bounds so that the minimum is 3000 and the maximum is 4000.

d. This allows me to take a closer look at a specified section of the graph. How many

data points do you see here (originally, there were 20)? __________

Make sure you included a title, legend, arrows and axis labels for all graphs.

Organize the excel sheet to make it look presentable.

Please make sure you have all the questions answered on this document and upload BOTH

this document and the Excel sheet.

…

Purchase answer to see full

attachment

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more