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
..............................................

[@gajananjadhav9189]

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

[@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.

[@ankamshreyash968]

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

[@aytindia]

Thanks keep watching and sharing

[@VijayKumar-vf1th]

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

[@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

[@chilldancer8139]

It's good video with all relevant details

[@MI-gr6lg]

Awesome Explaination

[@relaxationmusickavita6889]

Nice video,its really helpfull

[@shabirkhan9961]

The way you explain it, its so easy to understand

[@aytindia]

Thanks

[@preetigera4185]

Full knowledgeable thanks

[@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

[@abhisonic]

Thanks for an amazing way of teaching

[@aytindia]

You're welcome

[@saurabhmishra6590]

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

[@aytindia]

Thanks,, Keep Watching

[@darpansingh6404]

Thnx .....for sharing info

[@puranbhandari2504]

Very nice demonstration. Thank you

[@aytindia]

Glad it was helpful!

[@amanupadhyaya696]

Thank you so much sir

[@user-rt7us7qj9t]

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

[@aytindia]

Thanks,, keep watching and sharing

[@annuranjan3218]

Great

[@santmun2008]

Thank you so much sir ji...

[@gurpritsingh11]

Thank you so much buddy

[@arjunchauhan499]

Good Explained..

[@vishwassharma6635]

Good 👍

[@jesh5504]

Thank you so much sir 🙏

[@ghasiramsaini1151]

Very good 👍

[@aytindia]

Most welcome ! Keep Watching

[@ExcusemeNIKKI]

You have give me full information regarding this thanks

[@aytindia]

Thanks for your feedback

[@tateraopanchal3822]

Nice Explaination and Presentation

[@aytindia]

Thanks for the feedback

[@PRAVINYADAV-os4je]

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

[@aytindia]

Share your email id

[@narendranarendravs287]

Good explanation

[@aytindia]

Keep watching

[@babyChitransh7252]

Sir your all videos amazing

[@aytindia]

Thanks & Keep watching

[@Tapzzzzz_007]

Thank yo so much

[@dheerajkumargupta7009]

Awesome

[@AlishaAli0825]

Keep it up god bless u ❤

[@aytindia]

Thanks. Keep watching and sharing

[@mohammadshabbir7775]

Very Helpful sir..

[@aytindia]

Keep watching

[@sourabhdubey3920]

Good

[@aytindia]

Thanks

[@vinayakdoiphode7550]

Mast simple and best

[@avinashchougale2510]

very effective ,sir please sharer worksheet

[@aytindia]

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

[@pritikhairnar5638]

Very effective

[@mishras.k.2896]

Nice

[@sureshkandekar4140]

Thanks Sir

[@aytindia]

Glad it was helpful! Keep Watching and Sharing

[@manishprasad6166]

Bahut Badiya!!

[@aytindia]

Dhanywad...

[@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

[@anjukaur7619]

Good explanation sir

[@aytindia]

Keep watching & Share with Friends

[@prashantsingh8327]

Well explained sir 👏

[@aytindia]

Keep watching

[@job_in_gj]

Nice Sir

[@SauravKumar-wv3kf]

Nice video

[@aytindia]

Thank you, Keep Watching and Sharing

[@ashishbhosale5046]

Thank you

[@aytindia]

You're welcome

[@nileshpagar5000]

👍

[@kalyanrao8634]

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

[@aytindia]

Best of luck!

[@priyankachoubeyarora]

Amazing

[@aytindia]

Thanks

[@ashulittlestar3933]

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

[@aytindia]

ok

[@viralvideo...7464]

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

[@paprimondal5238]

Thank you sir.. Do u give six sigma training

[@aytindia]

Not available, as of now

[@sandilyatripathi4962]

Please share the worksheet.

[@karukumarchaudhari2454]

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

[@aytindia]

Pl watch complete Video

[@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 👍👍👍😊👏👏

[@careervision1162]

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

[@imgauravchauhan]

Worksheet Chahiye sir g

[@mohibaziz6024]

😇

[@aytindia]

Thanks , Keep watching and Sharing

[@yatendrayadav9]

Sir please share work sheet

[@rajnishkumarrai3743]

Please share this work sheet

[@jyotithakur7301]

Hlo sir can you share ppt and worksheet of this

[@aytindia]

pl send mail on [e-mail]

[@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

[@annuranjan3218]

Please share worksheet with me.regards

[@aytindia]

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

[@careervision1162]

= D1/last and slect last then freez f4 click

[@devendrasarna1056]

Great pls share work sheet

[@aytindia]

Pl share your Email ID

[@bhagvandas9545]

Ji Sir Hamen worksheet chahie

[@Shravanbhardwaj2332]

Please share this sheet

[@arifsaeed7914]

Sir mujhe work sheet ki need hai

[@aytindia]

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

[@shubhampandey-mv6hy]

Sir Plz share this exel sheet

[@aytindia]

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

[@yoginderkumar4370]

Sir,
Please share work sheet

[@aytindia]

Pl send a mail on [e-mail]

[@eliyasahmed9435]

I need this worksheet

[@aytindia]

pl write on [e-mail]

[@avanishtiwari6975]

Sir mujhe vi work seet cahiye

[@aytindia]

pl mail on [e-mail]

[@amolbaviskar8118]

Pls share work sheet

[@aytindia]

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

[@nirajchauhan1995]

Sir worksheet chahiye

[@aytindia]

pl mail on [e-mail]

[@mohanmunda7039]

Dear sir
Yah mujhe work chiye urgent hai

[@aytindia]

Pl send mail on [e-mail]

[@vivek4484]

Please share work sheet

[@aytindia]

Pl send a mail on [e-mail]

[@vj-ct2cr]

pl share the work sheet

[@aytindia]

Pl write a mail on [e-mail]

[@abhisheksharma5483]

Sir plz send this sheet 🙏

[@aytindia]

Please write mail on [e-mail]

[@Rajeevkumar-qo1be]

Sheet dedo

[@gulshankhan6714]

What is PFD

[@aytindia]

process flow diagram

[@yogendramanjhi4972]

i need chart

[@aytindia]

send request mail on [e-mail]

[@punamsasmal3624]

Pplease share

[@aytindia]

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

[@vikasgautam2498]

Share this excel sheet

[@aytindia]

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

[@balasahebtate4699]

Share me pareto sheet

[@aytindia]

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

[@user-wf4dm5rg7d]

Need data sheet

[@aytindia]

mail request on [e-mail]

[@Vinodbhardwaj92]

sir pls send work sheet

[@aytindia]

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

[@aytindia]

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

[@sahilsingh-em7yq]

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

[@dssharma474]

Work sheet required

[@aytindia]

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

[@rajeshbhedi4384]

Please send me

[@aytindia]

pl write a mail on [e-mail]

[@merathuni5408]

Q

[@shabddayalkhokhar3684]

Sir aapka no kya h ji

[@aytindia]

mentioned in videos

[@yoginderkumar4370]

Hello sir,
Very simple and most important learning.

[@aytindia]

Thanks and welcome

[@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

[@kalyanrao8634]

Good

[@aytindia]

Thanks

[@VimalKumar-to1fi]

Please share work sheet

[@aytindia]

pl send mail on [e-mail]

[@9812251336]

Sir worksheet chahiye plz

[@aytindia]

Pl send a mail on [e-mail]

[@saleemnaqvi9874]

Good presentation, sir worksheet required.

[@rajeshbhedi4384]

Please send me

[@aytindia]

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