MULTINOMIAL


Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.

Syntax:

MULTINOMIAL (number1, number2, ... number30)


number1 to number30 are up to 30 numbers or ranges of numbers.

This function returns:( number1 + number2 + ... + number30 )! / (number1! * number2! * ...* number30!)

Example:

MULTINOMIAL(1, 2)

returns 3, which is (1+2)!/(1!*2!).

MULTINOMIAL(F1:F3)

where F1 to F3 contain 2, 3 and 4 returns 1260.


Application:

The multinomial coefficient is a powerful tool for calculating the number of ways to arrange a set of objects into distinct groups. It's an extension of the binomial coefficient, which deals with two groups. The formula for the multinomial coefficient is:



where is the total number of items, and are the sizes of the distinct groups, such that .


Let's consider a scenario: a company is forming a new product development team.


The company has a pool of 10 employees and needs to form a team of 10 with the following roles:

  • 3 software engineers
  • 4 data scientists
  • 2 UX designers
  • 1 project manager


The question is, how many different ways can the company assign these 10 employees to these specific roles?


Here's how we can use the MULTINOMIAL function:


The MULTINOMIAL function takes the sizes of the distinct groups as its arguments. The total number of items (n) is calculated automatically by the function.

  • Group 1: 3 software engineers
  • Group 2: 4 data scientists
  • Group 3: 2 UX designers
  • Group 4: 1 project manager


The sum of the group sizes is , which equals the total number of employees.


Using the MULTINOMIAL function, the calculation is:



Let's break down the factorials:


Now, substitute these values back into the formula:



This means there are 12,600 different ways to form the new product development team with the specified roles.


Summary Table:

Role

Number of Employees ()

A
B
1
Software Engineer
3
2
Data Scientist
4
3
UX Designer
2
4
Project Manager
1
5
Total
10

Result for MULTINOMIAL(3, 4, 2, 1):

12600




This page is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof