How to create a single-tailed Gaussian distribution

Clinto

New Member
Joined
Jan 10, 2013
Messages
9
I need to create a data set consisting of 100 data points. The data set needs to be a single-tailed Gaussian distribution (with the tail below the median), with the data points in random order (i.e. not sorted from high to low, or low to high or anything like that).

The median value of the Gaussian distribution will be 100 and the standard deviation will be 3%. (It would be nice to be able to create the data set with any median and standard deviation.) The data values will be rounded to the nearest integer.

I found a website that generates data sets with Gaussian distributions after I specify median and standard deviation, and it will create a data set with any number of data points that I want and in random order. But it generates two-tailed data sets - with values above and below the median.

Two possible solutions to this:

(1) Can Excel generate a data set per my requirements? (I actually need to generate several such data sets with 100 data points in each data set.)

(2) I can use the website I found to generate a two-tailed data set with 200 data points, and then import the data set into Excel. Are there steps I could do in Excel to delete the data values above 100 (above the median) and compact the remaining data points into a single column in Excel, preserving the random order?

I'm using Excel 16.49 on a Mac.

I posted this question on Reddit and on ExcelForum.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,319
Office Version
  1. 365
Platform
  1. Windows
I posted this question on Reddit and on ExcelForum.
Thanks for letting us know, but can you please post links to those threads, as per board rules. Thanks
 

Clinto

New Member
Joined
Jan 10, 2013
Messages
9
Thanks for letting us know, but can you please post links to those threads, as per board rules. Thanks
Sorry about that. I read the rules and I guess I missed the requirement to post links. Here they are:


https://www.reddit.com/r/excel/comments/nluk7l/_/gzlvxae
It looks like I'm making headway from responses on the other forums. I think this question is about 95% answered, and with the next response from either of those forums it may be 100% answered.
 

Forum statistics

Threads
1,141,204
Messages
5,704,944
Members
421,372
Latest member
Jamie11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top