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 chart in the navigation bar. You can also use Insert -> Chart.
Select a line chart.
Specify D14:D215 as the Series option.
Include C14:C215 as the X-Axis option.

Практична інтерактивна вправа

Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ

Почати вправу