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
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
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.
this document and the Excel sheet.

attachment

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

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.

### Money-back guarantee

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.

### Zero-plagiarism guarantee

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

### Free-revision policy

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