Excel Statistics 56: Discrete Probability Distributions (Basics)

To anyone that will listen...I need serious help with excel and graphing. I
am taking statistics, and our instructor wants us to graph normal probability
distributions. I seem to be typing in the wrong information, although I am
not sure how. My book isn't very clear on how to do it, and neither do the
excel tutorials. I need this explained in PLAIN ENGLISH, as I am not overly
familiar with "computer lingo". The problem is: standard deviation=4.7,
mean=21.7 x is numbers 1-10, y is (in order) 25, 19, 17, 15, 20, 24, 30, 19,
16, 23. Please tell me what to type and where to put it in. (I have gotten
as far as going to fx, then "statistical", then NORMDIST. WHAT THEN???
Thank you!

Dear collegues.

I try to find a way to visualize some probability distributions, looking like this:

(example)
Code:

    >4 %:  

  0  

this distribution is, let s say, available for every month. i want to show that distribution over history, so i want to create something like this: http://www.graphicinvestor.com/econo...art_200608.gif

by now, i calculated the quartiles (25, 50 and 75%), but now i do not really how to continue to get where i want to.

anyone has an idea / hint how to continue?
any help would be great! I guess it s more a statistical problem...

How would I produce a distribution of, for example, students by their class:
Freshman 4
Sophomore 3
Junior 7
Senior 9

This can be either a formula or an algorithm.

Also, assuming that a freshman has completed 0 semesters, a sophomore 2, a junior 4 and a senior 6, how would I computer the average number of semesters that students on the list have completed? Basically, I guess I need to assign these numbers to the categories, but I don't know how to do that.

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 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.

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

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,

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!

Say you have a table (5x5, for argument's sake)-- along the top is
demand from customer A, on the bottom is demand for customer B. Say the
legend for both the rows and the columns is (0,1,2,3,4), and in the
table itself is the corresponding probability for each pair.

In other words, if you want to see the probability that demand from
both customers was zero, you'd look in the upper left corner of the
array. If you wanted to see the probability that customer A demanded 2,
and customer B demanded 3, you'd go down 3, and over 4 (remember that
0,0 is upper left, not 1,1).

Without using a macro, or manually writing out sum commands, is there a
way to create a total probability distribution table from the table I
have given you? In other words, we know that minimum demand is 0, and
that sum is given by the upper left cell, but the probability that the
total demand is 3 is the sum of cells (0,3), (1,2), (2,1), and (3,0).
The table in this example would be 9 wide, with the probability of 0 on
the left, and 8 on the right.

Perhaps there's a way to match a VLOOKUP, and HLOOKUP, and a few IFs,
maybe, but if anyone can suggest a more automated way or a clean
syntax, I'd be grateful.

Thanks!