{"id":4406,"date":"2023-02-23T06:14:56","date_gmt":"2023-02-23T06:14:56","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/relationships-between-variables\/"},"modified":"2023-02-23T06:14:56","modified_gmt":"2023-02-23T06:14:56","slug":"relationships-between-variables","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/relationships-between-variables\/","title":{"rendered":"Relationships Between Variables"},"content":{"rendered":"<div class=\"col-sm-12 messageContent\">\n <b>Learning Goal: <\/b>I&#8217;m working on a statistics spreadsheet and need the explanation and answer to help me learn.<\/p>\n<ol>\n<li>Open the Heart Rate Data Set in Excel and identify the X-variable (resting heart rates for all 200 participants) and the Y-variable (after-exercise heart rates for all 200 participants).<\/li>\n<li>Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables.<\/li>\n<li>Add a trendline to the scatter plot.<\/li>\n<li>Use the Data Analysis tools in Excel to find the regression equation.<\/li>\n<li>In a Word document, describe the relationship between the X-variable (resting heart rate)and the Y-variable (after exercise heart rate).\n<ul>\n<li>Graph the scatter plot with a trend line. Does it appear there is a linear relationship? What does this mean?<\/li>\n<li>Calculate the correlation coefficient r using excel. Is this r (value) high compared to +1? Based on the correlation coefficient is the relationship strong?<\/li>\n<li>Use excel to find the regression equation. Identify the slope. What does it tell us in terms of our heart rate data?<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learning Goal: I&#8217;m working on a statistics spreadsheet and need the explanation and answer to help me learn. Open the Heart Rate Data Set in Excel and identify the X-variable (resting heart rates for all 200 participants) and the Y-variable (after-exercise heart rates for all 200 participants). Use the Scatter Plot function in the Insert [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[658],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/4406"}],"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=4406"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/4406\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=4406"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=4406"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=4406"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=4406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}