1. Use excel function exp( ) to calculate raising e to the power of (-2.5 +...

1. Use excel function exp( ) to calculate raising e to the power of (-2.5 + 2*X1 + 3*X2), where X1=5.6 and X2=3.

2. Denote the result from part 1 as Y, calculate the Y/(1+Y), and let us denote this ratio as prob, i.e., prob= Y/(1+Y). Demonstrate the quantity is sandwiched by this interval (0, 1) by trying different values of X1 and X2. Also realize the any quantity that is capped between 0 and 1 can lend itself to the interpretation of probability.

3. Use excel function ln() to calculate ln(67).

Solutions

Expert Solution

Answers are given as excel screenshot with an explanation.

milcah answered 9 months ago

Next > < Previous

Related Solutions

The firm’s revenue function is R=250q-8q2 , cost function is C=10q+12q2. 1. Use Excel to calculate...

The firm’s revenue function is R=250q-8q2 , cost function is C=10q+12q2. 1. Use Excel to calculate the firm’s revenue, cost, and profit for q = 1 to q = 20 in increments of 1.Using Excel’s Charting tool, draw the graph of the profit curve and determine the profit maximizing level of output. 2. Based on these calculations, what output must you choose? Create columns in spreadsheet for MR and MC and verify that MR = MC at the profit-maximizing output...

remember and use <E>=?EiPiand Pi=1/Z ?exp(-?Ei) and Z=?exp(-?Ei) with ?=1/kT. (a) show that-dZ/d? = ?Eiexp(-?Ei) and...

remember and use <E>=?EiPiand Pi=1/Z ?exp(-?Ei) and Z=?exp(-?Ei) with ?=1/kT. (a) show that-dZ/d? = ?Eiexp(-?Ei) and (b) that the average energy can be derived directly from Z like <E>=-1/ZdZ/d? (c) show further that this simple expression is also correct <E> =-dlnZ/ d?

How to use the COUNTIFS Function in Excel. Need to calculate the number of days. Independent...

How to use the COUNTIFS Function in Excel. Need to calculate the number of days. Independent Challenge 4. #g page 127 Microsoft Excel 2016 Comprehensive

Build a program to calculate the value of e ( 2.71828) raised to the power of...

Build a program to calculate the value of e ( 2.71828) raised to the power of x (the independent variable). The function is based on the series expansion shown in class. Compare your result to the predefined function exp(x) as stated in the standard file ( cmath ). Your input will be " x" and "n" where n is the number of terms in the expansion and x is an arbitrary value of your choice. Have your output display your...

A green laser operates at 488.0 nm with an output power of 2.5 mW. Calculate the average...

A green laser operates at 488.0 nm with an output power of 2.5 mW. Calculate the average output in photons/s (“photon flux”). What would the output power be for the same flux of 244.0 nm photons? What would the photon flux be for a 488.0 nm laser operating at 5.0 mW?

1.)is the function f (x) = x exp^ (-x ^ 2/2) a proper function of the...

1.)is the function f (x) = x exp^ (-x ^ 2/2) a proper function of the operator O= d2 / dx2-x2? if so, what is the intrinsic value? 2.)is the function f (x) = exp^ (4ix) -exp ^(-4ix) its own function of the operator d2 / dx2? if so, what is the intrinsic value? 3.)is the function f (x) = exp^ (2ix) -exp ^(-2ix) a proper function of the operator d^2 / dx^2? if so, what is the intrinsic value?...

Use Excel to generate a column of x values from 0 to 2.5 in steps of...

Use Excel to generate a column of x values from 0 to 2.5 in steps of 0.05 (that means your column must have numbers like 0, 0.05, 0.1, 0.15, . . . , 2.5). Plot the PDF f(x) on your computer screen for the different values of x mentioned above for the following distributions. (a) Uniform (use A = 0 and B = 2.5) (b) Exponential (use mean = 2) (c) Gamma (use parameters 1.7 and 1.2) (d) Normal (use...

using R :- A Gumbel random variable X has distribution function FX (x) = exp (−e^−x)....

using R :- A Gumbel random variable X has distribution function FX (x) = exp (−e^−x). a) Give a graph of FX and explain using this plot why FX is a valid cumulative probability distri- bution function. (b) Find the values of the first and third quartiles and median X and show their values on the graph. (c) Make a table of x and FX (x) for x equal to the integers from −2 to 5. (d) Find the probabilities...

A) Write a macro function in excel to calculate the Future value for a series of...

A) Write a macro function in excel to calculate the Future value for a series of cash flows. B. Write a macro function to estimate the cost of equity using the: (i) Capital Asset Pricing Model (CAPM) Ri = rf + Ba (rm-rf) where: rf = the rate of return on risk-free securities (typically Treasuries) Ba = the beta of the investment in question rm = the market's overall expected rate of return (ii) Fama-French Model Ri = rf +...

Please use IRAC 1. In 2013, Bakersfield PG&E decided to demolish their old power plant. PG&E...

Please use IRAC 1. In 2013, Bakersfield PG&E decided to demolish their old power plant. PG&E hired Lincoln-Based Alpha Explosives, a well known demolition company with years of experience using high grade dynamite. The goal for the demolition was to destroy the old power plant with an internal explosion. Alpha Explosives was so certain in the process that they invited the public to watch. The week before the demolition date, Alpha Explosives sent dynamite experts to strategically place dynamite around...

Subjects