In this video, the presenter demonstrates how to calculate basic statistics using Python script in Power BI and create a dashboard from those statistics using Power BI visuals. The video starts with importing the Pandas library and reading data from an Excel file into a data frame. The presenter then calculates mean, mode, median, standard…
The video explains how to calculate basic statistics in Python. It covers the steps involved in importing libraries for statistical calculations, generating a list of random numbers, plotting the data on charts, calculating mean, median, mode, standard deviation, variance, covariance, correlation and linear regression. The results are displayed on the console window and bar chart….
Today we will calculate expected returns from historical data. We will calculate Mean historical return, Exponential Moving Average (EMA) historical return, and historical return using Capital Asset Pricing Model (CAPM). We will also calculate Variance, Standard Deviation and Correlation using Statistics library. #expectedreturn #stockmarket #exponentialmovingaverage #capm #variance #standarddeviation #correlation #pypfopt