Select Page

Please read the attached file. Solve all 12 questions using excel and follow the outlines precisely , make the whole answers in one file as well.
hw_1___excel___g.pdf

Unformatted Attachment Preview

CET 330 – Fluid Mechanics
Module 1 – Excel Homework
Create an excel spreadsheet to answer the following questions. Provide your work and place a
shaded box around your final answers. Label the tab or question in your spreadsheet so I can
determine where each answer is located. Upload your excel file to the digital drop box on
BlackBoard.
1. Determine the cross-sectional area IN SQUARE FEET for pipes ranging in diameter
from 10 – 36 inches, in increments of 2 inches. There should be 14 answers.
…….
2. Calculate the volume of a pool, in cubic feet, that is 18 ft wide by 38 ft long and has a
water level increasing from 6 inches up to a depth of 5 feet in 6-inch increments. There
should be 10 answers.
3. What is the centroid on the y axis for the figure shown? Values for the figure are provided
to right of figure.
y1
x1
x2
x3
8
4
3
5
4. Linear Interpolation. Find the value of y that is missing in the column below given the x
values to the left
X
Y
9.426
10.206
11.548
180
?
200
5. Solve the following equation for x, using excel & provide the positive root only. (we don’t
care about the negative values in this class)
3x 3  4 x 2  6 x  458
6. Solve the following equation for x, using excel & provide the positive root only.
12 x 3  8 x 2  16 x  106  0
7. Find the value of the definite integral below, using excel.
8
 10  y  dy
0
8. Find the value of the definite integral below, using excel.
10
  32  4 y  dy
2
9. What is the length of side AB in the triangle below?
BC =
CA =
20
16
10. What is the value of H in the triangle below?
=
L=
22
223
11. (E.C.) These are the HW, Quiz, and Exam scores. If the weights are HW = 15%, Quizzes
= 60 %, Mid Term = 12.5%, Final = 12.5% – what is the average grade? HW are out of a
possible 10 points and Quizzes are out of a possible 25 points.
HW 1
9
HW 2.1
6
HW 2.2
8
HW 3
9
HW 4.1
7
HW 4.2
9
HW 5
10
HW 6
9.4
HW 7
9.8
HW 8
8
HW 9
0
HW 10
9
HW 11.1
6
HW 11.2
9
HW 12
7
HW
13.1
10
HW 13.2
8
HW 14
7
HW 15
8
HW 16
8
HW 17
9
HW 18.1
12
HW 18.2
8
HW 19
7
HW 20
8
Q1
22
Q2
21
Q3
19
Q4
18
Q5
16
Q6
23
Mid
Term
65
Q7
25
Final
78
12. (E.C.) What is the Final Letter Grade IF lowest HW and Highest HW are dropped?

Purchase answer to see full
attachment