Interview Question: Logit in Excel

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?]

Advertisements
This entry was posted in Sample Qs and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s