Detailed SWOT Analysis Examples

Detailed SWOT Analysis Examples

Detailed SWOT Analysis Examples:

Hello Readers! Today’s topic is a very interesting and useful topic that I am going to describe in detail in the SWOT Analysis process with many more examples. As you know SWOT Analysis is a strategic planning technique, which is generally used to identify strengths, weaknesses, opportunities, and Threats related to the context of the organization. If you would like to download the template with Detailed SWOT Analysis Examples, then go through the given below link.

SWOT Analysis Template / Format.  [DOWNLOAD]

Detailed SWOT Analysis Examples
Detailed SWOT Analysis Examples

Strength: Advantages of Business Characteristics.

Weakness: Disadvantage of Business Characteristics.

Opportunity: Business Element that could be exploited to its advantage.

Threat: The Business element that could cause trouble for the business.

When to use SWOT Analysis:

You can use the SWOT analysis process in the below field but not limited to;

  • To overcome the Business concern types problem.
  • To explore new opportunities in NPD, Process Defects, Design defects, Manufacturing defects, R/M Defects, Customer End defects, technology up-gradation, etc.

Note: The SWOT Analysis tool is the best one to use for identifying the Risk and Opportunity of several Business system standards like IATF 16949, ISO 9001, ISO 14001, ISO 45001, ISO 31000, etc.

DOWNLOAD QA & QC Template / Formats

Detailed SWOT Analysis Examples:

Here, we are going to do the SWOT analysis of beneath Examples. So carefully read the Examples.

EXAMPLES:

  1. A Mobile manufacturing company has launched a mobile phone and after six months, the company’s particular product got more customer complaints due to screen issues causing a loss of brand image in the market. And accordingly, the company loses the 10% sales values of the previous.
  2. Rejection percentage of Mobile PCB is increased from 1% to 1.35%.

SWOT Analysis of Example-1

I/PStrengthWeaknessOpportunityThreat
Loss of brand ImageService Centers, Well-developed R&D Centre, QA teams, Latest Technology, QA Testing.Screen issues like a black spot on the screen, Flickering black screen, and Vertical split screen due to manufacturing problems (Special causes).Upgradation of screen quality through value engineering.10% sales loss, Customer Dissatisfaction, and Business losses.
detailed swot analysis examples
 SWOT Analysis of Example-2
I/PStrengthWeaknessOpportunityThreat
High Process RejectionProcess characteristics validation, Inspection, Checking, and Testing.Shortage of highly skilled labors, More variation in the process.Strengthen the on-Job TrainingCustomer dissatisfaction, Profit loss.
Detailed SWOT Analysis Examples
Detailed SWOT Analysis Examples

Useful Articles:

Process Capability Analysis |Cp & Cpk Calculation Excel Sheet with Example

Verification vs Validation | What is difference between verification and validation?

Kaizen vs Innovation | Key Differences between Kaizen and Innovation

Corrective Action vs Preventive Action

Thank you for reading…..Keep visiting Techiequality.com

Please let me know if you have any questions.

Popular Post:

SWOT Analysis Word Template

SWOT Analysis Word Template

SWOT Analysis Word, Excel, PDF and PPT Template:

Hello Readers! Download the SWOT Analysis Word Template, and also in Excel, PDF, and PPT from. Links are given below.

DOWNLOAD– QA & QC Format

The SWOT Analysis is a strategic planning technique, which is generally used to identify the strengths, weaknesses, opportunities, and threats related to the context of the organization.

DOWNLOAD the SWOT Analysis Templates / Formats in Word, Excel, PDF, and PPT form:

Illustration of Template / Format:

SWOT Analysis Word Template
SWOT Analysis Word Template
  • I/P: This is the input points that you would like to do the SWOT analysis. For example, several factors and business issues (Internal and External).
  • Internal issues example: policy, Standards, business strategy, labor strikes, Major accidents, Raw material Crisis, etc.
  • External Issues Example: Legal, Customer Contract, Profit loss, loss in share market, etc.
  • Strength: Advantages of Business Characteristics.
  • Weakness: Disadvantage of Business Characteristics.
  • Opportunity: Business Element that could be exploited to its advantage.
  • Threat: The Business element that could cause trouble for the business.

When to use SWOT Analysis:

You can use the SWOT analysis process in the below field but not limited to;

  • To overcome the Business concern types problem.
  • To explore the new opportunities in NPD, Process Defects, Design defects, Manufacturing defects, R/M Defects, Customer End defects, technology up-gradation, Socio-political issues, Internal factors, Issues to business strategy,  etc.

Note: The SWOT Analysis tool is the best one to use for identifying the Risk and Opportunity of several Business system standards like IATF 16949, ISO 9001, ISO 14001, ISO 45001, ISO 31000, etc.

EXAMPLES:

A car manufacturing company has lost its car sales 30% of the average of the last six months’ sales. After that, top management decided to do a SWOT analysis to identify the opportunity and their major threats.

SWOT Analysis (Example): 30% reduction in sales

I/PStrengthWeaknessOpportunityThreat
30% reduction in salesOffer in some special car, Low price, Low maintenance, Features w.r.t customer needs, etc.Lack of Digital and traditional marketing, Cost reduction, and old aesthetical view. Old interior designRedesign of Car, Electric car.Company Shut down, Decline in sales turn-over.
example

Useful Articles:

Detailed SWOT Analysis Examples

How to calculate Cp and Cpk? |Practical Case Study | Process Capability Example.

How to plot the Run Chart in Minitab

How to do Capability Analysis by Minitab 18? | Minitab Process Capability Tutorial

Thank you for reading…..Keep visiting Techiequality.com

I hope the above is useful to you.

Popular Post:

Swot Analysis of Marketing Operation

Swot Analysis of Marketing

Swot Analysis of Marketing Operation:

Hello Readers! Today, we will describe marketing-related Top 5 issues through SWOT Analysis.  As you know SWOT Analysis is a strategic planning technique, which is generally used to identify strengths, weaknesses, opportunities, and threats related to the context of the organization.

SWOT Analysis Template – [DOWNLOAD in Excel]  [DOWNLOAD in Word].

Swot Analysis of Marketing
Swot Analysis of Marketing

The SWOT:

Strength: Advantages of Business Characteristics.

Weakness: Disadvantage of Business Characteristics.

Opportunity: Business Element that could be exploited to its advantage.

Threat: The Business element that could cause trouble for the business.

When to use SWOT Analysis:

You can use the SWOT analysis process in the below field but not limited to;

  • To overcome the Business concern types problem.
  • To explore a new opportunity in NPD, Process Defects, Design defects, Manufacturing defects, R/M Defects, Customer End defects, technology up-gradation, etc.

Note: The SWOT Analysis tool is the best one to use for identifying the Risk and Opportunity of several Business system standards like IATF 16949, ISO 9001, ISO 14001, ISO 45001, ISO 31000, etc.

Top 6 Marketing Issues:

  1. Sales Issue.
  2. Reputation Issue.
  3. Operations Issue.
  4. Price Issue.
  5. Demand Issue.
  6. Brand Issue.

SWOT Analysis of the above major top marketing Issues are illustrated below;

list
Swot Analysis of Marketing
Swot Analysis of Marketing

Sales Issue:

SWOT Analysis of  Sales Issue:

I/PStrengthWeaknessOpportunityThreat
Sales IssueHigh-performing salesperson, Traditional Marketing, Digital marketing, Strong supply ChainLimited product range w.r.t market demand, High competitive product, High Product cost.A Variety range of products needs to be introduced in the marketA Drop down of sales quantities, Profit Loss, and The Company shut down.

Reputation Issue:

SWOT Analysis of  Reputation Issue:

I/PStrengthWeaknessOpportunityThreat
Reputation IssueA good relationship with the customer, High Customer Satisfaction, Excellent Vendor performancePoor customer ServicesTo enhance customer service through supply chain management.Profit loss, A drop-down of sales quantities

Operation Issue:

SWOT Analysis of  Operation Issue:

I/PStrengthWeaknessOpportunityThreat
Operation IssueAdvanced R&D Centre, Quick New Product development, Strong QC TeamSupply chain problem, Poor inventory levels.Strengthen the supply chain managementProfit loss, A drop-down in sales quantities, Loss in the Brand image, Loss in market demand

Useful Articles:

SWOT Analysis Word Template

SWOT Analysis Examples

Verification vs Validation | What is difference between verification and validation?

Kaizen vs Innovation | Key Differences between Kaizen and Innovation

Thank you for reading…..Keep visiting Techiequality.com

Please let me know if you have any questions.

Popular Post:

Repeatability vs Reproducibility | Discussion of Key difference.

Repeatability vs Reproducibility

What is the difference between Repeatability & Reproducibility?

Hello…Readers! Today here we will discuss the frequently used terms in an industry i.e. Repeatability vs Reproducibility. These two wards are more familiar with Measurement system analysis. So don’t waste your time and go through the below article and enhance your knowledge. If you are further looking for a similar type of article, then click on below links/ topic.

Reproducibility vs Repeatability :

Repeatability vs Reproducibility
Repeatability vs Reproducibility

Repeatability: Variation due to Gage.

As per the MSA Manual, The common cause, random variation resulting from successive trials under defined conditions of measurement. Often denoted to as equipment variation (EV), although this is misleading. The best term for repeatability is within-system variation when the conditions of measurement are fixed and defined the fixed part, instrument, standard, method, operator, environment, and assumptions. In addition to within equipment variation, repeatability will include all within variations from the conditions in the measurement error model.

It’s an Equipment variation.

Reproducibility: Variation due to Operators.

As per the MSA Manual, The variation in the average of measurements is caused by a normal condition(s) of change in the measurement process. Naturally, it has been defined as the variation in average measurements of the same part between different operators using the same measuring instrument & method in a stable environment. This is frequently true for manual instruments influenced by the skill of the operator. It is not true, however, for measurement processes (automated systems) where the operator is not a major source of variation. For this reason, reproducibility is mentioned as the average variation between systems or between conditions of measurement.

It’s a variation due to the operators, measuring the same part using the same measuring instrument and method in a stable environment.

Useful Articles:

5’S Concept | what are 5’S?

The Key difference between Corrective Action and Preventive Action.

Process Capability Analysis |Cp & Cpk Calculation Excel Sheet with Example.

How to calculate Cp and Cpk? |Practical Case Study | Process Capability Example

Repeatability vs Reproducibility
DOWNLOAD FREE FORMAT

Thank you for reading…..Keep visiting Techiequality.com

If you require any further information, feel free to contact us.

Popular Post:

Verification vs Validation | What is difference between verification and validation?

What is difference between verification and validation

What is difference between verification and validation?

Hi readers! Today we will discuss an important topic i.e. What is difference between verification and validation.

Verification: Am I building the product right?

  • Evaluating the process and product in the developing stage.
  • It is performed to build a product in the right way.
  • The verification process generally comes first done before validation.
  • It is the process, to ensure whether we are manufacturing the product according to drawing/ Standard/ specification or not.
  • It is a low-level activity.
  • Example: Inspection, Document review, Checking, etc.

Example of Verification:

Let us say that you are producing the mobile case covers, and you are checking the dimension of 100% product at the molding section and ensuring that the product is manufactured according to the Drawing.

Validation: Am I building the right product?

  • A process of seeing whether the product satisfies the customers’ requirements or not.
  • It is performed to build the right product.
  • The validation process is generally followed after verification.
  • It is the process of validating whether the product which we have developed is right or not.
  • It is a high-level activity.
  • Example: In-process testing, final product testing.

      Example of Validation:

After verification of the Mobile case cover, now the Test Team member will do the appropriate test to validate such products that meet the customer needs like fitment, color testing, drop testing, etc.

I hope that the above example is useful to you and you understand well. And if are searching for a similar type of topic to enhance your knowledge then the below articles will help you to enrich and enlarge your ken.

Useful Articles:

5’S Concept | what are 5’S?

Kaizen vs Innovation, Differences between Kaizen and Innovation.

The Key difference between Corrective Action and Preventive Action.

Rework vs Repair |IATF Requirement for Control of Reworked/ Repaired Product.

Process Capability Analysis |Cp & Cpk Calculation Excel Sheet with Example.

How to calculate Cp and Cpk? |Practical Case Study | Process Capability Example

What is difference between verification and validation
DOWNLOAD FREE TEMPLATE/ FORMAT

What is difference between verification and validation?

Thank you for reading…..Keep visiting Techiequality.com

If you require any further information, feel free to contact us.

Popular Post:

5’S Concept | What are 5’S?

Hi readers! today we will discuss a popular and important topic that is widely used in the industry i.e. 5’S Concept

What is 5’S Concept

5’s are the techniques for organizing the work effectively and safely. It helps people to do their jobs without wasting time or injury. 5’S is the base pillar of TPM (Total productive maintenance) and TPS (Toyota Production System).

What are 5’S?

Five Japanese words In English
1-S: Seiri 1-S: Sort
2-S: Seiton 2-S: Set in Order
3-S: Seiso 3-S: Shine
4-S: Seiketsu 4-S: Standardize
5-S: Shitsuke 5-S: Sustain
5’S Concept
5’S Concept

History:

The concept 5’S was initiated as part of the TPS [Toyota Production System] at the Toyota Motor Company in the early and mid-20th century. This system is often used in Lean manufacturing and TPM [Total Productive Maintenance].

Advantages of 5’S Concept:
  • Easy Accessing.
  • Better work environment.
  • Reduced costs
  • High quality
  • Increased productivity
  • A safer work environment

Illustration of 5’S:

1-S: Sort:

The first step of 5’S is the “Sort”, simply in this process, we have to remove the unwanted materials and to determine what needs to be present. If required for any situation to take the decision together with the lime manager at that situation we can use the Tag system (Red tag and yellow tag).

The below questions will help you to do the sorting in your work areas.

Q1: Does it really need to be here or not?

Q2: What is the tenacity of this item?

Q3: How often is it used?

Ask these questions during the sorting operation and make also a work layout.  

2-S: Set in Order:

It means neatness. Always follow the golden rule of “Place for everything and everything in its place”

Follow the below steps to “set in order”:

  • Identify each and every item.
  • Lay down the Work layout of each workstation/zone.
  • Keep the items nearest to the point of use.
  • Ensure easy accessibility, and easy retrieval, Minimize the inventories.
  • Mark the gangway and foot stoppage on the shop floor for safe and easy movement of men and materials.

In this way, you can easily store the essential material in the appropriate location. You will get so many advantages after the effective implementation of 2-S as;

  • Improves workplace utilization.
  • Reduce the inventory level.
  • Create a safe work environment.
  • Helps reduce time consumed in searching for materials for use.
3-S: Shine:

Cleaning is not a job; it is a frame of mind.

In many places, cleaning is considered as a separate job. A workman feels that it is not his job to clean the machine. So to overcome their thinking, the culture has to come from top management to the bottom-most designation. First of all, we have to clean our table, and chairs without waiting for the sweeper or peon. We have to follow the three-step approach as Macro level, Individual Level, and Micro Level. During the 3-S operation, we can also put the tag, if we will find the Problems like electrical, mechanical, civil, etc. in the workplace.

4-S: Standardize:

The 4-S is the Standardization, this means ensuring whatever cleanliness and orderliness have been achieved through improvement in Sort, Set in Order, and Shine have to be standardized.

You can follow the below-mentioned methodology to achieve standardization:

  • Prepare a 5-S SOP or Manual.
  • Lay down the Work Layout of every work zone.
  • Standardize the cleaning kits.
  • Visual management.
5-S: Sustain:

This is the last step but not the least, it’s a Sustain.

Define the rules and responsibilities of each zone member and make them aware of the 5-S benefit. If some practices are not followed, analyze the root cause of failure. Carry out the 5-S audit on a periodic basis and appreciate the best zone.

Useful Articles:

5’S Concept
DOWNLOAD FREE FORMAT

Thank you for reading…..Keep visiting Techiequality.com

I think the article “5’S Concept” is useful to you…If you require any further information, feel free to contact me.

Popular Post:

Rework vs Repair |IATF Requirement for Control of Reworked/ Repaired Product

Rework vs Repair

Rework vs Repair:

Hello Reader! Today we will discuss the Rework vs Repair of Parts and Control of Reworked/ Repaired Products.

If still, your process exists the Rework or Repair product, then what you need to do? What are the documents and records to be maintained? So don’t waste your time and read the below Article carefully.

Rework Definition:

ISO Definition: Action on a nonconforming product to make it conform to the requirements.”
NOTE Unlike rework, a repair can affect or change parts of the nonconforming product.

Explanation:

Fix the part to meet specifications.

To take action for correcting the defective or non-conforming parts to conforming parts that shall meet the specification/ requirement of the customer.

Example:

The Gearbox housing is rejected due to extra metal, which may probably cause the fouling issue. However the process engineer has taken action to remove the extra metal from the gearbox housing and finally, it meets as per the customer drawing. So here the “action taken by the process engineer” is the reworking process because by doing the temporary work/rework, it meets the customer’s requirement.  

Repair Definition:

ISO Definition: Action on a nonconforming product to make it conform to the requirements.”
NOTE Unlike rework, a repair can affect or change parts of the nonconforming product.

Explanation:

Fix the part so it is usable, but does not meet the specification

To take action for correcting the defective or non-conforming parts to conforming parts, so that it is usable but it does not meet the specification/ requirement of the customer.

Example:

Fixing of a flat tire, fixing a leak in a tire by putting a plug in the tire, or a patch on the tire is called repairing the tire; it doesn’t look like it did when it was brand new. It means the product is ready for use but does not meet the specifications.

Control of Reworked Product: (As per IATF 16949):

What does the organization need to be maintained?

Ans.:- 1. The organization shall prepare the PFMEA w.r.t risks in the rework.

2. The unit shall obtain approval from the customer if required by the customer.

3. The unit shall lay down the rework procedure, control plan, or other relevant documents.

4. The organization shall maintain a record of reworked products/parts including quantity, disposition, date, and traceability information.

[Note: above four important requirements need to be established by the organization/unit if there is an existence of Rework product/ items.]

Control of Repaired Product: (As per IATF 16949):

What are the mandatory requirements that an organization needs to be maintained?

1. The organization shall prepare the PFMEA w.r.t risks in the repair.

2. The unit shall obtain approval from the customer.

3. The unit shall lay down the repair procedure, control plan, or other relevant documents.

4. The unit shall obtain documented customer authorization for a concession for the product to be repaired.

5. The organization shall maintain a record of repair products/parts including quantity, disposition, date, and traceability information.

The Basic difference between the controls of the reworked product and the Repaired product:

In the case of repaired products, the organization must have to obtain the approval and customer authorization for a concession from the customer

I hope the above article is useful to you. We have prudentially described the difference between the rework and repair product with examples.

Useful Articles:

Quality Template
DOWNLOAD

Thank you for reading….Keep visiting Techiequality.Com

Don’t hesitate to comment below if you have any questions

Popular Post:

Corrective Action vs Preventive Action

Corrective Action vs Preventive Action

Corrective Action vs Preventive Action

Hi readers! Today we will discuss an important topic which is Corrective Action vs Preventive Action. The terms Corrective Action and Preventive Action are the most popular terminology in the manufacturing industry. But now in the new business system standard, the preventive action is expressed through the use of risk-based thinking. It means preventive action is replaced by Risk and opportunity. Here we will discuss the definition of Corrective action and preventive action with industrial examples.

CAPA Process/ CAPA Concept w.r.t ISO 9001 and IATF 16949.

CAPA Template/ Format

Corrective Action vs Preventive Action:

Correction: Action to eliminate the symptom of problems.

Corrective Action:

  1. Action to eliminate the cause of non-conformity in order to prevent a recurrence.
  2. Definition 2-Action to eliminate the Root cause of Problems.
  3. Action taken in order to eliminate the root cause.

Preventive Action:

  1. Action to eliminate the cause of potential nonconformities in order to prevent their occurrence.
  2. Definition2.-Action to eliminate the potential cause of problems
  3. Action taken in order to avoid root cause recurrence
Example1-

The XYZ Pvt Ltd Company manufactures Oil sump. But 2% of castings were rejected at the customer end due to shrinkage. So the purchasing department asked the supplier to submit the 8D report and CAPA Report. After getting the Customer Complaint. The Process Engineer of the Supplier started the Rejection investigation and finally prepared the CAPA Report;

Correction: Segregated the Casting and stopped the consignment of the same batch of products.

Corrective Action:

Problem- Shrinkage.

Why-why Shrinkage? Ans. Shrinkage was found at the In-gate of Casting so the process engineer thought that the wrong gating system may be a potential cause for in-gate shrinkage. And he started to recheck the in-gate system.

Why-why in-gate Shrinkage? Ans. The gating system was modified but validation was not done.

Why- Why gating system validation was not done?

Ans. – The production Manager has scheduled the same product for the Next day of modification without the validation of the tool.

Why- why validation is not done timely?

Ans. – There was no comprehensive Production planning. 

Corrective Action: Comprehensive Production planning will be prepared considering with tools status.

Preventive Action: Tools Status will update periodically.

I hope this example is helpful to you to understand the difference between Corrective Action vs Preventive Action.

Useful Articles:

Corrective Action vs Preventive Action
DOWNLOAD

“Should you need any further information, please do not hesitate to comment below”.

Thank you for Reading…Keep Visiting Techiequality.Com

Popular Post:

Kaizen vs Innovation | Key Differences between Kaizen and Innovation

Kaizen vs Innovation

Kaizen vs Innovation | Key Differences between Kaizen and Innovation

Kaizen vs Innovation: Both kaizen and Innovation can be applied at every stage in Manufacturing. But in normal circumstances, these two are applied in two different stages.

Kaizen vs Innovation
Kaizen vs Innovation

In the aforesaid figure, its clearly indicates that the Innovation phase can be started from scientific development i.e. R&D, and leads to new technology and later to design in this order. But the Kaizen phase is giving more emphasis on Gemba Kaizen (Work Place Kaizen).

Diagrammatic Comparison Between Kaizen vs Innovation:

Kaizen vs Innovation
Kaizen vs Innovation

In the above Fig. 2, it clearly indicates that, if an organization starts both the innovation plus kaizen culture, then it will take very little time to achieve a high level of improvement in all aspects.

The organization has only innovation-oriented products that would cost more. Because the transformation of technology will cost high.

Kaizen vs Innovation
Kaizen vs Innovation
Kaizen vs Innovation
Kaizen vs Innovation

Only innovation-oriented organizations may often face the above situation (Decline) due to non-maintenance. So we have to sustain the new standard of innovation to prevent the declining situation.

Innovation without maintenance:

Kaizen vs Innovation

Key Differences Between Kaizen and Innovation:

