Access Data Analysis Cookbook > Statistics > Returning All Combinations in a Set of Data

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Access Data Analysis Cookbook

Search

Access Data Analysis Cookbook

Dedication

Preface

Ch. 1. Query Construction

Ch. 2. Calculating with Queries

Ch. 3. Action Queries

Ch. 4. Managing Tables, Fields, Indexes, and Queries

Ch. 5. Working with String Data

Ch. 6. Using Programming to Manipulate Data

Ch. 7. Importing and Exporting Data

Ch. 8. Date and Time Calculations

Ch. 9. Business and Finance Problems

Ch. 10. Statistics

Creating a Histogram

Finding and Comparing the Mean, Mode, and Median

Calculating the Variance in a Set of Data

Finding the Covariance of Two Data Sets

Finding the Correlation of Two Sets of Data

Returning All Permutations in a Set of Data

Returning All Combinations in a Set of Data

Calculating the Frequency of a Value in a Set of Data

Generating Growth Rates

Determining the Probability Mass Function for a Set of Data

Computing the Kurtosis to Understand the Peakedness or Flatness of a Probability Mass Distribution

Determining the Skew of a Set of Data

Returning a Range of Data by Percentile

Determining the Rank of a Data Item

Determining the Slope and the Intercept of a Linear Regression

Measuring Volatility

Colophon

Index

10.7. Returning All Combinations in a Set of Data

10.7.1. Problem

I'd like to create a table containing all possible combinations from another table of data values for the specified number of output columns.

10.7.2. Solution

You can use the following routine to compute the number of possible combinations:

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial