Linear regression assignment help, Advanced Statistics

Assignment Help:

Using World Bank (2004) World Development Indicators; Washington: International Bank for Reconstruction & Development/ The World Bank, located in the reference section of the Learning Centre (Stats 330.9 WOR), collect a sample of data comprising cereal yield in kg/ha and fertilizer consumption in hundreds of grams /ha of arable land for the period 2000-2002 from 25 countries around the world. These data can be found in Table 3.3 pp123-126 and Table 3.2 pp 119-122 respectively.

For the regression analysis, use cereal yield as the dependent variable (Y) and fertilizer consumption as the independent variable (X). Enter the two variables into an SPSS file and carry out the following exercise: 

1.         Regress cereal yield (Y) on fertilizer consumption (X).

2.         Produce a plot of the 30 observations, the calculated regression line and the 95% confidence limits.                                                               

3.         What is the correlation between cereal yield and fertilizer consumption?             

4.          State whether the modeled regression relationship is significant.

 5.         Examine the plotted residuals and attempt to explain two of the extreme positive and negative values (max 300 words).                       

6.         Calculate the runs test and the Durbin-Watson statistic on the residuals and indicate whether auto-correlation is present at the 0.05 significance level.

 

1)

We run the regression of cereal yield on fertilizer consumption. The fitted regression line is given by:

 

cereal yield= 2254.069+0.253 * fertilizer consumption

 

 

Regression

 

Variables Entered/Removed

Model

Variables Entered

Variables Removed

Method

1

fertilizer consumptiona

.

Enter

a. All requested variables entered.

 

b. Dependent Variable: cereal yields

 

 

Residuals Statisticsa

 

Minimum

Maximum

Mean

Std. Deviation

N

Predicted Value

2254.07

3054.49

2400.90

195.404

25

Residual

-2.251E3

4481.879

.000

1822.796

25

Std. Predicted Value

-.751

3.345

.000

1.000

25

Std. Residual

-1.209

2.407

.000

.979

25

a. Dependent Variable: cereal yields

 

 

 

 

3) The Correlation coefficient is 0.01

 

4) From the ANOVA table we see that the regression is not significant at 5% level of significance.

 

ANOVAb

Model

Sum of Squares

df

Mean Square

F

Sig.

1

Regression

916388.422

1

916388.422

.264

.612a

Residual

7.974E7

23

3467045.255

 

 

Total

8.066E7

24

 

 

 

a. Predictors: (Constant), fertilizer consumption

 

 

b. Dependent Variable: cereal yields

 

 

 

 

6)

The Durbin-Watson statistic is 1.588 which is close to 2 indicating there may be no or little positive autocorrelation

Model Summary

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Durbin-Watson

1

.107a

.011

-.032

1862.000

1.588

a. Predictors: (Constant), fertilizer consumption

 

b. Dependent Variable: cereal yields

 

 

However we next perform the run test which clearly implies that the residuals are independent at 5% level.

 

NPar Tests 

 

Runs Test

 

Standardized Residual

Test Valuea

-.15308

Cases < Test Value

12

Cases >= Test Value

13

Total Cases

25

Number of Runs

15

Z

.417

Asymp. Sig. (2-tailed)

.676

a. Median

 

 

 

7)

For less developed countries the intercept term will be very low as compared to high developed countries.

Moreover the slope of the fertilizer consumption will also be low in less developed countries indicating slow growth rate of cereal yield.

 

7.         What differences would you expect to find between less developed and more developed countries in terms of the relationship between cereal yield and fertilizer consumption?


Related Discussions:- Linear regression assignment help

Glejser’s test, The Null Hypothesis - H0:  There is no heteroscedasticity i...

The Null Hypothesis - H0:  There is no heteroscedasticity i.e. β 1 = 0 The Alternative Hypothesis - H1:  There is heteroscedasticity i.e. β 1 0 Reject H0 if |t | > t = 1.96

Hazard regression, Hazard regression is the procedure for modeling the haz...

Hazard regression is the procedure for modeling the hazard function which does not depend on the suppositions made in Cox's proportional hazards model, namely that the log-hazard

Probability., 5. Packages from a machine a normally distributed with a mean...

5. Packages from a machine a normally distributed with a mean 200g and its standard deviation 2grams. Find the probability that a package from the machine weighs a) Less than

Quincunx, Quincunx  is the device used by Galton to illustrate his lecture...

Quincunx  is the device used by Galton to illustrate his lectures, which is shown in the Figure. It had a glass face and a funnel at its top. The shot was passed through funnel an

Censored observations, Censored observations : An observation xi on some va...

Censored observations : An observation xi on some variable of interest is consired to be censored if it is known that xi Li (left-censored)or xi Ui (right-censored) where Li and Ui

Regression diagnostics, Regression diagnostics is the process designed to...

Regression diagnostics is the process designed to investigate the suppositions underlying particular forms of regression examination, for instance, homogeneity of variance, norma

Explain prevalence, Prevalence : The measure of the number of people in a p...

Prevalence : The measure of the number of people in a population who have a certain disease at a given point in time. It c an be measured by two methods, as point prevalence and p

Buffon''s needle problem, Buffon's needle problem : A problem proposed and ...

Buffon's needle problem : A problem proposed and solved by the scientist Comte de Buffon in 1777 which includes determining the probability, p, which a needle of length l will inte

Gene environment interaction, The interplay of the genes and environment on...

The interplay of the genes and environment on, for instance, the risk of disease. The term represents the step away from the argument as to whether the nature or nurture is the pre

Explain Grade of membership model, Grade of membership model: This is the ...

Grade of membership model: This is the general distribution free method for the clustering of the multivariate data in which only categorical variables are included. The model ass

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd