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

Im trying to find formulas that calculate the values for slope, intercept, and r^2 for a log regression (the values from the log regression formula in the chart view).

Solved by O. J. in 29 mins

A criminologist is interested in the effects of unemployment and policing on murder and has run the following multiple regression: Summary Output Regression Statistics Multiple R 0.90303 R Square 0.815462 Adjusted R Square 0.762737 Standard Error 5.11041 Observations 10 Coefficients Standard Error t Statistic P-value Intercept 23.26309588 7.075518018 3.28783 0.013342 Unemployment rate 10.27754326 2.172859937 4.729961 0.002133 Police per 100,000 0.046737101 0.023409765 1.99648 0.086065

Solved by Z. S. in 16 mins

I need to lock a table reference in an index, match function. E.g. =INDEX(R[241]C[-8]:R[377]C[-5],MATCH(RC[-8],R[241]C[-8]:R[377]C[-8],0)+0,4) I do not want to change R[241]C[-8]:R[377]C[-5] or R[241]C[-8]:R[377]C[-8] when I drag the formula down

Solved by X. H. in 23 mins

Type in the R square of my model ( Hint: R square after first iteration) ?

Solved by A. L. in 20 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