View Single Post
  #2   Report Post  
Mike Middleton
 
Posts: n/a
Default

saita -

Use the RSQ worksheet function.

R^2 is usually called "coefficient of determination" in statistics. It's the
proportion of variation in Y that is explained by X in the model. I have
never heard it described as the "probability of approximation."

- Mike
www.mikemiddleton.com

"saita" wrote in message
...
I have a trendline on the chart and Value of probability of approximation
(R^2) correspondent to this trendline. How can I return this value in a sell
as number? I appreciate your help.