Forum Discussion

vamihe30's avatar
vamihe30
Copper Contributor
Sep 25, 2020

I need help with adding trendline and finding the r squared value

For my biology class, I had to conduct an experiment and put down all my information on excel. I had to put in all the data and create a scatter plot, after i did that I had to add a trendline and then find the r squared value. I don't know if I'm doing it wrong or something is wrong with my version of excel, but I desperately need help.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    vamihe30 Add a trend line by selecting any data point. On the "Chart design" ribbon, look for the button shown (Add chart element) in the picture below to add the trend line.

    Once you have added the trend line, click on it and a "Format Trendline" window will appear. Select "display R-squared value on chart" at the bottom. 

      • Bethann0622's avatar
        Bethann0622
        Copper Contributor

        HI my name is Beth Lindsay and I am having the same problem you are having with a trendline my excel does not give me the version he showed either I have no add button on the rt of my chart so how the heck are we supposed to do our projects for Math I need a trendline for my scatter boxErica_Roberson 

Resources