Thanks Gregg!
On 7/9/07, g. wygonik <[EMAIL PROTECTED]> wrote:
hey daniel
i think that means that you have three arrays of the B1:B7 Math.pow()
series, with each array being a different value in the curly-bracketed list.
That is:
B1:B7^{1,2,3} becomes
var myArray1 = [ Math.pow(B1,1),...,Math.pow(B7,1)];
var myArray2 = [Math.pow(B1,2),...,Math.pow(B7,2)];
var myArray3 = [Math.pow(B1,3),...,Math.pow(B7,3)];
B1:B7^{5,10} becomes
var myArray1 = [Math.pow(B1,5),...,Math.pow (B7,5)];
var myArray2 = [Math.pow(B1,10),...,Math.pow(B7,10)];
and so on
hth
g.
On 7/1/07, Daniel Cascais <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Hi, I've stumbled upon this function call in Excel:
> =LINEST(A1:A7,B1:B7^{1,2,3})
>
> And I'm having issues with this last bit:
> "B1:B7^{1,2,3}"
>
>
> Let's say B1:B7 is an array from 1 to 7 considering this Excel notation:
> "B1:B7"
>
> It would look like this in ActionScript:
>
> var n1:Number = 1;
> var n2:Number = 2;
> var n3:Number = 3;
> var n4:Number = 4;
> var n5:Number = 5;
> var n6:Number = 6;
> var n7:Number = 7;
>
> var myArray:Array = [n1, n2, n3, n4, n5, n6, n7];
>
>
> Now, if I change this, considering the following Excel notation:
> "B1:B7^2"
>
> It would look like this ActionScript:
>
> var n1:Number = Math.pow(1, 2);
> var n2:Number = Math.pow(2, 2);
> var n3:Number = Math.pow(3, 2);
> var n4:Number = Math.pow(4, 2);
> var n5:Number = Math.pow(5, 2);
> var n6:Number = Math.pow(6, 2);
> var n7:Number = Math.pow(7, 2);
>
> var myArray:Array = [n1, n2, n3, n4, n5, n6, n7];
>
>
> But what on earth happens to the array with this Excel notation???
> "B1:B7^{1,2,3}"
>
> --Daniel
>
--
weblog: broadcast.artificialcolors.com
blazePDF: www.blazepdf.com
band: www.cutratebox.com
_______________________________________________
Flashcoders@chattyfig.figleaf.com
To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Brought to you by Fig Leaf Software
Premier Authorized Adobe Consulting and Training
http://www.figleaf.com
http://training.figleaf.com
_______________________________________________
Flashcoders@chattyfig.figleaf.com
To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Brought to you by Fig Leaf Software
Premier Authorized Adobe Consulting and Training
http://www.figleaf.com
http://training.figleaf.com