Excel formula for Logistic Regression

[Luci]

Hello,

I need some help finding a formula to calculate the values from Table 3 (Lgt Exptds), details about the dataset are below.

- I have the main table (Table 1 - Actuals) which represents the values of 5 Brands for 3 different Brand Images.
- Table 2 (Logit) was calculated from Table 1 using the formula =LN(C4/100/(1-C4/100))
- Table 3 (Lgt Exptds), for this one I would highly appreciate any help I can receive, I need a formula to obtain the values displayed in the table (I assume that is calculated based on Table 2)
- Table 4 (Expecteds) is calculated based on Table 3, using the formula =100*EXP(K16)/(1+EXP(K16))
- Table 5 (Profiles) is calculated based on Table 1 and Table 4 using the formula =C4-C21

Note. The formulas in the examples are used for Image 1, Brand A.

Is there a formula I can use to obtain the values from Table 3 (replicate) from Table 2 or Table 1?
Thank you in advance for your help.

Best regards,
Luci

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel formula to replicate results
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.