Even You Can Learn Statistics and Analytics
(STATSANALYTICS.AB1)
/ ISBN: 9781644593899
Even You Can Learn Statistics and Analytics
Learn the basic concepts of statistics and analysis with the Even You Can Learn Statistics and Analytics course and lab. This will provide you with the knowledge to apply statistics and analytics in your life and you will have the opportunity to learn and practice the most commonly used statistical methods while using Microsoft Excel. Every concept is explained in plain English, without the use of higher mathematics or mathematical symbols. The course uses a ConceptInterpretation approach to help you learn statistics and analytics. This course will provide you a complete package with handson experience in applying statistics and analytics.
Lessons

19+ Lessons

189+ Exercises

233+ Quizzes

143+ Flashcards

143+ Glossary of terms
TestPrep

39+ Pre Assessment Questions

2+ Full Length Tests

39+ Post Assessment Questions

78+ Practice Test Questions
LiveLab

20+ LiveLab

13+ Video tutorials

16+ Minutes
 Mathematics Is Always Optional!
 Learning with the ConceptInterpretation Approach
 The First Three Words of Statistics
 The Fourth and Fifth Words
 The Branches of Statistics
 Sources of Data
 Sampling Concepts
 Sample Selection Methods
 OneMinute Summary
 References
 Presenting Categorical Variables
 Presenting Numerical Variables
 “Bad” Charts
 OneMinute Summary
 References
 Measures of Central Tendency
 Measures of Position
 Measures of Variation
 Shape of Distributions
 Important Equations
 OneMinute Summary
 References
 Events
 More Definitions
 Some Rules of Probability
 Assigning Probabilities
 OneMinute Summary
 References
 Probability Distributions for Discrete Variables
 The Binomial and Poisson Probability Distributions
 Continuous Probability Distributions and the Normal Distribution
 The Normal Probability Plot
 Important Equations
 OneMinute Summary
 References
 Foundational Concepts
 Sampling Error and Confidence Intervals
 Confidence Interval Estimate for the Mean Using the t Distribution (σ Unknown)
 Confidence Interval Estimation for Categorical Variables
 Confidence Interval Estimation When Normality Cannot Be Assumed
 Important Equations
 OneMinute Summary
 References
 The Null and Alternative Hypotheses
 Hypothesis Testing Issues
 DecisionMaking Risks
 Performing Hypothesis Testing
 Types of Hypothesis Tests
 OneMinute Summary
 References
 Test for the Difference Between Two Proportions
 Test for the Difference Between the Means of Two Independent Groups
 The Paired t Test
 Important Equations
 OneMinute Summary
 References
 ChiSquare Test for TwoWay Tables
 OneWay Analysis of Variance (ANOVA): Testing fo...ferences Among the Means of More Than Two Groups
 Important Equations
 OneMinute Summary
 References
 Basics of Regression Analysis
 Developing a Simple Linear Regression Model
 Measures of Variation
 Inferences About the Slope
 Common Mistakes When Using Regression Analysis
 Important Equations
 OneMinute Summary
 References
 The Multiple Regression Model
 Coefficient of Multiple Determination
 The Overall F Test
 Residual Analysis for the Multiple Regression Model
 Inferences Concerning the Population Regression Coefficients
 OneMinute Summary
 References
 Basic Concepts
 Descriptive Analytics
 Typical Descriptive Analytics Visualizations
 OneMinute Summary
 References
 Predictive Analytics Methods
 More About Predictive Models
 Tree Induction
 Clustering
 Association Analysis
 OneMinute Summary
 References
 Conventions for Keystroke and Mouse Operations
 Microsoft Excel Technical Configuration
 Chart Tips
 Function Tips
 Advanced HowTo Tips
 Analysis ToolPak Tips
Hands on Activities (Live Labs)
 Creating a Bar Chart
 Creating a Pie Chart
 Creating a Pivot Table
 Modifying and Refreshing the Pivot Table
 Creating a Bar Chart
 Creating a Line Chart
 Creating a Scatter Plot
 Calculating Mean
 Calculating Median and Mode
 Calculating First Quartile
 Working with Probability
 Calculating the Value of a Normal Random Variable
 Using the Poisson Distribution
 Computing Binomial Probabilities
 Calculating the Confidence Interval
 Analyzing the Hypothesis Test for the PooledVariance tTest
 Analyzing the Hypothesis Test for the ChiSquare Test
 Creating a Histogram
 Using Multiple Regression
 Creating a Sparkline
×