In New Jersey, banks have been charged with withdrawing from counties having a high percentage of minorities. To substantiate this charge, P. D'Ambrosio and S. Chambers (1995) present the data in the following table concerning the percentage, x, of minority population and the number of county residents, y, per bank branch in each of New Jersey's 21 counties. County Atlantic Bergen Burlington Camden Cape May Cumberland Essex Gloucester Hudson Hunterdon Mercer Middlesex Monmouth Morris Ocean Passaic Salem Somerset Sussex Union Warren Percentage of Minority Population, x 23.3 13.0 17.8 23.4 7.3 26.5 48.8 10.7 33.2 3.7 24.9 18.1 12.6 8.2 4.7 28.1 16.7 12.0 2.4 25.6 2.8 Number of Residents Per Bank Branch, y 3,073 2,095 2,905 3,330 1,321 2,557 3,474 3,068 3,683 1,998 2,607 3,154 2,609 2,253 2,317 3,307 2,511 2,333 2,568 3,048 2,349 (a) By a scatter plot discuss why a simple linear regression can explain the relationship between x and y. (b) Use R (minitab,...) and fit a simple linear regression (c) Interpret the regression coefficients (d) Test significance of the coefficients (e) For 50% minority of the population, predict the number of residents per bank branch.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Use excel please

In New Jersey, banks have been charged with withdrawing from counties having a high
percentage of minorities. To substantiate this charge, P. D'Ambrosio and S. Chambers (1995)
present the data in the following table concerning the percentage, x, of minority population and
the number of county residents, y, per bank branch in each of New Jersey's 21 counties.
County
Atlantic
Bergen
Burlington
Camden
Cape May
Cumberland
Essex
Gloucester
Hudson
Hunterdon
Mercer
Middlesex
Monmouth
Morris
Ocean
Passaic
Salem
Somerset
Sussex
Union
Warren
Percentage
of Minority
Population, x
23.3
13.0
17.8
23.4
7.3
26.5
48.8
10.7
33.2
3.7
24.9
18.1
12.6
8.2
4.7
28.1
16.7
12.0
2.4
25.6
2.8
Number of
Residents Per
Bank Branch, y
3,073
2,095
2,905
3,330
1,321
2,557
3,474
3,068
3,683
1,998
2,607
3,154
2,609
2,253
2,317
3,307
2,511
2,333
2,568
3,048
2,349
(a) By a scatter plot discuss why a simple linear regression can explain the relationship
between x and y.
(b) Use R (minitab,...) and fit a simple linear regression
(c) Interpret the regression coefficients
(d) Test significance of the coefficients
(e) For 50% minority of the population, predict the number of residents per bank branch.
(f) Find a 95% confidence interval for the future average number of residents per bank
branch when 50% of the population is minority.
(g) Find a 95% prediction interval for the future average number of residents per bank
branch when 50% of the population is minority.
(h) Make a comparison between confidence interval and prediction interval
Transcribed Image Text:In New Jersey, banks have been charged with withdrawing from counties having a high percentage of minorities. To substantiate this charge, P. D'Ambrosio and S. Chambers (1995) present the data in the following table concerning the percentage, x, of minority population and the number of county residents, y, per bank branch in each of New Jersey's 21 counties. County Atlantic Bergen Burlington Camden Cape May Cumberland Essex Gloucester Hudson Hunterdon Mercer Middlesex Monmouth Morris Ocean Passaic Salem Somerset Sussex Union Warren Percentage of Minority Population, x 23.3 13.0 17.8 23.4 7.3 26.5 48.8 10.7 33.2 3.7 24.9 18.1 12.6 8.2 4.7 28.1 16.7 12.0 2.4 25.6 2.8 Number of Residents Per Bank Branch, y 3,073 2,095 2,905 3,330 1,321 2,557 3,474 3,068 3,683 1,998 2,607 3,154 2,609 2,253 2,317 3,307 2,511 2,333 2,568 3,048 2,349 (a) By a scatter plot discuss why a simple linear regression can explain the relationship between x and y. (b) Use R (minitab,...) and fit a simple linear regression (c) Interpret the regression coefficients (d) Test significance of the coefficients (e) For 50% minority of the population, predict the number of residents per bank branch. (f) Find a 95% confidence interval for the future average number of residents per bank branch when 50% of the population is minority. (g) Find a 95% prediction interval for the future average number of residents per bank branch when 50% of the population is minority. (h) Make a comparison between confidence interval and prediction interval
Expert Solution
steps

