Computers and Technology

Computers and Technology, 15.11.2019 04:31, jj1077348

What value would excel return for this formula =(82-32)/5+8*2

answer

Answers: 1

Show answers

Similar questions

Предмет

Business, 22.06.2019 17:30, chilanka

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding

Answers: 2

Предмет

Mathematics, 24.06.2019 09:40, jadecharis5339

The historic returns on a balanced portfolio follow a normal distribution and have had an average return of 8% and a standard deviation of 13%. you will need excel for some of these questions. round all answers to at least 2 decimal places 1. if you see a return of 23%, what is the z-score of this value? 2. using excel, find the probability of seeing a return greater than 23%. 3. are you more likely to see a return less than -10.2% or greater than 30.1%? greater than 30.1% less than -10.2% 4. using excel, find the z-score that corresponds with the 20th percentile. z= 5. using the above, what is the 20th percentile for returns? % 6. the middle 60% of returns fall between what two numbers? % and % (write the smaller number first)

Answers: 2

Предмет

Mathematics, 24.06.2019 16:10, tyheath42

The analytical portion of the case assignment should be completed in the excel template which can be found in canvas. 1. plot in excel the risky asset opportunity set for portfolios a & b. to do this you will need to create the following table in excel assuming weights of portfolio a & b in 10 percentage point increments. then calculate expected return; standard deviation; and sharpe ratio for each allocation to a & b. your table in the excel file should look like the one below. weight port a weight port b return standard deviation sharpe ratio 0% 100% 10 90 20 80 30 70 40 60 50 50 60 40 70 30 80 20 90 10 100 0 determine the optimal allocation of a & b and draw in the capital allocation line (cal). the approximate optimal allocation can be determined using a table like the one shown above. or you can obtain a more precise optimal allocation using the formula shown in chapter 7 (equation 7.13). some students have used excel’s solver function to find the optimal risky portfolio – that is also acceptable. when drawing the cal on the efficient frontier graph plotted in excel, you can manually draw a line starting at the risk free rate to the tangent point.

Answers: 1

Предмет

Mathematics, 30.06.2019 21:30, leannamat2106

This is suppose to be a mathematical function i need to enter into excel. "enter a formula in cell b10 to return a value of 35000 if the net profit after tax (cell b9) is greater than or equal to 470000 or 1000 if it is not." how do i type this out in excel using the if function ?

Answers: 1

Do you know the correct answer?

What value would excel return for this formula =(82-32)/5+8*2...

Questions in other subjects:

Konu

World Languages, 03.02.2021 14:00

Help me please, . ...

Konu

Chemistry, 03.02.2021 14:00

Help me with this for a cookie ...

Konu

Physics, 03.02.2021 14:00

4. A pan of water is heated from 23°C to 78°C. What is the change in its temperature on the Kelvin and Fahrenheit scales?...

Konu

History, 03.02.2021 14:00

Plz answer ASAP I will give quickest and best answer brainliest

Konu

Physics, 03.02.2021 14:00

In solving a physics problem, why is it important to create pictorial and physical models before trying to solve an equation?...

Konu

Mathematics, 03.02.2021 14:00

Colin was thinking of a number. Colin subtracts 5 from it and gets an answer of 10.7. What was the original number?...

Konu

Mathematics, 03.02.2021 14:00

Please help me with this ...

Konu

Mathematics, 03.02.2021 14:00

Q2. * There are only black balls and white balls in bag A and in bag B, as shown in the diagram. B Heidi is going to take at random a ball from bag A and a ball from b...

Konu

Mathematics, 03.02.2021 14:00

The diagram shows a shaded parallelogram drawn inside a rectangle. 3 cm b) А c) 6 cm d) B +3 cm -12 cm a) What is the area of...

Konu

Mathematics, 03.02.2021 14:00

IF YOUR USERNAME IS RARE COMMENT UNDER THIS POST...

Other tasks in the category: Computers and Technology More task