Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Statistical Analysis Lab - Instrumentation and Measurement | MECH 591, Lab Reports of Mechanical Engineering

Material Type: Lab; Professor: Duva; Class: INSTRUMENTATION & MEASUREMENT; Subject: Mechanical; University: Wentworth Institute of Technology; Term: Spring 2008;

Typology: Lab Reports

Pre 2010

Uploaded on 08/19/2009

koofers-user-34v
koofers-user-34v 🇺🇸

10 documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
MECH 519- Instrumentation and measurement, Spring 2008
Statistical analysis lab
Introduction
There are two distinguished models for describing the events in science and
engineering.
One is the deterministic model, in which the relationship among a dependent
variable and independent variables is strictly and accurately described by a governing
equation. In this type of model, the outcome is predictable and solely determined by
independent variables. The physical meaning of this type of models is that all possible
mechanism or issues about the relationship among the dependent and independent
variables are fully understood and fully considered.
Another model is the statistical or probabilistic model. In this model, the outcome
is not predictable so that the value of the dependent variable should be described by a
random variable. There are two main causes for this phenomenon:
(1) Some mechanism for governing the relationship among the dependent
variable and independent variables are not fully understood. When these
mechanisms are fully understood, the statistical or probabilistic model can be
replaced by the deterministic model. Weather forecast is a good example.
With more advanced technology, current weather forecast is more reliable.
(2) Some mechanisms are very hard to be fully controlled. For example, human
error is very hard to be fully controlled. For another example, the
microstructure of a material is very hard to be fully controlled. If the material
composition and the microstructure of material are fully controlled, the yield
strength of this material will be a constant. Actually, the yield strength of the
same brand material is not a constant due to the variation of composition and
the microstructure of the material.
The statistical analysis or probability theory is a good tool to deal with uncertainty
or randomness. People will use information based on probabilistic theory to make their
decision. However, proper interpretation of information, data or conclusion from
probabilistic theory is a must because statistical model can only provide imperfect and
incomplete information. .
Objectives
In this statistical analysis lab, the main goal is to apply the several basic concepts
in statistical theory discussed in class to assess measurement uncertainty. The objectives
of this statistical analysis lab are:
To calculate the mean and standard deviation of a set of data
To create the histogram
To determine the confidence intervals with given confidence level
To apply the 6 sigma principle to judge some data
To run simple linear regression and determine the uncertainty of the fitting line.
Notes: Submit the lab report in the format of a word file
1
pf3
pf4
pf5

Partial preview of the text

Download Statistical Analysis Lab - Instrumentation and Measurement | MECH 591 and more Lab Reports Mechanical Engineering in PDF only on Docsity!

Statistical analysis lab

Introduction

There are two distinguished models for describing the events in science and engineering. One is the deterministic model, in which the relationship among a dependent variable and independent variables is strictly and accurately described by a governing equation. In this type of model, the outcome is predictable and solely determined by independent variables. The physical meaning of this type of models is that all possible mechanism or issues about the relationship among the dependent and independent variables are fully understood and fully considered. Another model is the statistical or probabilistic model. In this model, the outcome is not predictable so that the value of the dependent variable should be described by a random variable. There are two main causes for this phenomenon: (1) Some mechanism for governing the relationship among the dependent variable and independent variables are not fully understood. When these mechanisms are fully understood, the statistical or probabilistic model can be replaced by the deterministic model. Weather forecast is a good example. With more advanced technology, current weather forecast is more reliable. (2) Some mechanisms are very hard to be fully controlled. For example, human error is very hard to be fully controlled. For another example, the microstructure of a material is very hard to be fully controlled. If the material composition and the microstructure of material are fully controlled, the yield strength of this material will be a constant. Actually, the yield strength of the same brand material is not a constant due to the variation of composition and the microstructure of the material. The statistical analysis or probability theory is a good tool to deal with uncertainty or randomness. People will use information based on probabilistic theory to make their decision. However, proper interpretation of information, data or conclusion from probabilistic theory is a must because statistical model can only provide imperfect and incomplete information..

Objectives

In this statistical analysis lab, the main goal is to apply the several basic concepts in statistical theory discussed in class to assess measurement uncertainty. The objectives of this statistical analysis lab are:  To calculate the mean and standard deviation of a set of data  To create the histogram  To determine the confidence intervals with given confidence level  To apply the 6 sigma principle to judge some data  To run simple linear regression and determine the uncertainty of the fitting line.

Notes: Submit the lab report in the format of a word file

Question 1: A steel manufacturer produces a brand of steel for a long time. A lot of data about the yield strength of this material have been cumulated from tensile experiment and measurement. 200 test data of the yield strength of this material is listed in the attached excel file. Use Microsoft Excel as a tool to complete following question. (1) The mean and standard deviation of this data a. Use “AVERAGE ( number1 , number2,...)” to calculate the mean b. Use “ STDEVPA ( value1 , value2,...)” to calculate the standard deviation (2) Based on these 200 measurements, the yield strength is in the range of from 94 ksi to 142 ksi. Use the bin listed in column B to create frequency histogram by use of the data analysis tool “Histogram” in Excel. (Read the appendix to learn how to use “Histogram” in Excel if you don’t know how to “histogram”.) (3) It is assumed that the test data of the yield strength can be described by the normal distribution. Use the mean and standard deviation obtained from question (1) as the mean and standard deviation of the normal distribution. Calculate the probability of a yield strength which is larger than 100 ksi and less than 140 ksi, that is, (^)    ^ ^   ^     b a x P x e dx 2 2 1 2 1 ( 100 140 )^    

. Use the equation provided in the lecture and table 3.2 on page 50 to run the calculation. (4) The test engineer used the steel produced in a week to make the tensile test sample and did three tensile tests. The yield strength for those three tests was 151 ksi, 149 ksi and 143 ksi. Then the test engineer told the production manager that something might be wrong with the steel manufacturing process. Can you explain to the production manager why? (Hint: try to use 6 sigma principles to support your argument.) (5) Provide the 95% confidence level for mean of yield strength of this brand steel. Question 2:

Appendix Use “histogram” in Excel (1) If you do not see “data analysis” in “tools”, add the “Analysis toolPack”. (2) Access to analysis tool “histogram”

(3) Use the Histogram Select the “input range”, which is the test data. And select the “bin range” and “output location”. Also check “chart output”.