Calculate the value of R squared from the data

Assignment Help Basic Statistics

Reference no: EM131801402

Assignment - Investigation into linear regression

This assignment will be an investigation into linear regression.

On Sheet 1 is a very simple regression model. You will see that y is based on x according to y= 6+ coeff *x +e where e is a normally distributed variable with mean zero and standard deviation specified at G2. Therefore if you do a regression you should recover the 6intercept and the coefficient.

Study the way the data has been generated using the various formulae and the RAND() function, then answer the following:

Required

1) For different values of the coefficient (ranging from large to very small), and different values of the error standard deviation (at G2) note what happens to the x/y scatter plot. Why is this happening? Really play around with different, extreme values to study what is going on.

2) In a linear regression explain what is the meaning of R squared and what is the meaning of the p-value for the intercept and the coefficient. What does the "Significance F" value mean? (you do NOT need to explain how the p-value is calculated).

3) In the output from the regression on Sheet 1, explain the meanings of "Multiple R", "Adjusted R Squared" and Standard Error.

4) For each value of the relevant combinations the coefficient and the error standard deviation, carry out the linear regression and note R-squared and the p-value for the coefficient. Explain why the various values differ in each case.

5) Choose one regression model and save the values (i.e. not formulae) on a separate sheet, called "Model". Calculate the value of R squared from the data and show that it agrees with the Excel value in the regression output.

Attachment:- Assignment File.rar

Reference no: EM131801402

Questions Cloud

Determine which brand of pizza the students prefer : Managers of the student center at your university or college are considering three alternative brands of frozen pizza to be offered on the menu.

How does history differ from maturation : How does history differ from maturation? What specific actions might you take to deal with each in an experiment?

Was this virtual or face to face communication : Persuasive Communication Letter-Was this a virtual or face to face communication? Do you feel this made a different in how you chose to respond?

Calculate the annual sales revenue required : An owner has $200,000 to invest in a restaurant. Furniture and equipment are to be purchased for $160,000 and $40,000 respectively.

Calculate the value of R squared from the data : Investigation into linear regression. Calculate the value of R squared from the data and show that it agrees with the Excel value in the regression output

The average vacation allotted to employees : The average vacation allotted to employees in America is about two weeks but there is a mandatory five week vacation period for employees.

Switzerland as an online adjunct instructor : Say for instance I was hired by a University on Switzerland as an online adjunct instructor.

Organizational factors promote creativity : Identify specific ways that the individual or organizational factors promote creativity

About firms which integrate their process activities : Which of the following is NOT true about firms which integrate their process activities?

User Account

All Pages