Split Column by Delimiter
In Power Query transformations, the split column by delimiter has something that you need to be aware of. […]
Blog
Text Transformation in Power Query
This post covers a few common text transformations in Power Query. When you are working with a column, […]
Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]
API Introduction
What is an Application Programming Interface (API)? As a wide definition, the website programmableweb.com says “An Application Programming […]
Data Analytics/Analysis Life Cycle
Data undergoes various stages throughout its life, during its creation, testing, processing, consumption, and reuse. The Data Analytics […]
CI for Predicting Sales
We are finding that we have too many products on our shelves and some of the products aren’t […]
CI Population Unknown and Equal
The previous series of posts was called Inferential Statistics. Let’s now compare “apples to apples”. Last time we […]
Hypothesis Testing Introduction
Series of Posts This post is the first part of a short series of posts called Hypothesis Testing. […]
CI Independent Samples
Let’s work with confidence intervals with two means and independent samples. Let’s work with data where we know […]
CI for Two Populations
What if we had two populations to consider? So far we’ve been looking at single populations. In some […]
Margin of Error
In this post, we’ll introduce a new statistics term called the margin of error. Since a sample is […]
CI Population Variance Known
Suppose we have a sample of salaries for a job title and we know the population’s variance. In […]