Question

You predict that nature reserves located far from large cities (with populations >100,000) have a higher proportion of plant species that are native to their region than reserves that are close to large cities. You collect the following data on 7 nature reserves:

Conduct an appropriate analysis to test the prediction.

Answer 1

using excel>data >data ananlysis> Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.032111
R Square	0.001031
Adjusted R Square	-0.19876
Standard Error	18.62063
Observations	7
ANOVA
	df	SS	MS	F	Significance F
Regression	1	1.789428	1.789428	0.005161	0.945515
Residual	5	1733.639	346.7278
Total	6	1735.429
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	74.81957	14.30537	5.230173	0.003381	38.04644	111.5927
distance	0.019572	0.272439	0.071839	0.945515	-0.68076	0.719899

p value of f stat is 0.9455 which is greater tha 0.05 so we conclude that this model is not good to predict the %native

since the data contains oy=utlier which can be easily seen from the scatterplot given so we willl delete the outlier and

using excel>data>data analysis>Regression

Regression Statistics
Multiple R	0.874232
R Square	0.764282
Adjusted R Square	0.705353
Standard Error	3.817751
Observations	6
ANOVA
	df	SS	MS	F	Significance F
Regression	1	189.0324	189.0324	12.96944	0.022732
Residual	4	58.30088	14.57522
Total	5	247.3333
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	72.69027	2.939719	24.72695	1.59E-05	64.5283	80.85223
distance	0.211209	0.058648	3.601311	0.022732	0.048377	0.374042

the best regression equation to predit the % native

%native = 72.69v +0.211*distnace

--------------------------------------

DEAR STUDENT,

IF YOU HAVE ANY QUERY ASK ME IN THE COMMENT BOX,I AM HERE TO HELPS YOU.PLEASE GIVE ME POSITIVE RATINGS

*****************THANK YOU***************