I\u2019m unsure of the correct way to do this as it is strong suit. I need the landing page fixed, the other sheets are simply information that lays out the assignment. Data audit report is the sheet to refer to.\u00a0<\/p>\n
Instructions
\nComplete the following steps for cleaning the internal data provided.
\nSteps
\n1Download and Review the Data FileThe file below contains conversion data from Buhi\u2019s website. Identify any extreme outliers, incorrect value formats, impossible values, null values, and data outside of Q3. These values are errors in the data.
\n2Clean Landing Page \u2013 Conversions DataRemove the erroneous values you identified by clearing the individual cells containing them, not entire rows. After clearing a cell, simply leave it empty. Then, upload your cleaned file and check the correctness of your cleaned data by clicking Validate.
\nNote: If there are any errors remaining when you validate your file, you\u2019ll receive feedback pointing out the rows and columns where the errors are. When referring to column numbers, the numbering starts at zero. Therefore, column 0 in the feedback refers to the ID column, column 1 is Landing Page, and so on.<\/p>\n
(If you\u2019re using a spreadsheet application, deleting erroneous values in one column may cause a long value from an adjacent column to appear to bleed into the now-empty cell. This only affects the way the spreadsheet is displayed, not the actual value of the cell in question, which is still empty.)<\/p>\n
Upload Cleaned Internal Data
\nAccepted File Requirements
\nFile must be uploaded as a csv
\nFile must contain 7 columns with the names: \u201cID\u201d, \u201cLanding Page\u201d, \u201cDate Range\u201d, \u201cCountry\u201d, \u201cAd Campaign Clicks\u201d, \u201cConverted Sales\u201d, \u201cInstructions\u201d
\nFile must contain 391 rows (+-10)<\/p>\n
Have a similar assignment? “Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results.”<\/p>\n","protected":false},"excerpt":{"rendered":"
I\u2019m unsure of the correct way to do this as it is strong suit. I need the landing page fixed, the other sheets are simply information that lays out the assignment. Data audit report is the sheet to refer to.\u00a0 Instructions Complete the following steps for cleaning the internal data provided. Steps 1Download and Review […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-13558","post","type-post","status-publish","format-standard","hentry","category-essays"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/13558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=13558"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/13558\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=13558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=13558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=13558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}