Among the variables that appear in the results sheet (left),
depending on your experiment the most important result is
the R square value, highlighted at left in the pink cell. You
then report the R
2
value in your text when you describe
your statistical results. If you include a figure showing your
regression analysis, you should also include this value in the
figure. Steps for doing this appear below.
You can also see the p-value (in red box) indicating whether
or not the test is statistically significant (i.e. if p < 0.05). In
this example, the p-value is 0.00018.
Create your regression curve by making a scatter plot. Add the regression line by choosing the “Layout” tab in the “Chart
Tools” menu. Then select “Trendline” and choose the “Linear Trendline” option, and the line will appear as shown
above. To add the line equation and the R
2
value to your figure, under the “Trendline” menu select “More Trendline
Options” to see the “Format Trendline” window shown below. Select the boxes next to “Display equation on chart” and
“Display R-squared value on chart” and you are all set. (Note that you do not need to go through the “Data Analysis”
steps above to calculate your R
2
value if you use this method – Excel will do that automatically).