Question;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.;a. 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.
Paper#62264 | Written in 18-Jul-2015Price : $27