Question: 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
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 sandwichedby 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 interpretationof probability.
3. Use excel function ln() to calculate ln(67).
Show your results and excel formulas involved.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
