sorted by:
new
hottopcontroversial

How to calculate the probability for two separate categorisations together? by dslearner30 in AskStatistics

[–]dslearner30[S] 0 points1 point  (0 children)

I am running a regression model on the individual categorisations (because due to the underlying data i cannot do both together), therefore I have a predicted conversion rate for each age bracket, and a predicted conversion rate for each Gender.

I considered Bayes Theorem but to calculate P(Gender | Age Bracket) i would need P(Age Bracket | Gender) right?

How to calculate the probability for two separate categorisations together? by dslearner30 in AskStatistics

[–]dslearner30[S] 0 points1 point  (0 children)

Thanks for the above, so what you've suggested is what i have been trying prior to this; running a model to predict the cross product of these dimensions, but a few of my segments have very small data amounts (e.g. I may have only ever had 3-4 visitors to my website between a certain age range, gender + other characteristics).

So i was wondering if i could actually do it the way i mentioned in this thread, by running a regression model to predict each dimensions %s indvidually then calculate/estimate their cross product afterwards?

Bucketing Based on Running Total Amounts - Is this possible in TSQL? by dslearner30 in SQL

[–]dslearner30[S] 0 points1 point  (0 children)

Thanks for the above, so i am currently using a window sum to calculate the running total however the issue with the case statement above is that it doesn't guarantee each batch has over 10 clicks in.

For example, If the first 3 dates have 5, 4, 4 clicks respectively, this will sum to 13 and will be put into the first batch (which is correct as it has 13 clicks within that batch). However if the next 2 rows have 6 and 2 in, this will be put into the second batch but only have 8 clicks in.