Question
Total number of students who play Cricket are what
percent more or less than total number of students who play Badminton? Read the passage given below and answer the following questions. A school has a total of 990 students. Each student has to select at least 1 sport among Cricket, Football and Badminton. Students who play only Badminton are 50% of students who play only Football and ratio of students who play only Cricket to students who play only Badminton is 5:2. Students who play all 3 games together are 50% of students who play only Badminton. Students who play both Cricket and Badminton together are equal to students who play both Football and Badminton but not Cricket. Students who play both Cricket and Football but not Badminton are 50% more than students who play all 3 games together. Students who play both Cricket and Football but not Badminton are 50% of students who play both Football and Badminton together.Solution
Let students who play only Football be 20x. So, students who play only Badminton = 10x And, students who play only Cricket = 25x Now, students who play all 3 games together = 5x Now, students who play Cricket and Football but not Badminton = 7.5x And, students who play Football and Badminton together = 15x Now, students who play Football and Badminton but not Cricket = 10x Now, students who play both Cricket and Badminton together = 10x So, students who play Cricket and Badminton but not Football = 5x According to question, => 25x + 7.5x + 20x + 5x + 5x + 10x + 10x = 990 => x = 12 Total number of students who play Cricket = 300 + 90 + 60 + 60 = 510 Total number of students who play Badminton = 60 + 60 + 120 + 120 = 360 Required % = [(510 β 360)/360] Γ 100 = 41(2/3)%
In a data warehouse, a fact table typically contains:
Which type of schema uses a central fact table connected to dimension tables?
Which analytics type is focused on predicting future outcomes?
Metadata in data warehousing refers to:
What is a 'star schema' in data warehouse design?
Which of the following best describes a fact constellation schema in a data warehouse?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=βAsiaβ)?
In a data warehouse, which type of table stores quantitative data for analysis?
A snowflake schema is different from a star schema because:
Which clause is used to sort the results in SQL?