BUSS1020 Quantitative Business Analysis – Complete Study Notes (Formulas, Excel & Worked Examples)

Description

Complete, original study notes for BUSS1020 covering all 12 content modules. Each topic has plain-English explanations, the key formulas, the matching Excel functions, and fully worked examples with step-by-step solutions. Topics covered: Introduction to data: variable types, levels of measurement, data sources, data cleaning, sampling methods, survey errors Descriptive statistics: mean, median, mode, geometric mean, variance, SD, CV, z-scores, skewness, quartiles, IQR, boxplots, empirical rule vs Chebyshev, tables and charts Probability: addition and multiplication rules, conditional probability, independence, contingency tables, Bayes’ theorem, counting rules Discrete distributions: expected value, binomial, Poisson, hypergeometric, covariance, portfolio risk Continuous distributions: normal and standard normal, assessing normality, uniform, exponential Sampling distributions: standard error, Central Limit Theorem, sample proportions, finite population correction Confidence intervals: Z and t intervals for means, proportions, sample size, auditing One-sample hypothesis tests: 6-step method, Type I/II errors, power, Z and t tests, p-values, proportion tests Two-sample tests: pooled and separate-variance t tests, paired t test, two-proportion Z test Simple linear regression: correlation, least squares, interpreting coefficients, r², SYX, LINE assumptions, residual analysis, slope tests, confidence vs prediction intervals, Durbin-Watson, pitfalls Multiple regression: interpretation, adjusted r², F test, dummy variables, interactions, multicollinearity (VIF), reading Excel output Exam toolkit: “which test do I use?” table, full Excel function list, hypothesis test answer template, common mistakes, critical values Covers Weeks 1–12 (12 modules).