Statistical Macro Functions

ANOVA1

ANOVA2

ANOVA3

DESCR

EXPON

FTESTV

HISTOGRAM

MCORREL

MCOVAR

MOVEAVG

PTTESTM

PTTESTV

RANDOM

RANKPERC

REGRESS

TTESTM

ZTESTM


ANOVA1

Macro Sheets Only

Performs single-factor analysis of variance, which tests the hypothesis that means from several samples are equal.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

ANOVA1(inprng, outrng, grouped, labels, alpha)
ANOVA1?(inprng, outrng, grouped, labels, alpha)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Grouped    is a text character that indicates whether the data in the input range is organized by row or column.

If grouped is "C" or omitted, then the data is organized by column.

If grouped is "R", then the data is organized by row.

Labels    is a logical value that describes where the labels are located in the input range, as shown in the following table:

Labels	Grouped	Labels are in
TRUE	"C"	First row of the input range.
TRUE	"R"	First column of the input range.
FALSE or omitted	(ignored)	No labels. All cells in the input range are data.

Alpha    is the significance level at which to evaluate critical values for the F statistic. If omitted, alpha is 0.05.

Related Functions

ANOVA2	Performs two-factor analysis of variance with replication

ANOVA3	Performs two-factor analysis of variance without replication

List of Statistical Functions


ANOVA2

Macro Sheets Only

Performs two-factor analysis of variance with replication.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

ANOVA2(inprng, outrng, sample_rows, alpha)
ANOVA2?(inprng, outrng, sample_rows, alpha)

Inprng    is the input range. The input range should contain labels in the first row and column.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Sample_rows    is the number of rows in each sample.

Alpha    is the significance level at which to evaluate critical values for the F statistic. If omitted, alpha is 0.05.

Related Functions

ANOVA1	Performs single-factor analysis of variance

ANOVA3	Performs two-factor analysis of variance without replication

List of Statistical Functions


ANOVA3

Macro Sheets Only

Performs two-factor analysis of variance without replication.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

ANOVA3(inprng, outrng, labels, alpha)
ANOVA3?(inprng, outrng, labels, alpha)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels    is a logical value.

If labels is TRUE, then the first row and column of the input range contain labels.

If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel will then generate the appropriate data labels for the output table.

Alpha    is the significance level at which to evaluate critical values for the F statistic. If omitted, alpha is 0.05.

Related Functions

ANOVA1	Performs single-factor analysis of variance

ANOVA2	Performs two-factor analysis of variance with replication

List of Statistical Functions


DESCR

Macro Sheets Only

Generates descriptive statistics for data in the input range.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

DESCR(inprng, outrng, grouped, labels, summary, ds_large, ds_small, confid)
DESCR?(inprng, outrng, grouped, labels, summary, ds_large, ds_small, confid)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Grouped    is a text character that indicates whether the data in the input range is organized by row or column.

If grouped is "C" or omitted, then the data is organized by column.

If grouped is "R" then the data is organized by row.

Labels    is a logical value that describes where the labels are located in the input range, as shown in the following table:

Labels	Grouped	Labels are in
TRUE	"C"	First row of the input range.
TRUE	"R"	First column of the input range.
FALSE or omitted	(ignored)	No labels. All cells in the input range are data.

Summary    is a logical value. If TRUE, DESCR reports the summary statistics. If FALSE or omitted, no summary statistics are reported.

Ds_large    is an integer k. If ds_large is present, DESCR reports the k-th largest data point. If ds_large is omitted, the value is not reported.

Ds_small    is an integer k. If ds_small is present, DESCR reports the k-th smallest data point. If ds_small is omitted, the value is not reported.

Confid    is the confidence level of the mean. If confid is given, DESCR reports the confidence interval for the input range. If confid is omitted, the confidence interval is 95%. For more information about the confidence interval calculation, see CONFIDENCE.

Related Functions

List of Statistical Functions


EXPON

Macro Sheets Only

Predicts a value based on the forecast for the prior period, adjusted for the error in that prior forecast.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

EXPON(inprng, outrng, damp, stderrs, chart)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Damp    is the damping factor. If omitted, damp is 0.3.

