Assignments

Lab 5 — Statistical Analysis & Regression

Due

Sunday of Week 11, 23:59

Released

Week 11

Weight

Part of 20% Participation & Homework

CLOs

3, 6

Goal

Use Excel's built-in statistical tools (Analysis ToolPak) to test a hypothesis and build a regression model from your project dataset. The emphasis is on interpreting output, not on computation: given the ToolPak tables, what can you claim about the data?

Prerequisites

Enable the Analysis ToolPak: File → Options → Add-ins → Excel Add-ins → Go → check "Analysis ToolPak" → OK. Confirm that Data → Data Analysis appears.

Data

Statistical analysis dataset from Google Drive, or your own project dataset (preferred — use what your group has cleaned).

Tasks

Part A — Descriptive statistics with ToolPak

Run Data → Data Analysis → Descriptive Statistics on your main numeric variable. Check "Summary statistics" and "Confidence Level for Mean". Output to a new sheet.

Interpret: what does the standard error tell you? What is the 95% confidence interval for the mean?

Part B — Correlation

Use Data → Data Analysis → Correlation on two or three numeric variables. Produce the correlation matrix.

State: which pair has the strongest linear relationship? Is the correlation positive or negative? Is it practically meaningful (|r| > 0.5)?

Part C — Simple linear regression

Use Data → Data Analysis → Regression to regress one numeric outcome (Y) on one numeric predictor (X).

Read the output table and report:

1. The regression equation (Ŷ = b₀ + b₁X).
2. R² and its interpretation.
3. The p-value for the slope coefficient. Is it statistically significant at α = 0.05?
4. One residual plot interpretation: is the residual vs fitted plot random, or does it show a pattern?

Part D — Hypothesis test (t-test or ANOVA)

Choose one:

Option 1 (t-test): Test whether the mean Amount differs between two regions (e.g. North vs South). Use Data → Data Analysis → t-Test: Two-Sample Assuming Unequal Variances. State H₀ and H₁, report p-value, state your conclusion at α = 0.05.

Option 2 (ANOVA): Test whether mean Amount differs across all four regions. Use Data → Data Analysis → ANOVA: Single Factor. Report the F-statistic and p-value, interpret.

Submission

Submit one Excel workbook (.xlsx) containing:

• Descriptive Statistics, Correlation, Regression, and t-test/ANOVA ToolPak output on separate sheets
• A summary interpretation sheet (1 page) answering all interpretation questions in plain English
• The regression equation, R², p-value, and your conclusion stated clearly

Group Progress Report 5 is also due this week. Submit separately:

• Statistical hypotheses formulated for your project
• Analysis results (correlation, regression, or relevant tests)
• Interpretation of findings in context of your research problem (3–4 pages + Excel file)