normal distribution

Hi All, can anyone help me create a formula which will solve Owens T function. I have not been able to think of a way to do this. I have been using Wikipedia for the formula Owen's T function - Wikipedia. Does anyone know how to input a formula which can solve this for a range of x and a inputs?

Hi, I am trying to create a formula in excel which shows the provides the Cumulative distribution function for a skewed normal distribution giving set parameters for skewness, mean and std. dev. I have done this for a normal distribution using the Norm.Dist (Culminative True) function, but i...

Hello! I have trouble finding the mean and probabilty when only the standard deviation is given. I have the correct answer, look below questions. I think NORM.S.DIST might be the correct formula, but I cant figure out HOW to use this to get the solution. QUESTION 1) A Top-load washers at a...

I want to generate a series of values that would form a classic bell-curve shape if plotted on a graph, starting at zero rising to a max and descending again to zero, in a curve that maintains a prescribed average. The application is to generate a series of rainfall data sets using a defined...

Hi all, I'm trying to find the formulas needed in Excel to calculate Power and Sample size, as we currently use Minitab and it is tedious with a long list of inputs. I used this site http://www.real-statistics.com/sampling-distribuion/statistical-power-sample/ but I do not have a standard...

The picture below shows a simple example of the problem I'm facing. I'd like to maximize a cell that is the sum of other cells that are not linear. In the spreadsheet, I have Z scores for categories I and II (I hardcoded in a mean of 30 and stdev of 15 for category I and 40 and 10 for category...

Hey, I have a portfolio of 20 stocks over a time period of 15 years. I calculated the mean returns and the covariance matrix. Now I want to perform a Monte Carlo simulation based on a multivariate normal distribution with the same parameters. I downloaded the “real statistics resource pack”...

First of I'm not sure if this is the place for such a question I have a set of 8 Players (could be any number from 2 players to 8 players in the group) I would like an excel formula to workout the percentage chance of each player to score the most points. I have managed to workout on Excel...

Hi, I'm hoping someone can help me with the following. In excel I'd like to simulated return series for 2 correlated assets, X&Y, with the following properties, and using a normal distribution: Mean X:0.15%, Std Dev X:7.25% Mean Y:0.55%, Std Dev Y: 5.5% Correlation of X,Y: 0.66 Thanks

Hi, If I have a portfolio with, for example, a return of 5% and standard deviation of 7% how can I graph a growth of a thousand yearly over 40 years? Also, how can I graph the same chart but with an 80% confidence interval? I think I know how to do the first part: make a table with...

I would like to create a function that returns the following: 1. 20% of the time it returns a value of 0 2. 80% of the time it returns a normal distribution with a mean of 0.4, stdev of 0.1 but never less than 0 or more than 1. Please help!

My first post, so sorry for the format of question if wrong. I have created a (in Excel 2010) basic rolling calendar on which I project revenue recognition splits based on in-bound work mix. Projects come in about 14 types, each type has a fixed price, and the total ordered projects each day...

It would be super neat if this was possible, but I'm not at all sure how to even do it (if it IS possible). I used a handful of formulas to create a table so that I could create a normal distribution (an XY scatter plot with smooth lines). So, now I have my bell curve and it'd be really neat if...

Problem: X is a normally distributed variable with a mean=30 and standard deviation=4. Find a) P(x < 40) b) P(x > 21 ) c) P(30 < x < 35) How do i input this in excel. I'm actually having problems on how to put "<" and ">".

Normal Standard Distribution Question: I am looking to set up a spreadsheet where I have the following inputs: 1) A total number (e.g., 100) that I would like to distribute (normal standard distribution) over a variable number of data points. 2) The number of data points (e.g., 10) that I...

Hi, I'm a longtime lurker, but haven't been able to find a post that fits this (seemingly simple) purpose. I have multiple data sets containing two columns (Quantity & Price) which I want to revert back to raw Price data in order to make a statistical distribution curve. Example of Data...