Learn Data Analytics
45 articles in Data Analytics
Skewness and Kurtosis in Descriptive Statistics
Descriptive statistics. Our first topic for descriptive statistics is related to something called skewness and also something called kurtosis.
Probability: Events, Expected Values, and Conditional Outcomes
Probability 2. We're going to take a look at a couple more probability exercises.
Predicting Future Data Trends in Excel with Forecasting Techniques
Forecasting. In this section, we're going to take a look at forecasting at a more extensive level.
Statistical Measures: Percentiles and Quartiles Explained
Measures of position. We're going to take a look at two types of measures of position when it comes to statistics.
Regression Analysis with Excel's Analysis ToolPak
Simple linear regression. I want to estimate the relationship between variables.
Calculating Weighted Averages Using SUMPRODUCT and Conditions
This topic is called statistics according to the worksheet tab at the bottom, but it's basically an overview of the SUMPRODUCT function and its ability to...
Visualizing Data with the Normal Distribution Curve in Excel
The normal curve is a visual representation of the bell-shaped curve. That is something we have yet to create and we're actually going to create now in a...
Growth Patterns: Linear vs. Exponential Forecasting in Excel
Series forecast. In this section, we're going to take a look at two different types of growth, linear and exponential growth.
Excel Solver for Optimal Decision-Making and Profit Maximization
Solver overview. Solver is a tool that's available right next to the data analysis tool pack.