Basic Statistics Using Excel and MegaStat w Student CD

James Burdeane Deane Orris J.B. Orris is a professor of management science at Butler University in Indianapolis, Indiana. He received his Ph.D. from the University of Illinois in 1971, and in the late 1970s with the advent of personal computers, he combined his interest in statistics and computers to write one of the first personal computer statistics packagesMICROSTAT. Over the past 20 years, MICROSTAT has evolved into MegaStat, which is an Excel add-in statistics program. In 1999 he wrote an Excel book (Essentials: Excel 2000 Advanced) and has done work in neural networks, spreadsheet simulation, and statistical analysis for many research projects. He has taught statistics and computer courses in the College of Business Administration of Butler University since 1971. He is a member of the American Statistical Association and is past president of the Central Indiana Chapter. In his spare time, Professor Orris enjoys reading, working out, and working in his woodworking shop.

Chapter 1 IntroductionChapter 2 Descriptive StatisticsChapter 3 Frequency DistributionsChapter 4 Probability ConceptsChapter 5 Discrete Probability DistributionsChapter 6 Normal DistributionChapter 7 Sampling and Sampling DistributionsChapter 8 Confidence IntervalsChapter 9 Hypothesis Testing ConceptsChapter 10 Hypothesis Testing ApplicationsChapter 11 Analysis of VarianceChapter 12 Linear Regression AnalysisChapter 13 Multiple RegressionChapter 14 Chi-Square ApplicationsChapter 15 Time-Series AnalysisChapter 16 Summary and IntegrationAppendix A: Excel Statistical FunctionsAppendix B: Hypothesis Test SummariesAppendix C: Glossary and Key EquationsAppendix D: TablesAppendix E: Tutorial List