Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Javascript > How do I get the trendline equation from Excel to script?

Thread Tools

How do I get the trendline equation from Excel to script?

Posts: n/a
I want to display a bargraph including a trendline on the Internet
(using an asp-page). It doesn't matter what I use to display it. I
have found some graph-components (for example FusionCharts 2.2) that
seems ok.

First: What is the easiest way to go?
1. Calculate the trendline values (with vbscript or javascript) and
using a graphcomponent
2. or using a excelcomponent and somehow manipulate it to show the
graphs (bargraph and trendline) that I want.

IF 1: Then the problem I have is that I can not figure out how to
calculate the trendline values.

I have found a page (
that has some code used in Excel (see below). But the INDEX, LINEST
functions doesn't work in vbscript.
__________________________________________________ ____
Logarithmic Trendline
Equation: y = (c * LN(x)) - b

c: =INDEX(LINEST(y,LN(x)),1)

b: =INDEX(LINEST(y,LN(x)),1,2)

Power Trendline
Equation: y=c*x^b

c: =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2))

b: =INDEX(LINEST(LN(y),LN(x),,),1)
__________________________________________________ ____

IF 2: I am not very used to excel-programming so how can I do this
trendline using a component? Oh, the person that will see this graph
does not have the excel program.

Best regards,
Mattias in Sweden
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
How can I get the result of this equation Abder-Rahman Ali Ruby 4 07-14-2010 12:18 AM
How to get many places of pi from Machin's Equation? Richard D. Moores Python 4 01-09-2010 04:32 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
parallel CRC equation generator Shukla, Sunil Kumar VHDL 2 05-31-2005 01:57 AM