0
$\begingroup$

I have 4 covariates - $A$, $B$, $C$ and $D$. Three of them ($A$, $B$, $C$) independently show strong correlation with the forth one ($D$). I can create a chart in Excel for each pair ($A$-$D$, $B$-$D$, $C$-$D$), add a trend line, and get an equation for the trend line. In my case all of them show quadratic trends with the fourth covariate $D$.

I would like to create an equation using the three covariates ($A$,$B$,$C$) to predict the forth one ($D$).

$\endgroup$
0
$\begingroup$

As @whuber said, you need a cookie-cutter linear regression (you can add polynomial so without problem). You can use excel to accomplish it, but it is better to use a statistical package (R, STATA, SPSS etc..) each of these packages have easy tools for importing the data from excel as a .xls or .csv in a fairly straightforward format. After which you get a fairly easily interpretable output.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.