26134 · Responsible Evidence-Based Decisions26134 · 循证决策(商科统计)
UTS Business School's first-year statistics core — read data honestly, decide with evidence, and do it all in Excel.悉尼科大商学院大一统计核心课 —— 学会诚实地读懂数据、用证据做决策,并全程用 Excel 实操。26134 is the Bachelor of Business statistics foundation (formerly "Business Statistics"). It teaches you to describe data, reason about probability and uncertainty, and run estimation, hypothesis tests and regression on real business questions — assessed by online quizzes and Excel-based project work, with no final exam. This guide is built from 69 real 26134 course materials in the AskSia Library.
26134 是悉尼科大商科(Bachelor of Business)的统计基础课(前身为 Business Statistics)。它教你描述数据、理解概率与不确定性,并用估计、假设检验、回归去回答真实商业问题 —— 考核由在线 quiz 和基于 Excel 的项目作业构成,没有期末闭卷考试。本指南基于AskSia Library 中的 69 份真实 26134 课程材料整理而成。
Built from 69 real 26134 course materials in the AskSia Library.
基于AskSia Library 中的 69 份真实 26134 课程材料整理而成。
What 26134 is about26134 讲什么
26134 Responsible Evidence-Based Decisions is the introductory business-statistics subject in the UTS Bachelor of Business. It develops the ability to assess and critically interpret quantitative data from business and society within a framework of evidence-based reasoning. Students learn to explore and summarise data, work with probability and probability distributions, draw inferences through sampling, estimation and hypothesis testing, and model relationships with correlation and regression — performing the analysis in Microsoft Excel. The subject stresses interpreting results honestly and communicating defensible, data-driven conclusions for business and policy decisions.
26134 Responsible Evidence-Based Decisions 是悉尼科大商科本科的入门统计课。它在「循证推理」的框架下,培养学生评估并批判性解读来自商业与社会的定量数据的能力。学生将学习探索与汇总数据、掌握概率与概率分布、通过抽样·估计·假设检验进行推断,并用相关与回归对变量关系建模 —— 全部分析在 Microsoft Excel 中完成。课程强调诚实地解读结果,并就商业与政策决策给出有数据支撑、站得住脚的结论。
The 26134 syllabus, topic by topic26134 大纲 · 逐个主题
Exploring & describing data数据探索与描述
Types of data (categorical vs numerical, nominal/ordinal, discrete/continuous), frequency tables, histograms, bar and pie charts. How to summarise a dataset before analysing it.
数据类型(分类 vs 数值、名义/有序、离散/连续)、频数表、直方图、条形图与饼图。分析前如何先把一组数据「看清楚」。
Measures of centre & spread集中趋势与离散程度
Mean, median and mode; variance, standard deviation and the coefficient of variation; skewness and distribution shape. Choosing the right summary measure for the data.
均值、中位数、众数;方差、标准差与变异系数;偏度与分布形态。针对不同数据选择合适的汇总指标。
Probability fundamentals概率基础
Sample spaces and events, the rules of probability, conditional probability and independence, and Bayes' reasoning. The logic of uncertainty that underpins inference.
样本空间与事件、概率法则、条件概率与独立性、贝叶斯推理。这是后续统计推断背后的「不确定性」逻辑。
Random variables & probability distributions随机变量与概率分布
Discrete distributions (e.g. binomial) and continuous distributions, centred on the normal distribution and standardising with z-scores.
离散分布(如二项分布)与连续分布,重点是正态分布,以及用 z 分数做标准化。
Sampling & sampling distributions抽样与抽样分布
Populations vs samples, sampling methods, the sampling distribution of the mean and the Central Limit Theorem — why sample statistics behave predictably.
总体 vs 样本、抽样方法、样本均值的抽样分布与中心极限定理 —— 解释为什么样本统计量会有可预测的规律。
Estimation & confidence intervals估计与置信区间
Point estimates and confidence intervals for a mean and a proportion, and how confidence level and sample size affect interval width.
对均值与比例的点估计与置信区间,以及置信水平与样本量如何影响区间宽度。
Hypothesis testing假设检验
Null and alternative hypotheses, significance levels, p-values, Type I/II errors, and one- and two-sample tests for means and proportions.
原假设与备择假设、显著性水平、p 值、第一类/第二类错误,以及对均值与比例的单样本、双样本检验。
Correlation & regression相关与回归
Scatterplots, correlation, simple linear regression, interpreting slope and R-squared, and using a fitted model to make and qualify predictions.
散点图、相关性、一元线性回归、解读斜率与 R²,并用拟合模型做出(且审慎限定)预测。
Data analysis in ExcelExcel 数据分析实操
Carrying out the above analyses in Microsoft Excel (formulas, charts, the Data Analysis ToolPak) — the practical data-analytic toolkit assessed in the project work.
在 Microsoft Excel 中完成上述分析(公式、图表、Data Analysis 工具库)—— 这正是项目作业所考核的实操数据分析能力。
Interpreting & communicating evidence证据的解读与沟通
Turning statistical output into honest, defensible conclusions for business and policy decisions, and recognising misuse of data and analytical pitfalls.
把统计结果转化为诚实、站得住脚的商业与政策结论,并识别数据误用与分析陷阱。
How 26134 is assessed26134 怎么考核
Final exam: No期末考试:无| Component考核项 | Weight占比 | Note说明 |
|---|---|---|
| Online quizzes (best 4 of 6)在线 quiz(取 6 次中最好的 4 次) | 20% | Six quizzes across the session, best four count. Multiple-choice and fill-in-the-blank drawn from a question bank, 1 hour, one attempt, completed within a multi-day release window.整学期共 6 次 quiz,取最好的 4 次计分。题目为题库抽取的选择题与填空题,限时 1 小时、仅一次作答,在多日开放窗口内完成。 |
| Excel-based project / data-analysis report work基于 Excel 的项目 / 数据分析报告作业 | ~80% (project / coursework) | Excel-based data-analysis project/report work makes up the remainder. Exact weighting is in the current subject outline.基于 Excel 的数据分析项目 / 报告占其余部分。具体比例以当年 subject outline 为准。 |
No central written exam. Online quizzes 20% (best 4 of 6) + Excel-based data-analysis project/coursework (the remainder). Confirm exact project weighting on the current UTS subject outline.
没有集中笔试。在线测验 20%(6 次取最好 4 次)+ 基于 Excel 的数据分析项目 / 平时作业(其余部分)。具体项目比例以 UTS 当年 subject outline 为准。
When each 26134 task is due26134 各项考核时间
Test yourself: 26134 practice questions自测一下:26134 练习题
- Postcode is numerical, purchase amount is categorical
- Both are numerical
- Postcode is categorical (nominal), purchase amount is numerical (continuous)
- Both are categorical
- 邮编是数值型,消费金额是分类型
- 两者都是数值型
- 邮编是分类型(名义),消费金额是数值型(连续)
- 两者都是分类型
Show answer查看答案
- The mean, because it uses every value
- The median, because it is resistant to the extreme high values
- The mode, because it is the most common value
- The standard deviation, because it measures the centre
- 均值,因为它用到了每一个数据
- 中位数,因为它不受极大值的影响
- 众数,因为它是出现最多的值
- 标准差,因为它衡量中心
Show answer查看答案
- 95% of customers spend between $180 and $220
- There is a 95% probability the true mean is exactly $200
- We are 95% confident the interval [$180, $220] captures the true population mean spend
- If we resample, 95% of individual customers will fall in this interval
- 95% 的顾客消费在 $180 到 $220 之间
- 真实均值恰好为 $200 的概率是 95%
- 我们有 95% 的把握,区间 [$180, $220] 涵盖了真实的总体均值消费
- 若重新抽样,95% 的单个顾客会落在此区间内
Show answer查看答案
Key assessment-style questions in 2613426134 核心考核风格题
26134 glossary26134 术语表
- Descriptive statistics描述性统计
- Methods that summarise and describe the main features of a dataset (centre, spread, shape) without generalising beyond it.
- 用来汇总并描述一组数据主要特征(集中趋势、离散程度、形态)的方法,不对数据之外做推断。
- Standard deviation标准差
- A measure of how spread out values are around the mean, in the same units as the data.
- 衡量数据相对均值离散程度的指标,单位与原数据相同。
- Probability distribution概率分布
- A rule giving the probabilities of the possible values of a random variable (e.g. binomial, normal).
- 描述随机变量各可能取值对应概率的规则(如二项分布、正态分布)。
- Normal distribution正态分布
- The symmetric bell-shaped continuous distribution, central to inference; values are standardised using z-scores.
- 对称的钟形连续分布,是统计推断的核心;其取值用 z 分数标准化。
- Central Limit Theorem中心极限定理
- The result that the sampling distribution of the mean approaches a normal distribution as sample size grows, whatever the population shape.
- 无论总体形态如何,随着样本量增大,样本均值的抽样分布趋近正态分布的定理。
- Confidence interval置信区间
- A range of plausible values for a population parameter, with a stated confidence level (e.g. 95%).
- 在给定置信水平(如 95%)下,对总体参数的一段可信取值范围。
- p-valuep 值
- The probability of observing data as extreme as yours if the null hypothesis were true; small p-values argue against the null.
- 在原假设为真时,观测到与现有数据一样极端结果的概率;p 值越小越不支持原假设。
- Hypothesis test假设检验
- A procedure that uses sample evidence to decide between a null and an alternative claim about a population.
- 利用样本证据,在关于总体的原假设与备择假设之间做出判断的过程。
- Linear regression线性回归
- Fitting a straight line to model how one variable depends on another, for explanation and prediction.
- 用一条直线建模一个变量对另一个变量的依赖关系,用于解释与预测。
- R-squaredR²(决定系数)
- The proportion of variation in the outcome explained by the regression model, from 0 to 1.
- 回归模型所解释的因变量变异比例,取值 0 到 1。
- Evidence-based decision循证决策
- A decision justified by data and analysis rather than intuition alone — the organising theme of 26134.
- 以数据与分析(而非仅凭直觉)为依据的决策 —— 26134 的核心主题。
- Data Analysis ToolPak (Excel)Excel 数据分析工具库
- An Excel add-in providing statistical routines (descriptives, t-tests, regression) used for the subject's project work.
- Excel 的一个加载项,提供描述统计、t 检验、回归等统计功能,用于本课程的项目作业。
26134 — common questions26134 常见问题
How is 26134 assessed — is there a final exam?26134 怎么考核 —— 有期末考试吗?
Is 26134 the same as "Business Statistics"?26134 就是以前的「Business Statistics」吗?
Do I need maths or stats background, and are there prerequisites?需要数学/统计基础吗?有先修课吗?
What software does 26134 use?26134 用什么软件?
Can I use AskSia to study for 26134, and is that allowed?可以用 AskSia 备考 26134 吗?这被允许吗?
Other UTS course guides悉尼科大 其他课程指南
AskSia is an independent study aid and is not affiliated with, endorsed by, or sponsored by University of Technology Sydney. Course details may change — always confirm against the official handbook. Read about how this guide is built. AskSia 是独立的学习辅助工具,与悉尼科技大学没有任何隶属、背书或赞助关系。课程信息可能变动,请始终以官方 handbook 为准。了解本指南的编写方法。