My Math Forum  

Go Back   My Math Forum > Welcome > New Users

New Users Post up here and introduce yourself!


Reply
 
LinkBack Thread Tools Display Modes
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.
talvin singh is offline  
 
Reply

  My Math Forum > Welcome > New Users

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





Copyright © 2017 My Math Forum. All rights reserved.