How to Calculate Correlation Coefficients - a step-by-step example O Click to start. Then click on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
How to Calculate Correlation Coefficients - a step-by-step example O Click to start. Then click on each step below to calculate the correlation coefficient The following columns show the return on IBM and GE in a recent 12-month period: 1 IBM 2 GE Return, % Return, % Month 1 2.79 -9.40 2 -1.57 -3.89 3 6.47 5.31 4 -2.02 -4.84 5 8.85 -0.22 6 -3.09 -4.44 7 5.31 3.74 8 -5.84 0.44 9 0.69 -4.81 10 -5.67 -5.79 11 -0.77 -0.24 12 1.90 -0.34 Total 7.05 -24.49 Average 0.59 -2.04 O Step 1 Step 2 Step 3 O Step 4 Calculate the average monthly return of each stock For each stock calculate the deviations from the average return Square these deviations Calculate the average squared deviation (the variance). Take the square root of the variance. This is the standard deviation of returns (o). Step 5 Step 6 Multiply together the deviations from the average return in columns 3 and 4. Step 7 Average these products. This is the covariance (cov) between IBM and GE returns (OIBM.GE) Step 8 Divide the covariance by each of the two standard deviations. This is the correlation between IBM and GM returns. The formula for the correlation coefficient between IBM and GE is OIBM.GE/(OIBM X OGE) How to Calculate Correlation Coefficients - a step-by-step example O Click to start. Then click on each step below to calculate the correlation coefficient The following columns show the return on IBM and GE in a recent 12-month period: 1 IBM 2 GE Return, % Return, % Month 1 2.79 -9.40 2 -1.57 -3.89 3 6.47 5.31 4 -2.02 -4.84 5 8.85 -0.22 6 -3.09 -4.44 7 5.31 3.74 8 -5.84 0.44 9 0.69 -4.81 10 -5.67 -5.79 11 -0.77 -0.24 12 1.90 -0.34 Total 7.05 -24.49 Average 0.59 -2.04 O Step 1 Step 2 Step 3 O Step 4 Calculate the average monthly return of each stock For each stock calculate the deviations from the average return Square these deviations Calculate the average squared deviation (the variance). Take the square root of the variance. This is the standard deviation of returns (o). Step 5 Step 6 Multiply together the deviations from the average return in columns 3 and 4. Step 7 Average these products. This is the covariance (cov) between IBM and GE returns (OIBM.GE) Step 8 Divide the covariance by each of the two standard deviations. This is the correlation between IBM and GM returns. The formula for the correlation coefficient between IBM and GE is OIBM.GE/(OIBM X OGE)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Adele released her third album, 25 , in late 2015, quickly shattering several records. The album 25 was the first album to sell more than three million copies in a week and also racked up the most...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
Judy Baker is a new employee of Farnsdel and Babcock, LLP. Which of the following will provide proof of employment authorization for the completion of the I-9? 1. U.S. passport 2. U.S. military...
-
In order to see the effects of inflation, fill out the following spreadsheet given that the compound annual average rate of Inflation has been 3 percent. Annual Inflation Rate 3% Cumulative Inflation...
-
In the accompanying figure, the X and Y coordinates (in meters) of station A are 5084.274 and 8579.124, respectively, and those of station B are 6012.870 and 6589.315, respectively. Angle BAP was...
-
Assume that Exxon Mobile uses a standard cost system for each of its refineries. For the Houston refinery, the monthly fixed overhead budget is \($8,000,000\) for a planned output of 5,000,000...
-
The CFO of Sterling Chemical is interested in evaluating the cost of equity capital for his firm. However, Sterling uses very little debt in its capital structure (the firms debt-to-equity...
-
Determine whether the given experiment results in a binomial experiment. If not, give the reason why not. Rolling a single die 34 times, keeping track of the number of 3s that are rolled O Not...
-
Friault LAVINY Fortes Inc. has provided the following data concerning one of the products in its standard cost system. Variable manufacturing overhead is applied to products on the basis of direct...
-
Schuster is currently considering investing in "Machine A" that will enable greater manufacturing efficiency. The machine is expected to have a useful life of 10 years, a salvage value of $5,000, and...
-
Ka Co. has pre-tax accounting income of $300,000, including $12,000 paid for nondeductible officers' life insurance premiums where the company is the beneficiary. The effective tax rate for the...
-
Discuss in detail how you plan to continue to grow and develop before finishing the AAS in Hotel Management and once you have a full-time job in your prospective career field. Cite sources and...
-
The general and special revenue funds are used to account for resources that are not legally restricted and budgetary accounts are used to monitor the government's financial activities against its...
-
CEF, Inc. is an American company that executed a contract for the purchases copper rods from Forty-Three, Inc., a Chinese company that manufactures copper products. Forty-Three has breached the...
-
Please answer the two parts, using case laws, relevant legislations using international torts and in depth secondary research PART A: suggest a case note on Reeves v New South Wales [2023] NSWDC 196...
-
In Exercises 15 through 30, find the derivative dy/dx. In some of these problems, you may need to use implicit differentiation or logarithmic differentiation. y ex + et -2x 1 + e
-
You receive an offer for a new credit card offering an introductory APR of 8.5 percent per year. What is the corresponding EAR? a. 8.24% b. 8.50% c. 8.84% d. 8.97%
-
Campagna Company expects to have a cash balance of \($46,000\) on January 1, 2002. Relevant monthly budget data for the first 2 months of 2002 are as follows. Collections from customers: January...
-
You have just bought a new condo for $125,000. If you financed 100 percent of the purchase price via a 30-year, 7.75 percent APR loan from your bank, what will be the total amount of interest paid...
Study smarter with the SolutionInn App