##
** What is Matrix Data Analysis Diagram?**

→ The Matrix Data Analysis Chart (MDAC) is used to identify the relationships of related group items in a larger group of data_sets.

→ Sometimes this diagram is known as MDAC.

→ This tool is one of the most important tools of 7 Management and Planning Tools (New 7 QC Tools).

→ The MDAC is mostly used to perform market research and describe products and services.

→ Matrix_Data is arranged for easy visualization and comparisons.

→ The MDAC helps classify items by identifying two major characteristics common to all items and then plotting each item as a point on a standard x-y chart.

→ This makes it easier to see how the individual items relate both to the characteristics and to one another.

→ The basic Matrix Data Analysis Chart is mentioned in the below picture. We can easily understand the analysis of the matrix diagram.

→ We can take the decision based on the different characteristics scoring matrix falls in which quadrant.

➨ The quadrant wise the analysis as mentioned below.

→ (1) 1st Quadrant is known as Desirable Quadrant

→ (2) 2nd Quadrant is known as Partially Desirable Quadrant

→ (3) 3rd Quadrant is known as Non-Desirable Quadrant

→ (4) 4th Quadrant is known as Partially Desirable Quadrant

**When to use Matrix Data Analysis Chart**

→ We can use this tool when investigating factors that affect the number of different items, to determine common relationships.

→ This tool is used to check that similar items have effects of similar factors or having the effects of different factors also.

→ Matrix Data Analysis Diagram is also used as the __Problem Solving Tool__.

→ When comparing a large set of items, the complexity of the situation can make it difficult to determine how different factors relate to one another at this instance we can use this tool.

→ This tool is useful to find a group of items that behave in similar ways or not.

###
**How to Create a Matrix Data Analysis Chart (MDAC)?**

→ The Four steps for creating an MDAC diagram are mentioned below.

- Decide the Two Characteristics for Analyse
- Assign the Scoring to Characteristics and Prepare the Matrix
- Put all_data into the X-Y type Graph.
- Give the suitable title to the Graph and Analyze the graph based on Quadrant

→ For a better understanding of the Matrix Data Analysis Chart (MDAC), we are taking the below example.

**Example of Matrix Data Analysis Diagram**

→ We need to analyze the different dishes in the college canteen. So we will follow the above-mentioned steps for that.

**Step 01: Decide the Two Characteristics for Analyse**

→ We will compare the different dishes of the college canteen based on the below two-parameter (Characteristics).

→ (1) Visual Attractiveness of Dishes, and

→ (2) Taste of Dishes

→ Now we will take these dishes for analysis Chilly Potato, Masala Dosa, Papdi Chat, Macaroni, Lunch/Dinner, Sandwich, Grilled Sandwich, and Samosa.

####
**Step 02: Assign the Scoring to Characteristics and Prepare the
Matrix**

→ So we will consider the score based on the student's rating of all dishes of the college canteen on a scale of 1 to 10.

→ Score 1 stands for very poor and scores 10 stands for very good.

→ So refer to the below table for scoring given by the students.

**Step 03: Put all data into the X-Y type Graph**

→ From the above table, all_data points are then plotted on a simple x-y graph.

→ The X and Y both axis is shown from the 0 to 10 scoring.

→ Refer to the below picture for the planting of the graph.

####
**Step 04: Give the suitable title to the Graph and Analyze the graph
based on Quadrant**

→ Now the finally we need to analyze the graph based on the quadrant of data falling.

→ So based on the quadrant and matrix data_types we can get the below results for different dishes by comparing and scoring of different two parameters such as (1) Visual Attractiveness of Dishes, and (2) Taste of Dishes.

➨ The Desirable dishes are: Macaroni, Papdi Chat, Samosa, and Chilly Potato

➨ The Partially Desirable dishes are: Masala Dosa, Sandwich, and Grilled Sandwich

➨ The Non Desirable dishes are: Lunch/Dinner

**Other Examples of MDAC Diagram Analysis**

→ A Manufacturing Company is looking to develop alternative materials to build a more durable gearbox by comparing the material cost and material's durability.

→ A Manufacturing facility is looking to develop an alternative vendor for raw material for less cost and on-time delivery for the same material property.

## 2 Comments

So, where are the prepared excel templates to do the analysis that you describe? I want to check your methods, using the same tools. Thanks

ReplyDeleteThe method is described in 4 easy steps so you can easily understand it with the help of this tutorial.

Delete