mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmEXPECT, Expected values

Business Formulas

mmEXPECT, Expected values

Category: Market Research & Statistics

An expected value is the predicted value of a variable, calculated as the sum of all possible values each multiplied by the probability of its occurrence. In marketing such values can be very useful to compare, for instance, the results of a promotional action to a base level of expected results.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmEXPECT(Observed_Values, Optional Sample_Size, Optional Do_Percent)

Observed_Values The input values in the form of a contingency table
Sample_Size Optional - The sample size, when different from the table total
Do_Percent Optional - TRUE to return percent values, FALSE to return counts

Example

See example file Business Formulas.xls, sheet mmEXPECT.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmCHIp
  • mmCODING
  • mmSIGNIF
Related MM4XL software tools
  • CrossTab
  • Sample Manager
  • Proportion Analyst
  • Brand Mapping
Source
R. W. Madsen and M. L. Moeschberger, Statistical concepts with applications to business and economics
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: