# Manuals/calci/SAMPLING

Jump to navigation
Jump to search

**SAMPLING (Array,Method,Number,NewTableFlag)**

- is the array of values.
- is the type of sampling.
- is the number of samples.
- and is the logical value.
- SAMPLING(),Samples the data by Random or Periodic method

## Description

- This function gives the sample from a entire range of values.
- Sampling is used in statistical analysis in which a predetermined number of observations will be taken from a larger population.
- The methodology used to sample from a larger population will depend on the type of analysis being performed.
- In , is the array of values which contains the population of values to find the sample.
- is the Sampling type either Random or Periodic.
**RANDOM**:Here we have to mention the random Number of Samples. The number of values is taken from random positions in given array of values. A value can be selected more than once.**PERIODIC**: Here we have to mention the Period at which we want sampling to take place. Sampling stops when the end of the input range is reached.- is the number of random values that we want in the result.
- Each value is drawn from a random position in the given array, and any number can be selected more than once.
- is logical value like TRUE or FALSE.
- TRUE is indicating the result will display in new worksheet. Suppose we are omitted the value it will consider the value as FALSE.

## Examples

A | B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|

1 | 10 | 20 | 11 | 24 | 19 | 17 | 23 | 65 | 10 | 5 | 14 | 45 | 28 |

- SAMPLING(A1:M1,"RANDOM",5)

**SAMPLING**

INPUT | OUTPUT |
---|---|

10 | 24 |

20 | 20 |

11 | 11 |

24 | 19 |

19 | 17 |

17 | |

23 | |

65 | |

10 | |

5 | |

14 | |

45 | |

28 |

- SAMPLING(A1:K1,"PERIODIC",3)

**SAMPLING**

INPUT | OUTPUT |
---|---|

10 | 11 |

20 | 17 |

11 | 10 |

24 | |

19 | |

17 | |

23 | |

65 | |

10 | |

5 | |

14 |

## Related Videos

## See Also

## References