Dear collegues.
I try to find a way to visualize some probability distributions, looking like this:
(example)
this distribution is, let s say, available for every month. i want to show that distribution over history, so i want to create something like this: http://www.graphicinvestor.com/econo/UK/INFLATION/Fanchart_200608.gif
by now, i calculated the quartiles (25, 50 and 75%), but now i do not really how to continue to get where i want to.
anyone has an idea / hint how to continue?
any help would be great! I guess it s more a statistical problem...
I try to find a way to visualize some probability distributions, looking like this:
(example)
Code:
<TABLE style="WIDTH: 120pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=160 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt" span=2 width=80><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=80 height=17 x:str="'<-2">[FONT=Arial][SIZE=2]<-2 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=80 x:num>[FONT=Arial][SIZE=2]0[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'-2 - -1,6">[FONT=Arial][SIZE=2]-2 - -1,6 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>[FONT=Arial][SIZE=2]0[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'-1,5 - -1,1">[FONT=Arial][SIZE=2]-1,5 - -1,1 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="0.4">[FONT=Arial][SIZE=2]0,4[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'-1 - -0,6">[FONT=Arial][SIZE=2]-1 - -0,6 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="2.4">[FONT=Arial][SIZE=2]2,4[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'-0,5 - -0,1">[FONT=Arial][SIZE=2]-0,5 - -0,1 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="12.6">[FONT=Arial][SIZE=2]12,6[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'0,0 - 0,4">[FONT=Arial][SIZE=2]0,0 - 0,4 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="45.1">[FONT=Arial][SIZE=2]45,1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'0,5 - 0,9">[FONT=Arial][SIZE=2]0,5 - 0,9 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="32.4">[FONT=Arial][SIZE=2]32,4[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'1,0 - 1,4">[FONT=Arial][SIZE=2]1,0 - 1,4 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="6.1">[FONT=Arial][SIZE=2]6,1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'1,5 - 1,9">[FONT=Arial][SIZE=2]1,5 - 1,9 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="0.8">[FONT=Arial][SIZE=2]0,8[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'2 - 2,4">[FONT=Arial][SIZE=2]2 - 2,4 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num="0.1">[FONT=Arial][SIZE=2]0,1[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'2,5 - 2,9">[FONT=Arial][SIZE=2]2,5 - 2,9 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>[FONT=Arial][SIZE=2]0[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'3 - 3,4">[FONT=Arial][SIZE=2]3 - 3,4 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>[FONT=Arial][SIZE=2]0[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'3,5 - 3,9">[FONT=Arial][SIZE=2]3,5 - 3,9 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>[FONT=Arial][SIZE=2]0[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="'>4">[FONT=Arial][SIZE=2]>4 %:[/SIZE][/FONT]</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>[FONT=Arial][SIZE=2]0[/SIZE][/FONT]</TD></TR></TBODY></TABLE>
this distribution is, let s say, available for every month. i want to show that distribution over history, so i want to create something like this: http://www.graphicinvestor.com/econo/UK/INFLATION/Fanchart_200608.gif
by now, i calculated the quartiles (25, 50 and 75%), but now i do not really how to continue to get where i want to.
anyone has an idea / hint how to continue?
any help would be great! I guess it s more a statistical problem...