Excel File Edit View Insert Format Tools Data Window Help Mon Nov 22 5:53 PM AutoSave OFF AA Exam 3 Fall FR1 Q Home Insert Draw Page Layout Formulas Data Review View Developer Acrobat Tell me Share Comments Calibri (Body) 11 . i General LG #Insert v Conditional Formatting Format as Table Cell Styles WE Ayu O DX Delete FO IN Analyze Data Paste === A $ %) E OO Sensitivity # Format Sort & Filter Find & Select Create and Share Adobe PDF D22 x fox A B C D E F G H I J K L M N 0 1 4. 15 pts 2 3 4 minn 5 You work for an advertising firm and each month you get between five and ten new clients. Each client chooses to advertise in a magazine, on the radio, on a billboard, or all three. 10% of clients will choose the combination of all three, 20% will choose a magazine, 40% will choose radio. A radio spot earns you $500 commission; an ad in a magazine earns you $200 commission; a billboard ad earns you $350; when a client chooses all three methods, you will earn $1100 in commission. 6 7 8 9 A. Create a model for one month to determine which method(s) of advertising each new client will choose along with your respective commission. Calculate the total amount of money you will make for your monthly commission. 10 11 12 13 14 15 16 17 18 B. Replicate your monthly commission 300 times using a data table. What is the probability you make at least $3000 in commissions per month. Round the probability to the nearest thousandth. 19 20 Ready IT 3 PU 180% + New Folder nui cakalina. MGT 4560 Business Data Management TT, 5:00-6:15 Powers 203 Desktop.pkg oad ctv 22 4 Ps JU Excel File Edit View Insert Format Tools Data Window Help Mon Nov 22 5:53 PM AutoSave OFF AA Exam 3 Fall FR1 Q Home Insert Draw Page Layout Formulas Data Review View Developer Acrobat Tell me Share Comments Calibri (Body) 11 . i General LG #Insert v Conditional Formatting Format as Table Cell Styles WE Ayu O DX Delete FO IN Analyze Data Paste === A $ %) E OO Sensitivity # Format Sort & Filter Find & Select Create and Share Adobe PDF D22 x fox A B C D E F G H I J K L M N 0 1 4. 15 pts 2 3 4 minn 5 You work for an advertising firm and each month you get between five and ten new clients. Each client chooses to advertise in a magazine, on the radio, on a billboard, or all three. 10% of clients will choose the combination of all three, 20% will choose a magazine, 40% will choose radio. A radio spot earns you $500 commission; an ad in a magazine earns you $200 commission; a billboard ad earns you $350; when a client chooses all three methods, you will earn $1100 in commission. 6 7 8 9 A. Create a model for one month to determine which method(s) of advertising each new client will choose along with your respective commission. Calculate the total amount of money you will make for your monthly commission. 10 11 12 13 14 15 16 17 18 B. Replicate your monthly commission 300 times using a data table. What is the probability you make at least $3000 in commissions per month. Round the probability to the nearest thousandth. 19 20 Ready IT 3 PU 180% + New Folder nui cakalina. MGT 4560 Business Data Management TT, 5:00-6:15 Powers 203 Desktop.pkg oad ctv 22 4 Ps JU