I know EXCEL has functions for both the NORMAL DISTRIBUTION and the
cumulative value thereof...
but is it possible to graph this data..
(I imagine if I sort the data and then calculate the ***. distributions into
a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?)
Say I measure the height of 1000 people and I have those in a column in excel. It should be a normal distribution with mean x and standard deviation y. How do I actually graph it so I can see the normal distrubution curve that looks something like this:
[url]
I tried making a scatter graph but it graphs them point by point. I want the height to be on the x axis and something like frequency on the y axis.
i have some number that i want to put in a normal distribution
so.. i have age ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) and have the number of times that the kid wake in the night ( 10, 12, 9,11,8,9,7,9,11) and want to do the normal distribution grafic with that .
How to crate a chart for normal distribution for a set of datas. say marks of students/ number of students in a class
View 1 Replies View RelatedI'm trying to make a bell curve (normal gauss distribution). I have some problems regarding the probability density curve, since its values are so low. If you look column N in the attached file - I used the NORMDIST command. Values should be somewhere between 0,2 and 0,4 - but they're about 100x lower.
View 2 Replies View Relatedin VBA the RND function generates a random number using uniform distribution (every number is as likely as any other). Is there a function to generate a random number using normal distribution where the numbers closest to the mean are more likely to occure then numbers further away from the mean. I've created the following custom function to generate a random number between two given values using uniform distribution.
Function RandNum(Min As Double, Max As Double) As Double
RandNum = (Max - Min) * Rnd + Min
End Function
I would like to create a random number based on that data.
View 3 Replies View RelatedI saw one of my classmates do quick normal distribution by the click of a button and when I asked her she said she used VBA function of Excel.
This is what I would like to do: Have a macro/VBA in one excel file. And using that excel file do normal distribution for an excel file that's opened in another window.
I would like to generate a random value using a skewed normal distribution. For inputs I have the sample mean, standard deviation, and skewness. I would like to find a way to generate numbers randomly that would fit the skewed normal distribution described by the inputs.
Some information about skewed normal distributions can be found here: ...
I have weird alpha value like 14.385%, a sample size (36). What is the corresponding critical value for the normal distribution. There are questions like this dealing with the Student T dist, Chi Squared and F distribution. If i can figure out how to do it for one I can probably do it for all of them.
I would like to get random number generator for normal distribution and I’m using:
=NORMINV(RAND(),$B$1,$B$2)
Where B1 is mean (average) and B2 is SD.
This command works, but in the random generating numbers, I’m getting positive and negative numbers (ex. -23,34).
how to change command so I can generate positive only numbers?
I keep reading that this "Application.Dialogs(xlDialogPrint).Show" brings up the same dialog as File-> Print or Cntrl+P but it does not.
Instead I get this wrong.jpg
When I actually need this correct.jpg
How to get the second one?
I have a value say £11.50 what i need is for this to be turn in to 1150 no point.
When i try on excel i get it to 115
I sometimes come across spreadsheets that have only a few white, "normal" looking cells and the rest are grey with no borders.
Usually there is a thick blue line around the "normal" cells and I can make more cells look "normal" by dragging the blue border line.
What is this? And, how do I set it up in a spreadsheet if I need to?
I am currently using Excel 2007 and I am trying to find a good working formula for Normal Hours worked:
I have the following code for Total Hours, Time and a Half and Double Time hours but I can't seem to get the right formula for working up to 8 hours.
Whereas C11 = Total hours added for the day.
=MOD(SUMPRODUCT(C8:C10-C7:C9),1) =Total Hours Worked
=Normal work hours between 0 to 8 hour work day.
=MIN("04:00",MAX(0,C11-"08:00")) =Time and a Half hours over 8 hours worked.
=MAX(0,C11-"12:00") =Double Time hours over 12 hours worked
What I mean by my "bold" underlines:
QRG5UUl.png
Notice the difference between the bold underline and the normal ones. There is also some weird thing happening where in some cells, when I use the underline feature, it shows as a bold underline, but once I've pressed enter to move on to another cell, the underline reverts back to normal. If I select to edit (F2 or double-clicking) said cell, the underline becomes bold, and vice versa (s3lw.png).
All this started happening immediately after I did this (was just experimenting, and I have no idea what this actually does, or if it was the cause of those occurences): Insert > Symbol > Special Characters > No-width optional break. I did that to just one cell though, and now all this weird stuff is happening.
I would like to create a histogram from experimental data with the normal distribution curve overlaying the histogram.
View 7 Replies View RelatedIs there a way to generate a normal curve from just the statistical values (mean, std dev, etc)? I used the NORMDIST function but have to manually do the x values and it generates what I would descirbe as a "sample" curve. I would like to make one based on user input.
View 5 Replies View RelatedI have been trying to type a date in a column in MS excel. But excel always reads it as a serial number.
How Can I get it to display the date as it is in date format. I have the next column formatted/ formulated to display the day of the date in the previous column.
I use the following code to assign a macro to right arrow key.
Application.OnKey "{RIGHT}", "myMACRO"
My questin is how to let the right arrow key resume its normal function, that is move from left to right (A2 to A1) if I do not want the macro any more and without quit and restart EXCEL? The following code disabes the right arrow key's normal function. Application.OnKey "{RIGHT}", ""
I have a workbook that, when opened, sets the view to full screen. When it is closed, I want the view reset to normal.
The problem is that the prompt to close full screen appears rather than the view automatically resetting to normal.
What additional codes is needed to fully automate this?
I have:
ActiveWorkbook.Save
Application.Workbooks("PCAR Log.xls").Close (0)
Application.DisplayFullScreen = False
I need a formula that distributes a % based on position.
The positions are 1 through 20, and each one has a corresponding % value ...
Recently I come across a file with only 1 sheet, in which is a table only occupied an array of A1:Q49. In Normal View I can see the row / column header of A-Q and 1-49 as usual, but nothing outside that range (only grey colour). Also, the empty cells outside A1:Q49 are all grey too. How can I do that?
View 2 Replies View RelatedI'm been trying to create a timesheet that will auto calculate the hours of normal / overtime 1 / overtime 2
Rules:
Saturday / Sunday / Public Holiday = Overtime 2
Monday to Friday (8:30 till 17:30) = Normal (Auto
Monday to Friday (17:30 till 22:00) = Overtime 1
Monday to Friday (22:00 till 8:30) = Overtime 2
* If Public Holiday column is set to 1 then all hours will auto set to overtime 2
* If Breaktime column is > 0 then deduct from total hours calculate
Sample:
Name
Date / Day
Public Holiday
Start time
End time
Breaktime
Normal hour(s)
Overtime 1
Overtime 2
[code]....
I have been working on a problem that requires being able to calculate the chances of any winnng a series of coin tosses with a weighted coin.
The coin has for arguments sake a 65% / 35% chance of landing heads or tails and to win the game you need to hit your side 9 times.
Can you use excel to calculate things like: If heads takes the lead 1-0, what does that mean the its overall percentage chance of winning? If the score is 7-3 to tails, what are the chances of either side gaining victory? etc, etc.
I thought that there would be a way of setting up a spreadsheet that listed the goal (first to 9, 12, 15 or whatever) and below this the percentage chance of heads and the percentage chance of tails. Then somewhere would be a box to enter the current score (0-0, 3-5, 1-1 or whatever) and beside this the current chance of heads or tails gaining victory.
I've tried setting up something like this but am a bit of a dufus when it comes to knowing how, where and when to use the different functions of excel.
I'm looking to analyse is how long these articles take to reach maturity from their date of publication (so, when they achieve their optimum performance).
I'd then like to further analyse this across various metrics like article type/producer etc., which, I guess, would be in some kind of Pivot Table filter-type-thing.
Here's an example of some of my data:
ArticleName - PublishedDate - OctViews - NovViews - DecViews - ArticleType - Producer
Article1 - Oct-08 - 3701 - 4856 - 4561 - Food - ABCTV
Article2 - Nov-08 - 0 - 9824 - 1256 - Food - ABCTV
Article3 - Oct-08 - 1358 - 8953 - 9652 - Tech - XYZ.com
Article4 - Oct-08 - 1351 - 2354 - 3562 - Tech - ABCTV
The part I'm finding tricky is this; what we'd like to do is rather than look at a specific date (say, articles published on 09/04/08) it would be useful to combine all the dates so that the first month something is published is Month 1, regardless of the date it is actually published.
As the same article can be from the same producer but published at different times, if I could remove the "Jan-Mar = Month 1-Month 3" problem it would allow us to graph all the data into one snapshot of the publishing process and find trends. If this could then be cross examinable by the ArticleType etc. it'd be really useful.
I have a spreadsheet which has a list of staff (column B) and work categories (row 3).
Row 4 is updated each day with a count of the incoming work for each work category.
I want to be able to randomly distribute (as evenly as possible) the no of work items in Row 4 between the doers (B7:B13). Each item of work also has to be checked so I would also like to randomly distribute the checking between the checkers (B16:B18)....
There is trading system which generates a winning trade per ONE stock in ONE month’s time with a probability of 5/12 (0,4166%). If the system trades 10 independent stocks the probability of any number of winning trades occurring out of all of them in ONE month is shown below:
None 0,0046
One 0,0326
Two 0,1047
Three 0,1995
Four 0,2494
Five 0,2172
Six 0,1272
Seven 0,0519
Eight 0,0139
Nine 0,0022
Ten 0,0002
I took these values from a book…I tried to reproduce these values in the spreadsheet that I attached. My table looks as follows:
0 0,0046
1 0,0033
2 0,0023
3 0,0017
4 0,0012
5 0,0008
6 0,0006..........
There are 16,777,216 cells in a spreadsheet. These cells are distributed in a spreadsheet by 256 columns and 65,536 rows.
Can I in any way distribute these cells otherwise?
Say distributing them in 512 columns and 32,768 rows?
Refer to the attached sample workbook,
(Keep in mind that there is an error in the sample workbook; Im not sure how to remove and re-attach the sample workbook as this is my first day on this forum.)
Cell F19 should contain =D19*B19
Column 1- These values will not change and represent price/cost of each UNIT
Column 2- "UNITS" the quantity or number of items at column1 value
Column 3- "$ AMT" the total cost of UNITS at that price/cost, i.e. Column1*Column2
Im looking for a way populate the values in Column2 when, "NUMBER OF UNITS" AND "AVERAGE COST PER UNIT" are changed
Ideally speaking, As few units in one row as possible to allow for a good mix.
For example: What i don't want is $9000*86 for 774k.
If it helps: "AVERAGE COST PER UNIT" will always be a whole number rounded up to the nearest 1000.
I believe a Most Even distribution of units will work fine.
After the distribution/population of fields in column2;
D29 must equal F3
F29 must equal F7
I'm looking for something that will populate the values in D12:D27 while adhering to the two conditions above. Even when the Input at F3 and F4 are changed.
The values in "UNITS" represent the number of a specific cost item in inventory when added together do not exceed the "TOTAL COST OF INVENTORY". Depending on store location, the "AVERAGE COST PER UNIT" and/or the "NUMBER OF UNITS" will change. It will be used to help forecast how many of a specific cost item should be purchased based on the overall average unit cost without exceeding the budget or inventory space.