Question

In: Statistics and Probability

A regional planner employed by a public university is studying the demographics of nine counties in...

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 $ 48,952 48.3 1
B 46,669 58.8 1
C 47,780 48.0 0
D 46,855 39.2 1
E 37,724 51.9 1
F 35,414 56.2 1
G 34,389 49.1 0
H 38,128 30.3 0
I 30,384 38.9 0

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

Income = ________+ ____________ Median Age + ___________ Coastal

Test each of the individual coefficients to see if they are significant. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

Predictor t p-value

Constant

Median Age

Coastal

Solutions

Expert Solution

Using R for the analysis,

Code :

data = read.csv('C:\\Users\\Temp\\Desktop\\coastal.csv')
model = lm(income~., data = data)
summary(model)

Output :

Model : Income = 39669.20 - 48.08* median age + 5899.94* coastal

Call:
lm(formula = income ~ ., data = data)

Residuals:
Min 1Q Median 3Q Max
-7453.0 -5349.8 -84.4 3927.0 10418.7

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 39669.20 14380.78 2.758 0.0329 * (< 0.05, is significant)
age -48.08 334.77 -0.144 0.8905 (> 0.05, not significant)
coastal 5899.94 5768.20   1.023 0.3458 (>0.05, not significant)
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 7237 on 6 degrees of freedom
Multiple R-squared: 0.1761,   Adjusted R-squared: -0.09859 (shows that model is not good enough)
F-statistic: 0.641 on 2 and 6 DF, p-value: 0.5594

None of the variables is significant from above table.

Rate my answer and comment for doubt


Related Solutions

A regional planner employed by a public university is studying the demographics of nine counties in...
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. Is...
A regional planner employed by a public university is studying the demographics of nine counties in...
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,963 56.4 1 B 49,585 58.9 1 C 46,440 57.5 1 D 46,391 41.2 1 E 34,806 39.4 0 F 39,416 41.2 1 G 35,549 41.3 0 H 30,796 33.5 0 I 32,233 21.7 1   Click here for the Excel Data File...
A regional planner employed by a public university is studying the demographics of nine counties in...
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. Is there a linear relationship between...
A regional planner employed by a public university is studying the demographics of nine counties in...
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 County Median Income Median Age Coastal A $48,952 48.3 1 B 46,669 58.8 1 C 47,780 48.0 0 D 46,855 39.2 1 E 37,724 51.9 1 F 35,414 56.2 1 G 34,389 49.1 0 H 38,128 30.3 0 I 30,384 38.9 0 a) Is there a linear relationship between...
A regional planner employed by a public university is studying the demographics of nine counties in...
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 County Median Income Median Age Coastal A $48,952 48.3 1 B 46,669 58.8 1 C 47,780 48.0 0 D 46,855 39.2 1 E 37,724 51.9 1 F 35,414 56.2 1 G 34,389 49.1 0 H 38,128 30.3 0 I 30,384 38.9 0 A.)Use regression analysis to determine the relationship...
A regional planner employed by a public university is studying the demographics of nine counties in...
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: ounty Median Income Median Age Coastal A $ 48,952 48.3 1 B 46,669 58.8 1 C 47,780 48.0 0 D 46,855 39.2 1 E 37,724 51.9 1 F 35,414 56.2 1 G 34,389 49.1 0 H 38,128 30.3 0 I 30,384 38.9 0 Include the aspect that the county is...
Exercise 14-22 (LO14-1, LO14-5) A regional planner employed by a public university is studying the demographics...
Exercise 14-22 (LO14-1, LO14-5) 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 $ 49,374 58.5 0 B 46,850 46.5 1 C 47,586 48.5 1 D 47,781 45.5 1 E 33,738 37.3 0 F 35,553 43.4 0 G 39,910 45.3 0 H 37,266 34.2 0 I 34,571 36.5 0 Is there a...
A regional planner is studying the demographics in a region of a particular state. She has...
A regional planner is studying the demographics in a region of a particular state. She has gathered the following data on nine counties. Country Median Income Median Age Coastal A $47,963 56.4 1 B 49,585 58.9 1 C 46,440 57.5 1 D 46,391 41.2 1 E 34,806 39.4 0 F 39,416 41.2 1 G 35,549 41.3 0 H 30,796 33.5 0 J 32,233 21.7 1 (a) Is there a linear relationship between the median income and median age? (Round your...
in a paragraph, Provide a general description of global demographics with particular attention given to regional...
in a paragraph, Provide a general description of global demographics with particular attention given to regional differences, and the impacts and challenges of those differences.  How do these relate to environmental sustainability?  To global economic security?
A sample of nine public universities and nine private universities was taken. The total cost for...
A sample of nine public universities and nine private universities was taken. The total cost for the year (including room and board) and the median SAT score (maximum total is 2400) at each school were recorded. It was felt that schools with higher median SAT scores would have a better reputation and would charge more tuition as a result of that. The data are in the following table. Run the regression one time without dummy variable and one time with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT