Continue the Springdale Shopping Survey at the end of Chapter 9 in the Integrated Cases section in …

Continue the Springdale Shopping Survey at the end of Chapter 9 in the Integrated Cases section in Introduction to Business Statistics. You will again need the dataset given in Module 1 labeled SHOPPING.Write a short report that includes an introduction, a conclusion paragraph and a body which answers fully the three questions posed in the problem. Please include any tables of calculations and graphs associated with this problem in the body. It should be double-spaced and in APA style format per the Guide to Writing and APA Requirements.NOTE: You will need to type the equations from the chapter into Excel cells to perform the calculations that are required. Sometimes there will be functions in Excel you can use for shortcuts, other times you will have a long formula you need to type in.

The case in Chapt 2 listed 30 questions asked of 150 respondents in the community of Springdale. The coding key for the responses was also provided in that earlier exercise. The data are in file SHOPPING. In the exercise, some of the estimation techniques presented in the chapter will be applied to the survey results. You may assume that the respondents represent a simple random sample of all potential respondents within the community and that the population is large enough that application of the finite population correction would not make an appreciable difference in the results. 

Managers associated with shopping areas like these find it useful to have point estimates regarding variables describing the characteristics and behaviors of their customers. In addition, it is helpful for them to have some idea as to the likely accuracy of these estimates. Therein lies the benefit of the techniques presented in this chapter applied here. 

1. Item C in the description of the data collection instrument list variables 7,8,and 9, which represent the respondents 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 the interval scale of measurement.

a. Determine the point estimate, the construct the 95% confidence interval for u7= the average attitude toward Springdale Mall. What is the maximum likely error in the estimate of the population mean?

b. Repeat part (a) for u8 and u9, the average attitude 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% confidence interval for pi 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% confidence interval for Pi 28 = the population proportion in the “single or other” category. What is the maximum likely error in the point estimate of the population proportion?