Stderrs    is a logical value. If TRUE, standard error values are included in the output table. If FALSE, standard errors are not included.

Chart    is a logical value. If TRUE, EXPON generates a chart for the actual and forecast values. If FALSE, the chart is not generated.

Related Functions

MOVEAVG	Returns values along a moving average trend


FOURIER

Macro Sheets Only

Performs a Fourier transform.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

FOURIER(inprng, outrng, inverse, labels)
FOURIER?(inprng, outrng, inverse, labels)

Inprng    is the input range. The number of cells in the input range must be equal to a power of two (2, 4, 8, 16, ...).

Outrng    is the first cell in the output range or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Inverse    is a logical value. If TRUE, an inverse Fourier transform is performed. If FALSE or omitted, a forward Fourier transform is performed.

Labels    is a logical value.

If labels is TRUE, then the first row or column of inprng contains labels.

If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Function

SAMPLE	Samples data

List of Statistical Functions


FTESTV

Macro Sheets Only

Performs a two-sample F-test.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

FTESTV(inprng1, inprng2, outrng, labels)
FTESTV?(inprng1, inprng2. outrng, labels)

Inprng1    is the input range for the first data set.

Inprng2    is the input range for the second data set.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels    is a logical value.

If labels is TRUE, then the first row or column of inprng1 and inprng2 contain labels.

If labels is FALSE or omitted, all cells in inprng1 and inprng2 are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Functions

List of Statistical Functions


HISTOGRAM

Macro Sheets Only

Calculates individual and cumulative percentages for a range of data and a corresponding range of data bins.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

