STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P measures spread when your data is the entire group, not a sample. The P version divides by n instead of n−1, so it comes out a little smaller than STDEV.S.
Read article →STDEV.P measures spread when your data is the entire group, not a sample. The P version divides by n instead of n−1, so it comes out a little smaller than STDEV.S.
Read article →Model real things with classes: fields, constructors, methods, private data with public methods, and records for simple data.
Read article →Write static methods with parameters and return types, overloading, and keeping methods small and testable.
Read article →Use if/else, switch expressions, comparison and logical operators, for, enhanced for and while loops in Java.
Read article →Java’s static types: int, double, boolean, char and String, declaring variables, var, arithmetic and integer division, casting and printf formatting.
Read article →Install a JDK (Temurin or Oracle), check java -version, write and run Hello.java from the terminal and in VS Code or IntelliJ IDEA.
Read article →QUARTILE returns the quartile of a data set. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends QUARTILE.INC for new work. Both give the same result.
Read article →Use the Scripting.Dictionary in Excel VBA: create one, add and update keys, count and total by key, get unique lists, compare text case-insensitively, early vs late binding and speed tips.
Read article →QUARTILE.INC returns the minimum, the 25th, 50th or 75th percentile, or the maximum. It is the fastest way to see whether a salary band or sales spread is lopsided.
Read article →Finish and share the course project: build a one-page sales dashboard, publish to the Power BI service, schedule refresh with a gateway, share via apps or links with the right licences, and export to PDF or PowerPoint.
Read article →Make reports interactive: slicers and sync across pages, cross-filtering and edit interactions, drill-down hierarchies, drill-through detail pages, report-page tooltips and bookmarks for saved views.
Read article →Choose and format Power BI visuals: cards and KPIs, bar vs column vs line, tables and matrices, maps, conditional formatting, consistent themes and page layout that leads the eye.
Read article →