Question
You are tasked with analyzing sales data from multiple
sources for a quarterly report. The raw data contains missing values and duplicate records. What should your first step in the analysis process be?Solution
Data cleaning is a critical early step in the analysis process. Without clean and accurate data, any insights derived from the analysis will be unreliable. Cleaning involves removing duplicates, handling missing values (e.g., using imputation techniques), and ensuring consistency. This step ensures the foundation of the analysis is robust.
- Option A : Building predictive models before cleaning the data can lead to biased or inaccurate results.
- Option B : Exploratory analysis comes after cleaning the data to ensure trends reflect reality.
- Option C : While partially correct, removing duplicates and averaging missing values may not always be the best method for handling these issues.
- Option E : Visualizations should be created only after cleaning and analyzing the data for accurate representation.
R and S invested Rs. 18,000 and Rs. 12,000 respectively in a venture. After 5 months, R withdrew Rs. 3,000 and T joined the partnership with Rs. 9,000. ...
The savings of G and H are equal. The difference between H's expenditure and the total savings of G and H is nil. H's income amounts to Rs. 45,000, and ...
‘D’ started a business with a capital of Rs. 15000. After 4 months, ‘E’ joined the business with a capital of Rs. 10000. 6 months after ‘E’,...
Rohit and Dev invested ₹32,000 and ₹18,000 respectively. For the next four months after the first month both kept on adding ₹2000 every month. In ...
'A' initially invested 75% of the total capital in a business. After 4 months, 'C' joined, and at that point, 'A's investment became 50% of the total ca...
P, Q and R enter into a partnership by investing Rs.5000, Rs.8000 and Rs.5600 respectively. After 4 months, P invested Rs.1400 more and Q withdraw the ...
Sonia and Isha started a business with investments of Rs. 3100 and Rs. 2300, respectively. Four months into the business, Jai joined them with an invest...
If the ratio of time periods of investment of A and B is 3:5, profit at the end of the year is Rs.120000 and A’s share in it is Rs.20000, then what is...
K starts a business by investing ₹75,000. Four months later, L joins the business, contributing an amount that is 20% more than K's investment. At the...
- ‘P’ and ‘Q’ invested Rs. 7200 and Rs. 4800 respectively for 9 months and 15 months. P kept 35% of his profit and donated the rest. His remaining pr...
