Simple Regression Solution Using the following table of relation between X & Y

Question # 00019512 Posted By: jia_andy Updated on: 07/09/2014 01:28 PM Due on: 09/30/2014
Subject Mathematics Topic General Mathematics Tutorials:
Question
Dot Image

1. Using the following table of relation between X & Y (Y is the independent Variable):

xi

1

2

3

4

5

6

7

yi

8

7

7

6

4

4

– 1

  1. Find the estimated regression equation. Show ALL your calculations and the appropriate formula. WRITE Formula in all the questions below and substitute for the numbers, demonstrate your work.

  2. Calculate R2. Comment on the Goodness of the Fit. Is it a good fit? Why?

  3. Test the hypothesis regarding the significance of the slope ?1 . (Use ? = 0.05) Show ALL the calculations necessary to get your answer.

  4. Calculate the values of F, using formula for F statistics (Look at the Formula Sheet). Is F significant? Explain how you know.

2.Using the same values as in part (1), Run the Simple Regression Model in Excel. Copy all the relevant parts from the Excel output one by one, and paste it in MS Word, and answer the related question right below that question.

a. Write the Regression equation from Excel, and explain why your Independent variable is significant (Use ? = 0.05). Explain.

  1. Copy & pated the residual plot from Excel and paste it in MS Word and indicate whether the Homoscedasticity assumption has been met.

Dot Image
Tutorials for this Question
  1. Tutorial # 00018941 Posted By: jia_andy Posted on: 07/09/2014 01:32 PM
    Puchased By: 2
    Tutorial Preview
    The solution of Simple Regression Solution Using the following table of relation between X & Y...
    Attachments
    Simple_Regression_Solution_Using_the_following_table_of_relation_between_X_Y.docx (51.64 KB)

Great! We have found the solution of this question!

Whatsapp Lisa