Learn one useful thing today.
Newcombe Hybrid Wilson Score Confidence Interval for Two-Proportion Risk Difference
Construct boundary-respecting 95% confidence limits for independent risk difference RD = p_1 - p_2 using Robert Newcombe’s (1998) Method 10 square-and-add Wilson score intervals.
Read the guide →Time-Series Econometrics & ForecastingNewey-West Bartlett HAC Long-Run Variance and Standard Error Formula
Correct serially correlated regression or sample-mean standard errors using Newey and West’s (1987) Bartlett-kernel triangular weights w_j = 1 - j / (L + 1) that guarantee positive variance.
Read the guide →Network Science & Graph AnalyticsNewman-Girvan Network Modularity Q Partition Formula
Evaluate graph community clustering via Mark Newman and Michelle Girvan’s (2004) Modularity Q = SUM_c(e_cc - a_c^2) comparing intra-community edge share against the degree-preserving configuration null model.
Read the guide →Civil, Structural & Geotechnical EngineeringNewmark Seismic Sliding-Block Formula: Yield Acceleration k_y & Permanent Slope Displacement
Evaluate earthquake slope performance beyond pseudo-static failure using Nathan M. Newmark’s (1965) Critical Yield Acceleration k_y = (FS_static - 1) * SIN(beta) and Ambraseys-Menu permanent co-seismic displacement D_N (cm).
Read the guide →StatisticalNEWS2 Scale 1 spreadsheet exercise: scoring bands and single-parameter triggers
Practice IF and IFS with fictional NEWS2 Scale 1 observations, explicit input validation and the separate single-parameter three-point trigger.
Read the guide →StatisticalNewsvendor model formula: Critical Fractile & optimal perishable stock level
Calculate a single-period critical fractile and select an order quantity from five equally likely demand scenarios. Distinguish empirical demand quantiles from interpolated percentiles.
Read the guide →EngineeringNewton's Law of Cooling formula: transient temperature & time to cool
Calculate temperature and target time in a constant-ambient, constant-rate lumped cooling or warming model, with explicit reachability checks.
Read the guide →Date & TimeNext & Previous Working Day: Strict Step vs. Same-or-Next Business Day Roll
Calculate strictly next/previous working days and roll-forward/roll-backward settlement dates that preserve valid business days while skipping weekends and holidays via WORKDAY.
Read the guide →Date & TimeNext Biweekly Payday from Any Date formula (14-Day Anchor + CEILING.MATH)
Find the next date on or after a query date in a fixed 14-day schedule anchored to a known date.
Read the guide →Date & TimeNext business day N months in the future (EDATE + WORKDAY "-1, +1" trick)
Shift a date by whole months, then keep it if it is a working day or roll forward using a supplied holiday list and Saturday–Sunday weekends.
Read the guide →Date & TimeNext work anniversary date and completed years of service
Calculate completed employee tenure, exact upcoming anniversary date (leap-day safe), and 5-year service award milestones.
Read the guide →Healthcare & ClinicalNEXUS Cervical Spine Criteria: Five Flags and Their Limits
Explore a spreadsheet count of five pre-assessed NEXUS findings, and understand why the result cannot independently clear a neck injury or determine imaging.
Read the guide →StatisticalNFL Quarterback Passer Rating formula (0 to 158.3 Official Scale)
Calculate NFL passer rating with four clamped components and compare it with adjusted yards per attempt (AY/A).
Read the guide →Underground Caverns, Drill-and-Blast Tunneling & NATM, NGI Barton Q-SystemNGI Barton Tunneling Q-System & Roof Support Formula
Calculate Logarithmic NGI Rock Mass Quality Q (0.001–1,000), Equivalent Excavation Dimension De (m), Maximum Permanent Unsupported Span (m), and Crown Support Pressure (kPa).
Read the guide →Precision Aerospace & Optical Tooling, Nickel Sulfamate Electroforming & Throwing PowerNickel Electroforming Wall Rate & Haring-Blum Throwing Power
Calculate Faraday Nickel Deposition Rate (um/h), Electroformed Mandrel Shell Thickness (um and mm), and Field-Modified Haring-Blum Throwing Power (%).
Read the guide →Panel Econometrics & Time SeriesNickell Dynamic Panel Fixed-Effects Bias Formula (Short-T Audit)
Quantify exact Nickell (1981) downward Fixed-Effects bias in dynamic AR(1) panels y_it = alpha_i + rho*yi,t-1 + u_it to decide when Arellano-Bond GMM is required.
Read the guide →Healthcare & ClinicalNIH Stroke Scale: Understand the Score and Practice a Sum
Learn what the NIH Stroke Scale measures and practice a grouped point total while recognizing its clinical limitations.
Read the guide →OperationsNIOSH Lifting Equation: Recommended Weight Limit (RWL) & Lifting Index
Use supplied task multipliers to calculate a NIOSH recommended weight limit and numerical lifting index. Validate inputs and preserve precision without presenting a personal safe-lifting guarantee.
Read the guide →FinancialNOMINAL function: convert effective APY back to a stated annual rate (APR)
Find the stated nominal APR needed to hit a target effective annual yield under monthly or quarterly compounding using NOMINAL.
Read the guide →Math & StatisticalNon-Volatile Dynamic N-Period Sum & Average Without OFFSET (SUMIFS & AVERAGEIFS)
Replace slow volatile SUM(OFFSET(B2,0,0,N,1)) rolling windows with dependency-tracked SUMIFS(B2:B7, A2:A7, "<=" & E2) and AVERAGEIFS for instant multi-sheet recalculation.
Read the guide →Charts & Visual DataNormal Distribution Bell Curve Formula: Exact Gaussian PDF Ordinate & Sigma Grid
Generate smooth XY Scatter Bell Curve coordinates for any mean mu and standard deviation sigma using the universal closed-form Gaussian density formula (1 / (sigma * SQRT(2*PI()))) * EXP(-0.5 * z^2).
Read the guide →Statistical & Clinical AnalysisNormal Q-Q & Probability Plot Formula: Blom Plotting Position & Theoretical Z-Quantile
Build a Normal Q-Q (Quantile-Quantile) and Normal Probability Plot table from sorted sample data: compute Blom’s unbiased plotting position p_r = (r - 0.375) / (n + 0.25) and Tukey’s closed-form standard normal quantile z_r.
Read the guide →Engineering & ScienceNormal Zeeman Effect: Bohr Magneton Energy & Spectral Wavelength Splitting
Calculate Zeeman magnetic sublevel energy splitting delta_E = mu_B * B (in micro-electronvolts, mu_B = 57.8838 ueV/T) and Lorentz triplet wavelength shift delta_lambda = 4.66864e-5 * B * lambda_0^2 (in picometers).
Read the guide →StatisticalNormalize data between 0 and 1 (Min-Max scaling vs Z-score)
Rescale disparate KPIs onto a common 0–1 (or 0–100) scale with (x - MIN) / (MAX - MIN) or standardize into Z-scores.
Read the guide →Text & String FormulasNormalize Dirty Text Keys: Strip CHAR(160), Control Codes & Case (CLEAN & TRIM)
Sanitize web-scraped and ERP-exported lookup keys via LOWER(TRIM(CLEAN(SUBSTITUTE(A2, CHAR(160), " ")))) so invisible HTML non-breaking spaces and line breaks stop breaking XLOOKUP and VLOOKUP.
Read the guide →Text & CleaningNormalize Noisy Vendor & Bank-Feed Strings via Keyword Mapping (SEARCH & IFS)
Map messy corporate card and bank-feed descriptions containing terminal IDs, asterisks, and city suffixes to canonical vendor names using ordered ISNUMBER(SEARCH(...)) rules and SUMIF spend rollups.
Read the guide →Lookup & ReferenceNormalize storage units: binary KiB/MiB/GiB/TiB versus decimal GB
Use powers of 1024 for IEC binary units and powers of 1000 for decimal SI units; keep the two conventions distinct.
Read the guide →Electronics Packaging Reliability, IPC-9701 / JEDEC Norris-Landzberg BGA FatigueNorris-Landzberg BGA Solder Thermal Acceleration Formula
Calculate CTE Strain-Range Multiplier (dT_test/dT_field)^1.9, Creep Frequency-Arrhenius Factor, Total Acceleration Factor AF, and Equivalent Field Service Life (years).
Read the guide →Food Engineering & Microbial Hurdle SafetyNorrish Humectant Water Activity (aw) Formula
Calculate Ideal Raoult Water Mole Fraction x_w, Norrish Non-Ideal Sugar/Humectant Water Activity a_w = x_w * EXP(-K * x_s^2), Hydrogen-Bonding Depression, and FDA aw <= 0.85 Pathogen Hurdle status.
Read the guide →Healthcare & Clinical CalculationsNorton Pressure Ulcer Risk Scale: Context and Summing Example
Understand the context and limitations of the Norton scale and practice validating and adding five whole-number scores in a separate exercise.
Read the guide →LogicalNOT function: invert TRUE/FALSE and exclude blocked statuses cleanly
Negate logical tests and multi-value exclusion lists with NOT(OR(...)) so dispatch and approval rules stay easy to audit.
Read the guide →Date & TimeNOW function: compare live timestamps and add hours to the current time
Understand how NOW stores the current date and time as a serial number + decimal fraction, how it differs from TODAY, and why it recalculates on edit.
Read the guide →FinancialNPER function: calculate how many months it takes to pay off a loan
Find the number of payment periods needed to clear a balance with NPER, match monthly rate and cash-flow signs, and guard payments below monthly interest.
Read the guide →Financial analysisNPV function: keep the day-zero investment outside NPV
NPV discounts its first cash-flow argument by one full period. Add the initial day-zero outlay outside NPV(rate, Year1:YearN) so present value is never misstated.
Read the guide →Clinical Medicine & PhysiologyNRS-2002: Hospital Nutrition Screening Score and Context
Add pre-assessed nutrition and disease subscores and an age adjustment in an educational NRS-2002 example, with context about screening and follow-up.
Read the guide →Engineering & ScienceNRTL (Non-Random Two-Liquid) VLE & LLE Activity Coefficients
Calculate Henri Renon and John Prausnitz’s 3-parameter NRTL activity coefficients gamma_1 and gamma_2 using energy parameters tau_12, tau_21 and non-randomness factor alpha_12 for partially miscible liquid-liquid and azeotropic VLE mixtures.
Read the guide →Embedded Sensors, Battery BMS & Thermal ManagementNTC Thermistor Beta & Steinhart-Hart Divider Formula
Calculate Microcontroller Pull-Up Voltage Divider Output V_adc = V_ref * R_ntc / (R_pull + R_ntc), Log Resistance Ratio LN(R_ntc / R_25), Absolute Kelvin Temperature 1 / (1/298.15 + LN(R/R_25)/Beta), and Celsius Temperature.
Read the guide →StatisticalNth largest value without duplicates: dense Gold, Silver, Bronze tiers
Wrap UNIQUE inside LARGE(UNIQUE(Range), N) so tied top scores do not swallow 2nd and 3rd place prize tiers.
Read the guide →StatisticalNth Smallest Value with Criteria & Highlight Bottom K Bids (SMALL + FILTER)
Find the kth lowest bid in a category and flag all bids at or below that cutoff, with explicit tie handling and validation of K and matching bid data.
Read the guide →Date & TimeNumber of workdays in a month (and remaining business days)
Count total business days in any month and remaining working days to month-end excluding weekends and holidays with NETWORKDAYS.
Read the guide →Engineering & ScienceNusselt Laminar Film Condensation Coefficient on a Vertical Wall (h̄)
Calculate the mean condensing heat-transfer coefficient h̄ = 0.943 * ((ρ_l * (ρ_l - ρ_v) * g * h_fg * k_l^3) / (μ_l * L * ΔT))^0.25 (W/(m^2·K)) for vertical condenser tubes.
Read the guide →EngineeringNyquist Sampling Rate, Folded Alias Frequency & ADC SNR / ENOB formulas
Calculate a single-tone folded frequency, the twice-bandwidth Nyquist boundary, ideal full-scale sine quantization SNR and SINAD-derived ENOB.
Read the guide →Biostatistics & Clinical TrialsO’Brien-Fleming vs Pocock Group-Sequential Interim Boundary Formula
Compute O’Brien-Fleming information-scaled critical Z boundaries and Lan-DeMets cumulative alpha spending alpha*(t) across interim Data Monitoring Committee looks.
Read the guide →Chemical, Process & Catalysis EngineeringO’Connell Overall Distillation Tray Efficiency Formula & Actual Tray Count N_act
Convert theoretical equilibrium stages into actual sieve/valve trays using H. E. O’Connell’s (1946, AIChE) Overall Column Efficiency correlation E_0 (%) = 50.3 * (alpha * mu_L)^(-0.226) and Actual Tray Count -INT(-N_th / (E_0 / 100)).
Read the guide →Engineering & Fluid MechanicsO’Connell Tray Efficiency Correlation Formula: Actual vs. Theoretical Distillation Plates
Convert equilibrium McCabe-Thiele / Fenske-Underwood-Gilliland distillation stages N_eq into actual column trays N_actual = ROUNDUP(N_eq / E_o, 0) using H. E. O’Connell’s correlation E_o (%) = 50.3 * (mu_L * alpha)^(-0.226).
Read the guide →Healthcare & Clinical CalculatorsOABSS: Adding Four Symptom Subscores in a Spreadsheet
Add pre-scored items for the Overactive Bladder Symptom Score and understand why symptom thresholds alone do not establish a diagnosis.
Read the guide →Healthcare & Clinical CalculationsOakland Score Research: Seven Components and a Point Sum
Review the components of a lower gastrointestinal bleeding research score and practice adding already-assigned points.
Read the guide →Statistical & Clinical AnalysisOaxaca-Blinder Decomposition Formula: Explained Endowment vs. Unexplained Pay Gap
Decompose mean log-wage differentials (Y_A - Y_B) into Explained Endowment differences (X_A - X_B) * beta_A and Unexplained Coefficient/Return differences using Ronald Oaxaca & Alan Blinder’s 1973 counterfactual identity.
Read the guide →EngineeringOblique Shock Theta-Beta-Mach Wedge Deflection & Normal Mach Formula
Calculate supersonic wedge deflection angle theta (degrees) from upstream Mach M_1 and shock wave angle beta using the exact Theta-Beta-Mach relation, plus normal Mach component M_n1 = M_1 * SIN(beta).
Read the guide →Engineering & ScienceOcean Ekman Spiral Depth (DE) & Wind-Driven Ekman Transport Formula
Calculate Vagn Walfrid Ekman’s turbulent upper-ocean boundary layer thickness D_E = PI() * SQRT((2 * A_z) / |f|) (m) and depth-integrated 90°-deflected Ekman mass transport M_E = tau_wind / |f| (kg/(m*s)).
Read the guide →