Question: In Excel Function formatting Betting Assignment Write an IF statement with the description here The random # you roll is the number you pick you

In Excel Function formatting Betting Assignment

Write an IF statement with the description here

2 Bet Parameters Your initial $ bet Bet amount Bet Type Payoff Single 1 Number 35 Bet Initial Change balance # of Bets Total

3 Trial Data Trial # Trials are numbered from 1 to 100: (Use Fill, columns, linear, 1, 100) Generate a random number from 1 t

The random # you roll is the number you pick you win. Winnings formula in Excel would be something like =IF(C73=D73,$D$69,0)

If the random number = your number then the bet payoff is 35 and true or false resulting in you winning or losing the bet.

We are trying to create an excel formula that can display the current balance.

Next is creating binomial distribution functions in Excel

P- that exact number of wins Use a binomial distribution function: The probability of having x wins in y trials with P probab  
 

2 Bet Parameters Your initial $ bet amount 1 Bet Bet Initial Bet Type Payoff Change balance # of Bets $100 Single Number 35 no 100 Total $ Bet $100

Step by Step Solution

★★★★★

3.41 Rating (145 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Hello Student I ho... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Write an if statement that tests to see whether a String begins with a capital letter.

Q:

Write an if statement that uses the turtle graphics library to determine whether the turtle is inside of the rectangle. The rectangles upper left corner is at (100, 100) and its lower-right corner is...

Q:

(a) Write an if statement that increases pay by 3% if score is greater than 90. (b) Write an if statement that increases pay by 3% if score is greater than 90, otherwise increases pay by 1%.

Q:

1. Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center's classes....

Q:

This case is designed like the ones in the chapter. Your assignment is to write the audit approach portion of the case organized around these sections: Objective. Express the objective in terms of...

Q:

In the arithmetic of real numbers, there is a real number, namely 0, called the identity of addition because a + 0 = 0 + a = a for every real number a. This may be expressed in symbolic form by z a...

Q:

Suppose that you have used the parks-McClellan algorithm to design a causal FIR linear-phase system. The system function of this system is denoted H(z). The length of the impulse response is 25...

Q:

The following audit procedures are concerned with tests of details of general cash balances: 1. Obtain a standard bank confirmation from each bank with which the client does business. 2. Compare the...

Q:

Tuesday afternoon finds Anna and Chip having their weekly analysis and design review session. Chip waves toward a large stack of documents that are neatly organized on a large table. I cant believe...

Q:

The following is ABC, Inc.s, balance sheet (in thousands): Also, sales equal $ 500, cost of goods sold equals $ 360, interest payments equal $ 62, taxes equal $ 56, and net income equals $ 22. The...

Q:

c + + help without using the algorthim header ( #include ) .

Q:

Assignment question Sam owns a gift shop which sells a range of gifts, cards and jewellery. Sam prides himself on only sourcing and selling handmade items from independent crafts people. He decides...

Q:

A company pays an annual insurance premium. On 1 September 20X7 it paid $6,000 for the 12 months ended 31 August 20X8. On 1 September 20X8 it paid $7,200 for the 12 months ended 31 August 20X9. 1)...

Q:

Make an argument as to why Arnold Schwarzenegger's character in the movie would have a good argument for Fraudulent Misrepresentation. TITLE OF VIDEO: Mexican Turbo Man - Jingle All the Way (FIRST...

Q:

Based on the information given in the figure, determine the necessary power input to the compressor (Win). Yout=26 kJ/kg P = 600 kPa T2=600 K Air m = 0.02 kg/s P = 100 kPa T = 480 K Win = ?

Q:

Read the article, "This Map Shows the Scale of the 16th- and 17th-Century Scottish Witch Trials" located in the module resources. When reviewing this article, you may consult the map or the text. As...

Q:

POSSIBLE POINTS: 1 0 x Y Z Inc. is a manufacturing company that produces widgets. At the end of the fiscal year, XYZ Inc. has an inventory of 1 , 0 0 0 widgets. The company uses the FIFO inventory...

Q:

Can partitioned join be used for r r.A s? Explain your answer

Q:

Write a user-defined function that fits data points to a power function of the form y = bxm. Name the function [b, m] = powerfit (x,y), where the input arguments x and y are vectors with the...

Q:

The variation of gravitational acceleration g with altitude y is given by g = R2/(R + y)2 g0 where R = 6371 km is the radius of the earth, and g0 = 9.81 m/s2 is the gravitational acceleration at sea...

Q:

The fuel consumption of an airplane is measured in gal/mi (gallon per mile) or in L/km (liter per kilometers). Write a MATLAB user-defined function that converts fuel efficiency consumption from...

Q:

In the structure of the neuron, the ________ receives messages from other cells. a. myelin b. axon c. soma d. dendrite

Q:

Which of the following insulates and protects a neurons axon and helps speed along electrical impulses? a. myelin sheath b. synaptic knobs c. receptor sites d. neuromodulators

Q:

Which neurotransmitter stimulates skeletal muscle cells to contract but slows contractions in the heart? a. GABA b. acetylcholine (ACh) c. serotonin (5-HT) d. endorphin