January 20th, 2017, 03: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  

Similar Threads  
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 