CMIS Final Project.docx - Excel Data Analysis Capstone...

This preview shows page 1 - 4 out of 14 pages.

Excel Data Analysis CapstoneProjectPrepared by:Don Canlas (200435811), Aurora Gumapac-Parent (200436633),John Archie Cantal (200451549), and Thida Paw (200407240)Prepared forDong YeCMIS2250 Section A06Date of Submission:Tuesday, March 3, 2020Northern Alberta Institute of Technology
Explanation of the ProcessData SourcingThe group went to the website of the NBA, which is -reference.com/leagues/NBA_2019.html, to predict the playoffs and wins. To do this, we downloaded the “Miscellaneous Data” from the years, 2013 to 2018, as our Source Data. After that, we also downloaded the 2018-2019 NBA Summary to get the Subject Data,Data PreparationWe explored the worksheet to achieve the desired accuracy and MSE. The following procedures are:L, PW, PL, MOV, and SRS were taken out as it was written in the instructions. furthermore, the data would not be accurate and unreliable if the group would include it in the predictions.Playoffs column was added indicated by an asterisk “*” at the end of the team names. In the instructions given, we were asked to put the numbers “1” if they are in the playoffs and “0” for not. This is mostly because Solver could not understand words. As a result, we can use it as an Output Variable.The headers were confusing for the group as it some of the terms duplicate with each other, specifically the four factors of Offensive and Defensive, which are O eFG%, TOV%, ORB%, and FT/FGA. Because of this, our group renamed the headings of the worksheet to their full names for a better understanding of the others.Arena, Attendance and Attendance per home game does not have any relevanceto the predictions that the group needs to make. Thus, they are deleted from the worksheet.Team Names do not have any importance for predictions; However, it was not taken out for identification purposes. If we were to remove it, the group will have a hard time answering the “Presentation of Results” part in the group project.Dong Ye
Through trial and error in our project, Age, Net Rating, Pace, Attempts were also deleted as we realized that it lowers the accuracy. It means that they would be

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture