Excel Statistics 13: Column Chart From Frequency Distribution:

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?

timestamp / count in location 1 / count in location 2

e.g. rows:

15:05 / 22 / 12
15:32 / 21 / 10
15:44 / 20 / 9
17:30 / 10 / 8


What I'm trying to do is plot a graph that shows each 1/2 hour time slot on the X axis (can i configure how long each slot is?) between say, 7am and 9pm (once again, don't mind 24 hours!), with the lines on the chart showing the average count during that period.

so e.g. in this case on x axis i'd like 15:00 - 15:30, with the y axis valud being 21.5 for location 1 and 11 for location 2; showing no lines for the rest of the containers, and then having the 17:30-18:00 container having 10 in location 1 and 8 in location 2.

Quite complex given it needs to average?

Any ideas how to go about doing this?

Thanks!

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

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

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

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

I am trying to generate frequency distributions separately for hundreds of populations which vary in size (between 10 and 120) in 9 categories (Bins), is there a simple way to generate this information?