Create a regular scatter plot with the calculated log values

Assignment Help Mechanical Engineering

Reference no: EM13773569

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.

Reference no: EM13773569

Questions Cloud

The computer hardware of the early 1950s : Speedcoding was invented to overcome two significant shortcomings of the computer hardware of the early 1950s. What were they? Why was the slowness of interpretation of programs acceptable in the early 1950s?

Managing an organization is infrastructure : Write a 700- to 1,050-word paper discussing managerial issues associated with managing an organization's IS infrastructure.

Particular environmental law : As an environmentalist, you are very interested in how economics plays a role in determining how many and what type of environmental laws are passed. There are many environmental laws that are determined by economic conditions.

Should transportation security regulations be changed : Should Transportation Security (TSA) regulations be changed? Should funding for the U.S. space program be changed?

Create a regular scatter plot with the calculated log values : 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).

The organizations core competencies : As a manager of a health care organization, your goal is to create a successful environment for customers, patients, and staff, and planning is what makes this possible.

Provide an introduction body and conclusion : Provide an Introduction, Body, and Conclusion. Identify the main points and sections of the Research Project. Identify the sub-topics and details consistent with the main points and sections

What amount of oxygen is needed : Given the reaction CH4+2O2-->CO2+2H2O, what amount of oxygen is needed to completely react with 1 mol of CH4?

A resource for each level of government : Describe the local, state, and national resources which are available for addressing unintentional and intentional injuries in American communities.

User Account

All Pages