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:

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:

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:

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).

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.

Terms and Conditions

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 complying with these Terms & Conditions.

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.
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 copies of the Answer Keys to hand out to your class, but please collect them when the students are finished with them.
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; and please don’t change or delete any authorship, 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 eMath Instruction, 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:

eMath Instruction 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 Legalese version of these Terms & Conditions Here.

DISPUTES. If we have a dispute that we cannot resolve on our own, we will use Binding Arbitration instead of filing a lawsuit in a regular court (except that you can use small claims court). Binding Arbitration means our case will be decided by one or more arbitrators who are chosen and paid by all parties to the dispute. Arbitration is a faster and less formal way of resolving disputes and therefore tends to cost less.

To begin an arbitration proceeding, please send a letter requesting arbitration 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 see the Legalese version of our Terms & Conditions, please click HERE. We’ve given you the highlights above, in plain English, but it’s a good idea to look at the Legalese, too, because by checking the box below and proceeding with your purchase you are agreeing to both the English and Legalese.