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 linear regression comparing CBWS (X-axis) vs SGWS (Y-axis).

d. Coefficient of determination or regression coefficient (R2) for part (c).

e. Sum of squared error (SEE) for each weather station’s database.

Table 3. Average Ambient Temperatures.

Date Caballo Weather Station

We confidently assure you high-quality work. We engage a number of strategies in to guarantee top-level assignments. The projects go through a thorough system of control prior to being submitted to the customers. Studentscoursework.com guarantees that the assignments delivered are 100 percent plagiarism-free.

We never share or resell customer’s work. Therefore, once it is checked using our plagiarism software, the assignment will be original. In terms of assignment completion, we adhere to the guidelines given by you and assign the work to the most suitable writer. We assign our writers based on various factors such as academic qualification, previous customer feedback, etc.

First and foremost, we provide high-quality work. However, in case you require extra-brilliance, here is what you can do. First, select a top writer who is proficient in a certain discipline. Second, you can seek our editing services.

Our team of editors revises the assignments, checking them to ensure they comply with the standards of academic writings. Additionally, editing may entail refining the language, adding more reference material, and making sure the formatting part is properly done. The editors may also enhance papers completed by yourself in to meet your needs.

We guarantee the following quality in our work to you:

• Properly cited scholarly sources from assigned or outside reading and research.
• No wordy, vague or poorly constructed sentences
• Clearly written and structurally sound sentences, with no grammar, spelling and/or punctuation errors.
• Assignments with proper syntax, which demonstrates mastery of the subject and with clear organization flow.
• Strict adherence to requested citation styles (i.e. APA, MLA, HARVARD, CHICAGO/TURABIAN)
• Proper page numbering, heading, spacing and margins.
• Parenthetical citations are in the proper format, are properly punctuated and are used at appropriate points to document source material.
• Plagiarism free guaranteed work.
• Expert proofreading.

We use the following tools to crosscheck our assignments:

• Turnitin
• Grammarly