Statistical Analysis with Excel For Dummies. Joseph Schmuller
Чтение книги онлайн.

Читать онлайн книгу Statistical Analysis with Excel For Dummies - Joseph Schmuller страница 15

Название: Statistical Analysis with Excel For Dummies

Автор: Joseph Schmuller

Издательство: John Wiley & Sons Limited

Жанр: Программы

Серия:

isbn: 9781119844563

isbn:

СКАЧАТЬ job of a statistician — to use the findings from a sample to make a decision about the population from which the sample comes. But sometimes those decisions don’t turn out the way the numbers predict. History buffs are probably familiar with the memorable photo of President Harry Truman holding up a copy of the Chicago Daily Tribune with the famous, but incorrect, headline “Dewey Defeats Truman” after the 1948 election. Part of the statistician’s job is to express how much confidence they have in the decision.

      Another election-related example speaks to the idea of the confidence in the decision. Pre-election polls (again, assuming a representative sample of voters) tell you the percentage of sampled voters who prefer each candidate. The polling organization adds how accurate it believes the polls are. When you hear a newscaster say something like “accurate to within 3 percent,” you're hearing a judgment about confidence.

      Here’s another example. Suppose you’ve been assigned to find the average reading speed of all fifth grade children in the United States but you haven’t got the time or the money to test them all. What would you do?

      Your best bet is to take a sample of fifth-graders, measure their reading speeds (in words per minute), and calculate the average of the reading speeds in the sample. You can then use the sample average as an estimate of the population average.

      

Here’s some terminology you have to know: Characteristics of a population (like the population average) are called parameters, and characteristics of a sample (like the sample average) are called statistics. When you confine your field of view to samples, your statistics are descriptive. When you broaden your horizons and concern yourself with populations, your statistics are inferential.

And here’s a notation convention you have to know: Statisticians use Greek letters ((μ, σ, ρ) to stand for parameters, and English letters
, s, r) to stand for statistics. Figure 1-1 summarizes the relationship between populations and samples, and between parameters and statistics.

      FIGURE 1-1: The relationship between populations and samples, and between parameters and statistics.

      Variables: Dependent and independent

      Simply put, a variable is something that can take on more than one value. (Something that can have only one value is called a constant.) Some variables you might be familiar with are today’s temperature, the Dow Jones Industrial Average, your age, and the value of the dollar against the euro.

      Statisticians care about two kinds of variables: independent and dependent. Each kind of variable crops up in any study or experiment, and statisticians assess the relationship between them.

      For now, understand that the independent variable here is the method of instruction. The two possible values of this variable are new and traditional. The dependent variable is the improvement in reading speed (a child’s speed after instruction minus that child’s speed before instruction) — which you would measure in words per minute.

      

In general, the idea is to find out if changes in the independent variable are associated with changes in the dependent variable.

      

In the examples that appear throughout the book, I show you how to use Excel to calculate characteristics of groups of scores. Keep in mind that each time I show you a group of scores, I'm really talking about the values of a dependent variable.

      Types of data

      Data come in four kinds. When you work with a variable, the way you work with it depends on what kind of data it is.

      The first variety is called nominal data. If a number is a piece of nominal data, it’s just a name. Its value doesn't signify anything. A good example is the number on an athlete’s jersey. It’s just a way of identifying the athlete. The number has nothing to do with the athlete’s level of skill.

      Next come ordinal data. Ordinal data are all about order, and numbers begin to take on meaning over and above just being identifiers. A higher number indicates the presence of more of a particular attribute than a lower number. One example is the Mohs scale: Used since 1822, it’s a scale whose values are 1 through 10; mineralogists use this scale to rate the hardness of substances. Diamond, rated at 10, is the hardest. Talc, rated at 1, is the softest. A substance that has a given rating can scratch any substance that has a lower rating.

      What’s missing from the Mohs scale (and from all ordinal data) is the idea of equal intervals and equal differences. The difference between a hardness of 10 and a hardness of 8 is not the same as the difference between a hardness of 6 and a hardness of 4.

      Here’s something that might surprise you about Fahrenheit temperatures: A temperature of 100 degrees isn’t twice as hot as a temperature of 50 degrees. For ratio statements (twice as much as, half as much as) to be valid, zero has to mean the complete absence of the attribute you're measuring. A temperature of 0 degrees F doesn’t mean the absence of heat — it’s just an arbitrary point on the Fahrenheit scale.

      The last data type, ratio data, includes a meaningful zero point. For temperatures, the Kelvin scale gives ratio data. One hundred degrees Kelvin is twice as hot as 50 degrees Kelvin. This is because the Kelvin zero point is absolute zero, where all molecular motion (the basis of heat) stops. Another example is a ruler. Eight inches is twice as long as four inches. A length of zero means a complete absence of length.

      

Any of these data types can form the basis of an independent variable or a dependent variable. The analytical tools you use depend on the type of data you’re dealing with.

      A little probability

СКАЧАТЬ