Count the number of deliveries all doctors performed.With Pivot Tables and the file above you could: In past incarnations it was known as Crosstab (for cross tabulation). To summarize and analyze this data, you will want to learn how to use Excel's PivotTable tool. Most companies have lots of transaction data from "flat files" like the one shown below, but because the data consists of text and raw numbers, they sometimes have a hard time figuring out what to do with it. To succeed at Six Sigma or any process improvement effort, you'll often have to analyze and summarize text data. Free Agile Lean Six Sigma Trainer Trainingįree Excel Tips » Pivot Tables Pivot Tables Is there an improvement project lurking in your data?. Animated Lean Six Sigma Video Tutorials.
0 Comments
Leave a Reply. |