mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmSAMPLEMIN, Minimum Sample for Significant Values

Business Formulas

mmSAMPLEMIN, Minimum Sample for Significant Values

Category: Market Research & Statistics

The Minimum Sample for Significant Values function returns the minimum sample size required to establish if the difference between two proportions is statistically significant.

For instance, we test 2 product concepts with 2 different samples of 150 units each. 29% of the interviewees in sample 1 prefer Product A and 45% of the interviewees in sample 2 prefer Product B. At the 95% confidence level, mmSAMPLEMIN returns that at least 68 interviews are required. We have 150 samples, so we can state that the preference for Product B is statistically significant.

Business analysis formulas for Excel. Marketing tool for professionals

Where:

n = Minimum sample size
k = Confidence level
p = Proportion of preference
q = 1-p

Syntax

mmSAMPLEMIN(LikeA, LikeB, Confidence, Optional Rounded)

LikeA Percent of people who prefer brand or item A
LikeB Percent of people who prefer brand or item B
Confidence The confidence interval level
Rounded Optional - TRUE returns an integer value, FALSE returns a decimal value

Example

See example file Business Formulas.xls, sheet mmSAMPLEMIN.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmSAMPLE
  • mmSIGNIF
  • mmCHIp
  • mmCODING
  • mmCSII
  • mmCSIW
  • mmINTERPOLE
  • mmRANGE
Related MM4XL software tools
  • Sample Manager
  • CrossTab
  • Proportion Analyst
Source
Giorgio Marbach, 2011, Le ricerche di Mercato
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: