ZCubes Wiki

Changes

Manuals/calci/TREND (view source)

Revision as of 04:28, 18 February 2014

287 bytes added ,  04:28, 18 February 2014
→‎Examples
Line 19: Line 19:     
==Examples==
 
==Examples==
 +
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! DAYS(x) !! SALES(y) !! x1
 +
|-
 +
! 1
 +
| 1 || 40 || 10
 +
|-
 +
! 2
 +
| 2 || 35 || 11
 +
|-
 +
! 3
 +
| 3  || 42  || 12
 +
|-
 +
! 4
 +
| 4 ||50  || 13
 +
|-
 +
! 5
 +
| 5 || 54 || 14 
 +
! 6
 +
| 6 || 49 || 
 +
|-
 +
! 7
 +
| 7  || 51  || 
 +
|-
 +
! 8
 +
| 8 || 58  || 
 +
|-
 +
! 9
 +
| 9 || 60 || 
 +
|}
 
DAYS(x)      SALES(y)        x1
 
DAYS(x)      SALES(y)        x1
 
1                40          10
 
1                40          10
Line 32: Line 64:  
62.611111111111114,etc
 
62.611111111111114,etc
 
TREND(B1:B9,A1:A9,C1:C5,FALSE) =  
 
TREND(B1:B9,A1:A9,C1:C5,FALSE) =  
−
=  82.84210546,etc  
+
=  82.84210546,etc
    
==See Also==
 
==See Also==
Abin
writer
5,435

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/197871"