AutoSave . OFF APP . C ... Unit 2C Project(1) Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Calibri (Body) v 11 " A" A" 29 Wrap Text v General Insert v Ex AP- O. Delete v Paste BIUV TYGA - Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v v Filter Select Data B2 X V fx A B D E F G H K L M N 0 P Q R S U v W X Z A Function Provide your function in the colored cells in column B. Keep in mind that many of the questions require multiple functions or multiple uses of the same function. It might be something as simple as COMBIN(n,r) Function or it may be several factorial functions being multiplied or divided. Take your time. This is the hardest DOO YOU A W N P section in this project. Don't be afraid to reach out to classmates for help or to me for clarification. C Function Functions used on this page include =FACT, =PERMUT and =COMBIN. Each question is worth 2 points. A. The student council is required to have 6 members. Three should be seniors and the other 3 should be D Function underclassmen. If there are 14 senior applicants and 20 underclassmen applicants, how many ways can the student council be formed? 10 Function 11 B. How many ways can the letters in the word "PROBABILITY" be arranged? 12 13 C. How many different ways can I create a team of 5 from a group of 12 adults and 30 children if the 14 team must have at least 2 children on it and at least one adult? 15 16 . If there are 15 possible project topics and 5 students must choose from the available topics, how many ways can the project topics be assigned? E. There are 12 scouts and 4 scout leaders going on a camping trip. If there is a red tent, blue tent, green tent and orange tent, and each tent will hold 3 scouts and 1 group leader, how many different tent and group assignments can be made? 1. Prob Rules (Ch.4) A 2. Perm and Comb (Ch.4) A 3. Prob. Dist (Ch.5) 4. Normal Dist (Ch.6) + Ready + 100%