Showing posts with label statistics. Show all posts
Showing posts with label statistics. Show all posts

Friday, May 9, 2025

Relative Risk (Risk Ratio) in Microsoft Excel, and Online calculator (Excel-based)

Relative Risk (Risk Ratio) B2 shows exposure and outcome, B2 shows exposure and outcome, B3 shows non-exposure and outc... B2 shows exposure and outcome,B3 shows non-exposure and outcome,C2 shows exposure and no outcome,C3 shows no exposure and no outcome Odds Ratio Relative Risk (Risk Ratio) Relative Risk (Risk Ratio) =(B2/B3)/(C2/C3) =(B2/(B2+C2))/(B3/(B3+C3)) =(B2/(B2+C2))/(B3/(B3+C3)) syntax syntax syntax The Odds Ratio is a measure of association between an exposure/treatment and an outcome. It tells us how much more likely (or less likely) the outcome is to occur in the exposed/treated group compared to the non-exposed/untreated group. It is a statistical measure used to compare the probability (... It is a statistical measure used to compare the probability (risk) of a certain event occurring in two groups. It is commonly used in medical and epidemiological research. illustration Patreon and LinkedIn links LinkedIn Profile /usmanzafarparacha /usmanzafarparacha /usmanzafarparacha LinkedIn Patreon profile /uzparacha /uzparacha /uzparacha Patreon Usman Zafar Paracha 1 Usman Zafar Paracha Usman Zafar Paracha example example example Suppose we have this data Suppose we have this data Suppose we have this data Then then then gives gives gives Since the OR is greater than 1, there is a positive association between exposure/treatment and the outcome. This means the exposed group has double the risk/chances of t... This means the exposed group has double the risk/chances of the outcome compared to the unexposed group. Excel example data Usman Zafar Paracha 2 Usman Zafar Paracha Usman Zafar Paracha Sheet.221 Sheet.222

Thursday, May 8, 2025

POISSON.DIST Function in Microsoft Excel, and Online calculator (Excel-based)

NORM.DIST Function x – The number of events. x – The number of events. mean – The expected number of event... x – The number of events.mean – The expected number of events (λ).cumulative – A logical value:TRUE gives the cumulative distribution function (CDF): P(X ≤ x).FALSE gives the probability mass function (PMF): P(X = x). POISSON.DIST Function POISSON.DIST Function POISSON.DIST Function =POISSON.DIST(x, mean, cumulative) =POISSON.DIST(x, mean, cumulative) =POISSON.DIST(x, mean, cumulative) syntax syntax syntax It calculates the Poisson probability of a given number of events occurring in a fixed interval of time or space, assuming these events happen with a known constant rate and independently of the time since the last event. It calculates the Poisson probability of a given number of ev... It calculates the Poisson probability of a given number of events occurring in a fixed interval of time or space, assuming these events happen with a known constant rate and independently of the time since the last event. gives gives gives illustration Patreon and LinkedIn links LinkedIn Profile /usmanzafarparacha /usmanzafarparacha /usmanzafarparacha LinkedIn Patreon profile /uzparacha /uzparacha /uzparacha Patreon Then then then Usman Zafar Paracha 1 Usman Zafar Paracha Usman Zafar Paracha example example example Usman Zafar Paracha 2 Usman Zafar Paracha Usman Zafar Paracha Suppose we have this data Suppose we have this data Suppose we have this data Excel example data Usman Zafar Paracha 2.995 Usman Zafar Paracha Usman Zafar Paracha Excel example formula Usman Zafar Paracha 4 Usman Zafar Paracha Usman Zafar Paracha Excel example answer