Page 1 of 5

CE 331L –Fluid Mechanics and Hydraulics Laboratory

Assignment 1: Presenting Experimental Data in Word Document

Assigned: (08/24/2020 Sec. 1) & (08/27/2020 Sec. 2) Due: (08/31/2020 Sec. 1) & (09/03/2020 Sec. 2)

Instructions: Type tables 1 and 2 in Word and create four graphs in Excel using the data from

these tables. Follow every step and create complete, aesthetically pleasing graphs. Make sure

that the graphs contain titles, axis lines, axis labels including units, and ensure that a best-fit

trend line (model) is fitted through the data which must also include an equation and

coefficient of determination (R2). Once you have added all required elements to each graph,

and you are satisfied with the appearance of the graphs, import them into a new Word

document. Then read carefully the questions given in step 5 and think critically using your

calculus knowledge to answer them.

Table 1. Linear Series

Time, t (s) 0 5 10 15 20 25 30 35 40

Velocity, V (m/s) 24 33 62 77 105 123 151 170 188

Table 2. Power Series

Time, t Distance, d (s) (m)

0 0 1 4.9 2 19.6 3 44.1 4 78.4 5 122.5 6 176.4

1. Create a graph using the data provided in Table 1: Linear series.

a. Graph should show the data points on an x-y scatter plot chart type (with data

points shown as markers only, not lines). Choose Time as the independent

variable (x-axis) and Velocity as the dependent variable (y-axis).

b. Fit the data using a linear regression model (Under the Layout tab; Analysis sub

tab; and click on Trendline) and show the linear regression equation inside the

graph.

c. In the graph, also include the regression coefficient (or coefficient of

determination), R2 (Under the Layout tab; Analysis sub tab; Trendline; More

Page 2 of 5

Trendline Options). Make sure the equation and R2 is visible and not blocked by

data or legend.

2. Create a graph using the data provided in Table 2: Power series. Choose Time as the

independent variable (x-axis) and Distance as the dependent variable (y-axis).

a. Graph should contain the data points on an x-y scatter plot (with markers only).

b. Fit a regression model of the data. Choose the model (trendline) that best fits

the data: linear, power, polynomial, etc.

c. Show an equation of the best-fit model and corresponding R2 value inside the

graph.

3. Duplicate the completed graph from Step 2 Using log-transformed values. In your Excel

spreadsheet, add two additional columns to the right of Table 2. In the first added

column, calculate the logarithmic value of Time (s). In the second added column,

compute the logarithmic value of Distance (m).

a. Create a regular scatter plot (with axes in normal scale) by plotting the calculated

log-transformed values following the same steps as in the previous graphs. In

each graph add the best-fit model equation and its associated R2 value.

4. Duplicate the completed graph from Step 2 Using a log-log graph. Use the original

data from Table 2 (without logarithmic transformation). Create a scatter plot but this

time only change the x- and y-axis scales from regular to logarithmic scales. Just as you

performed in the previous steps, provide a best-fit model, regression equation and

associated R2 value. (Hint: The regression equation should read y = 4.9×2)

5. Answer the following questions:

a. For graphs from steps 3 and 4, are the slopes for the equations similar or

different, and why do you think this is so?

b. For graphs from steps 3 and 4, are the intercepts of the model equations similar

or different, and why do you think this is so?

Remember: This is not an actual laboratory experiment, so the report formatting does not

apply. Import your graphs into a Word document and make the graphs presentable; in black

and white and using Calibri font. Points will be deducted for graphs without proper formatting

or if they are missing any of the required elements (e.g., axis lines, axis labels and units, trend

lines, equations, R2 values, etc.). Turn in a printed Word document having 2 graphs per sheet

and one additional page answering the questions.

Page 3 of 5

6. Data Analysis and Statistics. Using the data from Table 3, determine the following with

use of Excel and using the equations provided (below the table):

a. Sample Mean for CBWS temperature dataset ( ix ) and SGWS dataset ( iy ).

b. Separate sample standard deviation (S) for each weather station’s data.

c. Slope and intercept of the linea

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.

Click here to Place your Order Now