In the material covered in the course so far, we have illustrated different techniques for debugging, cleaning and validating the data contained in a database that we extracted or that was archived in its raw form (raw data) and that we want to prepare it to make it suitable. to the subsequent analysis.

Required: Discuss five different problems that data might have once extracted, which we need to correct before we can use the data and subject it to analysis. Also, using the relevant Excel formulas or sections, explain how you would solve the various problems you mention.