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.

Практическое интерактивное упражнение

Превратите теорию в практику с помощью одного из наших интерактивных упражнений

Начать упражнение