Part 1
Use the random sampling method explained in the Instructor Perspective of Module 3 to
generate a random sample of size 45 from the given population. Then complete Table A in
the Q1 worksheet.
Part 2
Copy the sample obtained in Part 1 into the designated cells in the Q2 worksheet and
complete the following analysis of the data.
1. Complete Table A in the Q2 worksheet.
2. Use the sample to create 92%, 96% and 98% confidence intervals for the population
mean in the designated cells in Table B of the Q2 worksheet.
3. For each of the confidence intervals in step 2, use the information in Tables A and B
to determine the sample size needed to estimate the population mean to within .05
units. Do this in Table C of the Q2 worksheet.
In your report, explain your solution procedures and findings. Explain whether any of the
confidence intervals created in Step 2 does not contain the population mean.
Part 3
1. Use the random sampling method explained in the Instructor Perspective of Module 3
to generate a random sample of size 25 from the given population. Then complete Table
A in the Q3 worksheet.
2. Use the sample to create 92%, 96% and 98% confidence intervals for the population
mean in the designated cells in Table B of the Q3 worksheet.
In your report, explain your solution procedures and findings. Explain whether any of the
confidence intervals created in Step 2 does not contain the population mean.
Part 4
1. Use the random sampling method explained in the Instructor Perspective of Module 3
to generate a random sample of size 150 from the given population. Then complete
Table A in the Q4 worksheet.
2. Calculate the sample proportion of counties whose international migration rate (per
1000) is greater than 2 in cell I2.
3. Complete Table A in the Q4 worksheet.
4. Complete Table B, by using the sample to create a 90%, a 95%, and 99% confidence
intervals for the population proportion of counties whose international migration rate
(per 1000) is greater than 2 in the designated cells.
5. Complete Table C by determining the minimum sample size needed to estimate the
population proportion of interest to within 8%. Do this for each confidence interval
above. Assume that there is no prior knowledge about the proportion of counties whose
international migration rate (per 1000) is greater than 2.
6. Complete Table D.
In your report, explain your solution procedures and findings and state whether any of the
confidence intervals created in Step 4 above does not contain the population proportion of
interest.
Part 5
1. Use the random sampling method explained in the Instructor Perspective of Module 3
to generate a random sample of size 22 from the given population.
2. Complete Table A in the Q5 worksheet.
3. Use the sample to create 92%, 96% and 98% confidence intervals for the population
variance and standard deviation in the designated cells in Table B of the Q5 worksheet.
In your report, explain your solution procedures and findings. Explain whether any of the
confidence intervals created for the population standard deviation in Step 2 above does not
contain the population standard deviation.
Part 6
Use created sample in Q1 to test the hypothesis that the average migration rate (per 1000)
in the population is greater than 1. Use alpha = 0.05. Place results in the Q6 worksheet.
In your report, explain your hypothesis testing methods, procedures, and findings. In
particular, describe the meaning of the calculated P-value in the context of this problem.
Part 7
Use created sample in Q3 to test the hypothesis that the population average migration rate
(per 1000) is less than 1.5. Use alpha = 0.02. Place results in the Q7 worksheet.
In your report, explain your hypothesis testing methods, procedures, and findings.
Part 8
Use your created sample in Q4 to test the hypothesis that less than 20% of the US counties
have a migration rate that is higher than 2 (in 1000). Use alpha = 0.03. Place results in the
Q8 worksheet.
In your report, explain your hypothesis testing methods, procedures, and findings.
Part 9
Use your created sample in Q5 to test the hypothesis that the standard deviation of the
population emigration rates (in 1000) is different from 1.2. Use alpha = 0.05. Place results
in the Q9 worksheet.
In your report, explain your hypothesis testing methods, procedures, and findings.
The report should include all your findings along with important statistical issues. The report should follow the following format: (i) Introduction (ii) Analysis (iii) Conclusion
WhatsApp us