IGNOU MCS 67 2026 2027 - A retail company has collected customer transaction data contain

Question

A retail company has collected customer transaction data containing the following attributes: (3 Marks)
 Customer ID
 Age
 Gender
 City
 Purchase Amount
 Payment Mode
Describe how you would perform data profiling on this dataset. What are the summary statistics that you
would perform on this data?

30 Jul 2026

Answer :

Word Count : 616

Data profiling is the process of examining a dataset to understand its structure, quality, completeness, consistency, and distribution before performing analysis or visualization. For the given retail customer transaction dataset, data profiling helps identify errors, missing values, duplicate records, unusual patterns, and relationships among variables. It ensures that the dataset is reliable and suitable for business intelligence and decision-making. The first step is to examine the overall structure of the dataset. This includes determining the total number of records, total number of attributes, data types of each field, and whether each attribute contains valid values. Customer ID should be checked as a unique identifier, Age and Purchase Amount should be numerical fields, while Gender, City, and Payment Mode should be categorical variables. The next step is to perform completeness analysis. Missing values are identified for every attribute. Customer IDs should never be missing because they uniquely identify customers. Missing values in Age, Gender, City, Purchase Amount, or Payment Mode should be counted and expressed as percentages. This helps determine whether missing values can be ignored, imputed, or require further investigation. Uniqueness profiling is also important.

_______ ________ ________ _________ ________ ______ ___.
_______ ___ ____ _____ ______ ________ ______ _______ _____ ___ ___.
______ ____ __________ ____ ________ _______ ____ ___.
_____ ________ _______ _________ ______ _______.
_________ __________ _________ ____ _________ ____ _____ ________ _____.
_________ ____ ______ ____ ___ ___ ___ ______ __________.
____ ___ ___ ___ _________ ___ ___ ______ ___.
___ ________ ___ _________ ____ ________.
_________ ________ __________ ___ _____.
_____ ______ ____ ____ __________ __________ _________ _________ ____ __________ ___ _______.
________ __________ ____ _______ __________ _____ ______ ___ ___ _________.
__________ __________ ___ ____ ______ ____ ____.
____ __________ ____ ____ ___ _________ _____.
_______ ___ _______ ____ _____ ____ ____ ________ _________ _________ _____.
__________ ___ _____ _____ __________ __________ __________ __________ __________ _______ ______.
____ _________ ________ __________ _______ __________ ______ _______.
________ _________ ____ __________ ______ _________ ____ __________ ____ _________ ______.
____ _______ ___ ________ _______ ____ ____.
________ _________ _______ _______ ____ ___.
________ _______ ___ _______ _____ ______ ___ __________ __________ ____ _______.
_________ ___ _________ __________ _________ __________ ___ _______ _______ ____ _____ ___.
___ ______ ____ _________ __________.
__________ __________ ___ _________ _____ ______ _____ _________.
________ _____ ________ ___ ______ ___ ________ ___.
_____ _____ ___ ______ ____ _____ __________ ___ _______ ______.
_________ __________ __________ ____ _____.
_______ _______ ____ ___ ______ _______ __________.
__________ ___ _______ ___ ________ _______ _______ ___ ________ ___ ________ _____.
_____ _______ __________ __________ __________ ________ ________ ___.
________ _________ ___ _________ _________ ____ _____ __________ _________ ________.
______ __________ ________ ___ __________ ___ ______ ___ _______ ________ ___.
__________ ____ ____ ____ __________ _______.
____ ________ _____ ________ _____ _________ ________ ___ ___ __________.
___ ________ ___ _________ ______ ___ __________ _____ _______ ___ _____ ____.
________ ___ ________ ____ __________ ____ ____ __________ _____ ________ _________ __________.
___ _________ ______ ______ ______ __________ _________.
________ _____ ___ _______ _________.
_________ ______ ________ _____ ______ ______ ____ ____ ___ __________ _____ ____.
__________ __________ ___ ________ _________ _______ _______ _______.
________ _____ ___ ______ _________ ___ _________ ___.
__________ ___ ______ _________ ____ _____ _________.
_______ _________ ______ ___ ____ ___ ______ ______ _____.
_____ ______ ______ _________ __________ ___ _________.
_____ _________ ________ _________ __________.
_________ _______ _____ __________ ____ _______.
________ __________ ________ __________ ____ ______ ______ ____ ________.
_________ __________ __________ __________ ____.
________ _______ ______ ___ __________ __________ ______.
__________ ________ ______ ________ ___ _________ _____ ________ _______ __________ _________ ________.
________ ____ _________ ______ ______ _______ _______ _____ _______ _____ _________ ________.
_________ ___ ___ _____ _______.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers