What is PARETO ANALYSIS & Howto MAKE a PARETO CHART in MS Excel Explained in Hindi (हिंदी में )

What is PARETO ANALYSIS & Howto MAKE a PARETO CHART in MS- Excel Explained in Hindi (हिंदी में )
इस विडियो में बताया गया है पेरेटो चार्ट क्या होता है, इसे इस्तेमाल में कैसे लाया जाता है और इसे हम एक्सेल में कैसे बना सकते है
In this video it has been explained about the PARETO CHART, one of the seven basic quality tools.
Also How you can a draw a Pareto chart in Excel without use of any software like MINI TAB .
Hope You will Like the Video....................
----------------------------------------------
For more details and other videos click on the link: / @aytindia
Lean Manufacturing & Toyota Producytion System Training Videos: • LEAN Manufacturing
---------------------------------------------------
Music: www.bensound.com
-------------------------------------------------------
About Myself: Shakir Mohd (B.TECH)
• I am a B.Tech in Mechanical Engineering
• I have total working Experience of Around 7 Years in Training, Execution and Implementations of Various Lean Tools and Techniques (such as VSM, KAIZEN, TPM, 5S, Visual Management, Poka-yoke, SMED etc.) in approx. 100 Units.
• I have a wide exposure for Implementation of Lean Manufacturing Tools & Techniques to different industries like Automobile, Engineering, Food Industries, Leather Handicrafts, Leather Garments, Garments, Printing, Packaging, Shoes Industries, Plastic Injection Moulding, Aluminum Die Casting, CNC Machining, Conventional Machining, Tool Room, Press Shop, Fan Industry, Bicycle Industry, Fabrication & Sheet Metal etc. for improving their Productivity, Reducing Manufacturing cost & Rejection, 5S Levels, Employees Trainings with proper resource utilization and Implementation of various Kaizens (Improvements).
Key Skills:
• Value Stream Mapping (VSM), TIMWOOD (Seven Wastages), PQCDSME (Seven Benefits) Productivity Improvement, Time & Motion Study,
• TPM (Total Productive Maintenance), FUGAI Tags, 8 Pillars of TPM , Elimination of Six Big Losses (SSSMCB) through TPM
• 5S, KAIZEN, 7 QC Tools, VA/NVA Activities, Root cause analysis, SMED, Safety Improvements, Visual Management, etc.
----
SOME OF MY ONSITE PROJECT OF TRAINING & CONSULTANCY, COMLETED/ UNDER-PROCESS ARE:
Ultratech Cement (4 Plants)- Truck Turn Around Time (TAT) Prject
Combit Shoes, Bahadurgarh (HR)- Plant Layout Setup Project
Printsmith (Infinity Advertising Pvt. Ltd.),Faridabad
MSME- Faridabad Engineering Cluster No.1 (9 Units)- LMCS Cluster
MSME- Faridabad Engineering Cluster No.2 (6 Units)- LMCS Cluster
MSME- Faridabad Engineering Cluster No.4 (7 Units)- LMCS Cluster
MSME- Yamuna Nagar Engineering & Fabrication Cluster (9 Units)- LMCS Cluster
MSME- Ludhiana Cycle Parts Cluster No.2 (7 Units)- LMCS Cluster
MSME- Manesar, Leather Handicraft Cluster No.1 (7 Units)- LMCS Cluster
MSME- Bahadurgarh Footwear Cluster (6 Units)- LMCS Cluster
MSME- GZB Food Cluster (9 Units)- LMCS Cluster
Raga Engineers- Core Pins Productivity Improvement Project, Faridabad (HR)
Raga Engineers- Crack Toyota Project, Faridabad (HR)
Technomech Industries, Faridabad (HR)
Woodpecker Systems, Faridabad
Falcon Vacuum Pumps, Faridabad
Welcome Footwear, Bahadurgarh
RKP Packers, Delhi
Presto Stantest Pvt., Faridabad
United Cores Private Limited, Faridabad
PMT Engineers, Faridabad
UD food Products Pvt. Ltd., Ghaziabad
GK Industries, Faridabad
Durga Engineering Works, Faridabad
..............................................

[@amolpawar6462]

Sir ajj ki date me knowledge koe share nhi karta but asa Kam karke ap garib logo ki baoot helf our knowledge bad Rahi hai thanks sir ❤❤

[@aytindia]

dhnaywad...

[@ankamshreyash968]

SUPERB SIR!! sab cocnept direct dimag me fit ho jata he

[@aytindia]

Thanks keep watching and sharing

[@ambkumar]

Thank you for creating and sharing such a useful video. Your willingness to share your knowledge and expertise with the world is truly inspiring, and I know that many people, myself included, have benefited greatly from this. Your generosity and dedication to helping others is truly appreciated. Thank you for making a difference and for all that you do to help others.

[@sujitdable5907]

Thanku Sir Very Nice Information

