Data Analytics Assignment | Mathematics of Data Analytics
18 Pages4515 Words81 Views
Added on 2020-05-28
Data Analytics Assignment | Mathematics of Data Analytics
Added on 2020-05-28
ShareRelated Documents
Running Head: MATHEMATICS OF DATA ANALYTICSMathematics of Data AnalyticsStudent’s name:Institution Affiliation
Table of ContentsQuestion 1...................................................................................................................................................2Question 2...................................................................................................................................................2Question 3...................................................................................................................................................5Question 4...................................................................................................................................................6Question 5...................................................................................................................................................8Question 6.................................................................................................................................................11Question 7.................................................................................................................................................14References.................................................................................................................................................16
Question 1A poster has been created by using the Excel data provided in the Moodle. Both A power point and a Pdf file are available.Question 2Write a maximum of 2500 words about how you created your poster and why. In this, you should reflect on • How you cleaned the data — did you need to make any assumptions? • Why you chose the particular visuals you did and how you created them; • What the rationale for the design of your poster is; • What the design of the poster adds to the story it is telling.Errors Checked for in the datai)Missing dataii)Erroneous entriesiii)Data format inconsistenciesiv)Extraneous Entriesv)MisspellingsProposed Remedies for identified ErrorsIdentified errors include:i)Missing Data (Blanks)ii)Extraneous EntriesProposed Remediesi)Leave the data unchanged
Assumptions madeBecause the data provided had a larger sample size, then the few “blanks” will not affect the analysis, or the charts presented. Due to this assumption then all the identified errors were left unchanged. Data Cleaning ProcessData Backup:The first and most fundamental thing when it comes to data cleaning is to make a second copy of the original Excel workbook and save it as a separate file. It is highly recommended that you keep the original copy of the original data in a different folder to avoid its modification (Rothberg, 2017). One can change its attributes to READ-ONLY.Data Screening: The data screening process involves carefully and analytically looking for a suspect feature in the Excel data provided. In my case, I was evaluating the data for missing data, Excess data, outliers, inconsistencies, strange patterns and suspect analysis results.Data Diagnosis and Treatment: This process necessitates a comprehensive consideration of all sorts and sources of errors which are probable during data collection and recording processes.Documentation: This is the part where changes are documented leaving an assessment trail of mistakes identified, adjustments, additions and error checking. The main aim of documentation is to allow a return to the original copy of data if necessary.
End of preview
Want to access all the pages? Upload your documents or become a member.