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…)

Process Capability Basics, Cp and Cpk Deference and Unilateral Tolerance

The calculation for the Process Capability Index is “Your process’s CTQ Specification Interval divided by 6 Sigmas”. It is divided into ‘CTQ’, ‘Specification Interval’ and ‘6 Sigmas’ and each is illustrated to be easily understood.

 

(Duration: 7:17)

 

<< Related Posts >>

(more…)