Please see attached excel sheet. Also below is the link to the free book for reference. (I would start there!) The question is on Page #308. Thanks.
https://www.xn--klker-kva.hu/wp-content/uploads/2013/03/Introduction-to-Business-Statistics-7th-Edition-2008.pdf
1. Item C in the description of the data collection instrument lists variables 7, 8, and 9, which represent the respondent's general attitude toward each of the three shopping areas. 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.
a. Determine the point estimate, then construct the 95% con?dence interval for µ7 = the average attitude toward Springdale Mall. What is the maximum likely error in the point estimate of the population mean?
b. Repeat part (a) for µ8 and µ9, the average attitudes toward Downtown and West Mall, respectively.
2. Given the breakdown of responses for variable 26 (sex of respondent), determine the point estimate, then construct the 95% con?dence interval for π26 = the population proportion of males. What is the maximum likely error in the point estimate of the population proportion?
3. Given the breakdown of responses for variable 28 (marital status of respondent), determine the point estimate, then construct the 95% con?dence interval for π28 = the population proportion in the "single or other" category. What is the maximum likely error in the point estimate of the population proportion?
Attachment:- data.xlsx