Struggling to calculate weights
Hi I am new to statistics and have been reading this website on simple Logistic regression
Simple Logistic Regression
What I am struggling with is how it obtain the intercept and slope values which are -17.2086 and 0.5934
According to the site to calculate this is a simple weighted linear regression of the observed log odds on the independent variable X.
But I do not know how to calculate this
Here is the data
| X | Instances of Y | 0 | Total | Y as | Y as | Y as |
| Coded as | 0 | ii+iii | Observed | Odds | Log Odds |
| 28 | 4 | 2 | 6 | 0.3333 | 0.5 | -0.6931 |
| 29 | 3 | 2 | 5 | 0.4 | 0.6667 | -0.4055 |
| 30 | 2 | 7 | 9 | 0.7778 | 3.5 | 12528 |
| 31 | 2 | 7 | 9 | 0.7778 | 3.5 | 12528 |
| 32 | 4 | 16 | 20 | 0.8 | 4 | 1.3863 |
| 33 | 1 | 14 | 15 | 0.9333 | 14 | 2.6391 |
I am doing this by hand (well excel) and what I have been told so far it is multiplying the the number of each date points by its weight But I am struggling to do that.
Any help would be great.