| Edition |
Excel edition. |
| Description |
xviii, 403 pages : illustrations ; 26 cm |
| Note |
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. |
| Bibliography |
Includes bibliographical references and index. |
| 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. |
| Subject |
Statistics as Topic.
|
|
Microsoft Excel (Computer file)
|
| ISBN |
1412924812 (cloth : acid-free paper) |
|
9781412924818 (cloth : acid-free paper) |
|
1412924820 (pbk. : acid-free paper) |
|
9781412924825 |
|
