Question: create a correlation matrix using the result from (1) from M1- FFR and (2) from YOY M1- YOU GR FFR YOY GR CanCredit YOY GR

create a correlation matrix using the result from (1) from M1- FFR and (2) from YOY M1- YOU GR FFR

YOY GR CanCredit YOY GR FFR 0 O 320 Date 2002-01 01 2003 01.01 2004 01.01 2005-01-01 2006-01-01 2007-01-01 2002-01-01 2009-01-01 2010-01-01 2011-01-01 2012.0101 2013-0141 2014.01.01 2015-01-01 20160101 2017-01-01 2018-01-01 2019-01-01 2020-01 01 Sum Average 0 0 0 0 MI 11966 12738 13433 13720 13751 1345 14334 167.1 17400 20064 2016 25494 2160 30303 3245.9 35215 36543 35442 128545 526053 23 M2 59922 59813 6363 65306 70 72939 7788 84162 16242 92474 10006 1092 13 130415 128563 13500-4 141197 SP 500 (Index) CPI (Index 1982-1984-108) Comedit Federal Funds Rate YOY GR MI YOY GR M2 YOY S&P 500 YOY GR CPI 0 179 167 1926.79774 0 184 20339631 1.13 6.450197996 6.961462064 2.297808937 0 188.900 2137.35305 5.471915744 4.719551952 2667391304 0 195.267 224007646 2.1213613364259305255 33661183) 0 20135 2408 45172 40 0228754689 3,197072245 0 3.221742537 0 207144 2531 5141 503 00459468456170305677 o 270637732 215.254 265144347 4313369229 6.774153745 0 3X14916274 214.565 259545272 010 142243067) 065255738 0 -0.3200W 218076 2537 19367 0.10 6.300478192 247147415 0 141633978 324.921 27023179 01 15 25080723 7226177501 0 3.119711103 12004 2395 2017 56001 0.14 11.47162354 49470774 0 13935 2073153934 232.992 3000738 011 100413000 6.79741215 9457401651466117273 164 236.15 3310 10376111 4154219 191720738 1615354236 10313 237002 34434031 7.331690357 5.945844711 1740163903 0.121242445 2051 OT 240.005 35163509 0.30 7.472892443 6.765865654 6.714878 1267077915 2014 245,136 3719.94016 N49072645 5.710040992 1.629250626 2.137872121 24490 251 102 390252149 4432236934 3.194660937 1692072661 2433751051 2746 21 235653 409507231 210 4352526566 5.109881938 12.13211091 11241019) 291336 25844 4158.440 0. 234.J45426 19.05304153 6.086570219 1.248176239 184703 4216757 55629.0792 25.95 356.8169405 119.695963 19.5812939 36.5692024 0726 2210 19.5 66 5561941338 S033074134 $ 2271806 7016253528 5.1096340 4.737427586 211170231 2.21760125 647N763155 04675634 606993171 610218) 6032267776 3.29326128 5.78978393 4908179322 4.93401103 15480435 19.20572898 4.4 32.73809524 19.46902655 137.7777778 54.51710196 141290323 6143141153 -91.75257732 125 4444444444 40 2142857143 1818181818 4444444444 200 156 4103564 83 18.03278689 -8333333333 4143 16 1895992 99145 YOY GR CanCredit YOY GR FFR 0 O 320 Date 2002-01 01 2003 01.01 2004 01.01 2005-01-01 2006-01-01 2007-01-01 2002-01-01 2009-01-01 2010-01-01 2011-01-01 2012.0101 2013-0141 2014.01.01 2015-01-01 20160101 2017-01-01 2018-01-01 2019-01-01 2020-01 01 Sum Average 0 0 0 0 MI 11966 12738 13433 13720 13751 1345 14334 167.1 17400 20064 2016 25494 2160 30303 3245.9 35215 36543 35442 128545 526053 23 M2 59922 59813 6363 65306 70 72939 7788 84162 16242 92474 10006 1092 13 130415 128563 13500-4 141197 SP 500 (Index) CPI (Index 1982-1984-108) Comedit Federal Funds Rate YOY GR MI YOY GR M2 YOY S&P 500 YOY GR CPI 0 179 167 1926.79774 0 184 20339631 1.13 6.450197996 6.961462064 2.297808937 0 188.900 2137.35305 5.471915744 4.719551952 2667391304 0 195.267 224007646 2.1213613364259305255 33661183) 0 20135 2408 45172 40 0228754689 3,197072245 0 3.221742537 0 207144 2531 5141 503 00459468456170305677 o 270637732 215.254 265144347 4313369229 6.774153745 0 3X14916274 214.565 259545272 010 142243067) 065255738 0 -0.3200W 218076 2537 19367 0.10 6.300478192 247147415 0 141633978 324.921 27023179 01 15 25080723 7226177501 0 3.119711103 12004 2395 2017 56001 0.14 11.47162354 49470774 0 13935 2073153934 232.992 3000738 011 100413000 6.79741215 9457401651466117273 164 236.15 3310 10376111 4154219 191720738 1615354236 10313 237002 34434031 7.331690357 5.945844711 1740163903 0.121242445 2051 OT 240.005 35163509 0.30 7.472892443 6.765865654 6.714878 1267077915 2014 245,136 3719.94016 N49072645 5.710040992 1.629250626 2.137872121 24490 251 102 390252149 4432236934 3.194660937 1692072661 2433751051 2746 21 235653 409507231 210 4352526566 5.109881938 12.13211091 11241019) 291336 25844 4158.440 0. 234.J45426 19.05304153 6.086570219 1.248176239 184703 4216757 55629.0792 25.95 356.8169405 119.695963 19.5812939 36.5692024 0726 2210 19.5 66 5561941338 S033074134 $ 2271806 7016253528 5.1096340 4.737427586 211170231 2.21760125 647N763155 04675634 606993171 610218) 6032267776 3.29326128 5.78978393 4908179322 4.93401103 15480435 19.20572898 4.4 32.73809524 19.46902655 137.7777778 54.51710196 141290323 6143141153 -91.75257732 125 4444444444 40 2142857143 1818181818 4444444444 200 156 4103564 83 18.03278689 -8333333333 4143 16 1895992 99145

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Week Six - Correlations Exercises Correlations are used to describe the strength and direction of a relationship between two variables. A correlation between two variables is known as a bivariate...

I need help with these questions on Week 6 Correlations exercise. PART 1 1.What is the strongest correlation in the matrix? (Provide correlation value and names of variables) 2.What is the weakest...

Week 6 - Correlations SPSS Outputs Descriptive Statistics Mean Number of doctor visits, past Std. Deviation N 6.80 12.720 997 29.2226 7.37893 970 45.11422 10.840059 893 46.82843 10.806477 893 12 mo...

CIS 2640 ASSIGNMENT 3 Check the due date on e-learning Introduction Download hr1.xlsx. This is a human resources data set that we will used for the next sections. Data cleansing a. Remove all rows...

Correlations are used to describe the strength and direction of a relationship between two variables. A correlation between two variables is known as a bivariate correlation. In this module the...

As mentioned dataset contains information about customers' purchasing behaviors. Let us assume we have the following data: Calculate Basic Statistics: In Excel, use functions like AVERAGE, MEDIAN,...

Assignment 4 following questions: last_evaluation number_project Introduction average_montly_hours Download hr1.xisx. This is a human resources data set that we will used for the next sections....

Need help on this Introduction Download hr1.xlsx. This is a human resources data set that we will used for the next sections. Data cleansing 1. Load the above data using Power Query. Do the following...

Data Analysis 1 . Create a correlation matrix using the following columns in a worksheet called Correlation Matrix. Insert 3 blank lines at the beginning of the worksheet and answer the questions...

1. Create a hypothetical portfolio invested equally in five stocks from the following industries: Consumer Staples, Technology, Financial, Energy, and Retail (You may select any companies that you...

XYZ Co has two investments X and Y. Investment X has an initial capital outlay of $150 million, and the investment is expected to generate $380 million in ten years. Investment Y has an initial...

Which of the following is a reason to obtain professional certification? a. Certification provides credibility that an individual is technically competent. b. Certification often is a necessary...

The average accounting return method Multiple Choice is preferred by financial analysts over the alternative methods. ignores the timing of net income. ignores some project years

True or False? 1. Depreciation is a means of cost allocation, not a matter of valuation. [Select] 2. When an improvement to a piece of equipment extends the equipment's useful life without increasing...