Graded Lab Wed Dec 2 - Friday Dec 4

• In this lab you will work with cerealsTrainSetNov23 and cerealsTestSetNov23 Excel files (same files you worked with in Lab 8 and on Monday Nov 30)

• You will work with SAP and QlikView and document results in this Word File: MultipleLinearSummary.docx

• Open SAP

• Load cerealsTrainSetNov23 Excel file.

• Run Multiple Linear Regression Models listed in the Word file. Save these models and run these models on Test file.

• Document R^2, Adjusted R^2 and Multiple Linear Regression Formula for each Model in the Word file MultipleLinearSummary.docx

• Rate the models based on R^2 and adjusted R^2. Assume, 1 is a HIGHEST RATING

• Open QlikView Test file we worked on Monday. If you missed the class on Monday, download the QlikView test file and save it on your computer with your initials at the end of the file name.

• Complete Straight Table Chart adding expressions to calculate Predicted rating for EACH model and SSE for Each model

• IMPORTANT!!!For ALL expressions on Number Tab select Fixed to 2 Decimals

• Complete Combo Chart to display predicted rating vs actual rating for all 5 models.

• Find Test_R^2 = 1-SSE/SST for each model on the Test Data

• Document SSE and Test_R^2 for each model in the Word File

• Complete Correlation Table in the Word File. To calculate correlations, add Text Object and use the following formula:
  =Num(Correl(Variable1, Variable2))

• Complete CONCLUSION part in the Word File

Submit TWO FILES, QlikView file and Word Summary File

If time permits