Instructions: Use the information presented in this packet for this assignment. To complete this assignment, read and understand the problem and decide the right descriptive and inferential statistical methods needed to solve the problem. Plan, calculate, analyze, and interpret all statistical procedures relevant to the data presented. Write and justify your statistical strategies and procedures. Write down the statistical analysis and your findings and conclusions. Your report can be presented in either a Word or an Excel format. Since it is an exam, you are supposed to do it on your own.
The intent of this case is to analyze household income in two subdivisions. Each division has 50 households total. The head of household age and occupation are also recorded. The county manager is interested in finding out household income information about the two subdivisions in total and separate. Also of interest is whether any significant differences existed between the two subdivisions, and whether age or occupation affect the income level.
In addition, the county manager is also interested in the opinions of the residents of the two subdivisions regarding the location of a new high school. Households were given a short questionnaire asking their views. The following questions made up this questionnaire.
- Build the new high school in the existing park.
- Expand the elementary school ground to include the new high school.
- Build a new elementary school and a new high school both near the county land near the highway and keep the park as is.
- Build a new elementary school and a new high school both in the park.
- Don’t build the new high school.
The households responded to these questions using the following rating scale.
1. (1) strongly agree
2. (2) agree
3. (3) agree somewhat
4. (4) disagree
5. (5) strongly disagree
The county manager is interested in finding out how each subdivision and household by occupation responded to the survey. Were there any differences in questionnaire response between subdivision and occupation? Finally, the county manager seeks to see what relationship exists between household income and their responses to the questionnaire.
As county analysts, your responsibility is to examine the data presented in this package, analyze it, and present your findings to the county manager.
Chart of Codes
|Data Category||Data Interpretation|
|Subdivision||1= west side
2 = east side
|Occupation||1= Accountant, 2 = Engineer, 3= Banker, 4= Nurse, 5= Mechanics, 6 = teacher 7= salesman. 8= retailer, 9= baker 10= service worker, 11= management|
|Age||Age of head of household|
|Household||Total household income|
|Z Score||Household Income standardized|
|Q1||Response to Question 1 of Class Questionnaire|
|Q2||Response to Question 2 of Class Questionnaire|
|Q3||Response to Question 3 of Class Questionnaire|
|Q4||Response to Question 4 of Class Questionnaire|
|Q5||Response to Question 5 of Class Questionnaire|
|EvalM||Mean Score on Questionnaire|