# Integrate

## Description

Minimum Origin Version Required: 8.6 SR0

This function is used to integrate area under curve using Trapezoid Rule. Missing values will be ignored. Note that the X values for the integration are row numbers. To calculate the area of a curve with arbitrary X coordinates, please use IntegrateXY(vx, vy)

## Syntax

vector Integrate(vector vd)

## Parameters

vd

The vector for performing integration.

## Return

Return the cumulative areas as dataset from the integration

## Example

// using column
col(b) = Integrate(col(a));

// using dataset variable
dataset dsInput = {1, 2, 3, 4, 5};
dataset dsOutput = Integrate(dsInput);
dsOutput[2] = ;  // 1.5, get the second output value

// using range
range rInput = [Book1]Sheet1!col(1);
range rOutput = [Book1]Sheet1!col(2);
rOutput = Integrate(rInput);