KAIZEN:
Elements of Comparison Kaizen
Approach More often collective, team Effort, and System oriented.
Method More often collective, Team Effort, and System oriented.
Idea Generation Flow from experience and Knowledge.
Involvement Through People
Maintenance Effort Whether effort put into process improvement gives better results.
Impact Long Term and Long Lasting.
Participation & Involvements Everybody.
Evaluation Whether effort put in process improvement gives better results.
Advantage Very well suitable for a slow-growth economy.
Effect Long term  and continuous but undramatic
Speed Small Steps
Timeframe Continuous and Rising
Changes of success Always on a high level.
Motto Preservation & Improvement
INNOVATION:
Elements of Comparison Innovation
Approach An Aggressive individual likes efforts from an individual.
Method Drastic Change of existing methods by discarding i.e. Creating a new process.
Idea Generation New Investment, Technology Transformation, R&D.
Involvement Investment in Equipment, Technology
Maintenance Effort Through technology
Impact Short -but dramatic change, yielding short-term gains.
Participation & Involvements Select a few.
Evaluation Whether Efforts put in results in profit.
Advantage Fast-growing economic.
Effect Short term but dramatic.
Speed Big Steps
Timeframe Interrupted and limited.
Changes of success Unsettled
Motto Reconstruction

Useful Articles:

Quality Template
DOWNLOAD

Thank you for Reading…. Keep visiting Techiequality.com

If you require any further information, let me know.

Popular Post:

How to plot the Run Chart in Excel | Run Chart Excel Template:

Run Chart Excel

How to plot the Run Chart in Excel?

A run chart is also termed a Line Chart. You can use it on the shop floor to monitor the Process variation. In the run chart, you could able to set up the mean value, upper specification limit, lower specification limit, Median & mode. A Run chart will not be able to give an idea about the control limits. It represents the variation in summarizing data of Process, or Product characteristics. However, it can show you how the process is running. Today we will discuss on how to plot a run chart in Excel. Download the Run Chart Excel template from the below link.

Download Template.

Step by Step guide on How to plot Run Chart in Excel:

Step-1: Enter the reading in the Excel sheet.

Step-2: Calculate the Mean, Median, and Mode values in Excel

Step-3: Put the USL & LSL in an Excel sheet.

Step-4: Select the Excel data table and then follow the below step to select the line chart;

“Insert>>Line graph”

Illustration with Example:

Step-1:

We are going to plot the run chart of the Permeability Number of green sand. Hence we have observed the readings four times per day; these readings are given below;

Date Permeability Number
xx/12/18 198
xx/12/18 199
xx/12/18 195
xx/12/18 198
pp/01/19 196
pp/01/19 198
pp/01/19 199
pp/01/19 197
ss/02/19 198
ss/02/19 197
ss/02/19 196
ss/02/19 198
pp/03/19 197
pp/03/19 195
pp/03/19 196
pp/03/19 200
nn/04/19 199
nn/04/19 200
nn/04/19 198
nn/04/19 200
Step-2:

Calculate the mean, median, and mode of observed value;

Mean: Use the Excel formula to calculate the average value automatically. Details are described in the below figure.

step
Run Chart

Median: Select the Excel Median formula to calculate the Median value automatically. For better understanding, kindly go through the highlighted portion of the below figure.

steps
Run Chart

Mode: use the Excel formula to calculate the mode value for the details formula, kindly go through the below figure highlighted portion.

steps
Run Chart
Step-3:

Put USL and LSL values in Excel, if you would like to draw the line in the run chart. So here specification of Permeability is 200±10. USL is 210 and LSL is 190.

Step-4: To draw the run chart, kindly follow the sequence from “1” to “4” as per the below figure.

Sequence-1: Select the data table.

Sequence-2: Select the “Insert” option in the Excel sheet.

Sequence-3: Select the “Run Chart/ Line Chart” in Excel sheet.

Run Chart
Run Chart
Step-5: Run Chart:
Run Chart
Run Chart

[Run Chart]

(Click-Here to learn about the interpretation of the Run Chart)

Useful Links:

Run Chart Excel
Download

Thank you for reading….Keep visiting Techiequality.Com

Popular Post: