# How to generate random data based upon known percentage distribution using Excel

Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data to look familiar to the participants. I want to use the names of their products in sample data containing 1000 rows. I could use Randbetween() with Vlookup but that gives me almost equal distribution for all products. I want to make the data look realistic. I want to use the market share values of their products to generate the sample data. Here is how you do it. 3.5 minute video.

# Paste Special everything except formulas

In the earlier article we saw that Excel Paste Special Values and Number Formatting is the recommended option. But there is another option which can be even better in some cases.

# Why you should never use Paste Special Values in Excel

Yes. I know this is a commonly used feature. In spite of that, I am saying that you should never use Paste Special Values in Excel. Read on to find out why.

# Quality Management 6: Scatter Diagram

When you have two columns of numeric data, Scatter chart helps you understand how they affect each other (jargon: correlation). Creating a scatter plot is easy. But interpretation can be misleading or even absurd. Let us explore how to create effective Scatter plots.

# Quality Management 5: Pareto Chart

This chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.

# Quality Management 4: Histogram (using Excel 2016)

Well, the histogram articles don’t seem to be ending. I promise, this is the last one. With Excel 2016, a new chart type called Histogram was introduced. Now we don’t need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.

# Quality Management 4: Histograms (any version of Excel)

Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.

# Quality Management 2. Check Sheet

This is a simple grid. Usually done on paper. But with ubiquitous tablets being available, it can be done on Excel as well.