HISTOGRAM(inprng, outrng, binrng, pareto, chartc, chart, labels)
HISTOGRAM?(inprng, outrng, binrng, pareto, chartc, chart, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Binrng    is an optional set of numbers that define the bin ranges. The values must be in ascending order. The values are interpreted as more than value A up to value B, more than value B up to value C, and so on. One additional bin is created for values for less than the minimum value specified in binrng.

Pareto    is a logical value.

If pareto is TRUE, data in the output table is presented in both ascending-bin order and descending-frequency order.

If pareto is FALSE or omitted, data in the output table is presented in ascending-bin order only.

Chartc    is a logical value. If chartc is TRUE, HISTOGRAM generates a cumulative percentages column in the output table. If both chartc and chart are TRUE, HISTOGRAM also includes a cumulative percentage line in the histogram chart. If omitted, chartc is FALSE.

Chart    is a logical value. If chart is TRUE, HISTOGRAM generates a histogram chart in addition to the output table. If omitted, chart is FALSE.

Labels    is a logical value.

If labels is TRUE, then the first row or column of inprng contains labels.

If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Function

List of Statistical Functions


MCORREL

Macro Sheets Only

Returns a correlation matrix that measures the correlation between two or more data sets that are scaled to be independent of the unit of measurement.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

MCORREL(inprng, outrng, grouped, labels)
MCORREL?(inprng, outrng, grouped, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Grouped    is a text character that indicates whether the data in the input range is organized by row or column.

If grouped is "C" or omitted, then the data is organized by column.

If grouped is "R", then the data is organized by row.

Labels    is a logical value that describes where the labels are located in the input range, as shown in the following table:

Labels	Grouped	Labels are in
TRUE	"C"	First row of the input range.
TRUE	"R"	First column of the input range.
FALSE or omitted	(ignored)	No labels. All cells in the input range are data.
Related Functions

MCOVAR	Returns the covariance between two or more data sets

List of Statistical Functions


MCOVAR

Macro Sheets Only

Returns a covariance matrix that measures the covariance between two or more data sets.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

MCOVAR(inprng, outrng, grouped, labels)
MCOVAR?(inprng, outrng, grouped, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Grouped    is a text character that indicates whether the data in the input range is organized by row or column.

If grouped is "C" or omitted, then the data is organized by column.

If grouped is "R", then the data is organized by row.

Labels    is a logical value that describes where the labels are located in the input range, as shown in the following table:

Labels	Grouped	Labels are in
TRUE	"C"	First row of the input range
TRUE	"R"	First column of the input range
FALSE or omitted	(ignored)	No labels. All cells in the input range are data.
Related Functions

MCORREL	Returns the correlation coefficient of two or more data sets that are scaled to be independent of the unit of measurement

List of Statistical Functions


MOVEAVG

Macro Sheets Only

Projects values in a forecast period, based on the average value of the variable over a specific number of preceding periods.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

MOVEAVG(inprng, outrng, interval, stderrs, chart, labels)
MOVEAVG?(inprng, outrng, interval, stderrs, chart, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Interval    is the number of values to include in the moving average. If omitted, interval is 3.

Stderrs    is a logical value.

If stderrs is TRUE, standard error values are included in the output table.

If stderrs is FALSE or omitted, standard errors are not included in the output table.

Chart    is a logical value.

If chart is TRUE, then MOVEAVG generates a chart for the actual and forecast values.

If chart is FALSE or omitted, the chart is not generated.

Labels    is a logical value.

If labels is TRUE, then the first row or column of inprng contains labels.

If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Functions

List of Statistical Functions


PTTESTM

Macro Sheets Only

Performs a paired two-sample Student's t-Test for means.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

PTTESTM(inprng1, inprng2, outrng, labels, alpha, difference)
PTTESTM?(inprng1, inprng2, outrng, labels, alpha, difference)

Inprng1    is the input range for the first data set.

Inprng2    is the input range for the second data set.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels    is a logical value.

If labels is TRUE, then labels are in the first row or column of the input ranges.

If labels is FALSE or omitted, all cells in inprng1 and inprng2 are considered data. The output table will include default row or column headings.

Alpha    is the confidence level for the test. If omitted, alpha is 0.05.

Difference    is the hypothesized mean difference. If omitted, difference is 0.

Related Functions

PTTESTV	Performs a two-sample Student's t-Test, assuming unequal variances

TTESTM	Performs a two-sample Student's t-Test for means, assuming equal variances

List of Statistical Functions


PTTESTV

Macro Sheets Only

Performs a two-sample Student's t-Test, assuming unequal variances.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

PTTESTV(inprng1, inprng2, outrng, labels, alpha)
PTTESTV?(inprng1, inprng2, outrng, lables, alpha)

Inprng1    is the input range for the first data set.

Inprng2    is the input range for the second data set.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels    is a logical value.

If labels is TRUE, then labels are in the first row or column of the input ranges.

If labels is FALSE or omitted, all cells in inprng1 and inprng2 are considered data. The output table will include default row or column headings.

Alpha    is the confidence level for the test. If omitted, alpha is 0.05.

Related Functions

PTTESTM	Performs a paired two-sample Student's t-Test for means

TTESTM	Performs a two-sample Student's t-Test for means, assuming equal variances

List of Statistical Functions


RANDOM

Macro Sheets Only

Fills a range with independent random or patterned numbers drawn from one of several distributions.

If this function is not available, you must install the Analysis ToolPak add-in macro.

RANDOM provides six different random distributions and one patterned data option. Because the distributions require different argument lists, there are seven syntax forms for RANDOM.

Syntax 1

Uniform distribution

RANDOM(outrng, variables, points, distribution, seed, from, to)
RANDOM?(outrng, variables, points, distribution, seed, from, to)

Syntax 2

Normal distribution

RANDOM(outrng, variables, points, distribution, seed, mean, standard_dev)
RANDOM?(outrng, variables, points, distribution, seed,mean, standard_dev)

Syntax 3

Bernoulli distribution

RANDOM(outrng, variables, points, distribution, seed, probability)
RANDOM?(outrng, variables, points, distribution, seed, probability)

Syntax 4

Binomial distribution

RANDOM(outrng, variables, points, distribution, seed, probability, trials)
RANDOM?(outrng, variables, points, distribution, seed, probability, trials)

Syntax 5

Poisson distribution

RANDOM(outrng, variables, points, distribution, seed, lambda)
RANDOM?(outrng, variables, points, distribution, seed, lambda)

Syntax 6

Patterned distribution

RANDOM(outrng, variables, points, distribution, seed, from, to, step, repeat_num, repeat_seq)
RANDOM?(outrng, variables, points, distribution, seed, from, to, step, repeat_num, repeat_seq)

Syntax 7

Discrete distribution

RANDOM(outrng, variables, points, distribution, seed, inprng)
RANDOM?(outrng, variables, points, distribution, seed, inprng)

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Variables    is the number of random number sets to generate. RANDOM will generate variables columns of random numbers. If omitted, variables is equal to the number of columns in the output range.

Points    is the number of data points per random number set. RANDOM will generate points rows of random numbers for each random number set. If omitted, points is equal to the number of rows in the output range. Points is ignored when distribution is 6 (Patterned).

Distribution    indicates the type of number distribution.

Distribution	Distribution type

1	Uniform

2	Normal

3	Bernoulli

4	Binomial

5	Poisson

6	Patterned

7	Discrete

Seed    is an optional value with which to begin random number generation. Seed is ignored when distribution is 6 (Patterned) or 7 (Discrete).

From    is the lower bound.

To    is the upper bound.

Mean    is the mean.

Standard_dev    is the standard deviation.

Probability    is the probability of success on each trial.

Trials    is the number of trials.

Lambda    is the Poisson distribution parameter.

Step    is the increment between from and to.

Repeat_num    is the number of times to repeat each value.

Repeat_seq    is the number of times to repeat each sequence of values.

Inprng    is a two-column range of values and their probabilities.

Related Function

List of Statistical Functions


RANKPERC

Macro Sheets Only

Returns a table that contains the ordinal and percent rank of each value in a data set.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

RANKPERC(inprng, outrng, grouped, labels)
RANKPERC?(inprng, outrng, grouped, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Grouped    is a text character that indicates whether the data in the input range is organized by row or column.

If grouped is "C" or omitted, then the data is organized by column.

If grouped is "R", then the data is organized by row.

Labels    is a logical value that describes where the labels are located in the input range, as shown in the following table:

Labels	Grouped	Labels are in
TRUE	"C"	First row of the input range.
TRUE	"R"	First column of the input range.
FALSE or omitted	(ignored)	No labels. All cells in the input range are data.
Related Functions

List of Statistical Functions


REGRESS

Macro Sheets Only

Performs multiple linear regression analysis.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

REGRESS(inpyrng, inpxrng, constant, labels, confid, soutrng, residuals, sresiduals, rplots, lplots, routrng, nplots, poutrng)
REGRESS?(inpyrng, inpxrng, constant, labels, confid, soutrng, residuals, sresiduals, rplots, lplots, routrng, nplots, poutrng)

Inpyrng    is the input range for the y-values (dependent variable).

Inpxrng    is the input range for the x-values (independent variable).

Constant    is a logical value. If constant is TRUE, the y-intercept is assumed to be zero (the regression line passes through the origin). If constant is FALSE or omitted, the y-intercept is assumed to be a non-zero number.

Labels    is a logical value.

If labels is TRUE, then the first row or column of the input ranges contain labels.

If labels is FALSE or omitted, all cells in inpyrng and inpxrng are considered data. Microsoft Excel will then generate the appropriate data labels for the output table.

Confid    is an additional confidence level to apply to the regression. If omitted, confid is 95%.

Soutrng    is the first cell (the upper-left cell) in the output table or the name, as text, of the new sheet to contain the summary output table. If FALSE, blank, or omitted, places the summary output table in a new workbook. Microsoft Excel version 5.0 uses a single output table for REGRESS; Microsoft Excel version 4.0 used three different output tables for summary, residual, and probability data.

Residuals    is a logical value. If residuals is TRUE, REGRESS includes residuals in the output table. If residuals is FALSE or omitted, residuals are not included.

Sresiduals    is a logical value. If sresiduals is TRUE, REGRESS includes standardized residuals in the output table. If sresiduals is FALSE or omitted, standardized residuals are not included.

Rplots    is a logical value. If rplots is TRUE, REGRESS generates separate charts for each x versus the residual. If rplots is FALSE or omitted, separate charts are not generated.

Lplots    is a logical value. If lplots is TRUE, REGRESS generates a chart showing the regression line fitted to the observed values. If lplots is FALSE or omitted, the chart is not generated.

Routrng    is the first cell (the upper-left cell) in the residuals output table or the name, as text, of the new sheet to contain the residuals output table. If FALSE, blank, or omitted, places the residuals output table in a new worksheet. This argument is for compatibility with Microsoft Excel 4.0 only and is ignored in Microsoft Excel version 5.0.

Nplots    is a logical value. If nplots is TRUE, REGRESS generates a chart of normal probabilities. If nplots is FALSE or omitted, the chart is not generated.

Poutrng    is the first cell (the upper-left cell) in the probability data output table or the name, as text, of the new sheet to contain the probability output table. If FALSE, blank, or omitted, places the probability output table in a new worksheet. This argument is for compatibility with Microsoft Excel 4.0 only and is ignored in Microsoft Excel version 5.0.

Related Functions

List of Statistical Functions


SAMPLE

Macro Sheets Only

Samples data.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

SAMPLE(inprng, outrng, method, rate, labels)
SAMPLE?(inprng, outrng, method, rate, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output column or the name, as text, of a new sheet to contain the output column. If FALSE, blank, or omitted, places the output table in a new workbook.

Method    is a text character that indicates the type of sampling.

If method is "P", then periodic sampling is used. The input range is sampled every nth cell, where n = rate.

If method is "R", then random sampling is used. The output column will contain rate samples.

Rate    is the sampling rate, if method is "P" (periodic sampling). Rate is the number of samples to take if method is "R" (random sampling).

Labels    is a logical value.

If labels is TRUE, then the first row or column of inprng contains labels.

If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Function

List of Statistical Functions


TTESTM

Macro Sheets Only

Performs a two-sample Student's t-Test for means, assuming equal variances.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

TTESTM(inprng1, inprng2, outrng, labels, alpha, difference)
TTESTM?(inprng1, inprng2, outrng, labels, alpha, difference)

Inprng1    is the input range for the first data set.

Inprng2    is the input range for the second data set.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels    is a logical value.

If labels is TRUE, then labels are in the first row or column of the input ranges.

If labels is FALSE or omitted, all cells in inprng1 and inprng2 are considered data. The output table will include default row or column headings.

Alpha    is the confidence level for the test. If omitted, alpha is 0.05.

Difference    is the hypothesized difference in means. If omitted, difference is 0.

Related Functions

PTTESTM	Performs a paired two-sample Student's t-Test for means

PTTESTV	Performs a two-sample Student's t-Test, assuming unequal variances

List of Statistical Functions


ZTESTM

Macro Sheets Only

Performs a two-sample z-test for means, assuming the two samples have known variances.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

ZTESTM(inprng1, inprng2, outrng, labels, alpha, difference, var1, var2)
ZTESTM?(inprng1, inprng2, outrng, labels, alpha, difference, var1, var2)

Inprng1    is the input range for the first data set.

Inprng2    is the input range for the second data set.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels    is a logical value.

If labels is TRUE, then the first row or column of the input ranges contains labels.

If labels is FALSE or omitted, all cells in inprng1 and inprng2 are considered data. Microsoft Excel will then generate the appropriate data labels for the output table.

Alpha    is the confidence level for the test. If omitted, alpha is 0.05.

Difference    is the hypothesized difference in means. If omitted, difference is 0.

Var1    is the variance of the first data set.

Var2    is the variance of the second data set.

Related Functions

List of Statistical Functions


Macro Function Help file not installed

To display help topics for Microsoft Excel 4.0 macro functions, you must first install the complete Macro Function help file. You can obtain the complete Macro Function help file (macrofun.hlp), from Compuserve or from the Microsoft Network.

To obtain the Macro Function Help file from Compuserve, type go msexcel from any ! prompt and look for the file macrofun.zip.

To obtain the Macro Function Help file from the Microsoft Network, look on the Microsoft forum for information about obtaining macrofun.hlp. If you are a member of the Microsoft Network, you can connect to the Microsoft forum by clicking here

To install the Macro Function help file, copy the macrofun.hlp file you have obtained to the Excel folder, replacing the copy of macrofun.hlp that is already there.

Note The copy of macrofun.hlp currently in your Excel folder contains only this topic plus topics documenting statistical functions for the Analysis ToolPak.


For information on the selected worksheet function , see the List of Worksheet Functions or look for the selected function in the Microsoft Excel online index.