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 set of numbers 1-12 along with a corresponding % that number occurs
in some data I'm analyzing.
What I want to plot is a histogram with number bin 1 - 12 along the x axis,
and on the yaxis a cumulative value of the total % 's upto that number.
So for simple case with 4 numbers
1, 20%
2, 40%
3, 30%
4, 10%
so the cumulative values I would like to histogram would be
1, 20 %
2, 60%
3, 90%
4,100%
I can't seem to get this to work via the histogram charting tool in the
tools/data analysis menu ?
Can anyone give me any pointers as to how to achieve this ?
Regards
Tony
I read "Explore Histograms" in
http://office.microsoft.com/en-us/as...109481033.aspx and found it
educational. However, I can't see a difference in output between using a
Histogram and using the Frequency function.
Can anybody share the pros and cons of each?
My job requires me to establish the appropriate sample size during very expensive flight testing (i.e. can't afford to do more testing than the minimum required to establish the appropriate confidence). I have a nomograph that was given to me that we use to calculate the right value given confidence and demonstrated reliability (i.e. results). The nomograph can be found at: https://acc.dau.mil/docs/dtepi/pns/doc/nomogr/bdi.pdf.
Assuming we want to show that we have 80% confidence (right axis) that we'll succeed 80% of the time (left axis, also called reliability), I connect those values on each side with a straight edge and the chart shows that with zero failures (upper right boundary) we need 7 trials. If we have one failure (upper left boundary) the chart shows that we need 12 trials (11 successes). I was provided a formula that defines the zero failure curve [n=Log (1-confidence)/Log (reliability)]...What I need is a more generic equation or excel function that will generate these curves with failures not equal to zero.
Any statistics experts out there that can help me?
Thanks
Can anyone tell me how to plot a relative frequency histogram (using
midpoints). I know how to to make a histogram using the analysis tools, but
can't get Excel to put in plots for midpoints....
I need to develop a frequency distribution as well as a histogram from the attached data
It would be appreciated if someone can advise on how I go about doing this
Thanks
Howard
******** ******************** ************************************************************************>
Microsoft Excel - frequency Sist.Histogram.xls
___Running: 12.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1
=
A
B
C
D
E
F
G
H
I
J
K
1
1
11
3
3
9
9
20
2
22
Bins
2
10
16
1
11
10
24
10
13
1
10.5
3
22
2
14
7
6
1
1
6
20
20.5
4
15
3
2
23
6
15
3
15
1
30.5
5
7
1
1
1
4
1
10
2
30
6
6
17
5
2
23
10
22
3
6
7
1
34
2
1
34
23
7
24
1
8
33
1
1
1
1
14
4
11
8
9
4
4
9
6
1
6
1
13
2
10
10
6
6
4
2
16
1
3
9
Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
Hello all,
Slightly confused here. I have the following data:
Less than 5 minutes 7,990
5 to 9 minutes 30,778
10 to 14 minutes 48,575
15 to 19 minutes 65,983
20 to 24 minutes 69,709
25 to 29 minutes 28,965
30 to 34 minutes 72,458
35 to 39 minutes 12,896
40 to 44 minutes 14,116
45 to 59 minutes 32,932
60 to 89 minutes 14,506
90 or more minutes 8,366
which I would like to calculate a Median for...is this possible?
Thanks,
Larry
Book1.zipPlease see the attached Excel file. Below the matrix there is a list of cities and their distances. At the bottom of the list is the sum of the total distances. If you highlight two successive cities (for example, cities 5 & 6 or 2&3 or 8 & 9) and press the "swap cities button" the order changes and so does the total distance. I want to create a histogram that keeps track of the number of iterations. That is, the number of iterations on the x axis and the total distance on the y axis. I want the graph to update automatically everytime the "swap cities" button is pressed. Can someone please help me?
I need to develop a frequency distribution as well as a histogram from the attached data
It would be appreciated if someone can advise on how I go about doing this
Thanks
Howard
******** ******************** ************************************************************************>
Microsoft Excel - frequency Sist.Histogram.xls
___Running: 12.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1
=
A
B
C
D
E
F
G
H
I
J
K
1
1
11
3
3
9
9
20
2
22
Bins
2
10
16
1
11
10
24
10
13
1
10.5
3
22
2
14
7
6
1
1
6
20
20.5
4
15
3
2
23
6
15
3
15
1
30.5
5
7
1
1
1
4
1
10
2
30
6
6
17
5
2
23
10
22
3
6
7
1
34
2
1
34
23
7
24
1
8
33
1
1
1
1
14
4
11
8
9
4
4
9
6
1
6
1
13
2
10
10
6
6
4
2
16
1
3
9
Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
how do I construct a frequency distribution and histogram for a data set in excel?
