Kako koristiti funkciju COMBIN u Excelu

Český Angličtina
KOMBINACE COMBIN

Syntax and Description of the Function

The COMBIN function in Microsoft Excel and Google Sheets is used to calculate combinations, which are ways of selecting items where the order does not matter. Combinations are utilized in statistics and probability to determine the number of different ways a specified number of items can be selected from a larger set.

 Syntax: COMBIN(n, k) where: n - total number of items. k - number of items to select.  

Example:

 Example 1: Given 10 soccer players, we want to find out how many different teams of five can be formed. =COMBIN(10, 5) // Result: 252 Example 2: In a class of 15 students, we need to select 3 for a school project. =COMBIN(15, 3) // Result: 455  

Practical Uses of the Function

Task No. 1: Conference Organization

A conference organizer wants to select 3 keynote speakers from a list of 12 potential candidates. How many different combinations of speakers can the organizer create?

 Using the function: =COMBIN(12, 3) Result: 220  

This result shows that 220 different trios can be formed from 12 candidates, helping the organizer understand the options available for speaker selection.

Task No. 2: Team Sport

A basketball team coach has 8 players and needs to select 5 players for the starting lineup. How many different lineups can the coach create?

 Using the function: =COMBIN(8, 5) Result: 56  

The COMBIN function provides the coach with 56 different options for assembling the starting team, offering a clear idea of team composition flexibility for upcoming games.

This HTML-formatted instruction includes detailed explanations, syntax-like examples, and practical usage scenarios for the COMBIN function, ensuring that users can understand and apply the function effectively in Excel and Google Sheets.

Více informací: https://support.microsoft.com/cs-cz/office/kombinace-funkce-12a3f276-0a21-423a-8de6-06990aaf638a

Další funkce
Vrátí arkustangens čísla
Zaokrouhlí číslo na nejbližší celé číslo nebo na nejbližší násobek zadané hodnoty Číslo bude zaokrouhleno nahoru bez ohledu na jeho znaménko
Přiřadí názvy výsledkům výpočtu a umožní tak ukládání mezilehlých výpočtů, hodnot nebo definování názvů ve vzorci
Vrátí nejmenší společný násobek
Vrátí přirozený logaritmus čísla
Vrátí dekadický logaritmus čísla
Vrátí logaritmus čísla při zadaném základu