시작하기무료로 시작하기

Be fruitful and multiply

Now that you have multipliers, you can adjust your data. To do so, you'll multiply your original risk by the random number you created, and then add that total to your original risk. Keep in mind that you want to remove negative numbers so that you don't skew estimates of risk.

As a reminder, the MAX() function returns the highest value in a set of values (such as a range or array). You can use this to set a minimum value to your calculation.

For example, MAX(0, (-2*1)) will return 0, whereas MAX(0, (2*1)) will return 2.

이 연습은 강의의 일부입니다

Google Sheets로 배우는 오류와 불확실성

강의 보기

연습 안내

  • In cells I2:I10, calculate the new risk value as described above.
    • Make sure to remove negative risk estimates by using the MAX() function and comparing your calculation to 0.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작