The article explains why increasing PostgreSQL's work_mem does not guarantee per‑query memory limits, how multiple sort/hash nodes, parallel workers and long‑lived memory contexts can cause OOM even on a 2 TB server, and offers concrete diagnostics and mitigation strategies for DBAs and developers.
The article explores David Spiegelhalter's book on uncertainty, explaining how probability reflects personal ignorance, detailing Bayesian versus frequentist views, and illustrating real-world applications such as COVID risk communication, sports luck, and investment performance.
This article provides a comprehensive guide to gray releases and A/B testing, covering common scenarios, implementation methods, layered experiment design, hash-based bucket allocation, data collection workflows, statistical analysis, and practical Java and SQL code examples for reliable feature validation.
From Python 3.9 to 3.12 the standard library adds a suite of ready‑to‑use functions—such as str.removeprefix/removesuffix, math.dist, math.comb, zoneinfo, hashlib.blake2b, and tomllib—that eliminate repetitive code, boost performance, and let developers focus on core logic.
Judea Pearl’s Ladder of Causation framework divides reasoning into three levels—association, intervention, and counterfactuals—explaining how conditional probability, the do‑operator, and structural causal models enable moving from mere data correlation to actionable causal insights, with practical criteria like back‑door and front‑door adjustments.
This article applies mathematical modeling—including logistic regression, dynamic programming, game theory, survival analysis, and network theory—to quantify promotion dynamics in Chinese workplaces, revealing age constraints, sector‑specific weight differences, and optimal investment strategies across career stages.
This article explains why the median is a crucial statistic for interpreting massive job‑application data, defines the median concept, introduces the classic LeetCode "Data Stream Median" problem, and shows how to maintain a dynamic median efficiently using a max‑heap and a min‑heap.
After a normal DDL change on OneDBA, the table size grew by nearly 100 % and some queries became slow because InnoDB’s B+Tree page‑splitting logic mishandles rows larger than 8 KB, causing each page to hold only one record and corrupting statistics.
This article explains the core ideas, mathematical steps, geometric intuition, and practical differences between Principal Component Analysis and Factor Analysis, guiding readers on when to apply each technique for dimensionality reduction and latent structure discovery in high‑dimensional data.
This article explores ten fundamental mathematical inequalities—AM‑GM, Jensen, Bernoulli, Chebyshev, Markov, Cauchy‑Schwarz, Triangle, Mean‑Inequality Chain, Information, and Hoeffding—explaining their formal statements and illustrating how each offers practical insights for personal growth, risk management, and decision‑making.
This article uses ten vivid everyday metaphors—from a stretched rubber band to a domino chain—to illuminate the core ideas behind various mathematical models, helping readers intuitively grasp abstract concepts across fields such as statistics, optimization, and system dynamics.
This comprehensive guide introduces twenty essential advanced statistical methods—from Bayesian inference and maximum likelihood estimation to copulas and generalized additive models—explaining their concepts, real‑world use cases, and providing concise Python code examples so data scientists can confidently apply them to complex analytical problems.
The article explores real‑world industrial cases—from steel furnace timing and historic lithography to modern manufacturing—showing how continuous improvement, root‑cause analysis, and careful handling of correlation versus causation can reveal hidden inefficiencies, while highlighting the limits of traditional statistics and the emerging role of AI in industrial data analytics.
Using everyday scenarios—a random student who solved a tough math question and a rare‑disease test result—the article demonstrates how Bayes’ theorem updates prior probabilities with new evidence, revealing that intuitive guesses often misjudge the true likelihood of being a top performer or having a condition.
Research by aviation writer David Nolan shows rear‑seat passengers have higher crash survival rates, and the article explains how frequency distribution tables, probability calculations, and hypothesis testing can be used to analyze such data, illustrating core statistical concepts with real‑world aviation examples.
This article explores how mathematical and statistical thinking differ in their starting points, research objects, problem formulation, reasoning methods, and attitudes toward uncertainty, highlighting that mathematics emphasizes formal deduction while statistics focuses on probabilistic inference and decision‑making under uncertainty.
An analysis of PHP version adoption from January 2024 to June 2025 shows declining shares for older releases, a rapid rise of 8.3, and reveals that many popular packages still require outdated versions, highlighting security and tooling challenges for the PHP ecosystem.
This article explores why outliers destabilize online A/B tests, explains their statistical definitions, compares trimming and winsorizing techniques, reviews classic and machine‑learning detection methods, and offers practical guidance for applying these approaches to improve experiment reliability.
This whitepaper introduces the importance of data‑driven A/B testing, outlines its theoretical foundations, practical challenges such as small samples and spillover effects, and presents a structured roadmap—including experiment basics, statistical principles, advanced designs, and SDK implementation—to help practitioners design trustworthy experiments.
This article introduces Python's Matplotlib and Seaborn libraries for data visualization, covering basic and advanced statistical charts, common plot types, customization techniques, and multi‑plot layouts with clear code examples and a comparative summary of each library's strengths.
This article explains the differences between manual statistics collection methods in OceanBase 3.x and 4.x, compares DBMS_STATS and ANALYZE commands across MySQL and Oracle modes, provides version‑specific tables, detailed code examples for table, partition, and schema level collection, and shows how to verify statistics.
This article models the chance of finding a job that simultaneously offers a high salary, light workload, and proximity to one’s hometown, using conditional probability and real‑world data to show why such an ideal position is extremely rare and how relaxing requirements dramatically improves the odds.
This comprehensive guide explains the fundamentals of statistics—including data types, collection, descriptive analysis, visualization tools, measures of central tendency and dispersion, correlation techniques, and regression modeling—providing practical insights for data scientists and engineers seeking to extract meaningful insights from data.
This article explains the concept of median, demonstrates how to calculate it in PHP with a step‑by‑step guide, and provides a complete code example that handles both odd and even sized data sets.
The Texas Sharpshooter Fallacy—selectively highlighting data that supports a claim while ignoring contradictory evidence—appears in sports highlights, tech marketing, startup storytelling, and even medical research, and the article explains its mechanics and offers practical steps to avoid being misled.
This article introduces Redis bitmap operations, explains key commands such as BITSET, BITGET, and BITCOUNT, and demonstrates with PHP code how to implement an efficient user sign‑in tracking and counting system using bitmaps for accurate statistics.
This guide outlines the essential foundations for becoming a data science professional, debunking common myths, highlighting three core skill areas—mathematics, machine learning, and programming—and detailing key concepts such as linear algebra, probability, calculus, and essential Python libraries.
Despite long‑standing rumors that PHP is obsolete, recent data shows the official PHP Docker image has been pulled over one billion times, highlighting the language’s continued dominance in web development, with 79% of server‑side sites still powered by PHP and platforms like WordPress serving billions of pages.
The article reviews common AB‑testing interview questions for data‑science candidates, explaining the role of p‑values, Type I/II errors, the difference between statistical and business significance, why effects can vanish when scaling, and how to improve experiment sensitivity through larger samples, variance‑reduction methods, and careful metric design.
The Beta distribution is a flexible probability model defined on the interval [0,1] with two shape parameters that control its form, offering useful properties such as mean and variance, and is widely applied in A/B testing, risk assessment, and machine‑learning tasks to model proportions and uncertainties.
This article explains Redis bitmap data structures, introduces the main bitmap commands (BITSET, BITGET, BITCOUNT), and provides a complete PHP example that demonstrates how to record user sign‑ins and count them efficiently using Redis bit operations.
The article describes a kernel‑level hot‑key detection module for Redis that tracks per‑second access counts via an O(1) LRU queue, flags keys exceeding configurable thresholds, and provides real‑time subscription alerts and queryable logs, overcoming the latency and overhead limitations of existing detection methods.
This article provides a comprehensive overview of 20 essential Pandas data processing methods with detailed code examples covering statistics, data cleaning, transformation, filtering, merging, grouping, sorting, reshaping, aggregation, window functions, time series analysis, conditional selection, indexing, slicing, visualization, type conversion, data filling, filtering, renaming, and import/export operations.
This article presents thirty essential Python techniques for rapid statistical analysis, covering calculations such as mean, median, mode, variance, moving average, correlation, and more, each accompanied by complete code snippets and sample outputs to help readers apply these methods directly.
This guide compares the strengths and weaknesses of common data analysis tools—from basic spreadsheet software and multi‑dimensional tables to professional statistical packages, BI platforms, and programming languages like R and Python—helping readers select the most suitable solution for their needs.
This article explores how the mathematical concept of expectation helps us understand and manage everyday hopes, assess risk, and make more rational decisions by balancing optimism with realistic assessments of uncertainty and variability.
This tutorial explains ten crucial visualizations for linear regression—scatter plot, trend line, residual plot, normal probability plot, learning curve, bias‑variance tradeoff, residuals vs fitted, partial regression, leverage, and Cook's distance—each illustrated with clear Python code using scikit‑learn, matplotlib, seaborn, and statsmodels.
Statistics, the science of extracting information from data, underpins everything from medical diagnoses and scientific experiments to e‑commerce recommendations and market research, yet its misuse—confusing correlation with causation or suffering from sample bias—highlights the need for basic statistical literacy in daily life.
This article explores how everyday decisions—from buying breakfast to quitting a job—are built on hidden assumptions and shows how statistical hypothesis testing and Bayesian thinking can help you identify, test, and adjust those assumptions for better outcomes.
This article explores the charm of statistics by explaining skewness with clear diagrams, sharing memorable mnemonics, reviewing a top‑rated textbook, presenting diverse real‑world case studies, and solving probability problems about adult male hip widths using normal distribution and the central limit theorem.
This tutorial presents a detailed overview of over fifty core NumPy functions, covering array creation, reshaping, arithmetic, statistical analysis, set operations, splitting, stacking, printing, and data persistence, with clear explanations and complete code examples for each operation.
Using a real‑world example of office conditions, this article explains the concept of mediation effects, outlines the three‑step regression method, and demonstrates Sobel and Bootstrap tests to determine whether workplace environment influences employee performance through job satisfaction.
Statistics permeate daily life, from news to personal decisions, yet common pitfalls like misleading averages, ambiguous percentages, and false causal links often trick us, so understanding these traps helps us interpret data more accurately and avoid faulty judgments.
This article explains Redis bitmap data structures, introduces common bitmap commands such as BITSET, BITGET, and BITCOUNT, and provides a complete PHP example that records user sign‑ins and calculates daily sign‑in counts using Redis bit operations.
This article demonstrates how to create a Python program that simulates the Chinese card game Zha Jin Hua, covering deck preparation, player handling, card dealing, hand evaluation, scoring rules, and statistical analysis of game outcomes, with complete source code and example results.
This talk explains how combining heavy randomization with regression adjustment can effectively mitigate AA problems in A/B testing, improving experiment credibility by addressing covariate imbalance and enhancing result validity for data‑driven decision making.
This presentation introduces the AA problem that can compromise A/B test validity and explains how combining re‑randomization with regression adjustment provides an effective, practical solution to improve experiment reliability and credibility.
The DataFun Data Science Summit on May 25 will feature Tencent data scientist Li Yilin presenting a comprehensive talk on pairwise‑data A/B experiments, covering unbiased estimation under various randomizations, theoretical analysis, and practical insights for causal inference in network‑driven online experiments.
The DataFun Data Science Summit on May 25 will feature Tencent data scientist Li Yilin presenting a comprehensive overview of paired‑data A/B experiments, covering causal inference challenges, unbiased estimators under various randomization designs, theoretical analysis, and practical insights for network‑based online experiments.
Bootstrap, a versatile resampling technique, repeatedly draws samples with replacement from existing data to estimate statistics like means and confidence intervals, offering flexible, distribution-agnostic insights across fields—from education and economics to ecology and finance—illustrated with Python code examples.
This article clarifies the difference between mediation and moderation effects, explaining how each variable relationship works, illustrating with practical examples, and showing why mastering these statistical tools is essential for interpreting and designing empirical research.
This article explains the fundamentals of several common probability distributions—including uniform, normal, log‑normal, Poisson, exponential, binomial, Student's t, and chi‑squared—and provides complete Python code to generate and plot each distribution for data‑science and machine‑learning applications.
This guide recommends a four‑book sequence—SQL Data Analysis, Python Data Analysis, Python Report Automation, and Python Statistical Analysis—to help aspiring data analysts build essential SQL skills, master Python data manipulation, automate reporting, and grasp the theoretical foundations of statistics.
This article explains the concept and calculation of odds ratios, interprets their values, and illustrates their use with examples from epidemiology and marketing, while also discussing their limitations and proper interpretation.
This article explains the concept of mediation effects, outlines how to select mediators, describes step‑by‑step testing procedures—including the classic Baron‑Kenny approach and modern bootstrap methods—and demonstrates the whole workflow with a real‑world economic example.
This tutorial walks through essential seaborn techniques for visualizing data distributions—including univariate histograms, conditional histograms, KDE curves, ECDFs, boxplots, violin plots, bivariate histograms, and joint plots—providing code snippets, parameter explanations, and practical examples using the penguins dataset.
This article introduces ten common statistical techniques used in data analysis—including descriptive statistics, correlation, t‑test, ANOVA, linear regression, PCA, outlier detection, frequency distribution, time‑series analysis, and non‑parametric tests—providing concise explanations and Python code snippets for each method.
Determining the right sample size is crucial for reliable survey results, and this article explains the key factors—population size, confidence level, margin of error, response rate, and effect size—while walking through a concrete example of calculating the needed respondents for a university library service study.
Randomized Controlled Trials (RCTs) are considered the gold standard for establishing causal relationships because randomization balances known and unknown confounders, control groups provide clear comparisons, and reproducibility ensures reliable results, though practical limitations like cost and ethics often require alternative observational methods.
Simpson’s Paradox shows how aggregated data can suggest one trend while each subgroup reveals the opposite, illustrated with hospital survival rates where overall A appears better than B, yet detailed analysis by severity flips the conclusion, highlighting the need to consider background variables in statistical interpretation.
This article explores the distinction between causal reasoning and conspiracy thinking, the challenges of defining causality, and how Judea Pearl's causal graph framework provides a powerful tool for AI, epidemiology, and other fields to visualize and analyze complex cause‑effect relationships.
This article explains the statistical foundations of AB experiments—hypothesis testing and minimum sample size calculation—showing how to determine whether observed differences are real, how to control type‑I and type‑II errors, and how to plan experiments with sufficient power.
This article explains how the update_time column in the information_schema.tables view is populated, why its values can be unreliable, and details the mechanisms of active and passive persistence of table statistics in MySQL 8.0, including source‑code walkthroughs.
This article explains how to use Redis BitMap to build a memory‑efficient sign‑in feature and continuous‑sign‑in statistics in a Spring Boot microservice, covering basic BitMap commands, key design, core Java code, testing steps, and a bitmap‑based solution for cache‑penetration protection.
The Poisson distribution, originating from 19th‑century French military statistics, describes the probability of a given number of rare events occurring within a fixed interval, and its formula, derivation from the binomial limit, and diverse applications—from traffic flow to insurance claims—are explored in this article.
This comprehensive guide demystifies over one hundred core mathematical modeling terms—from basic concepts like models and abstraction to advanced topics such as optimization, dynamic systems, stochastic processes, statistical methods, and machine learning—helping newcomers confidently navigate the field.
This article introduces ten common anomaly detection approaches—including statistical thresholds, boxplots, clustering, isolation forest, LOF, collaborative filtering, robust covariance, NLP, computer‑vision, and time‑series methods—each accompanied by concise Python code snippets illustrating how to identify outliers in different data domains.
This article explains the Central Limit Theorem, shows how a sum of independent identically distributed variables approaches a normal distribution, and demonstrates its practical use through six detailed examples ranging from power supply planning to medical donor matching.
This article compiles a comprehensive alphabetically ordered list of 75 crucial data science and machine learning terms—from accuracy and AUC to zero-shot learning—providing concise definitions that help practitioners quickly grasp essential concepts and improve their analytical vocabulary.
This article presents a comprehensive collection of practical data visualization methods—including KS plots, SHAP explanations, Q‑Q plots, cumulative variance, Gini vs Entropy, bias‑variance tradeoff, ROC and precision‑recall curves, and elbow analysis—each illustrated with Python code and clear explanations to help analysts and non‑experts quickly interpret complex datasets.
This article explores how a mathematician applies Fermi estimation and the Drake equation to model the probability of finding a partner in London, illustrating the power of simple mathematical reasoning for everyday life questions.
This article outlines a clear framework for writing data analysis reports—including hierarchical structure, concise conclusions, business‑oriented recommendations, reliable data sourcing, and best‑practice chart design—while highlighting common statistical pitfalls and tips for improving readability and impact.
This article explains how to leverage Redis data structures such as Set, Sorted Set, Bitmap, and HyperLogLog to perform aggregation, sorted, binary‑state, and cardinality statistics efficiently in large‑scale applications, while addressing performance considerations and practical implementation details.
This article explores the Beta distribution’s role in Bayesian statistics, detailing its definition, properties, conjugate prior relationship, and practical examples such as coin flips and bus arrivals, illustrating how it simplifies probability updates and supports intuitive belief revision.
This article explains Bayesian methods—its core theorem, historical and everyday applications, a detailed medical testing model, and provides a step‑by‑step Python calculation illustrating how prior probabilities and new evidence combine to produce posterior probabilities.
This article explains how MySQL 8.0 updates the AUTO_INCREMENT column in INFORMATION_SCHEMA.TABLES, describes the underlying statistics caching mechanism, shows how the information_schema_stats_expiry parameter controls refresh frequency, and provides step‑by‑step tests demonstrating real‑time behavior with code examples.
This article examines how data can be misused or misinterpreted through real‑world case studies—ranging from breakfast myths and toothpaste advertising to contraceptive risks, crime statistics, judicial decisions, questionnaire bias, airline efficiency, and correlation‑causation confusion—offering practical guidelines to recognize and prevent invalid data analysis in the big‑data era.
This article introduces several common probability distributions—including uniform, normal, lognormal, Poisson, exponential, binomial, Student's t, and chi‑squared—explains their properties, and provides Python code using NumPy, SciPy, and Matplotlib to visualize each distribution.
This article breaks down MySQL's query optimizer cost model by detailing how full‑table‑scan cost is computed, covering the underlying formulas, required statistics, memory‑vs‑disk page ratios, and configurable cost constants with concrete code examples.
The article presents a practical toolbox of statistical and machine‑learning metrics—including short‑term growth rates, CAGR, Excel forecasting functions, Wilson score adjustment, sigmoid decay weighting, correlation coefficients, KL divergence, elbow detection with KneeLocator, entropy‑based weighting, PCA, and TF‑IDF—offering concise formulas and code snippets for data analysis without deep theory.
The article explains how Oracle's built‑in auto‑task jobs run during specific weekday and weekend windows, why they can cause performance degradation by changing execution plans or consuming resources, and provides practical steps to diagnose, adjust windows, and selectively disable problematic tasks.
Factor analysis, a statistical technique for uncovering underlying common factors among variables, is explained alongside its distinction from PCA, detailed procedural steps, adequacy tests, and a hands‑on Python implementation using the factor_analyzer library with visualizations and factor rotation methods.
This article explains how to determine whether a time‑series dataset exhibits a monotonic trend using the non‑parametric Mann‑Kendall test, walks through its statistical foundations, shows the calculation steps with sample sales data, and provides a complete Python implementation for practical analysis.
This article provides a comprehensive overview of causal inference, explaining its definition, the distinction between correlation and causation, classic pitfalls such as Simpson's paradox, key metrics like ATE and ATT, experimental designs, bias mitigation techniques, and practical case studies from content platforms and the Titanic dataset.
This article explains the Central Limit Theorem and demonstrates its practical use through six diverse examples ranging from power planning in factories to ambulance allocation, seed quality assessment, and prize‑draw probabilities, showing how normal approximations simplify complex random‑variable calculations.
This article explains why feature selection is crucial for machine learning, outlines the general workflow, compares filter, wrapper, embedded, and synthesis approaches, and provides practical Python examples—including Pearson correlation, chi‑square tests, mutual information, variance selection, recursive elimination, L1 regularization, and PCA—complete with code snippets and visualizations.
This article explains the scientific foundations, historical origins, statistical principles, implementation techniques, and practical applications of A/B testing as a data‑driven growth tool for product optimization, algorithm iteration, and marketing decisions in modern internet companies.
Understanding mean, standard deviation, and different data distributions equips policymakers with the quantitative insight needed to design fair, effective regulations and to interpret the massive data driving modern governance.
This guide explains how to conduct a 2 × 2 chi‑square test in SPSS, covering data entry, weighting, step‑by‑step menu selections, cell options, result interpretation, and decision rules for choosing the appropriate test based on sample size and expected frequencies.
This article presents a practical example using SPSS to perform an independent‑samples t‑test on iron concentrations in mouse livers from two diet groups, explains the assumptions, walks through data entry, test configuration, result interpretation, and concludes that the dietary effect is not statistically significant.
This guide walks through a health‑survey example, showing how to check SPSS assumptions for outliers and normality, perform a one‑sample t‑test on BMI data, interpret the output, and draw a statistically significant conclusion about the sample mean versus the population mean.
This article explains the theory behind simple linear regression, demonstrates how to generate random data and fit a model using R's lm() function, and interprets the statistical output including coefficients, significance tests, and goodness‑of‑fit measures.
This article explains the theory behind hypothesis testing, demonstrates one‑sample and two‑sample t‑tests using R’s t.test() function with agricultural yield examples, and shows how to interpret one‑sided versus two‑sided test results for decision making.
This article explains how various continuous and discrete probability distributions—such as normal, binomial, Poisson, and negative binomial—are used in real‑world contexts, introduces R’s naming conventions for distribution functions, and provides code examples for computing densities, CDFs, quantiles, and random samples.
This guide explains why data visualization matters, how to create and save graphics in R, adjust graphical parameters, and use core plotting functions such as barplot, pie, hist, boxplot, and scatter plots to produce clear, informative charts.
This article explains the simple linear regression model, its six key assumptions, how to evaluate the fit using ANOVA and the coefficient of determination, and covers hypothesis testing and confidence intervals for regression coefficients with practical examples.
This article walks through a complete F‑test example comparing the monthly return variances of IBM and HP stocks over 36 months, detailing hypothesis formulation, calculation of the test statistic, critical value lookup, and interpretation of results to determine if the variances differ significantly.
This article explains the null and alternative hypotheses for one‑ and two‑tailed variance tests, demonstrates how to compute the F‑statistic and critical value, and walks through a practical example comparing the monthly return standard deviations of IBM and HP stocks, concluding that their variances are not significantly different.
This article explains the paired comparison test for non‑independent samples, outlines the null and alternative hypotheses, presents the t‑test statistic formula, and walks through a detailed example evaluating a Dow‑10 investment strategy versus a buy‑and‑hold approach.
This article explains how to conduct hypothesis tests for equality of means between two independent normal populations, covering both equal‑variance and unequal‑variance cases, detailing test statistics, degrees of freedom, critical values, and decision rules through examples on S&P 500 returns and bond recovery rates.
