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 |
- 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.
- Calculate R2. Comment on the Goodness of the Fit. Is it a good fit? Why?
- Test the hypothesis regarding the significance of the slope ?1 . (Use ? = 0.05) Show ALL the calculations necessary to get your answer.
- 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.
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your essay.
Write My Essay For Mea. Write the Regression equation from Excel, and explain why your Independent variable is significant (Use ? = 0.05). Explain.
- Copy & pated the residual plot from Excel and paste it in MS Word and indicate whether the Homoscedasticity assumption has been met.
Welcome to our trusted essay writing website with track record among students. We specialize in connecting students in need of high-quality essay assistance with skilled writers who can deliver just that. Explore the ratings of our essay writers and choose the one that best aligns with your requirements. When you rely on our online essay writing service, rest assured that you will receive a top-notch, plagiarism-free A-level paper. Our experienced professionals write each paper from scratch, carefully following your instructions. Request a paper from us and experience 100% originality.



