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.
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.