Create a regular scatter plot with the calculated log

Question

Fluid mechanics laboratory

Assignment On Importing Excel graphs into Microsoft Word

Create four graphs in Excel using the data from tables 1 and 2. Follow every step and create complete, aesthetically pleasing graphs. 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.

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 (s)	Distance, d (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 Distance as the dependent variable (y-axis).

b. Provide a fitted linear regression model of the data (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, R2 (Under the Layout tab; Analysis sub tab; Trendline; More Trendline Options). Provide the R2 value next to, or below the linear equation.

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 R² 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 the calculated log values following the same directions as in steps 1 and 2 (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; however, 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.9x²)

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: Import your graphs into a Word document, as shown during the lab (make graphs presentable; in black and white; Times or 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.