Ablls-r

5 results

AP Statistics LSRL Activity - Is LSRL appropriate?

Created by

Just because r is strong, does that mean you can use a LSRL? This activity guides students to use excel/ google sheets to 1. Graph scatterplots with trend lines/ labels 2. Use XLMinter ToolPak to identify key statistics in linear regression analysis 3. Identify and interpret R, R^2, S 4. Graph and see residual plots 7. Compare key statistics in four data sets to determine which is most appropriate to use LSRL. This file was originally created as a google sheet. A sample answer key is included. T

11th - 12th

Math, Statistics

CCSS

HSS-ID.B.6b

, HSS-ID.B.6c

, HSS-ID.C.8

2-Day Flipped Classroom Lesson: Linear Regression

Created by

Jonathan Schillace

This 2-day lesson contains several java manipulatives and instructional videos from Khan Academy to help students in 9th grade Algebra to understand the concepts behind linear regression, r values and r-squared values. You must develop your own in class activities but this document contains the "homework."

8th - 9th

Algebra, Statistics

CCSS

HSS-ID.B.6

, HSS-ID.C.7

Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets

Created by

Holland Math

This project incorporates spreadsheets with scatter plots and lines of best fit. It asked students to perform various regressions, such as linear, power, exponential, and logarithmic, The students are asked to generate an model to help park rangers determine the weight of black bears by using only one of three measures, neck girth, length, and chest girth. Calculating the bears weights allow the rangers to anesthetize them in order for them to care for the bears. The r values in this project

9th - 12th

Algebra 2, Math, Statistics

Probability Experiments Spreadsheet

Created by

STEM with Josh

🎲 Probability Simulations – Interactive Excel for Coins & Dice (VBA Macros)Description:Bring probability to life with this interactive, macro-enabled Excel simulation! Designed for Grades 5–10, this resource lets students explore theoretical and experimental probability using coins, dice, and combinations of both. Perfect for classroom demonstrations, assignments, or student-led investigations! See it in action by clicking on the video link in the previews or click here - https://youtu.be/5

Not Specific

Math, Statistics

CCSS

7.SP.C.7

, 7.SP.C.7b

Social Security/Private Fund Benefit Comparison Project

Created by

Thomas R Eddlem

This project for an Economics, Accounting or Statistics class utilizes public information on the Internet (including the Social Security Administration website) to compare Social Security benefits with a comparably-funded private retirement account. All of the instructions and tables are provided in the attached Excel-format spreadsheet, other than data that needs to be culled directly from the Social Security Administration website (and instructions on how to pull that data is provided). Th

11th - 12th, Higher Education

Economics , Social Studies, Statistics