ENG101 West Virginia University Car Fuel Economy Questions

User Generated

zbuun

Engineering

ENG101

West Virginia University

Description

all the instructions on the file

Unformatted Attachment Preview

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 equation editor to display equations Plot on a secondary axis 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 (Please follow the correct homework heading format and please record your answers in blue color on this sheet) 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. What is that MPG? ___________________________. Record the Uhaul’s curb weight and predicted MPG on the excel sheet. Label clearly (linear) and use Equation Editor to show the equation used. Does that answer make sense? Why or why not? ___________________________________________________ ___________________________________________________________________________________________ 5. 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). 6. Select to display the equation on the chart. What is the equation? ________________________________ 7. Using your equation, predict the MPG of a Uhaul that has a curb weight of 12,600lbs. What is that MPG? ___________________________. Record the Uhaul’s curb weight and predicted MPG on the excel sheet. Label clearly (exponential) and use Equation Editor to show the equation used. Does that answer make sense? Why or why not? Is this prediction better or worse than the first equation? ___________________________________________________________________________________________ ___________________________________________________________________________________________ 8. 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. 9. 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? _____________________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ 10. 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)? _________________ data points. 11. Make sure you included a title, legend, arrows and axis labels for all graphs. 12. Organize the excel sheet to make it look presentable. 13. Please make sure you have all the questions answered on this document and upload the Excel sheet that you created in the assignment on eCampus.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi there👋 , the file with the instructions and the excel file are in the attachment.

Curb Weight (lbs) Highway MPG (mi/gal)Cost of the Vehicle
2907
37 R$
17,170.00
3961
31 R$
27,995.00
2911
34 R$
18,195.00
5073
22 R$
23,403.00
5375
21 R$
32,486.00
3291
32 R$
21,545.00
4470
28 R$
28,975.00
3423
30 R$
24,895.00
3777
32 R$
22,120.00
2483
40 R$
25,990.00

45
40

Highway MPG (mi/gal)

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

y=

35
30
25
20
15
10
5
0
0

Linear
𝑦 = −0.006𝑥 + 53.127
x
12600

y

1000

3rd graph

-22.473
45

Exponential

x

y
12600

5.012

Highway MPG (mi/gal)

𝑦 = 65.506 ∙ 𝑒

40
−2.04∙10−4 ∙𝑥

35
30
25
20
15
10
5
0
0

1000

2000

3000

4000

Curb Weight (lbs)
Highway MPG

Linear (Highway MPG)

Expon. (High

1st graph
45
40

Highway MPG (mi/gal)

y = -0.006x + 53.127

y = 65.506e-2E-04x

35
30
25
20
15
10
5
0

1000

2000

3000

4000

5000

6000

0

1000

2000

Curb Weight (lbs)
Highway MPG

Linear (Highway MPG)

Highway MPG

4th graph
45

R$ 35,000.00

Highway MPG (mi/gal)

40

R$ 30,000.00

35
R$ 25,000.00

30
25

R$ 20,000.00

20

R$ 15,000.00

15

R$ 10,000.00

10
R$ 5,000.00

5
0
4000

5000

6000

R$ 0

1000

2000

3000

4000

Curb Weight (lbs)
Expon. (Highway MPG)

Highway MPG

Cost

5000

6000

2nd graph

2000

3000

4000

5000

6000

Curb Weight (lbs)
Highway MPG

Expon. (Highway MPG)

5th graph
R$ 35,000.00

45
40

R$ 10,000.00

6000

R$ 30,000.00

35
R$ 25,000.00

30
25

R$ 20,000.00

20

R$ 15,000.00

15

R$ 10,000.00

10

R$ 5,000.00

5

R$ -

0
3000

R$ 5,000.00
R$ 3100

3200

3300

340...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags