Use the following empirical relationship to plot the fuel consumption in both km per liter and liters per km for a car for which the following relationship applies. Note: V is the speed of the car in km per hour and the given relationship is valid for 20 ≤ V ≤ 75 .Fuel Consumption (km per liter) = 1000×V/900+ V 1.85Refer to the Excel sheets shown in the accompanying figures when following the steps.1. First, as shown using Excel and the given formula, we compute thefuel consumption in km per liter and liters per km for the given range ofspeeds. Note that the values in cells C3 through C14 are the inverse of cellvalues in B3 through B14.2. We plot the fuel consumption in km per liter versus speed, as shown .3. With the mouse pointer in the chart area, click the right mouse button and choose Select Data …, also as shown.4. In the Select Data Source, under Legend Entries, click on the Add button( as shown ), and then type in the series name, and choose the SeriesX values, and Series Y values as shown. X v fr =(1000*A3)/(900+A3^B3Select Data SourceChart 2ADChart data range: Sheeti1SAS2:SBSL4|12 Speed (km) km per literliters per km2017a1liters per km17.312 Speed (mph) km per liter2519.4520.00Switch Row/Column20200.058252142E 1500 oLegend Entries (Series)Horizontal (Category) Axis Labels4021.842519.450.0512202Vecal al苗AddDEditX Bemove-P Edit30Ouine53020.830.04810552150210720 58202530km per liter21.624065116350.046Dee129 Reet teMch Style74021.980.046127020.es.ese14751951il Change Chan Tu84522.020.045G Seet DetaO 30BatationEomat Grdine1535165021.830.046401718105521.500.047Pomt AsHidden and Empty CellsOKCancelSheet116021.070.047126520.580.049FIGURE 14.21Plotting fuel consumption.FIGURE 14.22Select Data Source.137020.050.050147519.510.05115Edit SeriesSheetlSeries name:FIGURE 14.20Fuel consumption computation.Liters per km= Liters per km=Series X values:= Sheet1!SB$3:SBS14= 17.31, 19.45, .Series Y values:=Sheet1SDS3:SD$14|= 1OKCancelFIGURE 14.2 3Choosing Series X and Y values.

Name: Use the following empirical relationship to plot the fuel consumption
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: Use the following empirical relationship to plot the fuel consumption in both km per liter and liters per km for a car for which the following relationship applies. Note: V is the speed of the car in km per hour and the given relationship is valid fo

Given : speed(mph) cons.(km/llitre) cons.(llitres/km) 20 17.31 0.058 25 19.45 0.051 30…

Answered: X v fr =(1000*A3)/(900+A3^ B3 Select…

Algebra & Trigonometry with Analytic Geometry

13th Edition

ISBN:9781133382119

Author:Swokowski

Publisher:Swokowski

Chapter4: Polynomial And Rational Functions

Section4.6: Variation

Problem 37E

See similar textbooks

Related questions

Topic Video

Question

Use the following empirical relationship to plot the fuel consumption in both km per liter and liters per km for a car for which the following relationship applies. Note: V is the speed of the car in km per hour and the given relationship is valid for 20 ≤ V ≤ 75 .
Fuel Consumption (km per liter) = 1000×V/900+ V 1.85
Refer to the Excel sheets shown in the accompanying figures when following the steps.
1. First, as shown using Excel and the given formula, we compute the
fuel consumption in km per liter and liters per km for the given range of
speeds. Note that the values in cells C3 through C14 are the inverse of cell
values in B3 through B14.
2. We plot the fuel consumption in km per liter versus speed, as shown .
3. With the mouse pointer in the chart area, click the right mouse button and choose Select Data …, also as shown.
4. In the Select Data Source, under Legend Entries, click on the Add button
( as shown ), and then type in the series name, and choose the Series
X values, and Series Y values as shown.

X v fr =(1000*A3)/(900+A3^
B3
Select Data Source
Chart 2
A
D
Chart data range: Sheeti1SAS2:SBSL4|
1
2 Speed (km) km per liter
liters per km
20
17a1
liters per km
17.31
2 Speed (mph) km per liter
25
19.45
20.00
Switch Row/Column
20
20
0.058
25
2142
E 1500 o
Legend Entries (Series)
Horizontal (Category) Axis Labels
40
21.8
4
25
19.45
0.051
2202
Vecal al
苗Add
DEdit
X Bemove-
P Edit
30
Ouine
5
30
20.83
0.048
10
55
2150
2107
20 58
20
25
30
km per liter
21.62
40
65
11
6
35
0.046
Dee
12
9 Reet teMch Style
7
40
21.98
0.046
12
70
20.es
.ese
14
75
1951
il Change Chan Tu
8
45
22.02
0.045
G Seet Deta
O 30Batation
Eomat Grdine
15
35
16
50
21.83
0.046
40
17
18
10
55
21.50
0.047
Pomt As
Hidden and Empty Cells
OK
Cancel
Sheet
11
60
21.07
0.047
12
65
20.58
0.049
FIGURE 14.21
Plotting fuel consumption.
FIGURE 14.22
Select Data Source.
13
70
20.05
0.050
14
75
19.51
0.051
15
Edit Series
Sheetl
Series name:
FIGURE 14.20
Fuel consumption computation.
Liters per km
= Liters per km
=
Series X values:
= Sheet1!SB$3:SBS14
= 17.31, 19.45, .
Series Y values:
=Sheet1SDS3:SD$14|
= 1
OK
Cancel
FIGURE 14.2 3
Choosing Series X and Y values.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.