1. A planning official in the Texas Department of Community Affairs, which works in the office next to you, has a problem. He has been handed a data set from his boss that includes the costs involved in developing local land use plans for communities with populations between 75,000 and 125,000. The boss has a hunch that the plans are more expensive as population increases. He has no idea how to decide and asks for your assistance. Given the data in the following table, using regression analysis, are the plans more expensive (I mean statistically significantly different) as population increase? You must show SPSS output to get full credit for this question!
|
Community
|
Population
|
Cost
|
|
1
|
77000
|
12500
|
|
2
|
87000
|
13700
|
|
3
|
76000
|
12000
|
|
4
|
124000
|
23000
|
|
5
|
100000
|
21000
|
|
6
|
110000
|
19000
|
|
7
|
115000
|
22000
|
|
8
|
98000
|
18000
|
|
9
|
87000
|
13500
|
|
10
|
123000
|
27000
|
|
11
|
95000
|
17000
|
|
12
|
121000
|
21000
|
|
13
|
113000
|
22000
|
|
14
|
105000
|
19000
|
|
15
|
102000
|
17000
|
|
16
|
104000
|
23000
|
|
17
|
75000
|
14000
|
|
18
|
85000
|
14000
|
2. For the data in question #1, using your linear regression, predict the cost of the city plan for a community with a population of 250,000. Explain and discuss your model in detail. For example how well does it explain the variation in plan cost? Do the model's residuals behave appropriately? In short discuss the pluses and minuses regarding your model.
3. The following data are infant mortality rates for urban and rural counties. Is there a statistically significant difference between the infant mortality rates? If yes what direction?
|
Location
|
Mortality Rate
|
|
Urban
|
15
|
|
Urban
|
7
|
|
Urban
|
11
|
|
Urban
|
13
|
|
Urban
|
6
|
|
Urban
|
13
|
|
Urban
|
7
|
|
Urban
|
15
|
|
Urban
|
11
|
|
Urban
|
7
|
|
Urban
|
3
|
|
Urban
|
3
|
|
Urban
|
4
|
|
Urban
|
11
|
|
Urban
|
8
|
|
Urban
|
15
|
|
Rural
|
10
|
|
Rural
|
8
|
|
Rural
|
6
|
|
Rural
|
7
|
|
Rural
|
20
|
|
Rural
|
12
|
|
Rural
|
14
|
|
Rural
|
16
|
|
Rural
|
18
|
|
Rural
|
6
|
|
Rural
|
7
|
|
Rural
|
17
|
|
Rural
|
14
|
4. Using the one-way ANOVA, is there a difference between the following planning department's base salaries? If yes which are different and by how much?
|
State
|
Environmental
|
Geographic Information
|
Economic Development
|
|
1
|
59408
|
67566
|
107228
|
|
2
|
45296
|
77179
|
116071
|
|
3
|
46932
|
87420
|
84343
|
|
4
|
63379
|
90059
|
115666
|
|
5
|
65625
|
66929
|
105856
|
|
6
|
66175
|
61534
|
107071
|
|
7
|
52648
|
69891
|
101303
|
|
8
|
54049
|
69815
|
72352
|
|
9
|
46495
|
83430
|
79778
|
|
10
|
45353
|
64000
|
101396
|
|
11
|
46643
|
87177
|
102515
|
|
12
|
53418
|
79377
|
73040
|
|
13
|
59018
|
87019
|
86016
|
|
14
|
60012
|
84721
|
105480
|
|
15
|
51439
|
69999
|
109549
|
|
16
|
47749
|
76416
|
98611
|
|
17
|
54815
|
65540
|
77427
|
|
18
|
55720
|
74824
|
101787
|
|
19
|
62165
|
87602
|
98026
|
|
20
|
45154
|
78516
|
93526
|