Question

Using the data in the folder for Data Folder in Course Documents, please run simple regression model in Excel and, after the Summary Output is produced, in that same Excel file, do the following and then save when you have also Print your name on the top of that excel file in large Font, and reed color, save it and submit a it in this same folder. 1. use the Residual column (of that Excel Output YOU have produced), to produce a Histogram of the residuals. Be sure the Histogram is within the purview in the first glance. 2. Calculate the Durbin-Watson (D) statistic, using excel. You did this by hand in the first homework assignment, now you do this with Excel. Random n View Review Formulas Data Page Layout Insert Home File Enable Editing This file originated from an Internet location and might be unsafe. Click for more details Protected View fx B1 H G F E D C B A X 1 8.65 1,773 1,863 1,798 1,775 1,796 2 8.65 3 8.65 4 8.65 5 8.65 6 8.65 7.50 1,786 1,916 1,997 2,008 7 8 7.50 q 7.50 10 7.50 2,012 1,864 11 8.50 12 8.50 1,884 13 8.50 1,762 1,398 14 9.99 15 9.99 1,480 1,458 1,469 1,525 1,587 1,554 1,622 1,717 1,755 1,731 16 9.99 17 9.99 18 10.25 19 10.25 20 10.25 21 9.75 22 9.75 23 9.75 24 9.75 25 26 27 28 29 30

Answer 1

This website doesn't allow me to attach an Excel file. So I'm posting a google drive link. You can download the Excel sheet from the link:

https://drive.google.com/open?id=19z5mwaA9IejFq8pS_KfjenOjW8YsHr-a

Open the Excel sheet in microsoft excel and click the cells containing the results you will get the formula in the above formula bar.