Elective Data Analysis and Modeling
Data Analysis and Modeling notes
8 chapter notes, in syllabus order. Each starts with the key points.
Unit 1
Introduction to Data Analysis · note coming
Unit 2
Spreadsheet Data Management: Tools, Functions & WorkflowsUnit 2 of Data Analysis and Modeling explores spreadsheet fundamentals—data entry, formulas, functions, validation, and automation—using Excel/Google Sheets, with real-world applications in finance, logistics, and decision-making.8 min readUnit 3
Descriptive Analytics: Measures, Visuals & Data SummarizationUnit 3 of Data Analysis and Modeling covers how to summarize raw data into meaningful insights using measures (central tendency, dispersion), graphical tools (histograms, boxplots), and techniques (data cleaning, binning) to reveal patterns—essential for business decisions like inventory optimization or customer segmen16 min readUnit 4
Probability Models: Distributions, Rules & Real-World ApplicationsUnit 4 of Data Analysis and Modeling explores foundational probability models—discrete vs. continuous distributions, probability rules (addition/multiplication), Bayes’ theorem, and their applications in business decision-making. Learn through visual examples, real-world cases (e.g., Ncell’s call-drop prediction, Daraz10 min readUnit 5
Hypothesis Testing: Types, Tests & Decision RulesUnit 5 of Data Analysis and Modeling explores how to make data-driven decisions by testing assumptions (hypotheses) about populations using sample data, covering null/alternative hypotheses, test statistics, p-values, significance levels, and common tests (z-test, t-test, chi-square, ANOVA) with real-world applications15 min readUnit 6
Regression Modelling: Types, Assumptions, and ApplicationsUnit 6 of Data Analysis and Modeling explores regression modeling—how to predict relationships between variables, test assumptions, and apply linear/logistic regression in business. Learn formulas, diagnostics, and real-world uses in finance, marketing, and operations.8 min readUnit 7
Time Series Forecasting: Models, Trends & ApplicationsUnit 7 of Data Analysis and Modeling teaches how to analyze past data patterns (trends, seasonality, cycles) to predict future values using ARIMA, exponential smoothing, and machine learning, with real-world applications in business, finance, and logistics.18 min readUnit 8
Linear Programming Models · note coming
Unit 9
Decision Analysis: Trees, Payoffs, and Optimal ChoicesUnit 9 of Data Analysis and Modeling explores decision-making under uncertainty using decision trees, payoff matrices, expected value, and sensitivity analysis, with real-world applications in finance, logistics, and risk management.10 min readUnit 10
Simulation Models: Types, Applications & Worked ExamplesUnit 10 of Data Analysis and Modeling explores simulation models—how to replicate real-world systems (queues, supply chains, financial risks) using probability, random variables, and computational tools. Learn discrete-event, Monte Carlo, and system dynamics simulations, with step-by-step examples (e.g., Pathao driver 17 min read