My Math Forum Skewed Deviation

 New Users Post up here and introduce yourself!

 January 20th, 2017, 02:39 AM #1 Newbie   Joined: Jan 2017 From: Italy Posts: 1 Thanks: 0 Skewed Deviation Hi All, 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. =NORM.INV(RAND(),4.5,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.

 Tags deviation, skewed

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post John Travolski Probability and Statistics 1 July 14th, 2016 01:21 PM ALRS Advanced Statistics 2 January 27th, 2015 06:37 AM Axel Algebra 2 April 28th, 2011 03:25 AM ElMarsh Real Analysis 13 October 16th, 2009 07:54 AM sixflags11804 Algebra 1 September 29th, 2008 11:26 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top