Home |
Search |
Today's Posts |
#1
|
|||
|
|||
NORMAL DISTRIBUTION
I know EXCEL has functions for both the NORMAL DISTRIBUTION and the
cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#2
|
|||
|
|||
NORMAL DISTRIBUTION
http://www.tushar-mehta.com/excel/ch..._distribution/
Mangesh "FLKULCHAR" wrote in message ... I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#3
|
|||
|
|||
NORMAL DISTRIBUTION
I do not know who you are, but I am very impressed. I am a
Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#4
|
|||
|
|||
NORMAL DISTRIBUTION
In other words, can I blacken my area under the curve...(like the TI83 can do)?
"Mangesh Yadav" wrote: http://www.tushar-mehta.com/excel/ch..._distribution/ Mangesh "FLKULCHAR" wrote in message ... I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#5
|
|||
|
|||
NORMAL DISTRIBUTION
WHERE IS "THE PLOT MANAGER ADD-IN"??
"Mangesh Yadav" wrote: http://www.tushar-mehta.com/excel/ch..._distribution/ Mangesh "FLKULCHAR" wrote in message ... I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#6
|
|||
|
|||
NORMAL DISTRIBUTION
Hi,
First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#7
|
|||
|
|||
NORMAL DISTRIBUTION
thank you...however one more question...i tried graphing the normaldist using
the name, define routines..i.e.creating a graph using formulas.. when i get to the series tab, and i insert, for x, =NormCurveXVals, i get a reference error.. in other words, i cannot, YET, make it work.. i believe my formulas are all entered correctly in the name, define section, but the chart wizard will Not accept my X value. Can you be of more assistance? thanks "Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#8
|
|||
|
|||
NORMAL DISTRIBUTION
Hi,
Before I start getting into NamedRanges, did you try without using the named ranges. It works wihtout as well. Simple enter the range in the graph. Mangesh "FLKULCHAR" wrote in message ... thank you...however one more question...i tried graphing the normaldist using the name, define routines..i.e.creating a graph using formulas.. when i get to the series tab, and i insert, for x, =NormCurveXVals, i get a reference error.. in other words, i cannot, YET, make it work.. i believe my formulas are all entered correctly in the name, define section, but the chart wizard will Not accept my X value. Can you be of more assistance? thanks "Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#9
|
|||
|
|||
NORMAL DISTRIBUTION
And if you still have a problem, I could mail you a working example.
Mangesh "Mangesh Yadav" wrote in message ... Hi, Before I start getting into NamedRanges, did you try without using the named ranges. It works wihtout as well. Simple enter the range in the graph. Mangesh "FLKULCHAR" wrote in message ... thank you...however one more question...i tried graphing the normaldist using the name, define routines..i.e.creating a graph using formulas.. when i get to the series tab, and i insert, for x, =NormCurveXVals, i get a reference error.. in other words, i cannot, YET, make it work.. i believe my formulas are all entered correctly in the name, define section, but the chart wizard will Not accept my X value. Can you be of more assistance? thanks "Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#10
|
|||
|
|||
NORMAL DISTRIBUTION
I am not sure what the range in the graph is...
I follow this instruction: Next, plot the normal curve. Click any cell that does not contain data and has no adjacent cell with data. Click the Chart Wizard and select the XY Scatter chart (sub type Smoothed line with no markers) as in the 'Enumerating a set of points in a worksheet' section. In the 2nd step of the wizard, select the Series tab, then the Add button. Specify the names as the x- and y-values. Finally, format the chart as desired. And then, I get lost.. What do I insert in the chart wizard under ranges/ Thanks, FLKulchar "Mangesh Yadav" wrote: Hi, Before I start getting into NamedRanges, did you try without using the named ranges. It works wihtout as well. Simple enter the range in the graph. Mangesh "FLKULCHAR" wrote in message ... thank you...however one more question...i tried graphing the normaldist using the name, define routines..i.e.creating a graph using formulas.. when i get to the series tab, and i insert, for x, =NormCurveXVals, i get a reference error.. in other words, i cannot, YET, make it work.. i believe my formulas are all entered correctly in the name, define section, but the chart wizard will Not accept my X value. Can you be of more assistance? thanks "Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#11
|
|||
|
|||
NORMAL DISTRIBUTION
I am almost there....when I go to EVALUATE under formula auditing, I see the
x values completed and in column c1:c30....and I see the y values arrayed out perfectly! this occurs when i input =NormCurveXVals and =NormCurveYVals...but i still do NOT see it graphed... can you assist me?? "FLKULCHAR" wrote: I am not sure what the range in the graph is... I follow this instruction: Next, plot the normal curve. Click any cell that does not contain data and has no adjacent cell with data. Click the Chart Wizard and select the XY Scatter chart (sub type Smoothed line with no markers) as in the 'Enumerating a set of points in a worksheet' section. In the 2nd step of the wizard, select the Series tab, then the Add button. Specify the names as the x- and y-values. Finally, format the chart as desired. And then, I get lost.. What do I insert in the chart wizard under ranges/ Thanks, FLKulchar "Mangesh Yadav" wrote: Hi, Before I start getting into NamedRanges, did you try without using the named ranges. It works wihtout as well. Simple enter the range in the graph. Mangesh "FLKULCHAR" wrote in message ... thank you...however one more question...i tried graphing the normaldist using the name, define routines..i.e.creating a graph using formulas.. when i get to the series tab, and i insert, for x, =NormCurveXVals, i get a reference error.. in other words, i cannot, YET, make it work.. i believe my formulas are all entered correctly in the name, define section, but the chart wizard will Not accept my X value. Can you be of more assistance? thanks "Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#12
|
|||
|
|||
NORMAL DISTRIBUTION
I do not know how to add fill for the D part!!
"Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
#13
|
|||
|
|||
NORMAL DISTRIBUTION
If you can give me your email address, I could mail you the example.
Mangesh "FLKULCHAR" wrote in message ... I do not know how to add fill for the D part!! "Mangesh Yadav" wrote: Hi, First of all I want to clarify that this is not my site. It belongs to Tushar Mehta (http://www.tushar-mehta.com). I haven't checked the addin, but follow the method on his site by entering the range -4 to 4 in column A, you could skip column B for mean=0 and stdev=1. In C, enter the formula for Normdist as mentioned on the site. Now the extra part. In column D, enter =IF(A2<=$K$1,NORMDIST(B2,0,1,FALSE),0) or =IF(A2<=$K$1,NORMDIST(B2,$F$1,$H$1,$D$1),0) where K1 has a z value, the left of which you want the portion blackened. Now plot both the columns (C and D) in an area chart with no fill for the C plot, and a black fill for the D part. E.g. The cell K1 will have a z value like say -1, and in the area chart will have the area left of -1 blackened. Using TRUE in column C formula will give you the cummulative distribution. Mangesh "FLKULCHAR" wrote in message ... I do not know who you are, but I am very impressed. I am a Calculus/Statistics instructor; I only wish to apply my extensive mathematical skills with EXCEL; your site is certainly great... Next, can you possibly help me with the (integral..under the curve)...I believe we insert true...,etc? "FLKULCHAR" wrote: I know EXCEL has functions for both the NORMAL DISTRIBUTION and the cumulative value thereof... but is it possible to graph this data.. (I imagine if I sort the data and then calculate the cum. distributions into a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?) thank you, FLKULCHAR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
normal distribution curve | Charts and Charting in Excel | |||
Workbook page is not normal size | Excel Discussion (Misc queries) | |||
Normal Distribution? | Excel Discussion (Misc queries) | |||
how do i draw a distribution chart in excel | Charts and Charting in Excel | |||
bell-shape normal distribution curve | Charts and Charting in Excel |