Home Computers
 

Using Excel for Statistical Analysis - Terms You Should Understand Before You Start by Stephen Nelson

(Contd. from page 1...)

Unless otherwise stated, the Excel functions make a critical assumption regarding the process used to select the sample: they assume that the sample drawn was drawn at random, so in this case, every household would have the same likelihood (probability) of being selected.

Tip: When making statements about a population, it is wise to verify the selection process used to form the sample. For example, if the sample were formed by randomly selecting entries from a phone book, this is not random selection of the sample-it excludes households with unlisted numbers or no telephones and includes households with multiple telephone book entries multiple times. The households don't have the same probability of being selected.

Elements versus Variables

When describing the data in a set, each member of the set is called an element. So if you're describing customers, each customer is an element. The characteristics of interest in the elements are called variables. So if you're looking at annual income, age, and sales, these would be your variables.

The experimenter manipulates the independent variable and measures the dependent variable after the manipulation to see whether it experienced any effects. A random variable describes the outcome of an experiment numerically. It can take on different values or ranges with certain probabilities. The collective group of measurements obtained for an element is called an observation.

Browse Pages

About Stephen Nelson
About the author: Seattle CPA Stephen L. Nelson wrote the bestselling book, MBA's Guide to Microsoft Excel, from which this short article is adapted. Nelson also writes and edits downloadable do-it-yourself incorporation kits that businesses and investors can use for setting up an Missouri incorporation or an Montana incorporation.
Categories

Did you know?
French astronomer Adrien Auzout had once considered building a telescope that was 1,000 feet long in the 1600s. He thought the magnification would be so great, he would see animals on the moon.

Heh Heh Heh...
One summer evening, a 3-year-old came in while his parents were setting the table for supper. Quite surprisingly, he asked if he could help. His mother said, "No, but I appreciate your asking."
The child responded, "Well, I appreciate your saying no."

© 2008 Saj Infotech • All rights reserved.