{"id":138,"date":"2022-01-17T22:22:35","date_gmt":"2022-01-17T22:22:35","guid":{"rendered":"http:\/\/navigatingstem.com\/?p=138"},"modified":"2023-05-07T17:36:58","modified_gmt":"2023-05-07T17:36:58","slug":"excel-basics-for-chemistry-and-biology-plotting-a-graph-then-calculating-slope-and-line","status":"publish","type":"post","link":"https:\/\/navigatingstem.com\/index.php\/2022\/01\/17\/excel-basics-for-chemistry-and-biology-plotting-a-graph-then-calculating-slope-and-line\/","title":{"rendered":"Excel Basics for Chemistry and Biology: Graphing, Line and Slope."},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Lines graphically illustrate linear functions, which are stated in slope-intercept form as:<\/p>\n\n\n\n

y=mx+b<\/p>\n\n\n\n

To calculate the line and slope for our data in excel we need to first make a plot. <\/p>\n\n\n\n

We are going to use example data that is plant height in centimeters for each day in a week. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We have our data entered into excel in columns. In Column A we have “Days” which will be our x-axis in the plot. In Column B we have “Plant Height (cm)”, this will be our y-axis in the plot.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To create a plot, we first need to select the data to be in the plot.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To create the plot, we need to navigate to “Insert” shown at the top. In this menu, there will be multiple chart types you can choose from. We will be using a Scatter plot for this tutorial (shown highlighted in the above image). <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After selecting the Scatter plot, we will see our data plotted in a graph. You can change the title by selecting the text and typing an appropriate title. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Next, we will add a trendline for our data. You will click on one of the data points and three options will appear to the right. The trendline option will appear when the “+” image is selected. Check the “Trendline” option to add a trendline that fits the data plotted. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After plotting the trendline, we would like to determine the line equation and R-squared. By clicking the black triangle, you will be given a drop down menu. Clicking “more options” will bring up a menu to the right of the screen.<\/p>\n\n\n\n

\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

This menu will appear after selecting “More options.” To show the equation and R-squared value, check the two boxes for “Display Equation on chart” and “Display R-squared value on chart.”<\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now the equation will be shown on your chart in the form of y=mx+b. In this case, our slope is 0.0896 and our R-squared value is 0.9837.<\/p>\n","protected":false},"excerpt":{"rendered":"

Lines graphically illustrate linear functions, which are stated in slope-intercept form as: y=mx+b To calculate the line and slope for our data in excel…<\/p>\n","protected":false},"author":2,"featured_media":162,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_rtcl_gb_attr":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/navigatingstem.com\/wp-content\/uploads\/2022\/01\/Excel-Basics-for-Chemistry-and-Biology-Classes-2.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/posts\/138"}],"collection":[{"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/comments?post=138"}],"version-history":[{"count":8,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/posts\/138\/revisions"}],"predecessor-version":[{"id":163,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/posts\/138\/revisions\/163"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/media\/162"}],"wp:attachment":[{"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/categories?post=138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/navigatingstem.com\/index.php\/wp-json\/wp\/v2\/tags?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}