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’ averages and the F-test is used during the process of obtaining the T-test’s result.

(Duration: 8:03)

 

<< Related Posts >>

(more…)

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’. Also, there are several Standard Deviation Excel functions. You can learn which one you should use.

 

(Duration: 8:52)

 

<< Related Posts >>

(more…)

MSA – Gage R&R: the Easiest GRR 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-understand manner on an Excel Template.

 

(Duration: 7:19)

DOWNLOAD  ← Click this to download the “Gage R&R Using ANOVA” template file.

 

<< Related Posts >>

(more…)

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 situation done without preparation and in a short time. On the other hand, what’s Pre-Set Analysis?

 

(Duration: 5:28)

 

<< Related Posts >>

(more…)

Xbar-R Control Chart: Let’s make it with Excel and Spanish Template【Excel Template】

We’ll learn a Control Chart from the Control Chart Excel template. The important point about Control Chart is how to use it after completing it. This video explains the “Rule Of Seven” that indicates signs of abnormality in your process.

(Duration: 4:46)

DOWNLOAD  ← Click this to download the “Control Chart” template file.

 

<< Related Videos >>

(more…)