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 a simple baseline.
Read article →Keep part of the data hidden from the model to test it fairly. Measure regression accuracy with MAE and R2 and always compare with a simple baseline.
Read article →Models only accept complete, numeric tables. Find and fill missing values with the median and turn text columns like city into 0/1 columns with get_dummies.
Read article →What machine learning actually is, the words you need (features, target, training), installing scikit-learn, and a first model that predicts flat prices from area.
Read article →STOCKHISTORY fetches daily, weekly or monthly prices for a stock or currency pair into a spill range.
Read article →Collect data without retyping: build a Google Form with the right question types and validation, send responses to a Sheet, summarise them with formulas and charts, and get notifications.
Read article →Write your first Google Apps Script: open the editor, read a sheet, total by region, email yourself a summary, add a custom menu, schedule it with a time-driven trigger, and understand permissions.
Read article →The Google Sheets functions that make it special: QUERY, ARRAYFORMULA, IMPORTRANGE, GOOGLETRANSLATE, SPARKLINE, SPLIT, IMAGE, GOOGLEFINANCE and checkboxes, with practical examples.
Read article →Which customers are in this month’s list but not last month’s? Compare two lists with COUNTIF, MATCH/XMATCH, FILTER and conditional formatting — in old and new Excel — and avoid the spaces-and-text-numbers traps.
Read article →Understand INDEX and MATCH separately, combine them for flexible lookups in any Excel version, look left, do two-way and multiple-criteria lookups, approximate matches, and know when XLOOKUP is simpler.
Read article →Calculate weighted averages correctly — average price by quantity, weighted marks, blended interest rates — with SUMPRODUCT/SUM, weighted averages with conditions, and why plain AVERAGE gives the wrong answer.
Read article →VAR estimates variance from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends VAR.S for new work. Both give the same result.
Read article →Look up a value at the crossing of a row and a column — target for South in August, price for size L in red — with INDEX+MATCH+MATCH, nested XLOOKUP, and how to avoid the mistakes that return the wrong cell.
Read article →