--%>

Regression Analysis

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

   Related Questions in Basic Statistics

  • Q : What is Interactive Response Time Law

    Interactive Response Time Law: • R = (L/X) - Z• Applies to closed systems.• Z is the think time. The time elapsed since&nb

  • Q : FIN512 Entrepreneurial Finance Chapter

      Chapter 6: Discussion Question: #4 p. 223  It is usually easier to forecast sales for a seasoned firm contrast to an early-stage venture because an early-stage venture has limited access to bank credit lines, sho

  • Q : Program Evaluation and Review

    Program Evaluation and Review Technique (PERT) A) Developed by US Navy and a consulting firm in 1958 for the Polaris submarine project. B) Technique as for CPM method, but acti

  • Q : Define Utilization Law Utilization Law

    Utilization Law: • ρk = XK . SK = X . DK • Utilization of a resource is the fraction

  • Q : Explain Queuing theory Queuing theory :

    Queuing theory: • Queuing theory deals with the analysis of lines where customers wait to receive a service:

    Q : Decision Variables Determine Decision

    Determine Decision Variables: Let X1 be the number of private homes to be inspectedLet X2 be the number of office buildings to be inspect

  • Q : Sample z test and Sample t test A

    A random sample X1, X2, …, Xn is from a normal population with mean µ and variance σ2. If σ is unknown, give a 95% confidence interval of the population mean, and interpret it. Discuss the major diff

  • Q : Assumptions in Queuing system

    Assumptions in Queuing system: • Flow balance implies that the number of arrivals in an observation period is equal to the

  • Q : Statistics for Management Assignment

    Q : What is your conclusion The following

    The following data were collected on the number of emergency ambulance calls for an urban county and a rural county in Florida. Is County type independent of the day of the week in receiving the emergency ambulance calls? Use α = 0.005. What is your conclusion? Day of the Week<