EGR150301 South College Asheville Chapter 9 Excel Math Formulas Exercises Please perform all of the operations below in Excel.Upload your excel file showin

EGR150301 South College Asheville Chapter 9 Excel Math Formulas Exercises Please perform all of the operations below in Excel.Upload your excel file showing the formulas and results in Moodle. EGR-150-301
Date:
Ch 9 Excel assignment 2
Student Name
Please perform all of the operations below in Excel. Upload your excel file showing the formulas and results in
Moodle.
A) Perform the following calculation in Excel and show the final results.
:
a. Using a = 1.12, b = 2.34, c = 0.72, d = 0.81, compute the followings
r=
1
1 1 1 1
+ + +
a b c d
b. Using a = 1.12, b = 2.34, c = 0.72, d = 0.81, f = 19.83, compute the followings
2
1 f
y = ab
c 2
EGR-150-301
Date:
Ch 9 Excel assignment 2
Student Name
B) Perform the following in Excel.
4 ?r 3
The area of a sphere is 4?r
and its volume is
3 . Find the area and volume
2
a.
of the sphere with a radius of 2 ft.
b. For the triangle shown, find the length CB and the angle B.
C
CB 2 = AC 2 + AB 2 ? 2 AC. AB. cos( A)
sin( B) sin( A) sin( C )
=
=
AC
CB
AB
16
35º
A
20
B
EGR-150-301
Date:
Ch 9 Excel assignment 2
Student Name
c. Manning ‘s equation can be used to compute the velocity of water in a rectangular open
channel:
S ? BH ?
U=
?
?
n ? B + 2H ?
2
3
Where,
U = velocity (m/s)
S= channel slope
n= roughness coefficient
B= width (m)
The following data is available for five different channels:
n
0.035
0.020
0.015
0.030
0.022
S
0.0001
0.0002
0.0010
0.0007
0.0003
B
10
8
20
24
15
H
2
1
1.5
3
2.5
Use the above data to calculate the channel velocity. Save your Excel file.
U
EGR-150-301
Date:
Ch 9 Excel assignment 2
Student Name
Please perform all of the operations below in Excel. Upload your excel file showing the formulas and results in
Moodle.
A) Perform the following calculation in Excel and show the final results.
:
a. Using a = 1.12, b = 2.34, c = 0.72, d = 0.81, compute the followings
r=
1
1 1 1 1
+ + +
a b c d
b. Using a = 1.12, b = 2.34, c = 0.72, d = 0.81, f = 19.83, compute the followings
2
1 f
y = ab
c 2
EGR-150-301
Date:
Ch 9 Excel assignment 2
Student Name
B) Perform the following in Excel.
4 ?r 3
The area of a sphere is 4?r
and its volume is
3 . Find the area and volume
2
a.
of the sphere with a radius of 2 ft.
b. For the triangle shown, find the length CB and the angle B.
C
CB 2 = AC 2 + AB 2 ? 2 AC. AB. cos( A)
sin( B) sin( A) sin( C )
=
=
AC
CB
AB
16
35º
A
20
B
EGR-150-301
Date:
Ch 9 Excel assignment 2
Student Name
c. Manning ‘s equation can be used to compute the velocity of water in a rectangular open
channel:
S ? BH ?
U=
?
?
n ? B + 2H ?
2
3
Where,
U = velocity (m/s)
S= channel slope
n= roughness coefficient
B= width (m)
The following data is available for five different channels:
n
0.035
0.020
0.015
0.030
0.022
S
0.0001
0.0002
0.0010
0.0007
0.0003
B
10
8
20
24
15
H
2
1
1.5
3
2.5
Use the above data to calculate the channel velocity. Save your Excel file.
U
EGR-150-301
Date:
Ch 9 Excel assignment
Student Name
Please perform all the operations below in Excel. Upload your excel file showing the formulas and results in
Moodle.
A) Show the next 6 expressions (individually) in Excel and show the final results.
52
5( 2*3)
5/ 2*6*4
5+3
5*6
4 + 63
16
9 + 7 * 5( 3+2 )
12
1 + 5 * 3 / 6 2 + 2 2 ? 4 * 1 / 5 .5
B) Perform the next 3 equations in Excel and show the final solutions.
i)
y=
1 -z 2 / 2
e
2?
for z=3
ii)
T(?C)=5/9(T(?F)-32)
for T = 212 F
EGR-150-301
Date:
Ch 9 Excel assignment
Student Name
iii)
0.076(1 + 0.076) 5
A = 35000
(1 + 0.076) 5 ? 1
C) Perform the following calculation in Excel and show the final results.
i) Solve for Z using x=3
1 ?
?
z = ?1 ? 2 ?
? x ?
?1
ii) Solve for Z using x=3 and y= 4
z = 7( x1/ 3 ) + 4 x 0.58 ? y
EGR-150-301
Date:
Ch 9 Excel assignment
Student Name
Please perform all of the operations below in Excel. Upload your excel file showing the
formulas and results in Moodle.
A) Perform the following calculation in Excel and show the final results.
:
a. Using a = 1.12, b = 2.34, c = 0.72, d = 0.81, compute the followings
r=
1
1 1 1 1
+ + +
a b c d
b. Using a = 1.12, b = 2.34, c = 0.72, d = 0.81, f = 19.83, compute the followings
2
1 f
y = ab
c 2
EGR-150-301
Date:
Ch 9 Excel assignment
Student Name
B) Perform the following in Excel.
a.
3
4
?r
2
4
?
r
3
The area of a sphere is
and its volume is
. Find the area and volume of
the sphere with a radius of 2 ft.
b. For the triangle shown, find the length CB and the angle B.
C
16
CB 2 = AC 2 + AB 2 ? 2 AC. AB. cos( A)
sin( B) sin( A) sin( C )
=
=
AC
CB
AB
35º
A
20
B
EGR-150-301
Date:
Ch 9 Excel assignment
Student Name
c. Manning ‘s equation can be used to compute the velocity of water in a rectangular open channel:
S ? BH ?
U=
?
?
n ? B + 2H ?
2
3
Where,
U = velocity (m/s)
S= channel slope
n= roughness coefficient
B= width (m)
The following data is available for five different channels:
n
S
B
H
0.035
0.0001
10
2
0.020
0.0002
8
1
0.015
0.0010
20
1.5
0.030
0.0007
24
3
0.022
0.0003
15
2.5
Use the above data to calculate the channel velocity. Save your Excel file.
U

Purchase answer to see full
attachment