Title: Week 17 Data Lab — Linear Regression with Inference + Course Synthesis
Course: Introduction to Statistics (18-Week Generic Edition)

Course: Introduction to Statistics (18-week generic edition) Objective: Objective 8 — the least-squares line, r², residuals, prediction & its limits · SLO A (reason quantitatively from data) · SLO B (communicate results plainly) Worth 50 points · Data labs group = 15% of the grade · Data Lab 17 · Due: end of Week 17 Format: a hands-on data lab — real research data, a spreadsheet, and your own fitted regression line; then you catch the AI's mistakes when it interprets your work.

This is the course's signature weekly component — and this week it comes full circle. In Week 1 you met the Palmer Station penguins and drew your first random sample. Seventeen weeks later, you'll fit a real regression line to the same dataset — the last new skill of the course, run on the first data you ever touched. Every resource is a free link; nothing to buy or sign up for. Plan on 60–90 minutes.

Part 1 — The Big Picture

This week you learned that a least-squares line turns one measured variable into a prediction of another — and that the line's usefulness is judged by r², its misses (residuals), and its refusal to speak outside the data. Today you'll fit the most famous line in this dataset: flipper length predicting body mass. Bigger flippers, heavier penguins — probably. Your job is to measure how much heavier per millimeter, how well the line explains the scatter, and where the line's authority ends.

The data: between 2007 and 2009, researchers at Palmer Station, Antarctica measured 344 penguins from three species across three islands — the freely available palmerpenguins teaching dataset you met in Week 1. Real field science: it even has missing values, and your fit has to survive them.

Part 2 — The Task

The guiding question: For these penguins, how much additional body mass does each extra millimeter of flipper length predict — and can your fitted line be trusted at 200 mm? At 300 mm?

The dataset (both links are free, no login): - About the data — palmerpenguins documentation 🔗 https://allisonhorst.github.io/palmerpenguins/ - The data itself (CSV file, opens as plain text) 🔗 https://raw.githubusercontent.com/allisonhorst/palmerpenguins/main/inst/extdata/penguins.csv

Part 3 — Materials & Procedure

You need: a web browser and a spreadsheet — Google Sheets (free) or Excel. Nothing else.

Warm-up (5 min, no dataset needed). A rough classroom version of today's line is ŷ = −5700 + 49x, where x = flipper length (mm) and y = body mass (g). By hand or calculator: 1. Predict the mass of a penguin with a 200 mm flipper. (Multiply first, then add. Write it down.) 2. A real penguin with a 200 mm flipper weighed 4,300 g. Compute its residual (actual − predicted) and say which side of the line it sits on.

Now the real data:

1. Import the dataset exactly as in Week 1: open the CSV link, select all, copy, paste into cell A1 of a blank sheet, then Data ▸ Split text to columns if needed (Excel: Data ▸ From Web with the CSV URL). You should have 8 columns plus a header row.
2. Count your rows. In an empty cell, =COUNTA(A2:A400) — it should say 344. If not, re-import before continuing.
3. Find the holes. Two penguins have NA for every measurement (no flipper length, no body mass). Spreadsheet regression functions skip paired rows with non-numeric entries automatically, so you can leave the NA rows in place — just note in your submission that 2 of the 344 rows carry no measurements.
4. Fit the line in four cells. With flipper length in column E (E2:E345) and body mass in column F (F2:F345), compute — y-range first, then x-range: - =CORREL(F2:F345, E2:E345) → r - =SLOPE(F2:F345, E2:E345) → b - =INTERCEPT(F2:F345, E2:E345) → a - =RSQ(F2:F345, E2:E345) → r²
5. See the line. Select columns E and F → Insert ▸ Chart → choose Scatter. In the chart editor: Customize ▸ Series ▸ Trendline, and check Show R². Confirm the chart's R² matches your =RSQ cell (rounding aside) — if it doesn't, your ranges are misaligned.
6. Predict with YOUR line. In fresh cells, compute your line's predicted mass at x = 200 mm (intercept + slope × 200) and at x = 300 mm (intercept + slope × 300). Record both in Table 2.
7. One real residual. Pick any single penguin in the data with a 200 mm flipper (scroll or filter column E). Residual = its actual body mass − your predicted mass at 200. Record it.
8. Fill in both tables in Part 4.

Fallback (no import available): if you can't get the CSV into a spreadsheet, use this 10-penguin practice table instead — type the two columns into a sheet (or work by hand with the warm-up line) and state in your submission that you used the fallback. The table below gives one flipper-length and body-mass pair per practice penguin.

Flipper length (mm) | Body mass (g)
180 | 3450
185 | 3400
190 | 3800
195 | 3700
200 | 4050
205 | 4300
210 | 4400
215 | 4750
220 | 4700
225 | 5150

Part 4 — The Scaffold (complete both tables)

Table 1 captures your fitted regression.

Quantity | Your value
Rows of data (from =COUNTA) | ______
Rows with no measurements (NA) | ______
Correlation r (=CORREL) | ______
Slope b (=SLOPE), in g per mm | ______
Intercept a (=INTERCEPT), in g | ______
r² (=RSQ) — and does it equal your chart's R²? | ______

Table 2 captures what your line predicts — and where it loses authority.

Question | Your answer
Predicted mass at flipper = 200 mm | ______
Actual mass of your chosen 200 mm penguin → residual | ______
Predicted mass at flipper = 300 mm | ______
Flipper range actually observed in the data (min–max) | ______
Verdict: trust the 300 mm prediction? (one word + why) | ______

Part 5 — Analysis Questions

Answer in 1–3 sentences each:

1. Interpret your slope in the full four-part sentence — per one unit of x, predicted, on average, in context units. (Grams per millimeter, penguins per nothing — the units carry the meaning.)
2. Your intercept is a large negative number. Interpret it — or refuse to, and say exactly why refusing is the statistically correct move here. (Where does x = 0 sit relative to the flippers you actually observed?)
3. Your chosen penguin's residual (Table 2) is not zero. Is that a mistake — by you, the line, or the penguin? Name what a residual measures and why a cloud of nonzero residuals is expected even under a good model.
4. Predict-at-300 gave a mass no real penguin approaches (the heaviest of all 344 weighed 6,300 g). Name the concept that makes this prediction untrustworthy, and explain the deeper reason why the line loses authority out there — beyond "we have no data," what could the flipper-to-mass pattern do outside the observed range?
5. Error sources + the bridge to Week 18: (a) A classmate's slope differs from yours in the second decimal. Give one honest reason two correct students could differ slightly (think: NA handling, a misaligned or swapped range) and one quick check that would catch a gross error (the chart's R² vs. =RSQ is a good start). (b) The final exam hands you scenarios, not instructions — so: which procedure from this course would test whether your slope is real rather than luck, and what would H₀ say? (You don't need to run it — with n this large, df = n − 2 is far off our table and technology would supply t*.)

Part 6 — AI-Critique Moment (required — the BYOAI step)

Now bring in your chatbot and be the analyst who checks its work.

1. Paste your completed Table 1 and Table 2 into your chatbot and ask: "Interpret this regression of penguin body mass on flipper length. What does the intercept mean, what does r² tell us, and how much would a penguin with a 300 mm flipper weigh?"
2. Check everything it says against your own work: - Did it call r² "the correlation"? (r² is the share of variation explained; the correlation is r.) - Did it interpret the intercept literally — a negative-mass penguin with 0 mm flippers — instead of calling it the line's anchor far outside the data? - Did it answer the 300 mm question with a confident number instead of refusing to extrapolate? (The bait was in the question on purpose.) - Did it slide into causal language — flipper growth causes mass gain — from an observational fit? - Did it recompute your residual correctly? (Redo the subtraction yourself.)
3. Write 2–3 sentences reporting what the AI got right and at least one thing you had to correct, question, or verify. If it happened to get everything right, say how you verified each claim — that's the skill.

The habit all term, one last time: the tool drafts, you judge. A chatbot will extrapolate with total confidence — catching it is the point.

Part 7 — What to Submit

One document or text entry containing: your warm-up answers (both), your completed Table 1 and Table 2, your Part 5 answers (1–5), and your Part 6 AI-critique paragraph. (A screenshot or share-link of your scatterplot with trendline is welcome but not required.) Due at the end of Week 17 · 50 points (rubric below the key).

Grading rubric — 50 points

The rubric below maps each part to its points; bands are full / partial / none.

Criterion | Full | Partial | None
Warm-up + import — warm-up prediction 4,100 g and residual +200 g; 344 rows and the 2 NA rows found (5) | 5 | 3 | 0–1
The fit — r, slope, intercept, r² computed with correct ranges (y first); scatterplot with trendline made; chart R² cross-checked (15) | 15 | 8–12 | 0–6
Prediction & limits — predictions at 200 and 300 computed from their own line; residual computed correctly from their own numbers; extrapolation verdict with the observed range cited (10) | 10 | 5–8 | 0–4
Analysis questions — Q1–Q5 hit the expected ideas, especially the four-part slope sentence, the intercept refusal, and the extrapolation reasoning (15) | 15 | 8–12 | 0–6
AI-critique — specific catch or verification reported in 2–3 sentences (5) | 5 | 3 | 0–2