|January 20th, 2017, 03:39 AM||#1|
Joined: Jan 2017
Hope you're all well.
in excel, I am using 2 input parameters; average and standard deviation, and generating a set of 1000 lines using the random function. currently i have to avg set to 4.5 and stdev at 2.
i produce a graph and you can see a normal distribution curve. if i use the average function for the 1000 random numbers, it results around the 4.5 mark.
if i lower the avg to 1.3 for example, and keep stdev at 2, the graph goes into negative as expected and avg is around 1.3, but if i calculate the average for anything greater than zero, its never at 1.3.
I will never have a person buying less than zero items. therefore i require a skewed formula where the spread always starts from 1, where i input an average and stdev and create a sample of 1000 lines, and the average of the sample will always be around the input parameter set.
I there such a formula? I've tried forcing the less than zero to have 1, but that gives incorrect results =MAX(1,NORM.INV(RAND(),1.3,2))
Many thanks in advanced.
|Thread||Thread Starter||Forum||Replies||Last Post|
|Average Mean Deviation VS. Standard Deviation||John Travolski||Probability and Statistics||1||July 14th, 2016 01:21 PM|
|Mean/Std Deviation||ALRS||Advanced Statistics||2||January 27th, 2015 07:37 AM|
|Standard deviation VS Mean absolute deviation||Axel||Algebra||2||April 28th, 2011 03:25 AM|
|counter example to a skewed deltaepsilon defns?||ElMarsh||Real Analysis||13||October 16th, 2009 07:54 AM|
|Find the distance between two skewed lines||sixflags11804||Algebra||1||September 29th, 2008 11:26 PM|