The type of match to use in a Vlookup() function to assess the resort fee as a possible additional cost for a particular room is
1 answer:
You might be interested in
<h3>Answer: 0.519</h3>
==========================================
Explanation:
Let's start off counting the number of ways to form the panel that doesn't have Allen or Joe on it. In other words, both are not on the panel.
There are 22 students, but we want to exclude 2 of them (Allen and Joe) from the panel. So in reality, we only have 20 students to pick from. There are 6 slots to fill.
The first slot has 20 choices
The second slot has 19 choices
The third has 18 choices
And so on. We count our way down until all six slots are filled. We'll have this sequence of six values: 20, 19, 18, 17, 16, 15
They multiply out to 20*19*18*17*16*15 = 27,907,200
This is the number of permutations where we choose 6 from a pool of 20.
With permutations, order matters; however, order doesn't matter on this panel. All we care about is the group overall.
So we must divide by 6! = 6*5*4*3*2*1 = 720 and we get
(27,907,200)/(720) = 38,760
There are 38,760 different combinations, so there are 38,760 different panels where neither Allen nor Joe are selected.
We'll use this later later, so let A = 38,760
------------------------------------------------------
Now onto the next part. We need to count the total number of possible panels, and this time we're including Allen and Joe.
We have our original total of 22 students. There are still 6 seats to fill.
We could follow the same steps as the prior section, but I'll use a different route.
Let n = 22 and r = 6. Plug these values into the nCr combination formula below
There are exactly 74,613 ways to form a committee of 6 people from a pool of 22 total.
Let B = 74,613
------------------------------------------------------
To find the probability of neither Allen or Joe are on the committee, we divide the values of A and B found earlier
A/B = (38,760)/(74,613) = 0.5194805
This value is approximate.
Rounding to three decimal places, or rounding to the nearest thousandth, leads to the final answer 0.519
There's roughly a 51.9% chance of forming a panel where neither Allen nor Joe are members.