| Groups | Blog | Home |
dotnet drawing api : Have data to fill a triangular matrix, but how do I graph it???? - Please help
The pdf has got me thinking of doing the extra step of sorting the matrix by similar variables. I was surprised by the difference it makes to the chart. [quoted text, click to view] "Frank Hileman" <frankhil@no.spamming.prodigesoftware.com> wrote in message news:OQzhidDcFHA.3856@TK2MSFTNGP10.phx.gbl... > See also Corrgrams on this page: > http://www.math.yorku.ca/SCS/Gallery/bright-ideas.html > > There is a link to an excellent pdf paper on the subject. > > > Regards, > Frank Hileman > > check out VG.net: http://www.vgdotnet.com > Animated vector graphics system > Integrated Visual Studio .NET graphics editor > > > "Nevets Steprock" <.@.> wrote in message > news:Soire.62547$tt5.38490@edtnps90... >> I'm writing a web program where one of the sections is supposed to output >> a correlation matrix. The typical correlation matrix looks like this: >> >> .23 >> .34 .54 >> .76 .44 .28 >> .02 .77 .80 .99 >> >> I've written code to calculate the correlation data and it is populated >> in a vector like this: >> >> corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) >> >> I would like to present the data in a triangular matrix where each box >> has both the actual number and a colour scheme that represents the >> strength of correlation. >> >> I would be open to paying a fee for the help (please note that I'm not a >> corporation with deep pockets). I've done exhausting searches on google >> for "triangular matrix", code, .net, visual basic, etc... and can't find >> out how other programmers are doing it. >> >> Thanks for ANY help you can give. >> Steven >> > >
I'm writing a web program where one of the sections is supposed to output a
correlation matrix. The typical correlation matrix looks like this: ..23 ..34 .54 ..76 .44 .28 ..02 .77 .80 .99 I've written code to calculate the correlation data and it is populated in a vector like this: corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) I would like to present the data in a triangular matrix where each box has both the actual number and a colour scheme that represents the strength of correlation. I would be open to paying a fee for the help (please note that I'm not a corporation with deep pockets). I've done exhausting searches on google for "triangular matrix", code, .net, visual basic, etc... and can't find out how other programmers are doing it. Thanks for ANY help you can give. Steven
Have you seen this?
http://www.inductive.com/help-doc-correl.htm It looks simple. To draw a rectangular grid row you draw a filled rectangle, increment by the x width, draw another, until you reach the end of one row. Then you increment by the y height, and continue to draw rows. FillRectangle is the method you need on Graphics. The color could be determined by converting your floats into a scaled integer and indexing into an array of colors (int)(value * 10). To draw the text, you can use Graphics DrawString. Regards, Frank Hileman check out VG.net: http://www.vgdotnet.com Animated vector graphics system Integrated Visual Studio .NET graphics editor [quoted text, click to view] "Nevets Steprock" <.@.> wrote in message news:Soire.62547$tt5.38490@edtnps90... > I'm writing a web program where one of the sections is supposed to output > a correlation matrix. The typical correlation matrix looks like this: > > .23 > .34 .54 > .76 .44 .28 > .02 .77 .80 .99 > > I've written code to calculate the correlation data and it is populated in > a vector like this: > > corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) > > I would like to present the data in a triangular matrix where each box has > both the actual number and a colour scheme that represents the strength of > correlation. > > I would be open to paying a fee for the help (please note that I'm not a > corporation with deep pockets). I've done exhausting searches on google > for "triangular matrix", code, .net, visual basic, etc... and can't find > out how other programmers are doing it. > > Thanks for ANY help you can give. > Steven >
See also Corrgrams on this page:
http://www.math.yorku.ca/SCS/Gallery/bright-ideas.html There is a link to an excellent pdf paper on the subject. Regards, Frank Hileman check out VG.net: http://www.vgdotnet.com Animated vector graphics system Integrated Visual Studio .NET graphics editor [quoted text, click to view] "Nevets Steprock" <.@.> wrote in message news:Soire.62547$tt5.38490@edtnps90... > I'm writing a web program where one of the sections is supposed to output > a correlation matrix. The typical correlation matrix looks like this: > > .23 > .34 .54 > .76 .44 .28 > .02 .77 .80 .99 > > I've written code to calculate the correlation data and it is populated in > a vector like this: > > corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) > > I would like to present the data in a triangular matrix where each box has > both the actual number and a colour scheme that represents the strength of > correlation. > > I would be open to paying a fee for the help (please note that I'm not a > corporation with deep pockets). I've done exhausting searches on google > for "triangular matrix", code, .net, visual basic, etc... and can't find > out how other programmers are doing it. > > Thanks for ANY help you can give. > Steven >
look at htm tables. you should read a book on html (the bookstore is full of
them) -- bruce (sqlwork.com) [quoted text, click to view] "Nevets Steprock" <.@.> wrote in message news:Soire.62547$tt5.38490@edtnps90... > I'm writing a web program where one of the sections is supposed to output > a correlation matrix. The typical correlation matrix looks like this: > > .23 > .34 .54 > .76 .44 .28 > .02 .77 .80 .99 > > I've written code to calculate the correlation data and it is populated in > a vector like this: > > corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) > > I would like to present the data in a triangular matrix where each box has > both the actual number and a colour scheme that represents the strength of > correlation. > > I would be open to paying a fee for the help (please note that I'm not a > corporation with deep pockets). I've done exhausting searches on google > for "triangular matrix", code, .net, visual basic, etc... and can't find > out how other programmers are doing it. > > Thanks for ANY help you can give. > Steven >
I don't see a triangular matrix. What I see is a 4X4 table, with 3 empty
cells in the first row, 2 empty cells in the second row, and 1 empty cell in the third row. At least that's what I see in (imaginary) HTML. -- HTH, Kevin Spencer Microsoft MVP ..Net Developer Ambiguity has a certain quality to it. [quoted text, click to view] "Nevets Steprock" <.@.> wrote in message news:Soire.62547$tt5.38490@edtnps90... > I'm writing a web program where one of the sections is supposed to output > a correlation matrix. The typical correlation matrix looks like this: > > .23 > .34 .54 > .76 .44 .28 > .02 .77 .80 .99 > > I've written code to calculate the correlation data and it is populated in > a vector like this: > > corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) > > I would like to present the data in a triangular matrix where each box has > both the actual number and a colour scheme that represents the strength of > correlation. > > I would be open to paying a fee for the help (please note that I'm not a > corporation with deep pockets). I've done exhausting searches on google > for "triangular matrix", code, .net, visual basic, etc... and can't find > out how other programmers are doing it. > > Thanks for ANY help you can give. > Steven >
And the problem is ? Looks like to me that a table tag should easily allow
this layout ? Patrice -- "Nevets Steprock" <.@.> a écrit dans le message de news:Soire.62547$tt5.38490@edtnps90... [quoted text, click to view] > I'm writing a web program where one of the sections is supposed to output a > correlation matrix. The typical correlation matrix looks like this: > > .23 > .34 .54 > .76 .44 .28 > .02 .77 .80 .99 > > I've written code to calculate the correlation data and it is populated in a > vector like this: > > corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) > > I would like to present the data in a triangular matrix where each box has > both the actual number and a colour scheme that represents the strength of > correlation. > > I would be open to paying a fee for the help (please note that I'm not a > corporation with deep pockets). I've done exhausting searches on google for > "triangular matrix", code, .net, visual basic, etc... and can't find out how > other programmers are doing it. > > Thanks for ANY help you can give. > Steven > >
Patrice,
I modified my triangular matrix into a NxN matrix by putting some dummy values in the cells I don't want to waste time calculating. I suppose I'm being needlessly fussy, but 20 years ago the extra calculations meant a lot of waiting around and I have never shaken the habit of minimizing what the processor has to do. Still, it's a lot easier to use in this form. [update!!] You're right, I can get a quick and dirty correlation matrix up in no time. Hopefully, it's smooth riding from here. Steven [quoted text, click to view] "Patrice" <nobody@nowhere.com> wrote in message news:epkfvmLcFHA.4040@TK2MSFTNGP14.phx.gbl... >I would just output server side as many rows as needed. I was not talking > about a table (or array) structure. I was talking about the table HTML > tag. > > You could render this tag using either a vector or an array. Because of > the > structure of this triangular matrix, it should be easy to find out how > many > columns you need in the table. You'll then render each row picking an > additional cell each time (1, 2, 3 etc...) and filling the rest of the row > with empty cells... > > It would be trivial using an rray, it should be still easy using a > vector... > > Patrice > > > -- > > "Nevets Steprock" <.@.> a écrit dans le message de > news:tItre.61291$9A2.58275@edtnps89... >> I suspect both Bruce and Kevin are suggesting the same. I've only started >> programming for the web as of 3 months ago (~20 years of standalone >> applications - nothing serious, just mucking around) and have been having > a >> great time with the new environment. >> >> Since my correlation matrix will be anywhere from 2 to 16 variables, can >> I >> use jscript to do it dynamically or would you suggest I prebuild the >> table >> structure for 16 variables and then resize the rows as necessary? >> >> Steven >> >> PS Thanks for responding. >> >> "Patrice" <nobody@nowhere.com> wrote in message >> news:%23X3srlDcFHA.3328@TK2MSFTNGP09.phx.gbl... >> > And the problem is ? Looks like to me that a table tag should easily > allow >> > this layout ? >> > >> > Patrice >> > >> > -- >> > >> > "Nevets Steprock" <.@.> a écrit dans le message de >> > news:Soire.62547$tt5.38490@edtnps90... >> >> I'm writing a web program where one of the sections is supposed to > output >> > a >> >> correlation matrix. The typical correlation matrix looks like this: >> >> >> >> .23 >> >> .34 .54 >> >> .76 .44 .28 >> >> .02 .77 .80 .99 >> >> >> >> I've written code to calculate the correlation data and it is >> >> populated >> >> in >> > a >> >> vector like this: >> >> >> >> corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) >> >> >> >> I would like to present the data in a triangular matrix where each box >> >> has >> >> both the actual number and a colour scheme that represents the >> >> strength >> >> of >> >> correlation. >> >> >> >> I would be open to paying a fee for the help (please note that I'm not > a >> >> corporation with deep pockets). I've done exhausting searches on >> > for >> >> "triangular matrix", code, .net, visual basic, etc... and can't find > out >> > how >> >> other programmers are doing it. >> >> >> >> Thanks for ANY help you can give. >> >> Steven >> >> >> >> >> > >> > >> >> > >
I suspect both Bruce and Kevin are suggesting the same. I've only started
programming for the web as of 3 months ago (~20 years of standalone applications - nothing serious, just mucking around) and have been having a great time with the new environment. Since my correlation matrix will be anywhere from 2 to 16 variables, can I use jscript to do it dynamically or would you suggest I prebuild the table structure for 16 variables and then resize the rows as necessary? Steven PS Thanks for responding. [quoted text, click to view] "Patrice" <nobody@nowhere.com> wrote in message news:%23X3srlDcFHA.3328@TK2MSFTNGP09.phx.gbl... > And the problem is ? Looks like to me that a table tag should easily allow > this layout ? > > Patrice > > -- > > "Nevets Steprock" <.@.> a écrit dans le message de > news:Soire.62547$tt5.38490@edtnps90... >> I'm writing a web program where one of the sections is supposed to output > a >> correlation matrix. The typical correlation matrix looks like this: >> >> .23 >> .34 .54 >> .76 .44 .28 >> .02 .77 .80 .99 >> >> I've written code to calculate the correlation data and it is populated >> in > a >> vector like this: >> >> corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) >> >> I would like to present the data in a triangular matrix where each box >> has >> both the actual number and a colour scheme that represents the strength >> of >> correlation. >> >> I would be open to paying a fee for the help (please note that I'm not a >> corporation with deep pockets). I've done exhausting searches on google > for >> "triangular matrix", code, .net, visual basic, etc... and can't find out > how >> other programmers are doing it. >> >> Thanks for ANY help you can give. >> Steven >> >> > >
Hi Steven,
You're storing the data in an array, and I presume that you have a method for extracting the various "levels" from the array. So, in the process of extracting the levels, and I can only guess from what I've seen, the last row contains the number of elements as the number of columns in the table. The number of "levels" derived from the array would give you the number of rows in the table. Once you know that, you can dynamically build an HtmlTable Control with the number of rows and columns, and add the data into the table as you build it. -- HTH, Kevin Spencer Microsoft MVP ..Net Developer Ambiguity has a certain quality to it. [quoted text, click to view] "Nevets Steprock" <.@.> wrote in message news:tItre.61291$9A2.58275@edtnps89... >I suspect both Bruce and Kevin are suggesting the same. I've only started >programming for the web as of 3 months ago (~20 years of standalone >applications - nothing serious, just mucking around) and have been having a >great time with the new environment. > > Since my correlation matrix will be anywhere from 2 to 16 variables, can I > use jscript to do it dynamically or would you suggest I prebuild the table > structure for 16 variables and then resize the rows as necessary? > > Steven > > PS Thanks for responding. > > "Patrice" <nobody@nowhere.com> wrote in message > news:%23X3srlDcFHA.3328@TK2MSFTNGP09.phx.gbl... >> And the problem is ? Looks like to me that a table tag should easily >> allow >> this layout ? >> >> Patrice >> >> -- >> >> "Nevets Steprock" <.@.> a écrit dans le message de >> news:Soire.62547$tt5.38490@edtnps90... >>> I'm writing a web program where one of the sections is supposed to >>> output >> a >>> correlation matrix. The typical correlation matrix looks like this: >>> >>> .23 >>> .34 .54 >>> .76 .44 .28 >>> .02 .77 .80 .99 >>> >>> I've written code to calculate the correlation data and it is populated >>> in >> a >>> vector like this: >>> >>> corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) >>> >>> I would like to present the data in a triangular matrix where each box >>> has >>> both the actual number and a colour scheme that represents the strength >>> of >>> correlation. >>> >>> I would be open to paying a fee for the help (please note that I'm not a >>> corporation with deep pockets). I've done exhausting searches on google >> for >>> "triangular matrix", code, .net, visual basic, etc... and can't find out >> how >>> other programmers are doing it. >>> >>> Thanks for ANY help you can give. >>> Steven >>> >>> >> >> > >
I would just output server side as many rows as needed. I was not talking
about a table (or array) structure. I was talking about the table HTML tag. You could render this tag using either a vector or an array. Because of the structure of this triangular matrix, it should be easy to find out how many columns you need in the table. You'll then render each row picking an additional cell each time (1, 2, 3 etc...) and filling the rest of the row with empty cells... It would be trivial using an rray, it should be still easy using a vector... Patrice -- "Nevets Steprock" <.@.> a écrit dans le message de news:tItre.61291$9A2.58275@edtnps89... [quoted text, click to view] > I suspect both Bruce and Kevin are suggesting the same. I've only started > programming for the web as of 3 months ago (~20 years of standalone > applications - nothing serious, just mucking around) and have been having a > great time with the new environment. > > Since my correlation matrix will be anywhere from 2 to 16 variables, can I > use jscript to do it dynamically or would you suggest I prebuild the table > structure for 16 variables and then resize the rows as necessary? > > Steven > > PS Thanks for responding. > > "Patrice" <nobody@nowhere.com> wrote in message > news:%23X3srlDcFHA.3328@TK2MSFTNGP09.phx.gbl... > > And the problem is ? Looks like to me that a table tag should easily allow > > this layout ? > > > > Patrice > > > > -- > > > > "Nevets Steprock" <.@.> a écrit dans le message de > > news:Soire.62547$tt5.38490@edtnps90... > >> I'm writing a web program where one of the sections is supposed to output > > a > >> correlation matrix. The typical correlation matrix looks like this: > >> > >> .23 > >> .34 .54 > >> .76 .44 .28 > >> .02 .77 .80 .99 > >> > >> I've written code to calculate the correlation data and it is populated > >> in > > a > >> vector like this: > >> > >> corrcoeff(.23, .34, .54, .76, .44, .28, .02, .77, .80, .99) > >> > >> I would like to present the data in a triangular matrix where each box > >> has > >> both the actual number and a colour scheme that represents the strength > >> of > >> correlation. > >> > >> I would be open to paying a fee for the help (please note that I'm not a > >> corporation with deep pockets). I've done exhausting searches on google > > for > >> "triangular matrix", code, .net, visual basic, etc... and can't find out > > how > >> other programmers are doing it. > >> > >> Thanks for ANY help you can give. > >> Steven > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |