458 Chapter 14 Electronic Spreadsheets
14.21. Use Excel to plot the following data. Use two different
yaxes. Use a scale of zero to 100F for temperature,
and zero to 12 mph for wind speed.Time Temperature Wind
(P.M.) (F) Speed (mph)1754
2805
3828
4825
5785
6754
7703
8683Flow Rate Head of
(GPM) Pump (ft) Efficiency (%)0 120 0
2 119.2 10
4 116.8 30
6 112.8 50
8 107.2 70
10 100 80
12 91.2 79
14 80.8 72
16 68.8 50
18 55.2 3014.22.Use Excel to plot the following data for a pump. Use
two differentyaxes. Use a scale of zero to 140 ft for
the head and zero to 100 for efficiency.14.23.Use the following empirical relationship to plot the fuel
consumption in both miles per gallon and gallons per
mile for a car for which the following relationship
applies.Note: Vis the speed of the car in miles per hour
and the given relationship is valid for 30 V70.1050 V
910 V
1.88Fuel Consumption 1 Miles per Gallon 2
14.24.Starting with a 10 cm 10 cm sheet of paper, what is
the largest volume you can create by cutting outxcm
xcm from each corner of the sheet and then folding
up the sides. Use Excel to obtain the solution.Hint :
The volume created by cutting outxcm xcm from
each corner of the 10 cm 10 cm sheet of paper is
given by V(10 2 x)(10 2 x)x.
14.25.Given matrices:and
perform the following operations
using Excel.
a.
b.
c.
d.
e.
14.26.Solve the following set of equations using Excel.14.27.Solve the following set of equations using Excel.
e
1 5.88 21202
0
0
0
1 1.47 21702
u
E
7.11 1.23 0 0 0
1.23 1.99 0.76 00
0 0.76 0.851 0.091 0
00 0.091 2.31 2.22
000 2.22 3.69
U e
T 1
T 2
T 3
T 4
T 5
u
£
111
251
315
§•
x 1
x 2
x 3
¶•
6
15
14
¶
3 A 45 C 6 ?
3 A 43 B 4 ?
33 A 4 ?
3 A 4 3 B 4 ?
3 A 4 3 B 4 ?
3 C 4 •
1
2
4
¶,
3 B 4 £
12 1
53 3
45 7
3 A 4 £ §,
421
70 7
1 53
§,
Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