Never use plagiarized sources. Get Your Original Essay on
Business & Finance – Marketing Assignment
Hire Professionals Just from $11/Page
Order Now Click here

 

   

 

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.

 

Need a custom written plagiarism free essay? Click here to order now.

Open chat
Lets chat on via WhatsApp
Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.