INTRODUCTION TO ENGINEERING DESIGN (EDSGN 100)
202 Rydal (215)-881-7357
Laboratory Experiment 1: Data Collection/Display/Analysis
Report due: February 1, 2016 10AM – WRITE UP THIS LAB INDEPENDENTLY
Quite often in engineering practice, you will collect data on system performance, or as a needs
assessment to determine the best approach to a problem.
A difficult task for the engineer is to
correctly interpret such data.
This is complicated by the fact that automatic/digital data
acquisition can produce large volumes of numbers.
Statistical analysis techniques are often used
to aid in data interpretation and understanding in order to allow the responsible parties to make
appropriate decisions based on the data.
There are college courses in statistics which you can take if you want more information on
appropriate analyses for particular data sets; we will NOT be attempting to learn statistics in this
BUT: we will learn some very simple descriptive statistics and how to interpret and apply
In this experiment, you will collect data and then, using appropriate statistical analysis, reach
conclusions based on the data.
A spreadsheet program (Excel) will be used to analyze and the
plot the data
The statistical analysis techniques used will include:
Determination of means (average) and median values and when to use them
Determination of Standard Deviation – what does it tell you?
Generation of Histograms
Generation of graphs relating one variable to another
Plot the independent variable on the horizontal axis and the dependent variable on
the vertical axis
Evaluate the relationship between these variables using a regression (linear)
Determine the correlation coefficient (R2
) for the curve
Our silly research question:
What are the relationships between height, weight, biceps circumference, shoe size, gender, age
and cash carried for EDSGN100 students?
Collect the following data as instructed:
Your height, in inches
Your weight, in lbs.
Your shoe size (use “US” system)
Your age, in years
Your gender (male, female)
Amount of cash in your pockets/purse/wallet right now
Record your data on the Data Sheet (last page of this handout), then tear off the data sheet and
turn in to the instructor.
DO NOT PUT YOUR NAME ON THE DATA SHEET.
Report mean and median values for all values except gender
Report standard deviations for all values except gender
Generate histograms for:
Weight of Students
Height of Students
Age of Students
Cash carried by students
Correlation / regression
Generate curves for:
Weight (use height as the horizontal axis (independent variable)
Shoe size (use height as the horizontal axis (independent variable)
Cash (use height as the horizontal axis (independent variable)
Calculate the regression equations for the three graphs above, including the correlation
“Interpret” your data.
[I know this isn’t very interesting data, but tell me what the values are and
if they are different from what you expected.
] Values to discuss: means and/or medians; standard
deviations, correlation coefficients (R2
Address each ‘question’.
What conclusions can you draw from these data? Which parameters correlate (that is, which of
the correlation coefficients indicate a correlation)? Does the correlation “make sense” (that is,
would you expect this relationship based on your personal experiences)?
Fill this in, give the sheet to Dr.
DO NOT PUT YOUR NAME ON THIS SHEET
Please enter your height in inches: NOT feet and
For instance, if you are 5'2", you would enter
the number 62.
Don't put anything before or after the
number, just the number.
What is your weight in pounds? Again, just enter the
Measure the circumference of your biceps (upper arm)
to the nearest 1/8”
What is your Shoe Size? If half size, please use .
For example, if your shoe size is 10 1/2, you would
What is your age to the closest year? (no fractions)
What is your gender (choose one – use the letter)
How much cash is in your pockets/purse/wallet right
now? Round to the closest dollar.
(Don't type the dollar
sign, just put in the number)