Jump to content

Search the Community

Showing results for tags 'working with data'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Learning Business Excellence and Lean Six Sigma
    • We ask and you answer! The best answer wins.
    • Lean Six Sigma for Beginners
    • Lean Six Sigma applicability in Industry Sectors
    • Discussion Forum for Practitioners
    • Debate : For or Against
  • Know about Benchmark Six Sigma
    • About Us, Services, Recognition, Network, Support
  • Recreation Center
    • Debate Halls
    • Fun and Trivia
    • Benchmark Six Sigma Cartoon Strip
  • Discussions related to Training
    • Discussions related to Green Belt, Black Belt, Lean Expert
    • Right Sequence for Training and Projects
    • Master Black Belt and its competencies
    • Refresh your basics on data analysis
  • Benchmark Six Sigma Participants Support Forum
  • Articles from across the Globe
  • You ask and we answer!


  • Process Excellence
  • Data Driven Decision Making
  • Debate


There are no results to display.

There are no results to display.


  • Participants Support- General
  • Open Forum- General
  • Basic Maths for Six Sigma
  • Training Brochures
  • Black Belt Pre-Study Material & Exercise Content
  • Green Belt Pre-Study Material & Exercise Content


There are no results to display.

There are no results to display.

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start






BB Score

Found 19 results

  1. I suppose everyone agrees that if one is not good with numbers, career growth is likely to face a serious roadblock at one stage or the other. I have noticed several people who fear mathematics and this leads to certain problems in learning or applying Six Sigma. Many have already given up hope assuming that they can never cover up. Good news, however is that this weakness can be addressed by most people. It definitely needs a persistent effort to capture Mathematics concepts that are really important. Some of these are Algebra, Data Handling, Decimals, Equations, Exponents and powers, Fractions, Graphs, Integers, Mathematical modelling, Mathematical Reasoning, Probability, Proportions, Ratios, Rational Numbers and Statistics. If you are one of those who felt this way and wish to improve your math, I can provide you a step by step approach which shall broadly follow the sequence below. Plan study time for these topicsUse the uploaded materialStudy identified topics and answer questions provided in the text. Check your answers with answer key provided.Conquer your weakness and face the Six Sigma world more confidently.In case good number of people see value in such a sequence, I shall be putting in extra effort and make the content and sequence available to you free of cost. I have written this post just to know whether there are many people out there who really wish to use such content and approach. Reply to this post showing your interest so that I can view the count. Best Wishes, VK
  2. Descriptive Statistics is one of the simplest techniques used in quality management to obtain a meaningful insight into the data being analyzed. (The original article can be found at the source link mentioned below the extract) Let us take a few examples. It makes sense to build a frequency table of complaints by categories from the raw data on complaints from different customers. It clearly tells us the top few complaints that need immediate attention. On the other hand, it would be preferable to compute the average or mean from loan processing time data of thousands of applications from a bank to find out the average turnaround time required to process any application. This can subsequently be compared with industry average to benchmark bank's performance. SCAN: Basics of Statistics- www.discover6sigma.org/post/2005/12/statistics-simplified/ Data types tell us how we can gain meaningful insight in the data – this could be achieved by computing mean or by building frequency table or by using other summary measures such as mode or median. Therefore, it is important to understand the type of data being analyzed to determine what summary measures are applicable to obtain a meaningful insight. Read full article at: www.discover6sigma.org/post/2011/06/desc-stats/
  3. This section is for two types of users: BASICS - For users who are not conversant with Microsoft Excel. Also, people who know nothing about Excel and have just started using a computer. ADVANCED - People who have been using basic formulas but wish to use lookup, pivot tables and hundreds of other advanced features of Excel. It is important to know the use of Microsoft Excel formulas. If you find yourself using only Excel (instead of a calculator) for all calculations in a few days, you can congratulate and treat yourself. BASICS - For Six Sigma perspective, you need the basics given on the following link - www.free-training-tutorial.com/formulas.html Feel free to explore more on the website (beyond formulas) if you wish. ADVANCED - If you are an avid excel user and wish to learn more, you can use the following website link - www.chandoo.org/wp/learn-excel-online.html Cheers! VK
  4. InderjeetSingh

    Continuous And Attribute Data

    As a novice to the field of Six Sigma, I would like to understand, if in lean six sigma project I have the option of collecting both continuous and attribute data, which one should I opt for ?
  5. Dear All, I am running a project on Customer satisfaction and because we cannot do an MSA on the survey form. I would like to understand how to use logical validation of data. Kindly Help Thanks Hamza
  6. can we use probability distribution function in excel 2007 or 2010 . if yes then how?
  7. Vishwadeep Khatri

    Powers - Level 1

    During Six Sigma training, I come across participants unfamiliar with terms like 3 multiplied by ten to the power of minus 6. You may need to refresh the concepts of powers by moving through this chapter. Use the following link http://forum.benchmarksixsigma.com/index.php?/files/file/13-powers/
  8. Vishwadeep Khatri

    Statistics - Level 1

    The word ‘statistics' appears to have been derived from the Latin word ‘status' meaning ‘a (political) state'. In its origin, statistics was simply the collection of data on different aspects of the life of people, useful to the State. Over the period of time, however, its scope broadened and statistics began to concern itself not only with the collection and presentation of data but also with the interpretation and drawing of inferences from the data. Statistics deals with collection, organisation, analysis and interpretation of data. To refersh your basics on statistics of grouped data, have a look at this material statistics-level 1To refresh your basics on statistics of ungrouped data have a look at this material statistics-level 2
  9. How much can a graph show? Click here to see how India Ball took off late.See wealth and health of nations by clicking here. Click on Play to see how some nations picked up well, how China overtook India. Choose a country on the right and click on "Play" to see the path that stays on.To see much more in the same graph, use this tutorial by clicking here. Pictures speak larger than words. How much data do we need to explain the second graph? Even if we compiled it, how many people would like to read it?
  10. Vishwadeep Khatri

    Powers Level 2

    An interesting method to learn powers of 10 is shown here. Earth = 12.76 x 10+6 = 12,760,000 meters wide (12.76 million meters) Plant Cell = 12.76 x 10-6 = 0.00001276 meters wide (12.76 millionths of a meter) Please view on the following link to learn powers through distances www.micro.magnet.fsu.edu/primer/java/scienceopticsu/powersof10/
  11. It is remarkable that a science, which began with the consideration of games of chance, should be elevated to the rank of the most important subject of human knowledge. -Pierre Simon Laplace Where a mathematical reasoning can be had, it is as great a folly to make use of any other, as to grope for a thing in the dark, when you have a candle in your hand. - JOHN ARBUTHNOT If you study Six Sigma, you work with probabilities very often. Examples of basic questions - What is the probability of defects in process A or in process B or in Process C if the probabilities in A, B and C are 0.2, 0.3, 0.1 respectively? What is the probability of defects in this process? If someone says that probability is 0.35, is it a small chance or a worrisome probability? To refresh such concepts, you can go through some content on probability. Probability-1 Probability-2 Probability-3
  12. Level 3 can help you learn more. However, it is not necessary for everyone to follow Level 3. Try the following question - If you ask 23 random people their birth dates, what are the chances that at least two will match?If you ask 40 random people their birth dates, what are the chances that at least two will match?If you ask 60 random people their birth dates, what are the chances that at least two will match?Surprisingly, with only 23 people, the probability of at least one match is about 0.5073. With 40 people, the probability is about 0.8912, and with 60 people, the probability is about 0.9941 Why? How? Have a look by clicking here
  13. 1. Conditional Probability Learning - Example The probability of A is 7.5%. The probability of B is 20%. Move the events A and B around and study all event probabilities on the right side. Use the diagram by clicking here. Want to play around with more flexibility? Try this link here. 2. Probability of success in an event that requires multiple stages to be correct. Please try this link by clicking here Use all three probabilities as 80%. They seem good individually. Try rocket launches 20 times. How many were successful? Why? What happens if you keep all three probabilities as 50%.
  14. Many problems are solved with the use of mathematical models. To get an introduction to the creation of mathematical models, you may study the following: Mathematical Modelling-1 Mathematical Modelling-2
  15. Do you find ratios difficult to work with? What is three fourth of four fifth of hundred? If you wish to refresh your concepts please go through the following material - Ratio and Proportion-1Ratio and Proportion-2Rational Numbers-1Rational Numbers-2
  16. Do you know why the equation of a line is in the format y = mx + c? To refresh your concepts about equations please go through the following chapters: Equations-1 Equations-2 Equations-3
  17. One needs to be familiar with basics of Data Handling. Pictographs, Bar Charts - Data Handling-1Measures of central tendency and why they are needed - Mean, Median, Mode. Data Handling-2Grouped frequency distribution, histogram, pie chart, events and probabilities. Data Handling-3 If you are familiar and comfortable with these terms, you can skip this section.
  18. Vishwadeep Khatri

    Algebra - Level 1

    Why study Algebra - A common feature in Algebra is the use of unknown variables with x,y,z. This has special relevance in Six Sigma for the following reasons. Use of letters will allow us to write rules and formulas for elements that can vary. This helps in developing relationship between variables (like relation between cost and quality)Commonly letters denote unknown quantities. By learning methods of determining unknowns, we develop powerful tools for solving puzzles and addressing many process problems.Since letters stand for numbers, operations can be performed on them as on numbers. This leads to the study of algebraic expressions and their properties. This has application in many Six Sigma tools. Examples are regression analysis, design and analysis of experiments.
  19. Hi, We have 2 sets of data, one is the mean and the other its corresponding Std. deviation. We have independent targets for both against which they are tracked. Can you let us know if there is any way of combining the two into an equivalent single metric and project. Thanks Sridhar