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

Use an Affinity Diagram to organize your issues/ideas.【Excel Template】

You can list up all the issues/ideas in the Affinity Diagram, organizing them by affinity and create group names easily. This Affinity Diagram is very useful when you don’t know what to do with problems or when you have a lot of unclear ideas and want to think about what to do next.

(Duration: 6:02)

DOWNLOAD  ← Click this to download the “Affinity Diagram and Prioritizing” template file.

 

<< Related Posts >>

(more…)

8D Problem Solving: Great for Process Improvement【Excel Template】

The 8D Problem-Solving is utilized in process and product improvement. I made a template for the 8D Problem-Solving. This post shows you the comparison between the 8D Method and DMAIC and explain each step of 8D on the template.

(Duration: 7:30)

DOWNLOAD  ← Click this to download the “8D Problem Solving” template file.

 

<< Related Posts >>

(more…)

Excel Macro and VBA: Fundamental Basics (Record Macro Button and VBE)

This article is about Excel Macro fundamental basics and explains how to use the ‘Record Macro’ button, how to edit the codes and save the file with Macros in a step-by-step way.

(Duration: 7:41)

 

<< Related Posts >>

(more…)

How to Use Excel Pivot Table 【Screen Demonstration】

This article explains source data formats for a Pivot Table, each section of the Pivot Table’s work screen – the Field List – and demonstrates the elemental steps needed to make a Pivot Table on the Excel screen. You’ll be able to start making your own Pivot Table after reading this article.

(Duration: 7:11)

 

<< Related Posts >>

(more…)

What’s Toyota’s Jidoka (Autonomation)?

This article introduces about the origin of Jidoka and Andon that was evolved from Jidoka.  It also will explain the difference between Autonomation and Automation and the substance of Autonomation.

 

(Duration: 5:47)

 

<< Related Posts >>

(more…)