Would you help me solving problem in business analytic ?

please help me on this business anlaytic problem.

x Assignment SMc-Roulette ().xkx Open with B C D E F C K L M N O P Q R S T A Norra H Correct I J A Pusille ures 1 6 970 m2 OC TE 41 9122 Let's Play Roulette 28 0 11:30 PM (dminle gel 2 143 Cursos multimera matrik - Triin with a sita Icli witaratris tuwib up this uple rous capture the si Fouwla alavu.al v in UIN 100.tala Lilly Lub u rti uvid UX F9 10 acres You can also chang e cluditur r ruca Simu 100 tis. 19/35 23 36 24 3 153 Mall Four Filialbal . :11 . " IL 27/0011 13 18 31 193 Su Y. MIN B. SUMBILLUS TIIL 8 1229 25 plus.ba Ber: Cheng 1. Pourta nt . There a re 11 Jurr Pure SHU JURUL S O AL ULCIALI.. Choose a number c ond 32. Bercheorerunberforatra Thcolo. I o hali il b. Si The onlar wintires that ariser-hacedonthers h u l ning the help in hartian www. w 3. umbatwira TNT UESPILT-tharu. Dabar T LD rite balans - FIFA U-M IEL IN...rec. the bal van. U I . . x Assignment SMc-Roulette ().xbx Open with A B C D E F G H I J K L M N O P R S T 27 LIMI PASI 11:30 PM (4 minutes ago cal! aruan tilaa . Jos luul.. = Inthem llcpain th F, The Horare in the attesen The UTS B U WITHCS Tegin irgeline n batannarx en lainete Yence indicard Eids Writulu.cl bal .n.lar. in that corunibero Calubatilleri Meri The ability cancris irytal Datens C. der paste tactics. D'UIC Sri Pelus forth wiringsce orios volonirs. Jodora Boragile TWANGAWI are Varan sulten Alnate: Cornergrrthand Sarrarl ants: Freethin 1 Sarrib-Winn Gr i mrod krutte x Assignment SMc-Roulette ().xbx Open with A B C D E F H I J K L M N O P Q R S T | ENIMES 4 11:30 PM (5 minutes ago Willem II PUU. ea pasilicum? 3558333333333333333HHH : : 58983728258 : 299233 Roulette 1a Let's Play Roulette Polis Bi 4 Trial de 100 Ramush Your Nuwe i bon balance and Esting Boler Pwy wiener 1:38+ * Assignment SM C-R... ... The ------- is 14 DIE TO 11 I Let's Play Roulette 28 0 2 143 Instructions You are setting up a simulation of a roulette gambling game - the American version with 38 slots Follow the instructions below to set up the tables to play roulette and capture the results You will be playing multiple sessions of roulette with each session consisting of 100 trials A trial equals one spin of the roulette wheel. Use F9 to Refresh (You can also change an unused cell and hit enter) to generate a simulation of 100 trials. 35 23 4 16 33 2 Bet Parameters 27 6 18 31 Your initial bet Your first bet is for $1 Bet Type Single: You are betting on a particular single number Payoff for S1 bet 35 Bet Change "no". Your bet will consistantly be $1. It will not change. 1000% Let's Play Roulette 97 0) 97 6 Instructions You are setting up a simulation of a roulette gambling game - the American version with 38 slots Follow the instructions below to set up the tables to play roulette and capture the results You will be playing multiple sessions of roulette with each session consisting of 100 trials A trial equals one spin of the roulette wheel. Use F9 to Refresh (You can also change an unused cell and hit enter) to generate a simulation of 100 trials 2 14 352 35 23 4 16 33 2 Bet Parameters 16 33 21 6 Your initial bet Your first bet is for SI 618 31 19 5 Bet Type Single: You are betting on a particular single number Payoff for $1 bet 35 1918 12 Bet Change "no". Your bet will consistantly be $1. It will not change. 3 Trial Data Trial Trials are numbered from 1 to 100 Random Number Generate a random number from 1 to 38 (37 and 38 replace and 00) Use the Randbetween function Your Number Choose a number between 1 and 38. Bet the same number for each trial Bet The amount you bet on each trial which will be $1 Winnings The dollar winnings from that particular bet based on the probability of winning the bet. Use an If function. (if the bet wins, winnings.no winnings) A bet wins when your lucky number the roulette random number Current Balance Previous or initial balance plus winnings on a winning bet, else subtract the bet amount Use an If Function to determine if you had a winning bet 4 Key - Sumary Results You have $100 to bet with, however the casino will extend you credit if you Initial Balance need it. Key - Sumary Results You have $100 to bet with, however the casino will extend you credit if you Initial Balance need it # of Bets You will be betting 100 times Total S Bet The total amount bets for the session. Use the Sum function # of Winning Bets The number of winning bets placed in this session. Use a countif function Wof Losing Bets The number of losing bets in this session. The difference between the # of bets and the ff of winning bets Ending Balance Beginning Balance plus Winnings. bet amounts on losing hets. Winnings Difference between Initial Balance and Ending Balance % Return The winnings divided by the total bet amount for the session #of Losing Bets and the # of winning bets Ending Balance Beginning Balance plus Winnings - bet amounts on losing bets, Winnings Difference between Initial Balance and Ending Balance % Return The winnings divided by the total bet amount for the session P- that exact number of The probability of having x wins in y trials. Use a binomial distribution wins function P- that many wins or less The probability of having x or fewer wins in y trials P- that many wins or more The probability of having x or more wins in y trials 5 Captured Sessions Copy and then paste (value) the last 7 columns of the Summary Restuls for the winning scenarios of 0 to 6 wins. Conditional Formatting Rules Trial Data - Winnings: Red for and Green for 1 or greater 5 Captured Sessions Copy and then paste (value) the last 7 columns of the Summary Restuls for the winning scenarios of 0 to 6 wins. Conditional Formatting Rules Trial Data - Winnings: Red for 0 and Green for l or greater Summary Results of Winning Bets: Green for greater than 0 Summary Results of Losing Bets Red for greater than 1 Summary Results - Winnings: Cireen for a positive number, red for a negative number Bet Paramers Summary Results The summary of one session consisting of x number of trials of Losing Your initial bet Bet Type Bet Payor Bet Change Initial balance of Bets Total Be of Winning bets Ending winnings Reum bots Balance Trial Data Captured sessions Trial Random Bet number Winnings Current Balance of losind hats Winning bets Ending winnings Balance e) the last 7 columns of the Summary Restuls for the winning scenarios of 0 to 6 wins. miles ed for and Green for or greater inning Bets: Green for greater than 0 sing Bets: Red for greater than mgs: Green for a positive number, red for a negative number Summary Results The summary of one session consisting of x number of trials of W of Losind et Change Initial balance of Bets Total Bed Winning Ending Winnings Retum P- that P-that P-that exact b er of many wins many wins or less or more wins beis Balance bet Captured Sissions Be Winnings Balance of Winning bels of Losing Ending w bets Balance iness Return P that P-that P-that exact number or many wins many wins wins or more Bet Type Bet Payoff Bet Change bet # of Losing of Bets Initial balance Total S Bed Winning Ending Balance Winnings bets Trial Data Captured Sessions Current of losing Random Trial # Your number Bet Winnings Winning Ending winnings Balance bets Balance bets What are the minimum wins you need to have a posi Mof Winning score hets 0 0 1 0 2 0 0 0 0 0 0 0 Captured Sessions #of Winning Current Balance Ending winings of Losing bets % Return P- that P-that many wins many wins or less or more exact number of Balance bets 5 What are the mininum wins you need to have a positive retum? Nof Winning 0 0 0 0 5 What are the minimum wins you need to have a positive retum? of Winning 0 eole o --- 0 10 no Name . 00 123 Default (C. 11 BISA B E LI... fx . Name Possibl % Correct 1000% # Correct 0 Date Let's Play Roulette Instructions 1 You are setting up a simulation of a roulette gambling game the American version with 38 slots Follow the instructions below to set up the tables to play roulette and capture the results You will be playing multiple sessions of roulette with each session consisting of 100 trials A trial equals one spin of the roulette wheel. Use F9 to Refresh (You can also change an unused cell and hit enter) to generate a simulation of 100 trials. 3 23 4 16 332 Bet Parameters Your initial bet Your first bet is for $1 Bet Type Single: You are betting on a particular single number Payoff for $1 bet Bet Change "no" - Your bet will consistantly be $1. It will not change. + Roulette ta Bet Change "no" - Your bet will consistantly be $1. It will not change. 3 Trial Data Trial # Trials are numbered from 1 to 100 Generate a random number from 1 to 38 (37 and 38 replace 0 and 00) Use the Randbetween function Random Number Your Number Choose a number between 1 and 38. Bet the same number for each trial Bet The amount you bet on each trial which will be $1 The dollar winnings from that particular bet based on the probability of winning the bet. Use an If function (if the bet wins, winnings, no winnings) A bet wins when your lucky number = the roulette random number Winnings Previous or initial balance - plus winnings on a winning bet, else subtract the bet amount Use an If function to determine if you had a winning bet Current Balance 4 Key - Summary Results You have $100 to bet with, however the casino will extend you credit if you need it. Initial Balance Roulette is - T 150 - $ 125. Default (ca. 11 - B A . . . .. 60 YE. A Name fx E B 4 C D Key - Summary Results You have $100 to bet with, however the casino will extend you credit if you need it. Initial Balance # of Bets You will be betting 100 times Total $ Bet The total $ amount bets for the session. Use the Sum function The number of winning bets placed in this session. Use a countif function # of Winning Bets The number of losing bets in this session. The difference between the # of bets and the # of winning bets # of Losing Bets Ending Balance Beginning Balance plus Winnings. bet amounts on losing bets. Winnings Difference between Initial Balance and Ending Balance % Return The winnings divided by the total bet amount for the session P - that exact number of wins The probability of having x wins in y trials. Use a binomial distribution function Roulette 1o - FL ' DORU-1 B1A - I- - 60 . Name MN00 P- that many wins or less The probability of having xor fewer wins in y trials P-that many wins or more The probability of having xor more wins in y trials Captured Sessions Copy and then paste value the last 7 columns of the Summary Restuls for the winning scenarios of Oto 6 wins. Conditional Formatting Rules Trial Data - Winning: Red for and Green for 1 or greater ning bets Green for greater than Summary Results - of Lost Bets: Red for greater than 1 Summary Results - Winnings: Green for a positive number red for a negative num Summary Results summary of one session conting of a number of trials Total Winning Losing Ending Balance Winnings Return of wins initialbet Bet Type Payoll 1 P.that that that Random Your number of wine wins or wins or less Balance Winnings Return Roulottet File Edit View Insert Format Data Tools Add-ons Help Last edit was made 2 minutes ago by anonymous 1001 - 9 0 0 123 - Default (ca. 11 BISA B -FL - . .. . . ummary Results of Losing Bets: Red for greater than 1 Winnings: Green for a positive number, red for a negative number Total $ Bet Winning bets Losing b ets Ending Balance Winnings Random Your Ending Balance Winnings bets Retur What are the minimum wins you need to have a positive return? x Assignment SMc-Roulette ().xkx Open with B C D E F C K L M N O P Q R S T A Norra H Correct I J A Pusille ures 1 6 970 m2 OC TE 41 9122 Let's Play Roulette 28 0 11:30 PM (dminle gel 2 143 Cursos multimera matrik - Triin with a sita Icli witaratris tuwib up this uple rous capture the si Fouwla alavu.al v in UIN 100.tala Lilly Lub u rti uvid UX F9 10 acres You can also chang e cluditur r ruca Simu 100 tis. 19/35 23 36 24 3 153 Mall Four Filialbal . :11 . " IL 27/0011 13 18 31 193 Su Y. MIN B. SUMBILLUS TIIL 8 1229 25 plus.ba Ber: Cheng 1. Pourta nt . There a re 11 Jurr Pure SHU JURUL S O AL ULCIALI.. Choose a number c ond 32. Bercheorerunberforatra Thcolo. I o hali il b. Si The onlar wintires that ariser-hacedonthers h u l ning the help in hartian www. w 3. umbatwira TNT UESPILT-tharu. Dabar T LD rite balans - FIFA U-M IEL IN...rec. the bal van. U I . . x Assignment SMc-Roulette ().xbx Open with A B C D E F G H I J K L M N O P R S T 27 LIMI PASI 11:30 PM (4 minutes ago cal! aruan tilaa . Jos luul.. = Inthem llcpain th F, The Horare in the attesen The UTS B U WITHCS Tegin irgeline n batannarx en lainete Yence indicard Eids Writulu.cl bal .n.lar. in that corunibero Calubatilleri Meri The ability cancris irytal Datens C. der paste tactics. D'UIC Sri Pelus forth wiringsce orios volonirs. Jodora Boragile TWANGAWI are Varan sulten Alnate: Cornergrrthand Sarrarl ants: Freethin 1 Sarrib-Winn Gr i mrod krutte x Assignment SMc-Roulette ().xbx Open with A B C D E F H I J K L M N O P Q R S T | ENIMES 4 11:30 PM (5 minutes ago Willem II PUU. ea pasilicum? 3558333333333333333HHH : : 58983728258 : 299233 Roulette 1a Let's Play Roulette Polis Bi 4 Trial de 100 Ramush Your Nuwe i bon balance and Esting Boler Pwy wiener 1:38+ * Assignment SM C-R... ... The ------- is 14 DIE TO 11 I Let's Play Roulette 28 0 2 143 Instructions You are setting up a simulation of a roulette gambling game - the American version with 38 slots Follow the instructions below to set up the tables to play roulette and capture the results You will be playing multiple sessions of roulette with each session consisting of 100 trials A trial equals one spin of the roulette wheel. Use F9 to Refresh (You can also change an unused cell and hit enter) to generate a simulation of 100 trials. 35 23 4 16 33 2 Bet Parameters 27 6 18 31 Your initial bet Your first bet is for $1 Bet Type Single: You are betting on a particular single number Payoff for S1 bet 35 Bet Change "no". Your bet will consistantly be $1. It will not change. 1000% Let's Play Roulette 97 0) 97 6 Instructions You are setting up a simulation of a roulette gambling game - the American version with 38 slots Follow the instructions below to set up the tables to play roulette and capture the results You will be playing multiple sessions of roulette with each session consisting of 100 trials A trial equals one spin of the roulette wheel. Use F9 to Refresh (You can also change an unused cell and hit enter) to generate a simulation of 100 trials 2 14 352 35 23 4 16 33 2 Bet Parameters 16 33 21 6 Your initial bet Your first bet is for SI 618 31 19 5 Bet Type Single: You are betting on a particular single number Payoff for $1 bet 35 1918 12 Bet Change "no". Your bet will consistantly be $1. It will not change. 3 Trial Data Trial Trials are numbered from 1 to 100 Random Number Generate a random number from 1 to 38 (37 and 38 replace and 00) Use the Randbetween function Your Number Choose a number between 1 and 38. Bet the same number for each trial Bet The amount you bet on each trial which will be $1 Winnings The dollar winnings from that particular bet based on the probability of winning the bet. Use an If function. (if the bet wins, winnings.no winnings) A bet wins when your lucky number the roulette random number Current Balance Previous or initial balance plus winnings on a winning bet, else subtract the bet amount Use an If Function to determine if you had a winning bet 4 Key - Sumary Results You have $100 to bet with, however the casino will extend you credit if you Initial Balance need it. Key - Sumary Results You have $100 to bet with, however the casino will extend you credit if you Initial Balance need it # of Bets You will be betting 100 times Total S Bet The total amount bets for the session. Use the Sum function # of Winning Bets The number of winning bets placed in this session. Use a countif function Wof Losing Bets The number of losing bets in this session. The difference between the # of bets and the ff of winning bets Ending Balance Beginning Balance plus Winnings. bet amounts on losing hets. Winnings Difference between Initial Balance and Ending Balance % Return The winnings divided by the total bet amount for the session #of Losing Bets and the # of winning bets Ending Balance Beginning Balance plus Winnings - bet amounts on losing bets, Winnings Difference between Initial Balance and Ending Balance % Return The winnings divided by the total bet amount for the session P- that exact number of The probability of having x wins in y trials. Use a binomial distribution wins function P- that many wins or less The probability of having x or fewer wins in y trials P- that many wins or more The probability of having x or more wins in y trials 5 Captured Sessions Copy and then paste (value) the last 7 columns of the Summary Restuls for the winning scenarios of 0 to 6 wins. Conditional Formatting Rules Trial Data - Winnings: Red for and Green for 1 or greater 5 Captured Sessions Copy and then paste (value) the last 7 columns of the Summary Restuls for the winning scenarios of 0 to 6 wins. Conditional Formatting Rules Trial Data - Winnings: Red for 0 and Green for l or greater Summary Results of Winning Bets: Green for greater than 0 Summary Results of Losing Bets Red for greater than 1 Summary Results - Winnings: Cireen for a positive number, red for a negative number Bet Paramers Summary Results The summary of one session consisting of x number of trials of Losing Your initial bet Bet Type Bet Payor Bet Change Initial balance of Bets Total Be of Winning bets Ending winnings Reum bots Balance Trial Data Captured sessions Trial Random Bet number Winnings Current Balance of losind hats Winning bets Ending winnings Balance e) the last 7 columns of the Summary Restuls for the winning scenarios of 0 to 6 wins. miles ed for and Green for or greater inning Bets: Green for greater than 0 sing Bets: Red for greater than mgs: Green for a positive number, red for a negative number Summary Results The summary of one session consisting of x number of trials of W of Losind et Change Initial balance of Bets Total Bed Winning Ending Winnings Retum P- that P-that P-that exact b er of many wins many wins or less or more wins beis Balance bet Captured Sissions Be Winnings Balance of Winning bels of Losing Ending w bets Balance iness Return P that P-that P-that exact number or many wins many wins wins or more Bet Type Bet Payoff Bet Change bet # of Losing of Bets Initial balance Total S Bed Winning Ending Balance Winnings bets Trial Data Captured Sessions Current of losing Random Trial # Your number Bet Winnings Winning Ending winnings Balance bets Balance bets What are the minimum wins you need to have a posi Mof Winning score hets 0 0 1 0 2 0 0 0 0 0 0 0 Captured Sessions #of Winning Current Balance Ending winings of Losing bets % Return P- that P-that many wins many wins or less or more exact number of Balance bets 5 What are the mininum wins you need to have a positive retum? Nof Winning 0 0 0 0 5 What are the minimum wins you need to have a positive retum? of Winning 0 eole o --- 0 10 no Name . 00 123 Default (C. 11 BISA B E LI... fx . Name Possibl % Correct 1000% # Correct 0 Date Let's Play Roulette Instructions 1 You are setting up a simulation of a roulette gambling game the American version with 38 slots Follow the instructions below to set up the tables to play roulette and capture the results You will be playing multiple sessions of roulette with each session consisting of 100 trials A trial equals one spin of the roulette wheel. Use F9 to Refresh (You can also change an unused cell and hit enter) to generate a simulation of 100 trials. 3 23 4 16 332 Bet Parameters Your initial bet Your first bet is for $1 Bet Type Single: You are betting on a particular single number Payoff for $1 bet Bet Change "no" - Your bet will consistantly be $1. It will not change. + Roulette ta Bet Change "no" - Your bet will consistantly be $1. It will not change. 3 Trial Data Trial # Trials are numbered from 1 to 100 Generate a random number from 1 to 38 (37 and 38 replace 0 and 00) Use the Randbetween function Random Number Your Number Choose a number between 1 and 38. Bet the same number for each trial Bet The amount you bet on each trial which will be $1 The dollar winnings from that particular bet based on the probability of winning the bet. Use an If function (if the bet wins, winnings, no winnings) A bet wins when your lucky number = the roulette random number Winnings Previous or initial balance - plus winnings on a winning bet, else subtract the bet amount Use an If function to determine if you had a winning bet Current Balance 4 Key - Summary Results You have $100 to bet with, however the casino will extend you credit if you need it. Initial Balance Roulette is - T 150 - $ 125. Default (ca. 11 - B A . . . .. 60 YE. A Name fx E B 4 C D Key - Summary Results You have $100 to bet with, however the casino will extend you credit if you need it. Initial Balance # of Bets You will be betting 100 times Total $ Bet The total $ amount bets for the session. Use the Sum function The number of winning bets placed in this session. Use a countif function # of Winning Bets The number of losing bets in this session. The difference between the # of bets and the # of winning bets # of Losing Bets Ending Balance Beginning Balance plus Winnings. bet amounts on losing bets. Winnings Difference between Initial Balance and Ending Balance % Return The winnings divided by the total bet amount for the session P - that exact number of wins The probability of having x wins in y trials. Use a binomial distribution function Roulette 1o - FL ' DORU-1 B1A - I- - 60 . Name MN00 P- that many wins or less The probability of having xor fewer wins in y trials P-that many wins or more The probability of having xor more wins in y trials Captured Sessions Copy and then paste value the last 7 columns of the Summary Restuls for the winning scenarios of Oto 6 wins. Conditional Formatting Rules Trial Data - Winning: Red for and Green for 1 or greater ning bets Green for greater than Summary Results - of Lost Bets: Red for greater than 1 Summary Results - Winnings: Green for a positive number red for a negative num Summary Results summary of one session conting of a number of trials Total Winning Losing Ending Balance Winnings Return of wins initialbet Bet Type Payoll 1 P.that that that Random Your number of wine wins or wins or less Balance Winnings Return Roulottet File Edit View Insert Format Data Tools Add-ons Help Last edit was made 2 minutes ago by anonymous 1001 - 9 0 0 123 - Default (ca. 11 BISA B -FL - . .. . . ummary Results of Losing Bets: Red for greater than 1 Winnings: Green for a positive number, red for a negative number Total $ Bet Winning bets Losing b ets Ending Balance Winnings Random Your Ending Balance Winnings bets Retur What are the minimum wins you need to have a positive return