Question

A regional planner employed by a public university is studying the demographics of nine counties in the eastern region of an Atlantic seaboard state. She has gathered the following data:

County	Median Income			Median Age	Coastal
A	$	47,347		46.1	1
B		48,038		55.7	1
C		48,269		58.7	1
D		47,314		45.5	0
E		32,416		42.7	0
F		30,135		53.6	1
G		33,485		58.1	0
H		38,709		25.9	1
I		37,696		31.5	0

*1 = yes, 0 = no.

1. Is there a linear relationship between the median income and median age? (Round your answer to 3 decimal places.)

2. Which variable is the "dependent" variable?

• Median Age

• Median Income

1. c-1. Use regression analysis to determine the relationship between median income and median age. (Round your answers to 2 decimal places.)

1. c-2. Interpret the value of the slope in a simple regression equation. (Round your answers to 2 decimal places.)

4. Include the aspect that the county is "coastal" or not in a multiple linear regression analysis using a "dummy" variable. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

5. Test each of the individual coefficients to see if they are significant. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient to 3 decimal places and t, p to 2 decimal places.)

Answer 1

1. Is there a linear relationship between the median income and median age? (Round your answer to 3 decimal places.)

Yes, 0.158

1. Which variable is the "dependent" variable?

• Median Income

1. c-1. Use regression analysis to determine the relationship between median income and median age. (Round your answers to 2 decimal places.)

Income = 35699.43 + 100.80*Median Age

1. c-2. Interpret the value of the slope in a simple regression equation. (Round your answers to 2 decimal places.)

increase, 100.80

1. Include the aspect that the county is "coastal" or not in a multiple linear regression analysis using a "dummy" variable. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

Income = 34713.84 + 67.80*Median Age + 4531.14*Coastal

1. Test each of the individual coefficients to see if they are significant. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient to 3 decimal places and t, p to 2 decimal places.)

variables	coefficients	std. error	t (df=6)	p-value
Intercept	34,713.841	11,714.245	2.96	0.03
Median Age	67.804	247.528	0.27	0.79
Coastal	4,531.144	5,465.337	0.83	0.44