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.
- A furniture set was purchased for Rs. 850 and fixed with an additional Rs. 450. It was then tagged 40% above the cost but later sold at a 15% loss. What is...
A watch is purchased for Rs. 4200 and Rs. 300 is spent on its repair. The watch is then marked 20% above its effective cost price and then sold for Rs....
Article ‘P’, if sold at a profit of 20% earns a profit of Rs. 400. If article ‘P’ is marked 50% above its cost price and then sold after offerin...
The selling price of y items is equal to the cost price of 720 items. If the profit made is 60%, then find the value of y.
Marked price of an article is Rs.260 more than its cost price. If profit earned is equal to the discount given then find the profit earned?
A shopkeeper sold an article after giving a discount of 23% and made a profit of Rs.26. Find the difference between the marked price and selling price o...
A seller marks up the price of an article by 35% and then gives a discount of 20%. What is the profit if the marked price of the article is ₹810?
Each of the articles is marked 80% above its cost price and a 30% discount was given on it while selling. The selling price of article A is Rs. 126 less...
Cost price of an article is Rs X and marked price is 400% more than cost price. To gain profit of 100%, what percent of discount should be offered on th...
The sale price of an item is set at 30% above the cost price. After giving a 10% discount on the marked price, what is the merchant’s profit percentag...
