answersLogoWhite

0

In statistics, R2 (R-squared) indicates how closely a group of graphed points follow a straight line. Points that are closer to each other and the more they form a straight line, indicate a stronger relationship between the data points.

Here is a method you can use to find R2 with Excel:

  1. List two columns of numbers (need to be the same number of data points in each list).
  2. Find a location on the worksheet to insert a chart.
  3. Select the chart wizard and choose the standard XY (Scatter) chart.
  4. Follow the procedures to create the chart.
  5. Add a trend line to the chart, following the procedures of modifying the chart.
  6. Read R2 from the chart.
User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

JudyJudy
Simplicity is my specialty.
Chat with Judy
RafaRafa
There's no fun in playing it safe. Why not try something a little unhinged?
Chat with Rafa
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin

Add your answer:

Earn +20 pts
Q: How can you find the R2 value of data on Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp