Data Manipulations with Excel This assignment is to give you practice with communicating data and analysis in a visual format but specific to numbers collected in the process of your own research.

ENGR 1201: Introduction to Engineering

Department of Civil Engineering

Lesson 8 Handout

Topic: Excel & Data Manipulation (Computer Tools)

Example 1

A tension test was performed on a circular steel specimen having an original diameter of and a gauge length of . The data is listed in the table. Plot the stress-strain diagram and determine approximately the modulus of elasticity, the yield stress, the ultimate stress, and the rupture stress.

Example of Stress-Strain Diagram

Load vs. Displacement Data

Data Manipulations with Excel This assignment is to give you practice with communicating data and analysis in a visual format but specific to numbers collected in the process of your own research. 1

Load (kips)	Elongation (in)

1.50	0.0005
4.60	0.0015
8.00	0.0025
11.00	0.0035
11.80	0.0050
11.80	0.0080
12.00	0.0200
16.60	0.0400
20.00	0.1000
21.50	0.2800
19.50	0.4000
18.50	0.4600

Note: You are given load vs. displacement data. You need to convert it into stress and strain. Plot your results using Excel as x-y scatter points connected by lines (if you prefer to use a different program to generate the graph that is fine also).

Example 2

A tension test was performed on a circular brass specimen having an original diameter of and a gauge length of . The data is listed in the table in Excel. Plot the stress-strain diagram.