Statistics for people who (think they) hate statistics /
This edition shows the students how to install the Excel Analysis ToolPak option (free) to earn access to a host of new and very useful analytical techniques.
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Thousand Oaks :
SAGE Publications,
[2007]
|
| Edition: | Excel ed. |
| Subjects: | |
| Online Access: | Table of contents Publisher description Contributor biographical information Table of contents Publisher description |
Table of Contents:
- pt. I. Yippee! I'm in statistics
- 1. Statistics or sadistics? : it's up to you
- Why statistics?
- And why Excel?
- A five-minute history of statistics
- Statistics : what it is (and isn't)
- What are descriptive statistics?
- What are inferential statistics?
- In other words ...
- Tooling around with the Analysis ToolPak
- What am I doing in a statistics class?
- Ten way to use this book (and learn statistics at the same time!)
- About those icons
- Key to difficulty icons-- Key to "how much Excel" icons
- Glossary
- Summary
- Time to practice
- 1a. All you need to know about formulas and functions
- What's a formula?
- Creating a formula
- Operator, operator, get me a formula!
- Beware the parentheses
- What's a function?
- Using a function
- Using functions in formulas
- We're taking names : naming ranges
- Using ranges
- Summary
- Time to practice
- Answers to practice questions
- 1b. All you need to know about using the amazing data Analysis ToolPak
- A look at a data analysis tool
- Don't have it?
- pt. II. Sigma Freud and descriptive statistics
- 2. Computing and understanding averages : means to an end
- Computing the mean
- And now ... using Excel's AVERAGE function
- Things to remember
- Computing a weighted mean
- Computing the median
- And now ... using Excel's MEDIAN function
- Things to remember
- Computing the mode
- And now ... using Excel's MODE function
- Apple pie à la biomodal
- Using the amazing Analysis ToolPak to compute descriptive statistics
- Make the Analysis ToolPak output pretty
- When to use what
- Summary
- Time to practice
- Answers to practice questions
- 3. Vive la différence : understanding variability
- Why understanding variability is important
- Computing the range
- Computing the standard deviation
- And now ... using Excel's STDEV function
- Why n
- 1? : what's wrong with just n?
- What's the big deal?
- Things to remember
- Computing the variance
- And now ... using Excel's VAR function
- The standard deviation versus the variance
- Using the amazing Analysis ToolPak (Again!)
- Summary
- Time to practice
- Answer to practice questions
- 4. A picture really is worth a thousand words
- Why illustrate data?
- Ten ways to a great figure (eat less and exercise more?)
- First things first : creating a frequency distribution
- The classiest of intervals
- The plot thickens : creating a histogram
- The tally-ho method
- Using the amazing Analysis ToolPak to create a histogram
- The next step : a frequency polygon
- Cumulating frequencies
- Fat and skinny frequency distributions
- Average value
- Variability
- Skewness
- Kurtosis
- Excellent charts
- Your first Excel chart : a moment to remember
- Excellent charts part deux : making charts pretty
- Other cool charts
- Bar charts
- Line charts
- Pie charts
- Summary
- Time to practice
- Answer to practice questions
- 5. Ice cream and crime : computing correlation coefficients
- What are correlations all about?
- Types of correlation
- Coefficients : flavor 1 and flavor 2
- Things to remember
- Computing a simple correlation coefficient
- And now ... using Excel's CORREL function
- A visual picture of a correlation : the scatterplot
- Using Excel to create a scatterplot
- Bunches of correlations : the correlation matrix
- More Excel, bunches of correlations à la Excel
- Using the amazing Analysis ToolPak to computer correlations
- Understanding what the correlation coefficient means
- Using-your-thumb rule
- A determined effort : squaring the correlation coefficient
- As more ice cream is eaten ... the crime rate goes up (or association versus causality)
- Other cool correlations
- Summary
- Time to practice
- Answers to practice questions.
- pt. III. Taking chances for fun and profit
- 6. Hypotheticals and you : testing your questions
- So you want to be a scientist ...
- Samples and populations
- The null hypothesis
- The purpose of the null hypothesis
- The research hypothesis
- The nondirectional research hypothesis
- The directional research hypothesis
- Some differences between the null hypothesis and the research hypothesis
- What makes a good hypothesis?
- Summary
- Time to practice
- Answer to practice questions
- 7. Are your curves normal? : probability and why it counts
- Why probability?
- The normal curve (a.k.a. the bell-shaped curve)
- Hey, that's not normal!
- More normal curve 101
- Our favorite standard score : the z score
- Using Excel to computer z scores
- What z scores represent
- What z scores really represent
- Hypothesis testing and z scores : the first step
- Summary
- Time to practice
- Answers to practice questions.
- pt. V. Ten things you'll want to know and remember
- 19. The ten (or more) best Internet sites for statistics stuff
- Tons and tons of resources
- Calculators galore!
- Who's who and what's happened
- It's all here
- HyperStat
- Data? : you want data?
- More and more and more and more resources
- Plain, but fun
- How about studying statistics in Stockholm?
- Online statistical teaching materials
- More and more and more stuff
- 20. The ten commandments of data collection
- Appendix A. Excel-erate your learning : all you need to know about Excel
- Appendix B. Tables
- Appendix C. The data sets
- Glossary.