{"id":36058,"date":"2025-01-25T10:01:12","date_gmt":"2025-01-25T10:01:12","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/using-the-below-dataset-calculate-in-excel-r2-and-p-value-to-determine-the-power-of-association-and-if-your-calculations-are-statistically-significant\/"},"modified":"2025-01-25T10:01:12","modified_gmt":"2025-01-25T10:01:12","slug":"using-the-below-dataset-calculate-in-excel-r2-and-p-value-to-determine-the-power-of-association-and-if-your-calculations-are-statistically-significant","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/using-the-below-dataset-calculate-in-excel-r2-and-p-value-to-determine-the-power-of-association-and-if-your-calculations-are-statistically-significant\/","title":{"rendered":"Using the below dataset calculate in Excel; R2 and p-value to determine the power of association and if your calculations are statistically significant."},"content":{"rendered":"<p>Using the below dataset calculate in Excel; R2 and p-value to determine the power of association and if your calculations are statistically significant.<\/p>\n<p>V1 (Input Y Range) (Dependent Variable)<\/p>\n<p>V2 (Input X Range) (Independent Variable)<\/p>\n<p>12<\/p>\n<p>45<\/p>\n<p>15<\/p>\n<p>54<\/p>\n<p>17<\/p>\n<p>61<\/p>\n<p>13<\/p>\n<p>51<\/p>\n<p>18<\/p>\n<p>70<\/p>\n<p>20<\/p>\n<p>73<\/p>\n<p>22<\/p>\n<p>71<\/p>\n<p>18<\/p>\n<p>66<\/p>\n<p>25<\/p>\n<p>106<\/p>\n<p><em>Hint:<\/em> Excel Data Analysis; Regression.&nbsp;<\/p>\n<p><strong>Submission Instructions:<\/strong><\/p>\n<ul>\n<li>Submit your assignment by 11:59 pm ET on Sunday.<\/li>\n<li>It should include at least 2 academic sources, formatted and cited in APA.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Using the below dataset calculate in Excel; R2 and p-value to determine the power of association and if your calculations are statistically significant. V1 (Input Y Range) (Dependent Variable) V2 (Input X Range) (Independent Variable) 12 45 15 54 17 61 13 51 18 70 20 73 22 71 18 66 25 106 Hint: Excel [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[533],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/36058"}],"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=36058"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/36058\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=36058"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=36058"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=36058"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=36058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}