[@prathmeshmane6133]

Thank you so much sir👌👌🙏🙏very easy to understand with your teaching skills.

[@KA-oi4yf]

Thanks a ton. This is useful for CMA US 🇺🇸 students too

[@aytindia]

Thanks and you're welcome

[@Mathematicswithrahul]

Thanks sir apne bahut hi simple tareeke se samjhaya hai aur mujhe bilkul samajh me aa gaya hai

[@aytindia]

Thank you, Keep Watching and Sharing

[@user-rt7us7qj9t]

Bohat khub brother I have learnt now pareto chart making. Anas Raza from karachi pakistan

[@aytindia]

Thanks,, keep watching and sharing

[@ghasiramsaini1151]

Very good 👍

[@aytindia]

Most welcome ! Keep Watching

[@sourabhdubey3920]

Good

[@aytindia]

Thanks

[@annuranjan3218]

Great

[@gajananjadhav9189]

Thank you sir it's a really very good knowledge sharing video for the community like us

[@aytindia]

Thanks, keep watching and sharing

[@narendranarendravs287]

Good explanation

[@aytindia]

Keep watching

[@vishwassharma6635]

Good 👍

[@shabirkhan9961]

The way you explain it, its so easy to understand

[@aytindia]

Thanks

[@abhisonic]

Thanks for an amazing way of teaching

[@aytindia]

You're welcome

[@chilldancer8139]

It's good video with all relevant details

[@darpansingh6404]

Thnx .....for sharing info

[@Misscontroversy]

You have give me full information regarding this thanks

[@aytindia]

Thanks for your feedback

[@MI-gr6lg]

Awesome Explaination

[@tateraopanchal3822]

Nice Explaination and Presentation

[@aytindia]

Thanks for the feedback

[@VijayKumar-vf1th]

Very easy language... Easy to understand 👍 thanx lot

[@vinayakdoiphode7550]

Mast simple and best

[@mohammadshabbir7775]

Very Helpful sir..

[@aytindia]

Keep watching

[@arjunchauhan499]

Good Explained..

[@puranbhandari2504]

Very nice demonstration. Thank you

[@aytindia]

Glad it was helpful!

[@preetigera4185]

Full knowledgeable thanks

[@saurabhmishra6590]

Outstanding explanation sir I need to learn many more from you...👍👍👍

[@aytindia]

Thanks,, Keep Watching

[@SauravKumar-wv3kf]

Nice video

[@aytindia]

Thank you, Keep Watching and Sharing

[@sureshkandekar4140]

Thanks Sir

[@aytindia]

Glad it was helpful! Keep Watching and Sharing

[@priyankachoubeyarora]

Amazing

[@aytindia]

Thanks

[@amanupadhyaya696]

Thank you so much sir

[@AlishaFarhanAli]

Keep it up god bless u ❤

[@aytindia]

Thanks. Keep watching and sharing

[@manishprasad6166]

Bahut Badiya!!

[@aytindia]

Dhanywad...

[@avinashchougale2510]

very effective ,sir please sharer worksheet

[@aytindia]

bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@mishras.k.2896]

Nice

[@gurpritsingh11]

Thank you so much buddy

[@anjukaur7619]

Good explanation sir

[@aytindia]

Keep watching & Share with Friends

[@santmun2008]

Thank you so much sir ji...

[@pritikhairnar5638]

Very effective

[@relaxationmusickavita6889]

Nice video,its really helpfull

[@babyChitransh7252]

Sir your all videos amazing

[@aytindia]

Thanks & Keep watching

[@ashishbhosale5046]

Thank you

[@aytindia]

You're welcome

[@prashantsingh8327]

Well explained sir 👏

[@aytindia]

Keep watching

[@PRAVINYADAV-os4je]

Good explanation and Presentation. Please share work sheet on it.

[@aytindia]

Share your email id

[@yoginderkumar4370]

Hello sir, Very simple and most important learning.

[@aytindia]

Thanks and welcome

[@Tapzzzzz_007]

Thank yo so much

[@paprimondal5238]

Thank you sir.. Do u give six sigma training

[@aytindia]

Not available, as of now

[@job_in_gj]

Nice Sir

[@ajeetrajbhar2633]

Dear sir, Thanks for making the video, I learned very easily, pls share work sheet

[@aytindia]

Share your email address

[@imgauravchauhan]

Pls reply me

[@imgauravchauhan]

Share the worksheet

[@kalyanrao8634]

Looking at the video, I have enrolled in a course -on AYT website -Machine supervison course.

[@aytindia]

Best of luck!

[@sahilsingh-em7yq]

Watched lots of videos on parreto chart but after watching your video my all doubts have been removed.

[@ashulittlestar3933]

Sir, similarly make video on all tools .. Please.

[@aytindia]

ok

[@TAPASKOLEY]

Please share the pareto chart drawing method

[@aytindia]

