excel assignment

Lab 5 – Unit Conversion Relationship & Regression 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 lab to kg/m3. between these units for each property type:

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); 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

6. Save your file with the name ‘Last Name_Lab_5’ 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