Uncertainty charted
To really understand the power of the random volatility estimates, you can create a graph of the certain versus simulated stock prices.
The data will be simulated based on a random normal distribution, so your chart will change every time you edit a cell.
Bu egzersiz, kursun bir parçasıdır
Google Sheets ile Finansal Modelleme
Egzersiz talimatları
- Highlight the data for Stock Price and Certainty in Columns
B:C. - Click on
insert chartin the navigation bar; you can also useInsert->Chart. - Select a line chart.
Uygulamalı etkileşimli egzersiz
Teoriyi etkileşime dönüştürün, interaktif egzersizlerimizden biriyle
Egzersize başla