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

RafaRafa
There's no fun in playing it safe. Why not try something a little unhinged?
Chat with Rafa
CoachCoach
Success isn't just about winning—it's about vision, patience, and playing the long game.
Chat with Coach
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi

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