{"id":5614,"date":"2023-02-26T21:22:17","date_gmt":"2023-02-26T21:22:17","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/covariance-and-correlation-homework\/"},"modified":"2023-02-26T21:22:17","modified_gmt":"2023-02-26T21:22:17","slug":"covariance-and-correlation-homework","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/covariance-and-correlation-homework\/","title":{"rendered":"Covariance and Correlation Homework"},"content":{"rendered":"<div class=\"col-sm-12 messageContent\">\n <b>Learning Goal: <\/b>I&#8217;m working on a finance exercise and need the explanation and answer to help me learn.<\/p>\n<p>Use the attached template to develop a spreadsheet model that can calculate the covariance and correlation of any two samples with n&lt;=10. The first sheet, &#8220;Template&#8221;, is laid out and it will be your guide while developing the spreadsheet model, while the second sheet, &#8220;Test Data&#8221;, has three example data sets that you can use while testing your model. Your model is considered complete and working if I can copy and paste data sets into the model you&#8217;ve developed on the Template worksheet, and your model will calculate the correct Covariance and Correlation Coefficient. Again, the data I have provided on the Test Data worksheet is for your testing purposes, so to help you I&#8217;ve provided the correct Covariance and Correlation for each test set, but I will be using different test sets than these when I evaluate your model!<\/p>\n<p>To be clear, I want you to develop a spreadsheet model that reflects what you would do by hand if I made you solve the problems by hand, paper-and-pencil style, so you should build out the formulas the long way as I did in the example, not using the =Covariance.S and =Correl functions. Also, to prevent you from cheating and just typing in the answers somewhere, I&#8217;ll be using different test sets when I evaluate your spreadsheet than the ones I gave you to test it. So, the grading of your model will be simple: if your spreadsheet avoids shortcuts like =Correl and calculates the correct values for the data I put in, you get full credit! As before, I&#8217;ve provided the rubric below for additional details.<\/p>\n<p>WARNING: you MUST use Microsoft Excel specifically; if you use Numbers (the Mac equivalent) for example, I won&#8217;t be able to open the file. If you don&#8217;t have Microsoft Office, it can be downloaded for free at <a rel=\"noopener\" href=\"https:\/\/www.microsoft.com\/en-us\/education\/products\/office\" target=\"_blank\">this website<\/a>.<\/p>\n<p>Follow All the Directions Correctly and exactly as it says.<\/p>\n<p>Please Do Good and Correctly &#8211; IF DONE CORRECTLY , THERE IS BIG TIP !!!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learning Goal: I&#8217;m working on a finance exercise and need the explanation and answer to help me learn. Use the attached template to develop a spreadsheet model that can calculate the covariance and correlation of any two samples with n&lt;=10. The first sheet, &#8220;Template&#8221;, is laid out and it will be your guide while developing [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[676],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/5614"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=5614"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/5614\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=5614"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=5614"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=5614"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=5614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}