# Category: tutorials

• ## How to calculate Jensen’s alpha in Excel

The purpose of this tutorial is to teach you to calculate Jensen’s alpha in Excel. We’ll estimate the Jensen’s alpha on Amazon (AMZN) shares using the S&P500 as the market benchmark and the 13-week T-bill as the proxy of risk-free asset. Our analysis will be based on five years of monthly data (i.e., 60 observations…

• ## How to calculate portfolio risk and return in Excel

In this tutorial, we’ll teach you how to calculate portfolio risk and return in Excel. We’ll focus on an example where we construct a portfolio of the following three stocks: Tesla (TSLA), Amazon (AMZN), and Netflix (NFLX). If you’re unfamiliar with the formulas for portfolio return and portfolio risk, we’d recommend you check the following…

• ## How to calculate beta in Excel

In this tutorial, we’ll show you how to calculate beta in Excel. First, we explain the data you need before getting started. Then, we offer four different ways of computing betas in Excel (the first one is the fastest if you’re in a rush!). If you prefer a video tutorial, that is provided at the…

• ## Descriptive statistics for stock returns

Descriptive statistics offer a simple way of understanding distributions of stock returns. They give us an idea about a distribution’s centrality, dispersion, symmetry, and other features. In this tutorial, we will show you how to generate descriptive statistics for stock returns using Excel’s data analysis tool. Using Excel to get descriptive statistics for stock returns…

• ## Creating a histogram of stock returns with Excel

An easy way to visualize the distribution of stock returns is to plot a histogram. In this tutorial, we will teach you how to create histograms of stock returns using Excel and explain how to interpret them. Using Excel’s “data analysis” tool to plot a histogram We’ll be working with the monthly returns of two…