Excel Statistics 12: Categorical Frequency Distribution w Formulas

If I would like to compare two sets of data and display using as a frequency
polygon, can I do that in Excel. I tried using scatter charts and line chart,
but it puts the data on the Y axis, and I want it to be on the X-axis. Is
there a way to define what I want displayed on the X and Y axes incrementally
without it automatically numbering these axes automatically in Excel?

Apologies if this is covered somewhere in the forum but I just spent a good chunk of time looking for a solution here and on the interwebz and I couldn't find what I was looking for.

Basically I want to turn a data entry table into a frequency table with multiple columns. IE

the original data table looks like this

Person1 Person2 Person 3
A B A
A B A
A B A
A B A
A B A
A B B
A B B
A B B
A B B
A B B


and i want this output

Person1 Person2 Person3
A 10 0 5
B 0 10 5

before the last hour of searching for solutions or answers, i spent an hour jiggering with pivot tables without any success. I also tried using the histogram function in the data add-in pack but that seems to only want numeric data. Lastly, I looked though a ton of pivot table tutorials and none of them seem to be able to tell me how to do this.

is this something that can be done with pivot tables and i'm just not doing the right things with the fields? The best I've been able to come up with is 3 separate pivot tables that provide a frequency table for each person. There's got to be a way to do this in one step right? The actual data I'm working with has a lot more people and a lot more possible categories besides A and B, and I'll have to be doing this a lot in the future, so it would be nice if I could do it all in one fell swoop.

Again, thanks in advance for your help and if you want to direct me any links you think would be helpful, that would be great. Thanks again.

I have a data,That has three variables,age,height, weight
I am asked to do the question below

. Create frequency tables with class boundaries for the age 9.5, 19.5, 29.5,
39.5, 49.5, 59.5, 69.5, 79.5 for HT and WT. Find the mean, median,
mode, midrange, range, standard deviation, variance for these frequency
tables. Draw corresponding histograms, frequency polygons, pie charts.

Now here comes the tricky part..
I know how to make a frequency table of a single variable, but I have got no clue ho to make a frequency tables of other two that corresponds to the class boundaries of the corresponding age boundaries.
It is even possible?

Hi Everyone,

Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?

I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.

Any help would be appreciated.

Hi Everyone,

Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?

I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.

Any help would be appreciated.

Hello everyone,

I have a table with two coloumns, first is data and second is frequency, how to do descriptive statistics for this.

Please help me i am struck with this.

thanks

I have a worksheet with two columns of data

Column A has contains a reference code, d1, d2, d3....and so on to d6
however, this code can occur more than once.
Column B has a random number against the reference codes (could be anything
between 1 -100) e.g.

d1 5
d2 7
d1 10
d3 1
d1 5
d5 6
d4 20
d4 5
d6 15
d5 6
d1 10

I would like to calculate the number of occurances of each reference code
with each number, i.e. the number of d1's with number 5 = 2, the number of
d1's with 10 = 1.

Can anyone help?

Thanks

hello!

I am running a monte carlo simulation on a financial product.
I generate 100 simulations of a product with a 1 year maturity and with monthly observations. I need to build frequency distributions and charts for 2 variables

let's take an exemple of how it works:
I generate 1 year of daily log returns of a stock
every month there is a "fixing" where I check if the stock value is above or below 2 levels (let's say 90 and 110).
so after 1 year, I have 12 observations

on each observation:
if stock < 90: I return 0
if 90 < stock < 110: I return 1
if stock > 110 I return 2

then, I count all the occurences of 0, 1 and 2 over the 100 simulations
if stock > 110 on any observation: I don't continue the calculation for this simulation and proceed to the next one.
I only count 0 when it occurs on the last observation.

Now what I'd need is to generate a distribution frequency and a chart for this simulation. I need to do that for at least 2 out of the 3 variables: when the result is either 1 or 2

The X-axis would be the observations dates (in this case, the X axis would range between 1 to 12).

does anybody know how I can do that in vba please?
I don't really know where to start from...

thansk for your attention and have a good day/week end!
A

Help.

I am not sure if this question was transmitted yeterday. If so, I'm sorry for the repeat. I have a two column table in Excel 2000 as follows:
ZIP CUSTOMERS
------ ---------------
64151 5
64152 10
64151 9
64152 1
66666 3

I want a frequency distrbution of unique ZIP codes as weighted by the number of customers, as follows:

ZIP CUSTOMERS ZIP OCCURS PERCENT OF CUST.
----- ------------- ------------- -------------
64151 14 2 50%
64152 11 2 39%
66666 3 1 11%


Any guidance would be of help. Thanks
Daave Baird