Last Graded Lab - Due Day Friday Dec 6

• In this lab you will perform Descriptive and Predictive Analysis of the Toyota Used Cars Dataset.
• Final Files for Submission will include:
  • QlikView files with Test and Train analysis (predictive analytics)
  • QlikView file with BOTH datasets that analyze all data (descriptive analytics)
  • Word File with Predictive Analysis Summary

• Download ToyotaTest.xlsx and ToyotaTrain.xlsx files from Shared Files
• Open QlikView and load BOTH datasets. Call this file ToyotaTotal_YourName
• Perform Descriptive Analysis of the Data and Create a Dashboard Sheet that describes the data. Your dashboard must be visually appealing and must include:
  • At least 3 different charts
  • Statistics Box
  • At least ONE text box displaying results of calculations
• Predictive Analysis Requirements:
  • QlikView file with Train Dataset,Scatter Charts, Correlations, Linear Regression Models. Goal: To find a linear regression model and the best predictor based on the training dataset
  • QlikView file with Test Dataset. Testing your models. Making decision which model is working the best on the test data.
  • SAP: build at least two multiple linear regression models and test it on the test dataset.