Data Analytics Assignment | Mathematics of Data Analytics

Added on - 28 May 2020

  • 18

    pages

  • 4515

    words

  • 1

    views

  • 0

    downloads

Showing pages 1 to 4 of 18 pages
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 pointand a Pdf file are available.Question 2Write a maximum of 2500 words about how you created your poster and why. In this, youshould 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 theanalysis, or the charts presented. Due to this assumption then all the identified errors were leftunchanged.Data Cleaning ProcessData Backup:The first and mostfundamental thing when it comes to datacleaning is to make a second copy of theoriginal Excel workbook and save it as aseparate file. It is highly recommendedthat you keep the original copy of theoriginal data in a different folder to avoidits modification (Rothberg, 2017). Onecan change its attributes to READ-ONLY.Data Screening:The data screeningprocess involves carefully and analytically looking for a suspect feature in the Excel dataprovided. 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 allsorts 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 ofmistakes identified, adjustments, additions and error checking. The main aim of documentationis to allow a return to the original copy of data if necessary.
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document