Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3a. In this problem, we would learn how to generate the sampling distribution of a statistic using Excel. Generate 200 samples each of sample size

3a. In this problem, we would learn how to generate the sampling distribution of a statistic using Excel. Generate 200 samples each of sample size 40 from a normal distribution with a mean of 3 and standard deviation of 5. Please use 1370 as a random seed. Now take the mean of each sample (so, you will get 200 means, one for each of the 200 samples). Plot a histogram of these 200 means using 7 bins. Obtain the counts for each of the bins. Normalize these counts to 1 (by calculating Counts/sum of all Counts for each bin). Normalized counts sum to 1 and therefore they can be (approximately) thought of as probabilities. This is an approximate way of constructing the sampling distribution of the mean.

3b. Please submit the histogram which you have generated above.

3c. Now, please fill in the table below:

Table for problem 3

What is the population mean?

What is the population standard deviation?

What is the mean of sampling distribution of means?

What is the standard deviation of the sampling distribution of means?

What is the standard error?

you dont have to fill out the table if you dont want to, but please help me with the excel instructions. I have been watching YouTube videos all day and nothing is helping. please help.

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

Precalculus

Authors: Michael Sullivan

10th Global Edition

1292121772, 1292121777, 978-1292121772

More Books

Students also viewed these Mathematics questions

Question

What are the steps the NLRB follows in a representation election?

Answered: 1 week ago

Question

=+d) Find a 95% confidence interval for the mean difference.

Answered: 1 week ago

Question

=+a) Using the data provided, check the conditions for this test.

Answered: 1 week ago