Data merging is an important concept in Data Science Class 10 NCERT where students learn how to combine different sets of data into one meaningful dataset. It helps in analyzing large amounts of information by bringing data together from multiple sources.
Data Merging Class 10 NCERT Solutions
Please choose the correct option in the questions below.
1. The pth percentile of a distribution is such that:
a) p percent of the observations fall at it
b) p percent of the observations fall below it
c) p percent of the observations fall at or below it
d) the value is p.
2. Which of the following function is used for quantiles of quantitative values?
a) Quantile
b) Quantity
c) Quantiles
d) All of the mentioned
3. The distribution of heights of Indian women aged 18 to 24 is approximately normally distributed with a mean of 65.5 inches and standard deviation of 2.5 inches. Calculate the z-score for a woman six feet tall.
a) 2.60
b) 4.11
c) 1.04
d) 1.33
4. What is a z-score?
a) It is the number of standard deviations a particular score lies above or below the mean of the set of scores.
b) It is a standardized measure of the mean of a set of data.
c) It is the average frequency of scores in a sample
d) It is a measure of central tendency in the data.
5. The median, mode, deciles and percentiles are all considered as measures of
a) Mathematical averages
b) Population averages
c) Sample averages
d) Averages of position
6. According to percentiles, the median to be measured must lie in
a) 80th
b) 40th
c) 50th
d) 100th
7. What measures of position divides the distribution into 10 equal parts?
a) Quartiles
b) Deciles
c) Percentiles
d) Range
8. What measures of position divides the distribution into 4 equal parts?
a) Quartiles
b) Deciles
c) Percentiles
d) Range
Standard Questions
Please answer the questions below in no less than 100 words.
1. What is data merging?
Answer: Data merging means combining two or more sets of data into one. This is helpful when you store data in different files or tables and you want to analyze everything together.
2. Why is data merging required in data science?
Answer: The data merging is required in data science:
- It helps to get complete information like if two file having name, another has marks and you want to combine both file.
- It helps to answer better questionks like “Which student score highest?” or “Who failed?”.
- It helps to prepare for analysis like making chart or teaching a concept, merged data etc.
3. Name different ways of merging data sets
Answer: We can perform data merging by implementing data joins on the databases in frame. There are three categories of data joins:
- One to One Joins
- One to Many Joins
- Many to Many Joins
4. Explain one-to-one join with the help of an example
Answer: One-to-one join is probably one of the simplest join techniques. In this type of join, each row in one table is linked to a single row in another table using a “key” column.
In the database, a one-to-one relationship looks like this:
To join this, we use a primary key to connect two tables in the database. The employee ID is the primary key in the employee table, and in another table, the same employee ID is also the primary key. When you join these tables, you match rows where the employee ID is the same.
5. Explain one-to-many join with the help of an example
Answer: A one-to-many join means that one item in one table is connected to many items in another table.
In the database, a one-to-many relationship looks like this:
In the above table the student ID is a primary key in the students table, and in the library table, student ID is defined as a foreign key. Now when we join these tables, then we match all books to the student who borrowed them.
6. Explain many-to-many join with the help of an example
Answer: A many-to-many join happens when many items in one table are connected to many items in another table.
The below table demonstrates the Student table, which contains a record for every student. It also contains a Courses table, which contains a record for each course. A join table called Enrollments creates two one-to-many relationships, one between each of the two tables.
7. Think and explain how z-score can be used to determine average lifespan of car tires.
Answer: We want to understand how long car tyres last on average and whether a specific tyre’s lifespan is normal, better or worse than average.
- Step 1: Collect Tyre Lifespan Data
- Step 2: Calculate Z-Score
- Step 3: Interpret the Z-Score
Disclaimer: We have taken an effort to provide you with the accurate handout of “Data Merging Class 10 NCERT Solutions“. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above CBSE study material present on our websites is for education purpose, not our copyrights.
All the above content and Screenshot are taken from Data Science Class 10 Microsoft Textbook published on CBSE Website, CBSE Sample Paper, CBSE Old Sample Paper, CBSE Board Paper and CBSE Support Material which is present in CBSEACADEMIC website This Textbook and Support Material are legally copyright by Central Board of Secondary Education. We are only providing a medium and helping the students to improve the performances in the examination.
Images and content shown above are the property of individual organisations and are used here for reference purposes only. To make it easy to understand, some of the content and images are generated by AI and cross-checked by the teachers. For more information, refer to the official CBSE textbooks available at cbseacademic.nic.in.