I need someone to help answer these questions in Excel so I can understand the formulas. Explanation of how you
came to your answers would be extremely useful as well. Thanks (:
- Item A in the description of the data collection instrument lists variables 1-5, which represent the respondent's general attitude toward each of the five boroughs. Each of these variables has numerically equal distances between the possible responses, and for purposes of analysis they may be considered to be of the interval scale of measurement.
- Determine the point estimate, and then construct the 95% confidence interval for μ1 = the average attitude toward Manhattan.
- Repeat part (a) for μ2 through μ5, the average attitudes toward Brooklyn, Queens, The Bronx and Staten Island, respectively.
2.Given the breakdown of responses for variable 6 (highest level of education), determine the point estimate, and then construct the 95% confidence interval for p6 = the population proportion of doctoral degrees.
3.Given the breakdown of responses for variable 7 (marital status of respondent), determine the point estimate, and then construct the 95% confidence interval for p7 = the population proportion in the "single or other" category.
4.Assume the governmental agencies requested estimates of the mean attitudes towards each borough with a margin of error of 0.05 for each borough. If the governmental agency personnel want to have 95% confidence that the sample mean will fall within this margin of error, how large should the sample sizes be for each borough?