Probability plots using OWC10

[mithil.mohan]

hi everyone,
I am trying to make probability charts using OWC10 in ASP. I have no
idea as to where i should start off could anyone plz point me in the
right direction ? any help would be greatly appreciated

thanking you all,
Mithil

 

[Alvin Bruney [MVP]]

What exactly is a probability chart? As long as you figure out the data to
be plotted, you can use any of the chart types to plot the data.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[Mithil]

i am sorry should have explained what probabililty charts are. it is to
do with statistics. It has percent on the vertical axis and data on the
horizontal axis, which gives a percent measure of how many datas are
contained within that percent. For example: say there is a chart which
reads at 50% on Y-axis the corresponding X-axis value is 10 it means
that 10 datas are contained within the 50% range. For this to work I
need to use some statistical function namely: tinv, rank which is
provided in Excel but i don't know how to use it in ASP since it is
provided in excel i guess i can use it so could you plz help me out
with this.

Thanking u a lot for relpying,
Mithil

 

[Alvin Bruney [MVP]]

yup, so all you need to do is add a reference to the excel object model on
the server. That will give you access to the built in excel function. From
there, you can calculate your data. With the raw data, you simply plot a
chart and give it an appropriate type.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[Mithil]

how will i add a reference to the excel object model on the server ?
could you plz give me an example thanks for your help Alvin.

regards,
Mithil