Graph the stock distribution
You want to visualize the most likely price of a stock, and you will graph the distribution of the expected stock prices.
You previously created columns for price and probability of that price so you can create a probability density graph - the prices graphed against their likelihoods.
Using the graphing options for sheets, show that the distribution of the graph is log normal.
この演習はコースの一部です
Google Sheetsで学ぶファイナンシャル・モデリング
演習の手順
- Click on
insert chartin the navigation bar. You can also useInsert->Chart. - Select a line chart.
- Specify
D14:D215as theSeriesoption. - Include
C14:C215as theX-Axisoption.
