(C) 2012 - 2017 by Mourad Louha · All rights reserved.

Statistical functions

Description

The description for the function AVEDEV is not available yet.

Availability

The AVEDEV function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007YesStatistical
Excel 2003YesStatistical

Syntax

AVEDEV(Number1,Number2,,Number255)

Arguments

The AVEDEV has the following arguments. Required arguments are bold.

DesignationDescription
Number1
Number2
:
Number255

 


Description

The description for the function AVERAGE is not available yet.

Availability

The AVERAGE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007YesStatistical
Excel 2003YesStatistical

Syntax

AVERAGE(Number1,Number2,,Number255)

Arguments

The AVERAGE has the following arguments. Required arguments are bold.

DesignationDescription
Number1
Number2
:
Number255

 


Description

The description for the function AVERAGEA is not available yet.

Availability

The AVERAGEA function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007YesStatistical
Excel 2003YesStatistical

Syntax

AVERAGEA(Value1,Value2,,Value255)

Arguments

The AVERAGEA has the following arguments. Required arguments are bold.

DesignationDescription
Value1
Value2
:
Value255

 


Description

The description for the function AVERAGEIF is not available yet.

Availability

The AVERAGEIF function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007YesStatistical
Excel 2003No

Syntax

AVERAGEIF(Range,Criteria,Average_range)

Arguments

The AVERAGEIF has the following arguments. Required arguments are bold.

DesignationDescription
Range
Criteria
Average_range

 


Description

The description for the function AVERAGEIFS is not available yet.

Availability

The AVERAGEIFS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007YesStatistical
Excel 2003No

Syntax

AVERAGEIFS(Average_range,Criteria_range1,Criteria1,Criteria_range2,Criteria2,,,Criteria_range127,Criteria127)

Arguments

The AVERAGEIFS has the following arguments. Required arguments are bold.

DesignationDescription
Average_range
Criteria_range1
Criteria1
Criteria_range2
Criteria2
:
:
Criteria_range127
Criteria127

 


Description

The description for the function BETA.DIST is not available yet.

Availability

The BETA.DIST function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007No
Excel 2003No

Syntax

BETA.DIST(X,Alpha,Beta,Cumulative,A,B)

Arguments

The BETA.DIST has the following arguments. Required arguments are bold.

DesignationDescription
X
Alpha
Beta
Cumulative
A
B

 


Description

The description for the function BETA.INV is not available yet.

Availability

The BETA.INV function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007No
Excel 2003No

Syntax

BETA.INV(Probability,Alpha,Beta,A,B)

Arguments

The BETA.INV has the following arguments. Required arguments are bold.

DesignationDescription
Probability
Alpha
Beta
A
B

 


Description

The description for the function BINOM.DIST is not available yet.

Availability

The BINOM.DIST function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007No
Excel 2003No

Syntax

BINOM.DIST(Number_s,Trials,Probability_s,Cumulative)

Arguments

The BINOM.DIST has the following arguments. Required arguments are bold.

DesignationDescription
Number_s
Trials
Probability_s
Cumulative

 

 
Top