This preview shows pages 1–2. Sign up to view the full content.
Basic Statistical Analysis of Data
♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦♦
Statistics Worksheet
Complete as directed by your laboratory instructor.
Submit when completed.
Be sure to include proper units as appropriate.
Remember to be concise; use complete sentences as appropriate; answer only what is asked of
you; and answer all parts of the question.
Do NOT answer with long rambling confluent
paragraph.
Maintain the formatting subsections below (A,B,
etc
as labeled in the question).
(1) Regarding the Normal Distribution worksheet in MS Excel:
(a.)Review what a normal distribution is and how one can be constructed using MS Excel.
What information is required to make a normal distribution histogram using MS Excel?
What percentage of data is included within one standard deviation of the sample mean if the
data is normally distributed?
(b.)What happens to the distribution when the mean (average) value is increased?
(c.)What happens to the distribution when the mean (average) value is decreased?
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
 Fall '07
 Hanson
 molecular biology

Click to edit the document details