19 results
High school statistics projects for Microsoft Excel
Statistics Correlation and Regression Project for Movie "Moneyball" (5 day)
Prerequisite: Correlation and Regression (Linear). This is a project that divides a statistics class into 6 groups and students do ACTUAL data collection from given websites and they perform their OWN ANALYSIS. They will use computers/internet/excel/spreadsheets/graphing calculators to evaluate correlation. If you have interest in baseball and statistics, this is a great project to get the class interested, and covers about 5 days, plus you can watch the movie "Moneyball" afterwards as a reward.
Subjects:
Grades:
10th - 12th, Higher Education, Adult Education
Types:
Excel Projects for Statistics Frequency Distributions and Charts
This file contains three different projects with solutions and a quick reference card for students. It correlates to Bluman's Elementary Statistics textbook.
First is an Introduction to Excel. There is an example, guided practice and then 4 Projects. The instructions are on each sheet. The topics covered are: basic editing and formatting, beginning charts, beginning formulas, such as SUM and AVERAGE, and calculations. There is an editable grading rubric for this project. The Preview file
Subjects:
Grades:
8th - 11th, Higher Education, Adult Education
Types:
Real World Data for Statistical Analysis and Infographic Project
Give your students access to real world data for your statistical analysis unit or data literacy! Dive into statistics with Microsoft Excel™ or Google Sheets™ and years of data. Learn how to use standard deviation, mean or median to interpret data. Choose the best graphs to display conclusions in an infographic. Works great for science fairs! ✔ Includes an infographic project! (Template, expectations, and rubric). ✔ Everything is fully editable and you and your students can even use the images
Grades:
9th - 12th
Types:
CCSS:
Presidential Data Analyst Math Project | Excel | Presentations | Presidents Day
Elevate your Presidents' Day lesson plans with this comprehensive Presidential Data Analysis Math Project, designed to engage students in a deep exploration of U.S. presidential history through mathematical analysis. This invaluable resource provides educators with everything they need to guide their students through a dynamic and informative project that combines historical research with mathematical concepts.**Key Features:**1. **Thematic Relevance:** - Aligned with Presidents' Day, this o
Subjects:
Grades:
7th - 10th
Water Balloon Catcher Project - Data and Graphing - Mathematics
Transform your maths classroom into a dynamic hub of learning with this captivating data and graphing project! Designed for upper primary/middle school students, this hands-on and inquiry-based activity ensures an immersive experience in mastering data interpretation, chart creation, and understanding the role of data and graphs in advertising.In this engaging project, students will: Explore Data: Collaborate in teams to design and construct a Water Balloon Catcher using recycled materials, each
Subjects:
Grades:
5th - 9th
Types:
Statistics Project Unit 3 Spreadsheets Mean Median Mode Std. Deviation (2 day)
This is a 1-2 day project aimed at introducing a statistics class to Excel (or Numbers) who are familiar with Pie Charts, Bar Charts, Measures of Central Tendency, and Standard Deviation. The students will input data (included) into Excel (on fires in restaurants), form their own Bar Charts and Pie Charts, and be able to input formulas into the Excel to automatically calculate statistics. Students will be given the opportunity to explore different charts and design their charts to make them colo
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Statistics Unit 8 Project - Surveys, Confidence Intervals, Spreadsheets (3 days)
This is an end-of-unit project with Confidence Intervals for a Statistics class. Students will work together to create a survey, gather real-world data, create a spreadsheet, perform a confidence interval analysis to estimate the population mean μ, and create a Powerpoint presentation to present to class. The Product includes: Instructions for studentsTeacher instructions Excel spreadsheet with samplesGrading Rubric *The topics covered are Confidence Intervals, T-distribution, spreadsheets, pres
Subjects:
Grades:
10th - 12th, Higher Education
Types:
CCSS:
Statistics Unit 1 Project - Gathering Data (3 days)
This is an end-of-unit project for a Statistics class. It is introductory into survey methods, gathering data, using spreadsheets to organize data, creating charts, and presenting findings to the class. The Product includes: Instructions for studentsTeacher instructions for guidance on use and editingExcel spreadsheet with samplesGrading Rubric *The topics covered are survey methods - simple random, stratified, convenience, cluster, systematic - spreadsheets, charts, and presentations. The docum
Subjects:
Grades:
10th - 12th, Higher Education
Types:
AP Statistics LSRL Activity - Is LSRL appropriate?
Just because r is strong, does that mean you can use a LSRL?This activity guides students to use excel/ google sheets to1. Graph scatterplots with trend lines/ labels2. Use XLMinter ToolPak to identify key statistics in linear regression analysis3. Identify and interpret R, R^2, S4. Graph and see residual plots7. 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.There are
Subjects:
Grades:
11th - 12th
Types:
CCSS:
Bell Curve versus Boxplot
Students complete a formative assessment using data from Los Angeles County's Homicides and Gang-Related Homicides for the years 1985 through 2001. Students should know how to determine what data set to choose for each type of graph. Objectives included in the project are:
Create a bell curve and label properly.
Create a boxplot in Excel and label properly.
Determine z-scores for 4 years.
Determine percentages above and below a "test value".
Write a 2 page analysis.
Answer Key (Excel Spreadsh
Subjects:
Grades:
11th - 12th
Types:
Sports or Movies Excel Mini Project
Students will have the opportunity to choose between researching movies or sports players. They will use the data that they find to practice the basics of Excel:
-typing in cells
-formatting cells (italicized, bold, rounding, etc.)
-using basic functions for calculations (minimum, maximum, average)
-creating a graph
Check out my other personal finance products:
Cars and Colleges Excel Mini ProjectCritiquing BudgetsDeceptive Advertising ProjectIdentity Theft ProjectNo Money Mo Problems Credit
Subjects:
Grades:
9th - 12th
Types:
Excel Probability/Statistics Task - Biased Coin Simulator
Allow students to explore probability distributions and statistical sampling in real-time with this Biased Coin Simulator Task. Students will also develop strong ICT skills as they get the opportunity to create and test their own copy of this simulator in a Microsoft Excel Macro-Enabled Workbook.The SimulatorIn the Biased Coin Simulator the probability of the coin landing on heads can be adjusted to any value between 0 and 1. The Bernoulli trial of flipping the coin is repeated (the simulator ca
Grades:
9th - 12th
Types:
Stock Market Project plus Graphing and Data Recording
This is a project that I use in my classroom to teach students how the stock market works and what the data looks like after a period of at least three months. Students record data findings weekly, and after a period of at least twelve weeks, the graph their findings. This is useful in illustrating how the stock market goes up and down with the events that are happening throughout the world.
Subjects:
Grades:
11th - 12th
Types:
Overview of Mr. Bill's Store
I learned many years ago that the most effective way of keeping math engaging for students is through SELECTIVE PROBLEM SOLVING. All kinds of problem solving...not just traditional "solve this equation" problems. I will offer teachers ideas for keeping kids excited about math. Such as...building a probability distribution of outcomes from throwing dice...constructing a pendulum that will draw Lissajous figures...constructing a Foucault pendulum...how to do interesting large-scale astronomical
Subjects:
Grades:
5th - 12th
Types:
Excel Statistics Task - Australian Water Consumption
Dive deep into the waters of data analysis with this engaging Microsoft Excel activity focused on Australian water consumption! Sourced from the Australian Bureau of Statistics, students will navigate through real-world datasets from 2014-15 to 2020-21, equipping them with skills that extend beyond the classroom. What's Included:Interactive Spreadsheet: An authentic spreadsheet titled "Water Account, Australia (2020-21)" filled with key indicators for water consumption and use.Guided Instruction
Grades:
7th - 12th
Types:
Data Analysis Review Project for A.P. Statistics
This project reviews the data analysis unit for A.P. Statistics. Data collected from students will be their height and shoe size. The file includes the project description page to be handed to students along with a rubric. Included are the step-by-step Excel directions on analyzing the data and creating histograms. The project also includes an investigation on the correlation between height and shoe size. This portion of the project may work for Algebra 2 teachers wishing to review the least squ
Subjects:
Grades:
10th - 12th, Higher Education
Types:
Excel Data Analysis Project
This mini Project covers the concepts of scatterplots and linear regression lines using data analysis in Excel. The project introduces the concepts of scatterplots and lines of best fit, has students work through a basic analysis of a data set using Excel, then has students complete a more complex analysis of a baseball data set. I created this for my standard 8th grade math class to cover CCSSM.8.SP.1, CCSSM.8.SP.3, MP.4, and MP.5 in an engaging and practical way. I had students working in pair
Monty Hall Project
Need a project to help your students with excel and probability? I've got you covered! Use this Monty Hall Project to help students make predictions, record data, and reflect on their process. Have students work individually or together and customize the project to your liking!
Subjects:
Grades:
7th - 12th
Types:
Olympic Medal Data for "Predicting Tokyo Olympics" Activity
This data is used for this product: Predicting Tokyo Olympics
Subjects:
Grades:
8th - 10th
Types:
Showing 1-19 of 19 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands