Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We will be using Google Sheets to simulate anormal distributionwith a mean of 200 and a standard deviation of 7. Please note there are five

We will be using Google Sheets to simulate anormal distributionwith a mean of 200 and a standard deviation of 7. Please note there are five parts to this question.'t forget to follow the directions in the Technology Corner for "Locking Random Numbers" after creating each sample.

First, generate a random sample of 18 data points from a normally distribution population (using the =norminv command in Google Sheets). Create a histogram where the first bin starts at 180.75 (Horizontal Axis >> Min) and the width of each bin is 3.5 (Histogram >> Bucket Size). Save that histogram as an image file and attach it here. (Please note that even though there is a drop-down for Bucket Size, you can type the value you want.)

Second, generate a random sample of 65 data points from a normally distribution population (using the =norminv command in Google Sheets). Create a histogram where the first bin starts at 180.75 and the width of each bin is 3.5. Save that histogram as an image file and attach it here

Next, generate a random sample of 280 data points from a normally distribution population (using the =norminv command in Google Sheets). Create a histogram where the first bin starts at 180.75 and the width of each bin is 3.5. Save that histogram as an image file and attach it here.

Then, generate a random sample of 2000 data points from a normally distribution population (using the =norminv command in Google Sheets). Create a histogram where the first bin starts at 180.75 and the width of each bin is 3.5. Save that histogram as an image file and attach it here.

In as much detail as possible, explain what you've noticed as the sample size increased. You should address the distribution of the sample..

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probability And Statistics For Engineering And The Sciences

Authors: Jay L. Devore

9th Edition

1305251806, 978-1305251809

Students also viewed these Mathematics questions