12600 ENGR Spring 2009
Laboratory 3
Task 1
Task 1 Data Measurements
(Estimated Time = 15-20 minutes)
In this task, each team member will learn how to use calipers to measure a length and width.
1. Use Use dial calipers to measure the length (long dimension) and width (maximum
dimension perpendicular to the length) of 10 sunflower seeds. Record your measurements to
3 decimal places in the table below.
Sample
Number
Length
(in)
Width
(in)
Sample
Number
1
7
3
8
4
9
5
Width
(in)
6
2
Length
(in)
10
2. In Microsoft Excel, resave your probtemplate.xlsx as lab3task1yourlogin.xlsx (use your
own login in the file name) and properly comment the file.
3. In your Microsoft Excel file, enter your measurement data in the Input Section as follows:
a. In Row 7, enter column labels with units for the Sample Number in Column A, Length in
Column B, and Width in Column C.
b. Starting in Row 8, enter your measurement data for the Sample Number in Column A,
measured length in Column B, and measured width in Column C.
4. Submit this file on Blackboard under the Lab 3 link: Lab 3 - Task 1 Submittal.
ENGR 12600 Spring 2009
Laboratory 3
Task 2
Task 2 Uploading Data to MATLAB
and Descriptive Statistics
(Estimated Time = 30 minutes)
In this task, each student will learn how to load data into MATLAB.
Consider this situation: As an industrial engineer working for an automotive company, one of
your responsibilities is the manufacture of a shaft, which requires milling a bearing journal. (A
journal is the part of a rotating shaft, axle, or spindle that turns in a bearing.) You study this
process by measuring a sample of the shafts as they come off the line until you have a sample
size of 26.
Sample Number
1
2
3
4
5
6
7
8
9
10
11
12
13
Diameter (inches)
20.541
20.425
20.475
20.547
20.678
20.651
20.531
20.580
20.558
20.677
20.400
20.408
20.526
Sample Number
14
15
16
17
18
19
20
21
22
23
24
25
26
Diameter (inches)
20.537
20.591
20.515
20.479
20.648
20.437
20.581
20.692
20.539
20.413
20.743
20.415
20.537
1. The above data are available in electronic form from the Lab 3 links on Blackboard in a file
named journal_diam.txt. Save journal_diam.txt to your career account.
2. In MATLAB, resave your probtemplate.m as lab3task2.m and properly comment the file.
3. In the script file, load the data set journal_diam.txt using the load command. Examples are:
load journal_diam.txt
load journal_diam.txt
S = load(journal_diam.txt)
4. In your script, compute the mean, median, standard deviation, minimum, and maximum of
the journal diameters measured above. Record the results for each statistic as comments
under the output section in your script file.
ENGR 12600 Spring 2009
Laboratory 3
Task 3
Task 3 Histograms using MATLAB
(Estimated Time = 30 minutes)
In this task, each student will learn how to generate and manipulate histograms using MATLAB.
Use the data from Task 2 to complete this task.
1. Re-save your lab3task2.m file as lab3task3.m
2. Your script will:
a. Use the hist command to generate a histogram with 10 bins as Figure 1 (use the
MATLAB helpbrowser or the textbook to learn more about the hist command).
b. Add labels to the x and y axes and add a title the plot (use the same commands as those
used for x-y scatter plots).
c. Use the hist command again to return the number of data points in each bin and the
center points of each bin.
d. Determine which bins contain samples 2 and 3 and record your results in the table below
(try using the sort command to sort the vector of diameters).
e. Use the hist command to generate a histogram with 8 bins Figure as 2. Label the x and y
axes and add a title.
f. Repeat steps c. and d. to determine which bins contain samples 2 and 3 in this histogram
and record your results in the table below.
g. Create a histogram with bins centered at 20.4, 20.45, 20.5, 20.55, 20.6, 20.65, 20.7, and
20.75 as Figure 3. Label the x and y axes and add a title.
h. Repeat steps c. and d. to determine which bins contain samples 2 and 3 in this histogram
and record your results in the table below. Determine which bins contain samples 2 and
3.
Result from above
Sample #
2
Step d.
3
2
Step f.
3
2
Step h.
3
Bin #
ENGR 12600 Spring 2009
Laboratory 3
Task 4
Task 4 Importing Data into EXCEL
and Descriptive Statistics
(Estimated Time = 20-30 minutes)
In this task, each student will learn how to load data into MATLAB.
1. Open the file journal_diam.txt in EXCEL and let EXCEL guess the format.
2. In EXCEL, resave your probtemplate.xlsx as lab3task4.xlsx and properly comment the file.
3. Copy the imported data from step 1 and paste it under the Input section in your file
lab3task4.xlsx.
a. The data label (including units) should be entered in cell A7.
b. The journal diameter data should start in cell A8.
4. Under the Calculation section, use EXCEL functions to calculate the mean, median, standard
deviation, minimum, and maximum of the journal diameters.
a. Column D should contain the labels (including units) for each of the descriptive statistics
being calculated (use cells D7 through D11).
b. Column E should contain the calculations (cells E7 through E11).
ENGR 12600 Spring 2009
Laboratory 3
Task 5
Task 5 Histograms in EXCEL
(Estimated Time = 30 minutes)
In this task, each student will learn how to construct a histogram using EXCEL.
1. Open Microsoft Excel and install the Analysis ToolPak as follows:
a. Click the Microsoft Office Button (upper-left hand corner button), and then click Excel
Options.
b. Click Add-Ins.
c. In the Manage box, click Excel Add-ins, and then click Go.
d. In the Add-Ins available box, select the Analysis ToolPak check box, and then click
OK.
2. Re-save your lab3task4.xlsx file as lab3task5.xlsx, and properly comment the file.
3. In your Microsoft Excel file, generate a histogram of the journal diameter measurements as
follows:
a. Under the Calculation Section, in Column D, create a set of bin intervals for the
diameter measurements.
i.
In cell D13, create a label titled interval spacing.
ii. In cell E13, calculate the interval spacing. To determine the interval spacing,
subtract the minimum diameter from the maximum diameter, and divide by the
number of bins being created (use 8 bins).
iii. In cell D15, create a label titled bin intervals.
iv. Starting in cell D16, create your 8 bin intervals. (hint: the first value is the minimum
plus the interval spacing).
b. Create the histogram of Diameters as follows:
i.
Select the Data menu, then select the Data Analysis Icon.
ii.
In the Data Analysis pop-up window, select Histogram, then click OK.
iii.
In the Histogram pop-up window, click the box next to Input Range box and
select the length data.
iv.
Click the box next to Bin Range and select the length bin data you created.
v.
Select Output Range radio-button, then click the box next to Output Range.
Select cell G7, which located in the Output Section.
vi.
Check the Chart Output box.
vii. Click OK. Your journal diameter histogram appears the Output Section. If the bin
spacing you selected is not appropriate, delete the histogram, change your bin data,
and repeat steps i) through vii).
viii. Modify the x-axis label and title.