Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart

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

From my Pivot table I have inserted a Line Chart to depict the number of defects that were "fixed in an event" Vs. when they were "Detected". The Pivot and chart are working with the exception of 1 thing:
- seems like the "Fixed In Event" grouping values do not always appear on the chart axis (some are left blank for no apparent reason????) the "Detected in Event" values all appear. Any suggestions?

am using a Pivot Chart to create a Line Chart where the X Axis of my chart depicts a grouping (by month

Pivot Chart Settings:
Row Labels: (In this order)
Fixed in Event
Detected in Event

Sum Values:
Count of Defect

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?

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.

I'm trying to change the name of the category name in a pivot chart.

I have pivot table where I summarize some values from a table. I than created a chart out of this pivot table. The chart type is a pie-of-pie chart.

The first pie consists of 2 values "true" and "false". The 2nd pie is a break-down pie of the "true" pie slice.
When the chart is generated, it shows "Others" in the 1st pie. But I want to change this name to "true".
How am I able to do it?
Any help would be appropriated and thanks in advance!


The outlined part is the part I want to change.

http://img4.imageshack.us/img4/5191/pic1qep.jpg

My manager would like me to create charts for 30+ departments every month in separate files with their average weekly spend for the past year and headcount.

There are sub-departments that I've been using in the page field of a pivot chart so the manager can view total spend, or spend by sub-department. (There's a similar chart for headcount.)

Is there a simple macro that I can use that will create separate charts based on the department name?

Even better, is there a separate macro that will take each chart and save it as a separate file for distribution?