Question
Two identical items are sold for Rs.200 each, with 10%
gain on one but 10% loss on the other. What is the net percentage loss or gain?Solution
Given, that the SP of each item is the same, each Rs. 200. Total SP of both items = 2 × 200 = Rs. 400 CP of first article = 200 × (100/110) = Rs. 2000/11 CP of second article = 200 × (100/90) = Rs. 2000/9 Total CP of both article = 2000/11 + 2000/9 = (18000 + 22000) /99 = 40000/99 Ratio of total CP to total SP = 40000/99: 400 = 100:99 Let CP = 100 and SP = 99 Loss = 100-99 = 1 Loss percentage = (1/100) x 100 = 1% Smart Approach- When the selling price of two items is the same then the profit or loss on them is- =10-10+(10×-10)/100 = -1% (negative sign denote loss) = 1% loss
Which analytics type is focused on predicting future outcomes?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
Data cleansing is primarily concerned with:
Which type of OLAP allows operations on pre-aggregated data cubes?
What is a data mart?
A data cube allows analysis by:
A star schema in a data warehouse consists of:
Which schema uses multiple fact tables sharing dimension tables?
Which of the following is NOT a common OLAP operation?
Which OLAP operation allows users to view data at different levels of granularity?