Skip to main content

Ü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.



Chapter 1. Data and Statistics

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

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

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

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

Linda Herkenhoff, John Fogli

Chapter 5. Survey Design

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

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

Linda Herkenhoff, John Fogli

Chapter 7. Inference

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

Linda Herkenhoff, John Fogli

Chapter 8. Probability

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

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

Coefficient of determination, Method of least squares, Market model, Regression, Residual, Residual plots, Slope, Standardized residuals, y- intercept,

$$ \bar{y} $$




, and

$$ \hat{y} $$


Linda Herkenhoff, John Fogli

Chapter 11. Significance Tests Part 1

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

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.



Linda Herkenhoff, John Fogli

Chapter 13. Multiple Regression

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

Linda Herkenhoff, John Fogli

Chapter 14. Non-linear Regression

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

Linda Herkenhoff, John Fogli

Chapter 15. Survey Reports

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

Linda Herkenhoff, John Fogli


Weitere Informationen

Premium Partner

Neuer Inhalt

BranchenIndex Online

Die B2B-Firmensuche für Industrie und Wirtschaft: Kostenfrei in Firmenprofilen nach Lieferanten, Herstellern, Dienstleistern und Händlern recherchieren.



Product Lifecycle Management im Konzernumfeld – Herausforderungen, Lösungsansätze und Handlungsempfehlungen

Für produzierende Unternehmen hat sich Product Lifecycle Management in den letzten Jahrzehnten in wachsendem Maße zu einem strategisch wichtigen Ansatz entwickelt. Forciert durch steigende Effektivitäts- und Effizienzanforderungen stellen viele Unternehmen ihre Product Lifecycle Management-Prozesse und -Informationssysteme auf den Prüfstand. Der vorliegende Beitrag beschreibt entlang eines etablierten Analyseframeworks Herausforderungen und Lösungsansätze im Product Lifecycle Management im Konzernumfeld.
Jetzt gratis downloaden!