Can you perform logistic regression with Excel? If so, how?

Answer 1

First you take the log of the column that has large values.

The you do linear regression on those two variables.

As an example,

Suppose it is x = [-10.10] and y is in millions

In that case, you take log(y) and do the

linear regression of x vs. log(y)

Your linear equation is then log(y) = Mx + B

Then it follows that y = exp(Mx+B)

is the exponential model

Answer 2

Yes, but it is not nearly as straightforward as in designated statistical software. It requires you to do all the math yourself leveraging what functions in Excel you can. So, it's sort of like a hybrid version of doing it 'long hand' on paper -- but you could make it generalizable for future use and save the spreadsheet.

Here's a blog entry that could get you started:

https://blog.learningtree.com/how-to-apply-logistic-regression-using-excel/