Need VBA Questions done
- or -
Post a project like this2328
$$
- Posted:
- Proposals: 2
- Remote
- #1800003
- Awarded
Description
Experience Level: Intermediate
Industry: Business
Description of excel work: Hi there, I have an urgent yet very short assignment due based on VBA. Please let me know if you’ll be able to do this within 12 hours after the posting time.
Question:
The coffee shop is giving away a prize by selling coffee cups with a letter placed under each cup’s rim. To win the prize, you must collect cups with letters that spell the name, DORTATH (assuming you were not previously aware of this name). In production, letters are randomly selected and placed under the rims of the cups. Create a program that does the following:
(a) Animates the selection of cup letters. Keeps selecting coffee cups until all seven of the necessary letters have been collected and displays the number of cups purchased in order to win the prize. (Letters should be randomly and independently selected from the alphabet when inserted under the rims of the coffee cups.)
(b) Performs this simulation several times (without the animation) to determine, on the average, how many coffee cups need to be bought in order to win the prize. Your program should prompt the user to provide the number of simulation runs required.
(c) How much would the prize need to be worth in order to play the game without losing money on all the cups of coffee purchased? (Assume that each coffee costs $1.00.) Note: You can determine this via the coding from (b) and then have your program write the result on your spreadsheet.
Extra notes:
Description of excel work: Hi there, I have an urgent yet very short assignment due based on VBA. Please let me know if you’ll be able to do this within 12 hours after the posting time.
Question:
The coffee shop is giving away a prize by selling coffee cups with a letter placed under each cup’s rim. To win the prize, you must collect cups with letters that spell the name, DORTATH (assuming you were not previously aware of this name). In production, letters are randomly selected and placed under the rims of the cups. Create a program that does the following:
(a) Animates the selection of cup letters. Keeps selecting coffee cups until all seven of the necessary letters have been collected and displays the number of cups purchased in order to win the prize. (Letters should be randomly and independently selected from the alphabet when inserted under the rims of the coffee cups.)
(b) Performs this simulation several times (without the animation) to determine, on the average, how many coffee cups need to be bought in order to win the prize. Your program should prompt the user to provide the number of simulation runs required.
(c) How much would the prize need to be worth in order to play the game without losing money on all the cups of coffee purchased? (Assume that each coffee costs $1.00.) Note: You can determine this via the coding from (b) and then have your program write the result on your spreadsheet.
Extra notes:
Jie Z.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
24 Nov 2017
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
What do you mean for animation ? How do you want the data to be displayed ?
544661
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies