QBUS5001 · Foundation In Data Analytics For Business
The Complete Exam Bible · S1 2026Foundation in Data Analytics for Business
QBUS5001 Foundation in Data Analytics for Business is the postgraduate statistics engine of the University of Sydney's Business School Masters programs — it carries you from sourcing and visualising data, through probability, distributions, sampling and the Central Limit Theorem, to confidence intervals, hypothesis testing and regression, all executed in Microsoft Excel.
Assessment is dominated by a closed-book final exam worth 50% that covers all of Modules 1 to 12 with a supplied 8-page formula sheet; the final is a hurdle — you must score at least 40 out of 100 on it and reach an overall mark of at least 50 to pass.
The skill the exam rewards is method discipline: pick the right test or distribution, run the formula sheet correctly to 4 decimal places, and interpret the number in business context.
What QBUS5001 covers
The whole subject → one exam-ready map. Each topic links to its free chapter guide.
How QBUS5001 is assessed
| Component | Weight | Format |
|---|---|---|
| Weekly Homework (Mindtap/Aplia) | 10% | 10 online homeworks, best 5 count; due Sundays from Week 2 |
| In-Semester Test | 25% | Closed-book, 1h30m; covers Modules 1–5; held Week 7; formula sheet supplied |
| Group Assignment | 15% | Due Week 12 |
| Final Exam · hurdle | 50% | Closed-book; covers Modules 1–12; supplied 8-page formula sheet; ≥40/100 hurdle |
One-sample t-test on a mean (with confidence interval)
- 1 markState the hypotheses. H₀: μ = 250 versus H₁: μ ≠ 250 (two-tailed, because “differs” gives no direction).
- 1 markChoose the test. σ is unknown and estimated by s, so use the t-statistic with df = n − 1 = 35.
- 1 markCompute the standard error: s/√n = 9/√36 = 9/6 = 1.5 ml.
- 2 marksCompute the test statistic: T = (x̄ − μ₀)/(s/√n) = (246 − 250)/1.5 = −4/1.5 = −2.6667.
- 1 markDecision rule. Reject H₀ if |T| > t(0.025, 35) ≈ 2.030. Here |−2.6667| = 2.6667 > 2.030, so reject H₀.
- 1 markConfirm with the 95% CI: 246 ± 2.030 × 1.5 = 246 ± 3.045 = [242.96, 249.05]. The claimed value 250 lies outside this interval — the same conclusion.
- 1 markConclude in context: at the 5% level there is sufficient evidence that the true mean fill differs from (is below) 250 ml.
Key terms
- Central Limit Theorem (CLT)
- For a sample of size n ≥ 30, the sampling distribution of the sample mean x̄ is approximately Normal regardless of the population shape, with mean μ and standard error σ/√n. It is what licenses Normal-based inference on non-Normal data.
- Confidence interval
- An interval of the form point estimate ± (critical value)(standard error) that, over repeated sampling, contains the true parameter (1−α) of the time — e.g. a 95% CI. It is a statement about the procedure, not a probability about the fixed parameter.
- p-value
- The probability, if H₀ were true, of observing a test statistic at least as extreme as the one obtained. Reject H₀ when the p-value ≤ α.
- Type I / Type II error
- A Type I error rejects a true H₀ (probability α); a Type II error fails to reject a false H₀ (probability β). Power = 1 − β.
- R² (coefficient of determination)
- R² = SSR/SST, the proportion of variation in Y explained by the regression model. Adjusted R² penalises extra predictors so models with different numbers of variables can be compared fairly.
- Standard error
- The standard deviation of a sample statistic's sampling distribution — for the mean it is σ/√n. It shrinks as n grows, which is why larger samples give tighter estimates.
QBUS5001 FAQ
Is the QBUS5001 final exam open or closed book?
Closed book. You are given a supplied 8-page formula sheet (printed separately and not removable from the venue) and may use a non-programmable calculator, but you cannot bring your own notes. The final covers Modules 1 to 12.
What is the pass hurdle for QBUS5001?
Two conditions must both hold: you must score at least 40 out of 100 on the final exam, and your overall mark across all assessment tasks must be at least 50. The final exam is therefore a hurdle as well as the largest single weight (50%).
What does the in-semester test cover and when is it?
The in-semester test is worth 25%, runs for 1 hour 30 minutes closed book, and covers Modules 1 to 5 (descriptive statistics through sampling distributions and the CLT). It is held in Week 7, with a formula sheet supplied.
Do I need to memorise the formulas?
No — a formula sheet is provided in both the in-semester test and the final. The marks come from choosing the correct formula for the scenario, substituting carefully (keep 4 decimal places for non-integer results), and interpreting the answer in business terms.
Which software does the course use?
Microsoft Excel 365 with the Analysis ToolPak add-in. You will use functions such as NORM.DIST, NORM.S.DIST, BINOM.DIST, POISSON.DIST, T.INV.2T, CORREL and the Data Analysis → Regression tool. Weekly homework is done on Cengage Mindtap/Aplia.
How to study for the exam
Treat the formula sheet as the course map: print it early and, for every formula, write beside it the one trigger phrase that selects it (“σ unknown → t”, “comparing two layouts → two-sample test”, “counts in a window → Poisson”). Because the exam is closed-book on method, build a one-page decision tree: is the question about a distribution, an interval, a test, or a regression? Then which sub-case? Drill the in-semester material (Modules 1–5) to fluency by Week 7, since it reappears in the final. Practise every calculation twice — once by hand to 4 decimals and once in Excel — so you trust your numbers under time pressure. Finally, never stop at the number: each answer needs a one-sentence business interpretation, which is where easy marks are won and lost.
