Descriptive Analytics
Descriptive Analytics
Here are some notes on quasi-advanced visual Descriptive Analytics and how to draw Distribution graphs in Excel.
Yes, a picture speaks a thousand words. But still, sometimes helps to explain with a few.
Version: Feb. 2021
by Olivia, 2020
Part 1:1 - Visualization of Distribution in Excel
The monthly stock yield data that is used in the illustration. In the Excel file the data for 2020 is also included. In addition, Apple has also been added, however, the dividend that Apple paid out has NOT been included in the yield calculations.