Sample Question #323 (Excel)
We’re interested in implementing a logit model, but we only want to implement it in Excel using only its built-in tools. [That is, we’re not buying third-party add-ins for this.] Describe to me in general terms how you would proceed. Name a couple of built-in Excel functions that you’ll be using.
[Hint: Even though this question is framed in the context of Excel, it’s really a statistics question. How would you estimate the coefficients in a logit (or probit, for that matter) model by hand?]