Data Analytics

Your college or university wishes to obtain reliable information about student perceptions of administrative communication. Describe how to design a sampling plan for this situation based on your knowledge of the structure and organization of your college or university. How would you implement simple random sampling, stratified sampling, and cluster sampling for this study? What would be the pros and cons of using each of these methods?

Q 6.2 (2 pts): Number the rows in the Excel file Credit Risk Data to identify each record (already done for you). The bank wants to sample from this database to conduct a more detailed audit. Use the Excel Sampling tool to find a simple random sample of 20 unique records.

Q 6.7 (1 pt): Based upon extensive data from a national high school educational testing program, the standard deviation of national test scores for mathematics was found to be 120 points. If a sample of 225 students are given the test, what would be the standard error of the mean?

Q 6.9 (2 pts): Suppose that the mean score for the mathematics test cited in Problem 7 is 610. What is the probability that a random sample of 225 students will have a mean score of more than 625? Less than 600?