Do some Excel Work

Points are also be based on quality of presentation. If your lab is difficult for me to follow, points will be lost. Keep in mind you are the statistician explaining it to others. I also want to see a print of your Excel commands. 1) Part A) Conduct a census with a population of seven individuals by creating a categorical survey question such that the response variable is binomial having only two values like yes or no, male or female, happy or unhappy, blue or red, etc. Express the response distribution. State the variable, its values, and how often the variable’s values occur (relative frequency). Display the distribution in table and bar graph form. Part B) Write all possible random samples (SRS) using a sample size of four. Compute all the sample proportions using the data from your census. Then take the average of all the statistics and compare it to the population proportion to confirm they equal. Part C) Express the sampling distribution. State the variable, its values, and how often the variable’s values occur (relative frequency). Display the distribution in table and bar graph form.