# Search the Community

Showing results for tags 'working with data'.

• ### Search By Tags

Type tags separated by commas.

### Forums

• 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

### Categories

• Process Excellence
• Data Driven Decision Making
• Debate

### Categories

• 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

• 0 Replies

• 0 Reviews

• 0 Views

Found 19 results

2. ## Descriptive Statistics

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. ## Microsoft Excel Tips - For New Users And Advanced Users

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. ## 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. ## Logical Validation Of Attribute Data In Measure Phase

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. ## Probability Distribution Function In Excel

can we use probability distribution function in excel 2007 or 2010 . if yes then how?
7. ## 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. ## 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. ## Data Handling Level 2

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. ## 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. ## Probability - Level 1

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

13. ## Probability - Level 2

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. ## Mathematical Modelling - Level 1

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. ## Ratios, Proportions And Rational Numbers - Level 1

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. ## Simple Equations, Linear Equations - Level 1

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. ## Data Handling - Level 1

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. ## 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. ## Combining Mean & Std. Deviation Metrics

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
×