 # Get instant live expert help on I need help with r multivariate regression “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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
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
I need to do multivariate measures of data to build a chart using correlational relationships
Solved by A. Q. in 16 mins
I need to lock a table reference in an index, match function. E.g. =INDEX(RC[-8]:RC[-5],MATCH(RC[-8],RC[-8]:RC[-8],0)+0,4) I do not want to change RC[-8]:RC[-5] or RC[-8]:RC[-8] when I drag the formula down
Solved by X. H. in 23 mins