Start learning 50% faster. Sign in now
Explanation: Converting all revenue values to a common currency ensures uniformity, enabling accurate comparison and aggregation. This approach requires using reliable and updated exchange rates to maintain data integrity. It is especially critical in financial analysis, where inconsistencies in currency formats can lead to significant inaccuracies in insights and decisions. Automating this process through scripts or tools ensures scalability and consistency when dealing with large datasets. Option A: Removing inconsistent rows leads to data loss and affects the completeness of analysis. Option C: Ignoring inconsistencies results in flawed comparisons and unreliable outcomes. Option D: Replacing currency formats with generic placeholders eliminates crucial contextual information. Option E: Treating inconsistent rows as outliers disregards their relevance and importance in the dataset.
13 24 75 134 447 892
...362 284 393 451 144 221
...14 26 50 98 194 ?
...89 78 74 67 63 ?
D irection: Which of the following will replace ‘?’ in the following series
460, 462, ‘?’, 467.5, 470.97
...If 43 34 x 36 39 38
Then, (x/2) + 0.5 + x = ?
...35.25 71 146 296 624 1376
...9134 170 ? 577 1306
...4 8 12 48 ? 432
...11, 12, 16, 25, ?, 66