book

Business Statistics For Dummies, 2nd Edition

by Alan Anderson

January 2024

Beginner

400 pages

9h 3m

English

For Dummies

Read now

Unlock full access

Copyright
About This BookFoolish AssumptionsIcons Used in This BookBeyond the BookWhere to Go from Here
Representing the Key Properties of DataProbability: The Foundation of All Statistical AnalysisUsing Sampling Techniques and Sampling DistributionsStatistical Inference: Drawing Conclusions from Data
Analyzing the Distribution of Data by Class or CategoryHistograms: Getting a Picture of Frequency DistributionsChecking Out Other Useful Graphs
Looking at Methods for Finding the MeanGetting to the Middle of Things: The Median of a Data SetDetermining the Relationship Between the Mean and MedianDiscovering the Mode: The Most Frequently Repeated ElementComputing the Mean, Median, and Mode with the TI-84 Plus Calculator
Determining Variance and Standard DeviationFinding the Relative Position of DataMeasuring Relative VariationComputing Measures of Dispersion with the TI-84 Plus Calculator
Understanding Covariance and CorrelationInterpreting the Correlation CoefficientComputing Covariance and Correlation with the TI-84 Plus Calculator

Working with SetsBetting on Uncertain OutcomesLooking at Types of ProbabilitiesFollowing the Rules: Computing Probabilities
Defining the Role of the Random VariableAssigning Probabilities to a Random VariableCharacterizing a Probability Distribution with Moments
Looking at Two Possibilities with the Binomial DistributionKeeping the Time: The Poisson DistributionComputing Binomial and Poisson Probabilities with the TI-84 Plus Calculator
Comparing Discrete and Continuous DistributionsUnderstanding the Normal DistributionComputing Probabilities for the Normal Distribution with the TI-84 Plus Calculator
Sampling Techniques: Choosing Data from a PopulationSampling DistributionsThe Central Limit Theorem
Almost Normal: The Student’s t-DistributionGraphing the t-DistributionProbabilities and the t-TablePoint Estimates vs. Interval EstimatesEstimating Confidence Intervals for the Population MeanComputing Confidence Intervals for the Population Mean with the TI-84 Plus Calculator
Applying the Key Steps in Hypothesis Testing for a Single Population MeanTesting Hypotheses About Two Population MeansTesting Hypotheses about Population Means with the TI-84 Plus Calculator
Staying Positive with the Chi-Square DistributionTesting Hypotheses about the Population VariancePracticing the Goodness of Fit TestsConducing a Goodness of Fit Test with the TI-84 Plus Calculator
Getting to Know the F-DistributionTesting Hypotheses about the Equality of Two Population VariancesTesting Hypotheses about Two Population Variances with the TI-84 Plus Calculator
The Fundamental Assumption: Variables Have a Linear RelationshipDefining the Population Regression EquationEstimating the Population Regression EquationTesting the Estimated Regression EquationUsing Statistical SoftwareAssumptions of Simple Linear RegressionConducting Simple Regression Analysis with the TI-84 Plus Calculator
Implementing Excel FunctionsChecking Out Excel’s Key Statistical FunctionsGoing Deeper with the Analysis ToolPak
Designing Misleading GraphsDrawing the Wrong Conclusion from a Confidence IntervalMisinterpreting the Results of a Hypothesis TestPlacing Too Much Confidence in the Coefficient of Determination ()Assuming NormalityThinking Correlation Implies CausalityDrawing Conclusions from a Regression Equation When the Data Do Not Follow the AssumptionsUsing Regression Analysis to Make Predictions About Values Outside the Range of Sample DataPlacing Too Much Confidence in ForecastsUsing the Wrong Distribution
Summary Measures of a Population or a SampleProbabilityDiscrete Probability DistributionsContinuous Probability DistributionsSampling DistributionsConfidence Intervals for the Population MeanTesting Hypotheses about Population MeansTesting Hypotheses about Population VariancesUsing Regression Analysis

Content preview from Business Statistics For Dummies, 2nd Edition

Chapter 16

Key Statistical Techniques in Excel

IN THIS CHAPTER

Understanding how to implement functions in Excel

Discovering Excel’s key statistical analysis functions

Performing complex statistical analyses with the Analysis ToolPak

Microsoft Excel provides a large collection of tools that can help you with statistical calculations. You can use the built-in functions to calculate a single value or an array of values, or use one of Excel’s add-in tools such as the Analysis ToolPak to calculate more advanced routines. In this chapter, you discover how to implement Excel functions, become familiar with the many statistical functions available in Excel, and see how Excel’s add-in tools can help you generate results more quickly and easily than is possible with a calculator.

Implementing Excel Functions

You implement Excel functions by selecting a cell, typing an equals sign (=) followed by the name of the function, a left parenthesis ((), and then the values needed by the function to work, known as arguments. (If you need multiple values, you separate them with commas.) You then follow the input values with a right parenthesis ()) and press the Enter key. For example, the square ...