Discover insights, ideas, and tips from our latest articles.
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.
Lesson planning, grading, and organizing materials can take up hours of precious time. Having ready-to-use resources means less stress and more space to focus on students. With the right tools, teachers can spend their energy on what matters most: inspiring a love of math and helping every learner succeed.
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.
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.
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.
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.
To start your free trial, please log in to your account.