Forum Discussion
vamihe30
Sep 25, 2020Copper Contributor
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_EekelenPlatinum 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.
- Erica_RobersonCopper Contributor
- Bethann0622Copper 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