Microsoft Excel Tutorial

Short Description
Statistical Analysis. by Dr. James E. Parks. Department of Physics and Astronomy. 401 Nielsen Physics Building. The University of Tennessee …

Website: www.phys.utk.edu | Filesize: 205kb

Content
Statistical Analysis
by Dr. James E. Parks
Department of Physics and Astronomy
401 Nielsen Physics Building
The University of Tennessee
Knoxville, Tennessee 37996-1200
Copyright . August, 2000 by James Edgar Parks*
*All rights are reserved. No part of this publication may be reproduced or transmitted in any form or by
any means, electronic or mechanical, including photocopy, recording, or any information storage or
retrieval system, without permission in writing from the author.
Objective: The objectives of this experiment are: (1) to understand how to find the
average value, the median value, the standard deviations, and the standard deviation of
the mean for a set of measurements that conform to a normal distribution, and (2) to use
these values for a set of measurements to fit a gaussian distribution to the actual data.
Another objective is to help become proficient in the use of an Excel spreadsheet for data
analysis.
Theory
Probably the most elusive factor to establish in all of the experiments is to determine the
degree of certainty in the results. The basic tool is the variance of the data.
Probability and statistics is a very complex field. Many people have made a lifetime
career…