The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown area on Main Street. A telephone survey has been conducted to identify strengths and weaknesses of these areas and to find out how they fit into the shopping activities of local residents. The 150 respondents were also asked to provide information about themselves and their shopping habits. The data and the survey variables can be found in the attached files. Please address each of the following:
- Construct three different frequency distributions, one each for variables 7, 8, and 9. How do the three areas compare in terms of residents' general attitudes toward each?
- Do people tend to spend differently at the three areas? Construct and compare frequency distributions for variables 4, 5, and 6.
- To find out more about specific strengths and weaknesses of the areas, set up a frequency distribution for variable 10 (e.g., how many "best-fits" votes did each area get for "easy to return/exchange goods"?). Repeat this for variables 11-17 and interpret the results. Which of the malls seems to be the "bargain mall"? Which area seems to have the most convenient shopping hours?
- To find out more about the shoppers in the areas, set up a frequency distribution table to find out the number of male and female shoppers (Variable 26); the number of years each shopper has for education completed (Variable 27); and the marital status (Variable 28). Then find the average number of people in the house as well as the average age of the shopper interviewed. Interpret the results.
This solution is provided in two attached documents: a Word document and an Excel document.