P $2-7($LO $2\mathrm{.}4)$ The Chapter $2$ Problem dataset contains a list...

Skip to question

$[$The following information applies to the questions displayed below.$]$

The Chapter $2$ Problem dataset contains a list of outstanding invoices for a fictional company, but the data aren$$t ready for analysis yet. Using this data file, take the following steps to validate and clean the data for completeness and integrity in Excel:

P $2-7($LO $2\mathrm{.}4)-$ Part c

c$.$ There are several empty values in the Days Past Due field. Either remove those values or replace them with the average. Explain which method you chose and why. Also explain how you implemented the method.