excel assignment

Lab 6 – Natural & Synthetic Material Density Analysis

Instructions: Utilize the spreadsheet example performed in class to complete this assignment, and GO TO THE

TA’S FOR HELP! The student will be responsible for writing a lab report to document the necessary steps,

equipment, procedure, etc. to EGR 150 Report Guidelines. In addition, the student must design an excel

spreadsheet that meets the following criteria below.

Due Date: Please refer to Blackboard under ‘Course Info’ for assignment deadlines

1. In Excel, calculate and document in a table, the unit conversion relationships to convert the raw data collected during the materials labs to kg/m3 for both labs:

a. When it is written as km2, it should be noted as km2 for each unit type b. Enter in a table with the appropriate headings and same as performed with the in-class example.

2. Create an additional table from each of the conversion type’s final solution. The table will consist of two columns (individual & group densities) & (dry vs saturated); whereas the first column lists the

control metric on the x-axis and the other unit on the y-axis.

a. All 16 different materials must be included in the plotted data set.

b. 3. Create a chart that plots the ordered pairs for the second requirements (shown above).

a. Reformat each chart on back to replicate the formatting (i.e. same as in-class example). 4. Add a trend line (linear) to the set of data points, and display the equation and coefficient of correlation

value (r2).

a. An example of a finalized graph is shown on the back with the trend line, equation, and r2. 5. Rename each of the seven different Excel tabs to the corresponding content (i.e. Tab = Content)

1) Raw Data & Conversions = Steps 1 & 2 2) Ind. vs Grp = Steps 3 & 4 (Materials Lab 1) 3) Dry Density vs Saturated Density = Repeat of steps 3 & 4 (Materials Lab 2)

6. Save your file with the name ‘Last Name_Lab_6’ on BB under ‘Course Work’. Only an Excel file will be accepted to receive a grade. All other file types will receive a zero.

Figure 1 – Microsoft Excel Formatted Scatter Chart per Two Units

Figure 2 – Microsoft Excel Formatted Scatter Plot with Trendline, Equation, & R2 per Two Units