Articles about Data Analysis

## How to interpret the result of the Two-Factor Anova, Part 2: P-Value

This article is about how to interpret the results of Anova, including P-value, and connect it to our action. In order to understand P-value, you have to understand the concept of 'Null Hypothesis'. This article explains the P-value and Null Hypothesis visually easy to understand manner.

## What’s ANOVA? (Analysis of Variance Basics) 【Excel Data Analysis Tools】 Part 1: Get the results quickly

With Anova, you can identify if there is significant difference among the data groups. This article explains the basics of Anova and demonstrate the Two-Factor Anova using Excel's Data Analysis tools.

## Learning Multiple Regression Analysis with an SEO Example【Regression Analysis Series 3】

This article explains Multiple Regression Analysis using my SEO activities as example and a Dummy Variable for Qualitati...

## Simple Regression Analysis Interpretation (Excel Data Analysis Tools)【Regression Analysis Series 2】

This post explains how to interpret results of Simple Regression Analysis using Excel Data Analysis Tools. You'll learn ...

## Simple Regression Analysis by Scatter Plot in Excel【Regression Analysis Series 1】

This post shows the basics of Regression Analysis, explains its confusing terms, and how to use a Scatter Plot for a Sim...

## Control Chart Types: You’ll understand Xbar, c, u, p, np with this!

The type of your data will decide what type of Control Chart you should use. The Control Chart Quick Reference Table giv...

## How to use the T-test and F-test in a real world【Excel Function】

Today's topic is the T-test and F-test and their Excel functions. The T-test is used to compare two data groups’ average...

## What is Standard Deviation? There are too many Excel functions for Standard Deviation!

This article explains 'What Standard Deviation is', 'Why it's needed', and differences between 'Population' and 'Sample'...

## Gage R&R: the Easiest Gage R&R Template to Use in the World! 【Excel Template】

Today's topic is Gage R&R, the most common method in MSA. This article explains a very difficult topic in an easy-to...

## For the PDCA Cycle, which one would you use, an Ad Hoc Analysis or a Pre Set Analysis?

Ad Hoc means "for this" or "for this situation" in Latin. Ad Hoc Analysis is an analysis for a temporary and particular ...