Excel Statistics 32: Frequency Distribution Summary (Pivot Table & Formula)

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

How do I find medians from a frequency distribution table?

So I have a table that looks roughly like this:


values: 6 5 4 3 2 1
group1: 1 3 0 0 5 1
group2: 3 4 7 0 0 0
group3: 0 0 1 3 4 2


Where the numbers in the group rows indicate how many people selected each value in the first row. There are actually several thousand rows (and 13 possible values) -- the number of people in each group varies wildly.

I have added a row that calculates the mean of that row, and I would like to add an additional column to each row that tells me the median of that row, if it was expanded out (so for group 1 it would be the median of 6,5,5,5,2,2,2,2,2,1 = 2).

I'm having a really hard time figuring out how to do this however. Macros are fine, but I'd prefer avoid them if possible. Help please?

Hi,

I currently have a pivot table that returns min(date) and max(date) for each by-group 'Name.' So it looks something like this:


Name Min of Date Max of Date
John 1/1/2000 9/1/2000
Mary 4/1/1999 3/1/2000
Chris 2/1/2000 6/1/2006

Now I would like to create a new field that returns the difference between these two dates for each name. However Min of Date and Max of Date do not show up under Field List when I go into Calculated Field. How could I do it and still stay within the pivot table (i.e. not create a formula outside it)?

Thank you in advance for your help.

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?

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.

Hi,

I'm using Excel 2007 and have a pivot table with multiple values and need to average all the data rather than sum. There are a lot of columns of data in my original data sheet so it will take quite a long time to manually change the "Value Field Settings".

Is there a way to automatically change all the values at the same time? I know in Excel 2003 there is an add-in (PivotPower) that automatically does this, but does this add-in work in 2007 (I can't get it to do so)?

Any help would be much appreciated!

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