Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas

🀯 Wacky fact of the day · Human Body

You blink around 15–20 times a minute.

Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry…

Why? How? β†’Source β†—

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips β€” plus wacky facts

Skip to content
  • ✨ AI Helper
  • πŸŽ“ Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact

Atul Vij

VARP Function in Excel: Population Variance (Older Name)

VARP Function in Excel: Population Variance (Older Name) featured illustration

16 Mar 2021 Β· Excel Functions A–Z Β· 1 min read

VARP Function in Excel: Population Variance (Older Name)

VARP gives the variance of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…

Read article β†’
16 March 2021 by Atul Vij Excel Functions A–Z, Statistical

Slow Wi-Fi at Home? 10 Fixes That Actually Work

Slow Wi-Fi at Home? 10 Fixes That Actually Work featured illustration

16 Mar 2021 Β· Internet & Browser Β· 2 min read

Slow Wi-Fi at Home? 10 Fixes That Actually Work

Diagnose and fix slow home Wi-Fi: speed tests the right way, router placement, 2.4 GHz vs 5 GHz, channel congestion, DNS, restarting, firmware, mesh…

Read article β†’
16 March 2021 by Atul Vij Internet & Browser

VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE

VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE featured illustration

13 Mar 2021 Β· Excel Functions A–Z Β· 1 min read

VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE

StatisticsLevel: IntermediateAvailable in: Excel 2007+VARPA is the population version of VARA.Syntax=VARPA(value1, [value2], ...)ArgumentWhat it.

Read article β†’
13 March 2021 by Atul Vij Excel Functions A–Z, Statistical

AVEDEV Function in Excel: Average Distance From the Mean

AVEDEV Function in Excel: Average Distance From the Mean featured illustration

12 Mar 2021 Β· Excel Functions A–Z Β· 1 min read

AVEDEV Function in Excel: Average Distance From the Mean

AVEDEV is the average of absolute deviations β€” an easier-to-explain measure of spread than standard deviation (β€œon average we are off by 12 units”).

Read article β†’
12 March 2021 by Atul Vij Excel Functions A–Z, Statistical

DEVSQ Function in Excel: Sum of Squared Deviations

DEVSQ Function in Excel: Sum of Squared Deviations featured illustration

7 Mar 2021 Β· Excel Functions A–Z Β· 1 min read

DEVSQ Function in Excel: Sum of Squared Deviations

DEVSQ adds up how far each value is from the mean, squared. It is the raw ingredient of variance and of ANOVA tables.

Read article β†’
7 March 2021 by Atul Vij Excel Functions A–Z, Statistical

VAR.P Function in Excel: Variance of a Whole Population

VAR.P Function in Excel: Variance of a Whole Population featured illustration

2 Mar 2021 Β· Excel Functions A–Z Β· 1 min read

VAR.P Function in Excel: Variance of a Whole Population

VAR.P is the population version of VAR.S: it divides by n, not nβˆ’1. Use it when the data is everything there is β€” all…

Read article β†’
2 March 2021 by Atul Vij Excel Functions A–Z, Statistical

Machine Learning Lesson 8: Project, Predict Late Invoice Payments

Machine Learning Lesson 8: Project, Predict Late Invoice Payments featured illustration

24 Feb 2021 Β· Machine Learning Β· 3 min read

Machine Learning Lesson 8: Project, Predict Late Invoice Payments

Build a complete model that predicts which invoices will be paid late, test it, save it, and score new invoices into an Excel file…

Read article β†’
24 February 2021 by Atul Vij Machine Learning

Machine Learning Lesson 7: Pipelines, Cross-Validation and Avoiding Leakage

Machine Learning Lesson 7: Pipelines, Cross-Validation and Avoiding Leakage featured illustration

23 Feb 2021 Β· Machine Learning Β· 2 min read

Machine Learning Lesson 7: Pipelines, Cross-Validation and Avoiding Leakage

Bundle cleaning and the model into one scikit-learn pipeline so nothing leaks from test data, and compare models fairly with 5-fold cross-validation.

Read article β†’
23 February 2021 by Atul Vij Machine Learning

Machine Learning Lesson 6: Clustering Customers with K-Means

Machine Learning Lesson 6: Clustering Customers with K-Means featured illustration

22 Feb 2021 Β· Machine Learning Β· 2 min read

Machine Learning Lesson 6: Clustering Customers with K-Means

Group shoppers into segments without any labels using K-Means. Scale features first, choose the number of groups with the elbow method, and describe each…

Read article β†’
22 February 2021 by Atul Vij Machine Learning

Machine Learning Lesson 5: Decision Trees and Random Forests

Machine Learning Lesson 5: Decision Trees and Random Forests featured illustration

21 Feb 2021 Β· Machine Learning Β· 3 min read

Machine Learning Lesson 5: Decision Trees and Random Forests

Decision trees learn readable if/then rules; unlimited trees overfit. Random forests combine hundreds of trees and show which features matter most.

Read article β†’
21 February 2021 by Atul Vij Machine Learning

Machine Learning Lesson 4: Classification (Which Customers Will Leave?)

Machine Learning Lesson 4: Classification (Which Customers Will Leave?) featured illustration

20 Feb 2021 Β· Machine Learning Β· 3 min read

Machine Learning Lesson 4: Classification (Which Customers Will Leave?)

Predict yes/no outcomes with logistic regression. Read accuracy, precision, recall and the confusion matrix, and choose your own probability cut-off.

Read article β†’
20 February 2021 by Atul Vij Machine Learning

Machine Learning Lesson 3: Train/Test Split and Honest Evaluation

Machine Learning Lesson 3: Train/Test Split and Honest Evaluation featured illustration

19 Feb 2021 Β· Machine Learning Β· 2 min read

Machine Learning Lesson 3: Train/Test Split and Honest Evaluation

Keep part of the data hidden from the model to test it fairly. Measure regression accuracy with MAE and R2 and always compare with…

Read article β†’
19 February 2021 by Atul Vij Machine Learning

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
Β© 2026 Atul Vij Β· AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? β†’