“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to have R-squared value displayed on a graph yet there doesn't appear to be such an option.

Solved by M. A. in 25 mins

I need to find the fit line equation for a graph. I was able to get the r squared value but I need the actual equation to finish my lab

Solved by I. H. in 24 mins

Hi, Trying to make a graph and am having difficulty. I need the x axis to be column O and the Y axis to be column G. it should form a linear line. I am trying to calculate R squared. Looking for agreement between the two values.

Solved by G. J. in 27 mins

I have a formula that is finding rank even when filtered. Now I need to turn that rank into a percentage, 1-100, even when filter also. The formula for the rank is =SUM(IF(SUBTOTAL(103,OFFSET($R$2:$R$1022,ROW($R$2:$R$1022)-ROW($R$2),0,1))>0,IF(R2>$R$2:$R$1022,1)))+1

Solved by E. J. in 24 mins

A sleep study was done to see how sleep deprivation would affect reaction time (in milliseconds). Provide multivariate statistics (correlation and r-squared) about the sleep study and the best chart to show a relationship between reaction time and days of deprivation to include a trend line. All the data should be in one chart.

Solved by B. J. in 14 mins