answersLogoWhite

0

You can use the slope function on excel which takes a cell range representing the Y-Variable and another cell range representing the X-Variables. For instance the Y-Variable may be a column of excess returns for a stock and the X-Variable maybe the column of risk premia.

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga

Add your answer:

Earn +20 pts
Q: How do you calculate Beta by using Variance and Covariance?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Statistics

How is beta determined for a stock?

You'll need a spreadsheet like Excel. Do the following. 1) Get percentage daily returns for the stock between two dates (I suggest every day for a year). You can get this historical data from Yahoo Finance 2) Pick a benchmark index 3) Get percentage daily returns for the index between the two dates as well 4) Calculate the covariance of the stock with respect to the index and divide by the variance of the stock [the two excel functions you'll need are covariance.p() and variance.p() ] Go to the related link below for a spreadsheet to do this.


How do you calculate beta in mutual funds?

Check out these websites: http://faculty.babson.edu/academic/Beta/CalculateBeta.htm http://www.money-zine.com/Investing/Stocks/Stock-Beta-and-Volatility/


The most commonly used greek letters in statistics?

I'll give you some common Greek symbols used in statistical analyses. I can't tell you which is the most common one given the enormous task of reviewing every statistics book. The Greek mu for mean, sigma for variance and rho for correlation are probably the first ones that one encounters in statistical analyses. Also, beta for beta distribution, gamma for gamma distribution, chi for chi-squared distribution. Alpha and beta are common as distribution parameters. In derivations, delta is common for differences of variables. Tau is common for a time variable. You will find more information in the related link.


What is the difference between Gamma and Beta burns?

"beta burns" are shallow surface burns


How do you convert a beta probability density function to a beta frequency distribution?

probability density distribution