I was composing a long reply in the original thread and it got somewhat unwieldy, so let’s move things over here:Q. Is there any way to see how the regression c… ...

VIDEO: It's easy to run a regression in Excel and you only need to understand a few data points to make sense of the results.

Financial modeling, much like coding, involves numerous interconnected spreadsheet tabs, complex logical structures built through Excel formulas and links.

Regression models using fractional polynomials of the covariates have appeared in the literature in an ad hoc fashion over a long period; we provide a unified description and a degree of formalization ...