Step by step

Solved in 5 steps with 6 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

d,e,f,g,h

In New Jersey, banks have been charged with withdrawing from counties having a high
percentage of minorities. To substantiate this charge, P. D'Ambrosio and S. Chambers (1995)
present the data in the following table concerning the percentage, x, of minority population and
the number of county residents, y, per bank branch in each of New Jersey's 21 counties.
County
Atlantic
Bergen
Burlington
Camden
Cape May
Cumberland
Essex
Gloucester
Hudson
Hunterdon
Mercer
Middlesex
Monmouth
Morris
Ocean
Passaic
Salem
Somerset
Sussex
Union
Warren
Percentage
of Minority
Population, x
23.3
13.0
17.8
23.4
7.3
26.5
48.8
10.7
33.2
3.7
24.9
18.1
12.6
8.2
4.7
28.1
16.7
12.0
2.4
25.6
2.8
Number of
Residents Per
Bank Branch, y
3,073
2,095
2,905
3,330
1,321
2,557
3,474
3,068
3,683
1,998
2,607
3,154
2,609
2,253
2,317
3,307
2,511
2,333
2,568
3,048
2,349
(a) By a scatter plot discuss why a simple linear regression can explain the relationship
between x and y.
(b) Use R (minitab,...) and fit a simple linear regression
(c) Interpret the regression coefficients
(d) Test significance of the coefficients
(e) For 50% minority of the population, predict the number of residents per bank branch.
(f) Find a 95% confidence interval for the future average number of residents per bank
branch when 50% of the population is minority.
(g) Find a 95% prediction interval for the future average number of residents per bank
branch when 50% of the population is minority.
(h) Make a comparison between confidence interval and prediction interval
Transcribed Image Text:In New Jersey, banks have been charged with withdrawing from counties having a high percentage of minorities. To substantiate this charge, P. D'Ambrosio and S. Chambers (1995) present the data in the following table concerning the percentage, x, of minority population and the number of county residents, y, per bank branch in each of New Jersey's 21 counties. County Atlantic Bergen Burlington Camden Cape May Cumberland Essex Gloucester Hudson Hunterdon Mercer Middlesex Monmouth Morris Ocean Passaic Salem Somerset Sussex Union Warren Percentage of Minority Population, x 23.3 13.0 17.8 23.4 7.3 26.5 48.8 10.7 33.2 3.7 24.9 18.1 12.6 8.2 4.7 28.1 16.7 12.0 2.4 25.6 2.8 Number of Residents Per Bank Branch, y 3,073 2,095 2,905 3,330 1,321 2,557 3,474 3,068 3,683 1,998 2,607 3,154 2,609 2,253 2,317 3,307 2,511 2,333 2,568 3,048 2,349 (a) By a scatter plot discuss why a simple linear regression can explain the relationship between x and y. (b) Use R (minitab,...) and fit a simple linear regression (c) Interpret the regression coefficients (d) Test significance of the coefficients (e) For 50% minority of the population, predict the number of residents per bank branch. (f) Find a 95% confidence interval for the future average number of residents per bank branch when 50% of the population is minority. (g) Find a 95% prediction interval for the future average number of residents per bank branch when 50% of the population is minority. (h) Make a comparison between confidence interval and prediction interval
Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman