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 are provided in the file SHOPPING. The variables in the survey can be found in the file CODING.

In applying some of the techniques from this module, the following questions could provide insights into the perceptions and behavior of Springdale residents regarding the three shopping areas.

1.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?
2.Do people tend to spend differently at the three areas? Construct and compare frequency distributions for variables 4, 5, and 6.
3.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?
4.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.
Be sure that your report contains the following:

?A title page
?An introduction
?The body of the paper that answers the questions posed in the problems and includes calculations and graphs.
?A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.
Be sure to submit your Excel file.

To make sure your Excel program has the appropriate items turned on, please download one of the following documents and follow the directions enclosed for your version of Excel.

?Data Analysis ToolPak for PC. This is also described in Appendix E.
?Data Analysis ToolPak for Mac Excel 2001 or X

?Data Analysis ToolPak for Mac Excel 2008 or 2011