Hello,
I can't for the life of me figure out how to create the standard normal distribution chart.I have a pic of it but I also can't figure out how to attach a pic to a post(sorry), so i'll try to describe where i'm having the problem.
here's where i'm stuck : I don't know how to make the y axis cross the x axis at point 0.
The data i'm using has negative x values so the y axis crosses at the most negative value instead.
Please help.
Thanks.
Hello all. First post here and I'm looking for a little bit of help .
I've started on a project for a Prob & Stat class I have and I'm stuck trying to figure out how to display a lognormal probability distribution on a Histogram.
In the attached .xlsx on sheet "C1 HIST" you can see the random variable seeds, the loginv to get the full numbers (column C), the BIN I used for the histogram, and my attempt at the "lognormaldist" values. On sheet 3 you an see the actual commands I used to generate the numbers. I don't think I'm using the "lognormaldist" properly because the values in Column E of "C1 HIST" keep going up instead of spiking up quickly and then coming back down.
Toward the bottom of this sheet you can see what an add-in called "EasyFitXL" shows the lognormal distribution to be, but I'd like to know how to do it without an add-in.
I also attached the project statement (I'm trying to do the probability distribution part of step 2 of "Progress Report 1". Right now I'm just trying to figure out everything for Random Variable C1, and once that's done, the rest will be easy. You can also see the distribution type, CV, and Mean on the table in the .pdf (seen at the upper right of sheet "C1 HIST").
If you guys have any help/input it's be greatly, greatly appreciated.
Thanks so much!
Greetings,
I have been wondering about this for some time. I'm doing a lot of
work with probability and statistical distributions these days, and
many of the classes or types of distributions have different parameters
which characterize them. For example, standard distributions tend to
have a (mu, sigma) which defines the familiar bell curve. My question
is, is there a way to enter those two numbers (or function
characteristics of any number) and have Excel autogenerate the the
row/column data from which a bell curve can be automatically drawn on a
subsequent chart? By this I mean, I'd like to not have to manually
have a column which uses a function to calculate the values at that
point and copy the function to every cell yielding a new F(x) -- I want
Excel to be able to take my numbers and blam! fill in the columns for
me. Also, I'd like to be able to add a checkbox for the user to select
either discrete or continuous, and have the chart draw itself
accordingly (i.e. either discrete, integral vertical lines forming a
curve shape, or an actual curve like what you'd find on a "non-pointed"
scatter chart). Thanks.
Mike
Hi,
I have a spreadsheet full of daily stock returns and want to find out which distribution is closest to the one exhibited by the returns. Excel should give me the answer like: this is a normal distribution, or this is a log-normal distribution, or this a Bernoulli distribution....
Is there any function that lets Excel test all distributions and returns the closest or do I have to test my daily returns with all distributions I can think of and see myself if the returns are close to one distribution?
In a second step I want to use the distribution to generate random numbers based on the distribution (like a monte carlo simulation) to simulate scenarios. How can I do this then?
(I have this Excel Add-In called PopTools but I am not so familiar with it)
Would be great if someone had an answer for me!
Thanks
I have 103 years of daily rainfall data. I need to know which probability distribution it follows. Is it possible to find the distribution pattern followed by rainfall using MS excel.
Is there a slick way to plot probability distributions and probability density functions?
Any help will be appreciated.
Hi Everyone,
Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?
I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.
Any help would be appreciated.
Hi Everyone,
Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?
I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.
Any help would be appreciated.
Hello Everyone,
I have a quick question. I am using Excel to do some statistical modelling and I am wondering if anyone knows if the PERCENTILE function in Excel has the ability to determine the most suitable probability distribution model that best describes the data set before giving an answer. No reference is made to the probability distribution model in the Excel help file on PERCENTILE function. Does anyone here definitively know how the PERCENTILE function works? Does it base the answer on the probabilty distribution function or does it simply order the data set and give the answer based on the rank? Any clarification is welcome.
hi
how are u all
i have a data like this and lets say that it's in column E in an excel sheet
Code:
8
-2
2
-6
2
-2
2
-8
7
now i want to bulid a chart like in the attached pic.
the numbers in the top of the pic is for illustration only we dont need it
but by looking at the arrangement of the bars (it's the same as the arrangement of the previous schedule) and also the numbers in the body of the bars is not important ,,,,,i need the bars only
my question is it posible to make this chart in excel?
any suggestion plz?
[..[/URL]
