distribution

Hi Guys, I have been trying to create a bell curve / normal distribution chart but my data does not give a belle curve. What do I do wrong ? Given X values, I use formula z= STANDARDIZE Fx = NORM.DIST <colgroup><col span="3"></colgroup><tbody> X z f(x) 490 0.9 0.029 490 0.9 0.029...

Hello everybody, I'm using the NORMINV() function to calculate likely random outcomes of specific variables in a Monte Carlo simulation. (Modeling this after the example from the excellent book, How To Measure Anything.) However, NORMINV() uses standard distribution. What if my distribution is...

IV:9710388235LADD DISTRIBUTION LLC Did a search on extract, but couldnt find a solution, so I wanted to see if someone could help out. I want to populate 3 columns from 1 column. Column 1 would have IV: - simple enough as I can trim 3 characters. Column 2 would have 9710388235 - Anything...

Hi, I am new to powerpivots. I have an Excel report with Data Model that I am looking to distribute to different Zone owners. There are 7 Zones, and the source data has all of them. How do I limit the report that I distribute only to one Zone since I do not want other Zone owners to see other...

Hi Everyone, I'm not that technical and I'm hoping someone wouldn't mind helping. I have multiple data sets which vary both in range (lower and upper bounds?). Each data set will also change for each new scenario, for example on any given date Set 1 might have a range of -4 to +4 and the next...

I have hundreds of rows of data. Each row is a project and cost with start date and end date. Some projects are old and complete, others have started and are ongoing and some have not even started. Using the full range of dates, I want to show the cost of each project by month. I've added the...

Hi there. i am looking for a formula to allocate a percentage out of 100%, to a range of values. I am evaluating 6 options (Column A) and they have different costs (Column B). I wish to write a formula in Column C that displays the cost as a %, where 0% is the least cost and 100% is the most...

Hi I have a distribution question, I have this split over 10 qtrs, 100% total, which creates a bell curve <tbody> Quarter % Split Q1 4% Q2 10% Q3 11 Q4 12% Q5 13% Q6 13% Q7 12% Q8 11% Q9 10% Q10 4% </tbody> What I would like to do is evenly distribute the % for the 10...

Hi, I would like to seek some help over here for my school band distribution program. The flow of the flow chart as below :- 1. Individual Registration based on school 2. Automated grouping based on individual instruments (e.g.Flute, Clarinet) 3. Automated distribution into the Band A & Band B...

Hello all! I could really use some brainstorming and help with a project for which I have been tasked. I work for a multifamily management firm that oversees more than 5,000 apartments. We have around 80 staff that are each assigned to a portfolio of apartments. Every apartment receives a...

Given a whole number in a particular cell - I want it to be distributed in the adjacent cells in terms of number 1. Eg : 5 = 1 + 1 + 1 + 1 + 1 <colgroup><col span="9"></colgroup><tbody> 5 1 1 1 1 1 6 1 1 1 1 1 1 3 1 1 1 2 1 1 8 1 1 1 1 1 1 1 1 0 3 1 1 1...

I am sure you can tell by the title this is going to be fun! I have an array of random number of card players getting a random (but equal) number of cards. The cards are all numbered based on "power". So card 50 is weaker than card 49. I have the random number generator all set up to...

Hi, I have a file that I created to calculate a distribution based on time (periods) and total value to create a distribution curve. This is to be used as a forecast/estimate on a project. Output looks like the below. Now that I have my estimated amounts, I want to be able to apply actual data...

Hi, I'd like to calculate the area of a non-normal distribution set of numbers. The set of numbers are in rows in series of 20 records. Each serie can have a different distribution, so some might be close to Normal while others won't be Ideally i need a function that can approx for any...

Hi, I am having difficutly building a formula to distribute overall sales quotas to employees base on each employees expected phone hours. Total Sales Target : 1000 Total Employees : 15 Total Phone Hours for Dept : 2000 Employee 1 : 161 hours (8.05%) Employee 2 : 123 hours (6.15%) Employee 3 ...

Hi, I have a cell that is dependent on multiple randomly generate cells and I need help on how to graph the output of this single cell as it generates a new value every time I refresh the spreadsheet. If not, is there a way i can get its value each time it is refreshed (life for n=100...

Hi All, Any help greatly appreciated... I am trying to produce a distribution chart (bell curve) of my company's employee grades Each employee achieves a numerical score, which results in a final grade (U, M, F-, F, F+, E, S) I am using this formula to set the achieved grade...

I need a formula for doing cash flow projection. I have the s-curve (Cumulative Time vs Cumulative Cost). The total cost is provided and the time period during which this will happen. Now I need to find the monthly cash flow per the s-curve (or distribution curve). Can someone please guide...

Hi! I'm trying to create a table from 5 to 36 columns (months). Each column should add up to 100%. The problem is that in each column I want the distribution of “percentages” to be normally distributed. For instance in colum 7, I need 100% to be close to normally distributed over 7 rows (For...

I need to generate a random log-normal distribution with a given average 500,000 and standard deviation 100,000. For a normal distribution I would simply type =NORM.INV(RAND();500000;100000) which produces reasonable results with approximately an average output of 500,000 and standard deviation...