Graded Lab

• In this lab you will continue to work with Cereal Ratings Dataset

• You will work with SAP and QlikView and document results in this Word File: MultipleLinearSummaryFall2019.docx . Make sure you

  complete CONCLUSION part in the Word File

• Open SAP and open file we worked last week. Check you have cereals training dataset loaded.

• Run Multiple Linear Regression Models listed in the Word file. There are 3 new models listed that you need to complete

• Document R^2, Adjusted R^2 and Multiple Linear Regression Formula for each Model in the Word file MultipleLinearSummaryFall2019.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, download the QlikView test file and save it on your computer with your initials at the end of the file name.

• Create a new sheet, call it Nov20.

• Create a Straight Table Chart to document results for new models (Dimension is name). Calculate Predicted rating for EACH model and SSE for Each model.

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

• Create a Combo Chart to display predicted rating vs actual rating for new 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 TEST file and Word Summary File

If time permits