Excel Statistics 51: Probability Basics with Excel

Hi,
I was hoping someone could help me with this particular statistics+excel problem that I cannot solve, or, at least need some confirmation that I am solving it correctly...

MY DILEMMA: Let's say I am asking people to choose their favorite letter(s) ranging from a-vvv (1-100). I ask 9 people to choose their favorites, but they can't choose more than 100 #'s (obviously since a-vvv represents 100 letters). Once I gather the information, the only way I know how to create the proper order is to AVERAGE the data by inputting zero into the fields/letters that were not chosen (since no one chose all 100 letters). My question is... HOW DO I PROPERLY ORDER THE "LETTERS" FROM MOST TO LEAST POPULAR BASED ON THE SUBMISSIONS??? I realize this is a statistics problem, but I'm hoping something efficient can be done in excel.

I've also attached the working excel file to use as a working document. Feel free to PM if you would like to attach an excel file.

Thanks in advance everyone!

-Ryan

I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.

Please can anyone help me answer any of these questions:

How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help



How do you format a cell to have dollar signs next to the numbers?



How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?



How do you rename a sheet?



Can I delete the sheets that I don't need? If so how?



How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A



How do you add up all the contents of column D and make the answer show
up in column C?


Thanks in advance!
abi

I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone

I'm trying to populate a Word 2003 document with data from an Excel 2003 document -- I realize some use mail merge but this, for me, has been an excruciating pain in the neck, so I am trying to avoid it by going the Word bookmark route, which looks like it will fit the bill... if only I could figure it out!

I have done some searches on here and this is the code that seems to have set the precedent:

http://www.mrexcel.com/forum/showthread.php?t=478182

However, as a beginner, it's a bit overwhelming for me. While I'm learning a lot by looking at it and looking up the things I don't understand, it's taking a long time and I actually need to use something similar for my own project.

Specifically, I wanted to open a template letter; populate it from the active Excel row I'm working on; and then "Save As" so I can keep the template.

Is there some more generalized information out there that outlines this procedure? Otherwise, would someone be kind enough to separate the code and/or elaborate more on what the invididual lines/sections do?

Hope you can help!

Basicly the same as the title.. I want to learn more about excel... I consider myself to be just a bit better then a noob, i can use the sum function, and i think i understand how most easy things work

Alright i'm using Excel 2007, i created a table with 2 columns and 5 rows
cell A1 - A5 has a list of numbers, and Cells B1 - B5 has a list of food items,

I've created a blank User-Interface form, using VisualBasics which came inside excel 2007, how do i get the table in my Excel Sheet, to show as it is with it's color coding and grid lines in the VisualBasics Form,


My second question is, I also created a Seperate Visual Basics form in Visual Basics 2008, could i get the table in the Excel form, to show in the form in Visual Basics 2008 programme, I have no clue how to link Visual basics, to Excel so a non-overly technical step-by-step guide would be extremely appreciated,


Thank you,

hiya all i was wndering if anyone could help me i need to work the probability of number using a percentage for expample 50 sales has a probability of occuring 40% and 60 sales has probability of occuring 5% and so on, can any explain how i need to do this im new to excel ,
thank u

I have a pack of cards and already drawn some cards.

I have 40 cards left: 12 diamonds, 11 hearts, 10 spades and 7 clubs.

The probability of the next 3 cards being (in order) a diamond followed by a club then another diamond is (12/40)*(7/39) * (11/38).

The answer is 1.5587%. What formula should I or could I use to get this result? I'd imagine it would be a nested formula that's not going to be easy to decipher!!

My problems I'm encountering when trying to get Excel to work out the probability for me without me having to hard-wire the figures in to the formula:

The cards are not being replaced, so when a diamond is drawn out, there is one less diamond in the pack to take into consideration when looking for another diamond. It's easy when, say, there are the same number of each suit left remaining but this is not the case!!

I can see a long-haul solution would be to list every possibility then lookup the desired combination but time/speed/hassle.... there's another easier way, isn't there?

Hi everyone, first thanks for the help.

I am trying to create a histogram and let me explain some of the data.

I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...

Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5

I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).

I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.

If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.