bzxqj.on-app.in/app/oc/371667/bzxqj?Dcopy-link%26Dtutor-course-referral%26Dcourse-overview-app

[@kubersingh1432]

Thanks a lot for the useful video 👍👍👍😊👏👏

[@deepanshu1077]

Within 80 consider krna hai ki within 90.... because jo third hai wo to 87.02 hai.... I just wanted to ask ki ek bar chart ki frequency 43% and agle ki 80% then third wala jiski 86% hai use bhi analysis mei include krna hai??

[@aytindia]

top 3 bhi le sakte h

[@karukumarchaudhari2454]

sir, please suggest me how to match secondary axis to first axis

[@aytindia]

Pl watch complete Video

[@devendrasarna1056]

Great pls share work sheet

[@aytindia]

Pl share your Email ID

[@viralvideo...7464]

Kis key se data select kar rhe hi.. Please tell me

[@jyotithakur7301]

Hlo sir can you share ppt and worksheet of this

[@aytindia]

pl send mail on [e-mail]

[@annuranjan3218]

Please share worksheet with me.regards

[@aytindia]

bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@imgauravchauhan]

Worksheet Chahiye sir g

[@mohibaziz6024]

😇

[@aytindia]

Thanks , Keep watching and Sharing

[@yoginderkumar4370]

Sir, Please share work sheet

[@aytindia]

Pl send a mail on [e-mail]

[@sandilyatripathi4962]

Please share the worksheet.

[@sujitdable5907]

Sir Plz Send Work sheet

[@aytindia]

bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@eliyasahmed9435]

I need this worksheet

[@aytindia]

pl write on [e-mail]

[@nileshpagar5000]

👍

[@careervision1162]

Hello sir excel me right click krne pr secondary axis ka option ni aa rha h

[@shubhampandey-mv6hy]

Sir Plz share this exel sheet

[@aytindia]

bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@rajnishkumarrai3743]

Please share this work sheet

[@arifsaeed7914]

Sir mujhe work sheet ki need hai

[@aytindia]

bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@amolbaviskar8118]

Pls share work sheet

[@aytindia]

bzxqj.on-app.in/app/oc/371667/bzxqj?Dcopy-link%26Dtutor-course-referral%26Dcourse-overview-app

[@9812251336]

Sir worksheet chahiye plz

[@aytindia]

Pl send a mail on [e-mail]

[@saleemnaqvi9874]

Good presentation, sir worksheet required.

[@avanishtiwari6975]

Sir mujhe vi work seet cahiye

[@aytindia]

pl mail on [e-mail]

[@gulshankhan6714]

What is PFD

[@aytindia]

process flow diagram

[@mohanmunda7039]

Dear sir Yah mujhe work chiye urgent hai

[@aytindia]

Pl send mail on [e-mail]

[@careervision1162]

= D1/last and slect last then freez f4 click

[@bhagvandas9545]

Ji Sir Hamen worksheet chahie

[@abhisheksharma5483]

Sir plz send this sheet 🙏

[@aytindia]

Please write mail on [e-mail]

[@Shravanbhardwaj2332]

Please share this sheet

[@dssharma474]

Work sheet required

[@aytindia]

Pl check : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@yogendramanjhi4972]

i need chart

[@aytindia]

send request mail on [e-mail]

[@vikasgautam2498]

Share this excel sheet

[@aytindia]

docs.google.com/forms/d/e/1FAIpQLSeCZgM3HehFwHoFOcamOipVN92HJrTCcw721YNXhhOjSnX8rA/viewform

[@user-wf4dm5rg7d]

Need data sheet

[@aytindia]

mail request on [e-mail]

[@chiragpatel3226]

Send me worksheet

[@aytindia]

bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@balasahebtate4699]

Share me pareto sheet

[@aytindia]

Pl check here bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@punamsasmal3624]

Pplease share

[@aytindia]

Pl check here : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@Rajeevkumar-qo1be]

Sheet dedo

[@shabddayalkhokhar3684]

Sir aapka no kya h ji

[@aytindia]

mentioned in videos

[@rajeshbhedi4384]

Please send me

[@aytindia]

Pl Check : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

[@merathuni5408]

Q

[@taashifqadimi4044]

Sir, please don't use the background music in your videos

[@aytindia]

it is my old video.. in new videos there is no background music after such feedbacks, thanks

[@jesh5504]

Thank you so much sir 🙏

[@kalyanrao8634]

Good

[@aytindia]

Thanks

[@dheerajkumargupta7009]

Awesome

[@yatendrayadav9]

Sir please share work sheet

[@VimalKumar-to1fi]

Please share work sheet

[@aytindia]

pl send mail on [e-mail]

[@nirajchauhan1995]

Sir worksheet chahiye

[@aytindia]

pl mail on [e-mail]

[@vj-ct2cr]

pl share the work sheet

[@aytindia]

Pl write a mail on [e-mail]