Skip to navigation Skip to content
eMATHinstruction

  • $0.00 0 items
  • For Students
    • N-Gen Math™ 6
    • N-Gen Math™ 7
    • N-Gen Math™ 8
    • N-Gen Math™ Algebra I
    • Common Core Algebra I
    • Common Core Geometry
    • Common Core Algebra II
    • Algebra 2 + Trigonometry
  • For Teachers
    • N-Gen Math™ 6
    • N-Gen Math™ 7
    • N-Gen Math™ 8
    • N-Gen Math™ Algebra I
    • Common Core Algebra I
    • Common Core Geometry
    • Common Core Algebra II
    • Algebra 2 + Trigonometry
    • Standards Alignment
  • Shop
    • N-Gen Math™ 6
    • N-Gen Math™ 7
    • N-Gen Math™ 8
    • N-Gen Math™ Algebra I
    • N-Gen Math™ Geometry
    • Common Core Algebra I
    • Common Core Geometry
    • Common Core Algebra II
    • Algebra 2 + Trigonometry
    • Efofex
    • eMATH Merch
  • About Us
    • Who We Are
    • What We Do
    • FAQs
      • General eMath Instruction
      • Videos
      • Memberships
      • Books
      • School Orders
      • New York City DOE Orders
      • Sign-Up Codes
    • Contact Us
  • Blog
  • Success Stories
    • Case Studies
    • Testimonials
    • Reviews
  • My Account
  • For Students
    • N-Gen Math™ 6
    • N-Gen Math™ 7
    • N-Gen Math™ 8
    • N-Gen Math™ Algebra I
    • Common Core Algebra I
    • Common Core Geometry
    • Common Core Algebra II
    • Algebra 2 + Trigonometry
  • For Teachers
    • N-Gen Math™ 6
    • N-Gen Math™ 7
    • N-Gen Math™ 8
    • N-Gen Math™ Algebra I
    • Common Core Algebra I
    • Common Core Geometry
    • Common Core Algebra II
    • Algebra 2 + Trigonometry
    • Standards Alignment
  • Shop
    • N-Gen Math™ 6
    • N-Gen Math™ 7
    • N-Gen Math™ 8
    • N-Gen Math™ Algebra I
    • N-Gen Math™ Geometry
    • Common Core Algebra I
    • Common Core Geometry
    • Common Core Algebra II
    • Algebra 2 + Trigonometry
    • Efofex
    • eMATH Merch
  • About Us
    • Who We Are
    • What We Do
    • FAQs
      • General eMath Instruction
      • Videos
      • Memberships
      • Books
      • School Orders
      • New York City DOE Orders
      • Sign-Up Codes
    • Contact Us
  • Blog
  • Success Stories
    • Case Studies
    • Testimonials
    • Reviews
  • My Account
Home / Algebra II / Google Sheets for CC Alg II Statistical Simulation – by Kirk

Google Sheets for CC Alg II Statistical Simulation – by Kirk

Posted on April 20, 2016February 16, 2021

As many of you know eMATHinstruction offers online apps for performing the statistical simulations required in Common Core Algebra II. You can find links to those simulators at this post of mine:

Statistical Simulations and Inferential Statistics – by Kirk

The simulators work like a charm and I explain how to use them as well as how to use our TI based calculator programs in this YouTube video:

YouTube – Statistical Simulation Programs from eMATHinstruction

One of the things I mention in the video is using Google Sheets to analyze the results of the simulations. Google Sheets is super convenient to use given that everyone has access to it. I also find it is much, much easier to use than Excel in terms of creating distribution histograms of the simulation results. Here’s a distribution of 1000 sample means that I created just now:

Histogram

I show how to create these in the video. But, now I’ve created three Google Sheets for the simulators that people can just copy and paste their data into. I’ll give a links in a second. One of the nice things is that it will report the mean of the results, the standard deviation of the results, the 2.5% percentile, the 5% percentile, the 95% percentile, and the 97.5% percentile (hopefully you know why these are good to have). Here’s what a screen shot looks like:

NormSamp Screen

As always, click on the images to see them much more clearly. Then hit the back arrow to come back to the article.

Anyhow, I’m going to supply links to all of these sheets. Now, and this is key, we don’t want to make it so that everyone is sharing and editing the same Sheet. So, I’m going to make the links “View Only.” All you have to do to have them all for yourself is make a copy:

Screenshot 2016-04-19 20.43.00

Then, give it a cool new name and, as all things Google, it will magically now be in your Google Drive (assuming you have a Google account).

Screenshot 2016-04-19 20.44.01

O.k. Here are the links to all of the Google Sheets:

Normal Sample (NORMSAMP) Google Sheet

Proportion Simulator (PSIMUL) Google Sheet

Difference in Sample Means (MEANCOMP) Google Sheet

Have fun with them. If you are going to share the links with students, consider making copies on your own drive and then sharing them from there.

Categories: Algebra II, Math Education Discussion, Teacher Submitted Resources - All Access

Post navigation

Previous post: CC Algebra II – 3rd Quarter Exam – by James Sposato
Next post: New CC Algebra II Statistics Videos – by Kirk
Categories
Archives
LEGAL:

Privacy Policy

Terms and Conditions

Data Security Measures

Single User License Agreement

CONTACT:

Contact Us

(845) 287-0201

[email protected]

SCHOOL ORDERING:
  • Fax: (845) 758-6717
  • Email: [email protected]
  • Current Price List
  • Sole Source Letter
CONNECT:

Like us

Follow us

Subscribe to us

© eMATHinstruction 2023
  • My Account
  • Search
  • Cart 0
We use cookies to offer you a better browsing experience, analyze site traffic, and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.

WHY. We are a small, independent publisher founded by a math teacher and his wife. We believe in the value we bring to teachers and schools, and we want to keep doing it. We keep our prices low so all teachers and schools can benefit from our products and services. We ask that you help us in our mission by reading and following these rules and those in our Single User License Agreement. 

When you use this site, you are agreeing to comply with these Terms & Conditions and our Single User License Agreement. 

PLEASE, NO SHARING. We know it’s nice to share, but please don’t share your membership content or your login or validation info. Your membership is a Single User License, which means it gives one person – you — the right to access the membership content (Answer Keys, editable lesson files, pdfs, etc.) but is not meant to be shared.

  • Please do not copy or share the Answer Keys or other membership content.
  • Answer keys are for teacher use only and may not be distributed to students.
  • Please do not post the Answer Keys or other membership content on a website for others to view. This includes school websites and teacher pages on school websites.
  • You can make in-house photocopies of downloaded material to distribute to your class.  You may not pay any third party to copy and or bind downloaded content.  You may not send out downloaded content to any third party, including BOCES districts, to copy and or bind downloaded content. You may not publish or compile downloaded content into the digital equivalent of a bound book. 
  • You may distribute downloaded content digitally to your class only through password protection or enclosed environments such as Google Classroom or Microsoft Teams.
  • If you are a school, please purchase a license for each teacher/user.

PLEASE RESPECT OUR COPYRIGHT AND TRADE SECRETS. We own the copyright in all the materials we create, and we license certain copyrights in software we use to run our site, manage credentials and create our materials; some of this copyrighted software may be embedded in the materials you download. When you subscribe, we give you permission (a “Single User License”) to use our copyrights and trade secrets and those we license from others, according to our Terms & Conditions. So in addition to agreeing not to copy or share, we ask you:

  • Please don’t reverse-engineer the software or printed materials.  This includes copying or binding of downloaded material, on paper or digitally.
  • Please don’t change or delete any authorship, copyright mark, version, property or other metadata.
  • Please don’t try to hack our validation system, or ask anyone else to try to get around it.
  • Please don’t put the software, your login information or any of our materials on a network where people other than you can access it.
  • Please don’t copy or modify the software or membership content in any way unless you have purchased editable files.
  • If you create a modified assignment using a purchased editable file, please credit us as follows on all assignment and answer key pages:

“This assignment is a teacher-modified version of [eMATH Title] Copyright © 201x eMATHinstruction, LLC, used by permission”

FEEDBACK REQUESTED. We value your feedback about our products and services. We think others will value it, too. That’s why we may do the following (and we ask that you agree):

  • Use your feedback to make improvements to our products and services and even launch new products and services, with the understanding that you will not be paid or own any part of the new or improved products and services (unless we otherwise agree in writing ahead of time).
  • Share your feedback, including testimonials, on our website or other advertising and promotional materials, with the understanding that you will not be paid or own any part of the advertising or promotional materials (unless we otherwise agree in writing ahead of time).

SATISFACTION GUARANTEED. If you are not 100% satisfied, we will refund you the purchase price you paid within 30 days. To get a refund:

  • Within 30 days of your purchase,
  • Delete the software and all membership content from all your computers, destroy all photocopies or printouts of our materials and return all tangible copies (disks, workbooks, etc) and other materials you have received from us to:

eMATHinstruction Returns Department
10 Fruit Bud Lane
Red Hook, NY 12571

TECHNICAL SUPPORT: If you are having trouble logging in or accessing your materials, or if your downloaded materials won’t open or are illegible, please notify us immediately by email at [email protected] so we can get it fixed.

NO WARRANTY. We believe in the quality and value of our products and services, and we work hard to make sure they work well and are free of bugs. But that said, we are providing our products and services to you “as is,” which means we are not responsible if something bad happens to you or your computer system as a result of using our products and services. For our full Disclaimer of Warranties, please see our Single User License Agreement  Here.

DISPUTES. If we have a dispute that we cannot resolve on our own, we will use mediation before filing a lawsuit in a regular court (except that we can use small claims court). Mediation means we will each present our case to one or more professional mediators who are chosen and paid by all parties to the dispute, and the mediator(s) will work with us to find a fair resolution of our dispute. Mediation is a faster and less formal way of resolving disputes and therefore tends to cost less.

  • If you have a dispute, please send a letter requesting dispute resolution and describing your claim to:

Emath Instruction Inc.
10 Fruit Bud Lane
Red Hook, NY 12571

LIMITATION OF LIABILITY. If you do win a case against us, the most you can recover from us is the amount you have paid us.

To read the Single User License Agreement, please click HERE. These Terms & Conditions present some of the highlights  of the Single User License Agreement in plain English, but it’s a good idea to look at the complete Single User License Agreement, too, because by checking the box below and proceeding with your purchase you are agreeing to both these Terms & Conditions and the Single User License Agreement.

Terms and Conditions

Thank you for using eMATHinstruction materials. In order to continue to provide high quality mathematics resources to you and your students we respectfully request that you do not post this or any of our files on any website. Doing so is a violation of copyright. Using these materials implies you agree to our terms and conditions and single user license agreement.

Members Only

The content you are trying to access requires a membership. If you already have a plan, please login. If you need to purchase a membership we offer yearly memberships for tutors and teachers and special bulk discounts for schools.

Login or Purchase Membership
Teachers Only

Sorry, the content you are trying to access requires verification that you are a mathematics teacher. Please click the link below to submit your verification request.

Complete Verification