nach oben

2013 | Buch

Applied Statistics for Business and Management using Microsoft Excel

verfasst von: Linda Herkenhoff, John Fogli

Verlag: Springer New York

Enthalten in: Springer Professional "Wirtschaft+Technik" , Springer Professional "Technik" , Springer Professional "Wirtschaft"

Einloggen, um Zugang zu erhalten

Über dieses Buch

Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.

Inhaltsverzeichnis

Frontmatter

Chapter 1. Data and Statistics

Abstract

Business statistics, Constant, Continuous data, Cross sectional data, Data, Descriptive statistics, Discrete data, Distribution, Frequency, Inferential statistics, Longitudinal data, Population, Probability, Qualitative data, Quantitative data, Random sample, Sample, Scales, Statistics, and Variables.

Linda Herkenhoff, John Fogli

Chapter 2. Introduction to Excel and Basic Charts

Abstract

Area charts, Bar and Column charts, Bubble charts, Filtering, Formatting, Line charts, Pie charts, Pivot Tables, Sorting, Radar charts.

Linda Herkenhoff, John Fogli

Chapter 3. Summarizing Data: Descriptive Statistics and Histograms

Abstract

Central tendency, Dispersion, Histogram, Kurtosis, Mean, Median, Mode, Range, Sample variance, Skewness, Standard deviation, and Standard error.

Linda Herkenhoff, John Fogli

Chapter 4. Normal Distributions

Abstract

Chebyshev approximation, Normal distribution, Percentiles, Standard deviation, Standard units, and z-score.

Linda Herkenhoff, John Fogli

Chapter 5. Survey Design

Abstract

Bias, Bipolar scale, Extreme checking, Likert scale, Nonprobability sampling, Primary data, Probability sampling, Random sampling, Random sampling error, Response rates, Reversed items, Secondary data and Systematic error.

Linda Herkenhoff, John Fogli

Chapter 6. Sampling

Abstract

Accuracy, Confidence level, Finite population, Infinite population, Proportion, Homogeneity, Population, Sample size, and Standard error.

Linda Herkenhoff, John Fogli

Chapter 7. Inference

Abstract

Confidence interval, Estimator, Expected value, Population, Sample, and Standard error.

Linda Herkenhoff, John Fogli

Chapter 8. Probability

Abstract

Addition Rule, Binomial distribution, Complement rule, Combinations, Factorial function, Conditional probability, Dependence, Multiplication Rule, Mutual exclusivity, Permutations, and Probability, Probability density function, Random variable, With and Without replacement.

Linda Herkenhoff, John Fogli

Chapter 9. Correlation

Abstract

Association, Correlation coefficient, Correlation matrix, Causation, Direct relationship, Inverse relationship, Pearson correlation coefficient, and Positive relationship.

Linda Herkenhoff, John Fogli

Chapter 10. Simple Linear Regression

Abstract

Coefficient of determination, Method of least squares, Market model, Regression, Residual, Residual plots, Slope, Standardized residuals, y- intercept, \( \bar{y} \), y _i, and \( \hat{y} \).

Linda Herkenhoff, John Fogli

Chapter 11. Significance Tests Part 1

Abstract

Alternate hypothesis, Chi-square test, Confidence level, Critical values, Cronbach’s alpha, Degrees of freedom, F-test, Hypothesis, Null hypothesis, Precision, Reliability, Statistical Significance, t-test, Validity, X²-test, and z-test.

Linda Herkenhoff, John Fogli

Chapter 12. Significance Tests Part 2

Abstract

The significance tests covered in this chapter include the X² test and the z test. The conditions for selecting either of these significance tests are included in this chapter. See Fig. 12.1.

Linda Herkenhoff, John Fogli

Chapter 13. Multiple Regression

Abstract

Adjusted coefficient of determination, Law of Parsimony, Multicollinearity, and Multiple regression.

Linda Herkenhoff, John Fogli

Chapter 14. Non-linear Regression

Abstract

Exponential function, Logarithmic function, Polynomial function, and Power function.

Linda Herkenhoff, John Fogli

Chapter 15. Survey Reports

Abstract

Cross-tabulation, Conclusions and Recommendations, Executive summary, Multi-analysis report, Overall report, and Pilot testing

Linda Herkenhoff, John Fogli

Backmatter

Titel: Applied Statistics for Business and Management using Microsoft Excel
verfasst von: Linda Herkenhoff
John Fogli
Verlag: Springer New York
Electronic ISBN: 978-1-4614-8423-3
Print ISBN: 978-1-4614-8422-6
DOI: https://doi.org/10.1007/978-1-4614-8423-3