IIBA CBDA Practice Test - Questions Answers, Page 8

Explanation: A bar chart is a graphical representation of data that uses rectangular bars of different heights or lengths to show the values of one or more variables1. A bar chart is suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it can show the frequency or proportion of each category across time.A bar chart can also help identify trends, patterns, or outliers in the data2. A pie chart is a circular chart that shows the relative sizes of data points in a whole by using different-sized and colored slices3. A pie chart is not suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it can only show the distribution of one variable at a time, and it does not show the changes over time.A pie chart can also be misleading or confusing if there are too many categories or if the slices are too similar in size4. A funnel chart is a type of chart that shows the stages of a process and the amount of data that passes through each stage5. A funnel chart is not suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it does not show the categories of delivery options, but rather the progression of customers through a sales or marketing funnel.A funnel chart can help visualize the conversion rates, drop-off rates, or bottlenecks in a process6. A scatter plot is a type of chart that shows the relationship between two numerical variables by using dots to represent the values of each pair of data points. A scatter plot is not suitable for comparing the number of online orders received requesting different types of delivery options for the last 3 years, as it does not show the categories of delivery options, but rather the correlation or association between two continuous variables.A scatter plot can help identify the direction, strength, and shape of the relationship, as well as any outliers or clusters in the data.

Explanation: According to the Guide to Business Data Analytics, PERT (Program Evaluation and Review Technique) is a type of estimation that uses three values: optimistic, pessimistic, and most likely. The PERT estimate is calculated as the weighted average of these three values, with more weight given to the most likely value. PERT can be used to estimate the duration, cost, or other variables of a project or activity, taking into account the uncertainty and variability of the dat a. PERT can help provide a realistic and reliable estimate based on the available information.

Probabilistic linkage is a technique that uses statistical methods to match records from different data sources based on the similarity of key variables, such as name, address, date of birth, etc1.Probabilistic linkage can handle variations, errors, or missing values in the data, and assign a score or probability to each potential match2. Probabilistic linkage would be useful in this situation, as the address column may have different formats, spellings, or abbreviations in the internal and external data sources, and a deterministic linkage (which requires exact matches) might miss some valid matches or create false matches.

Deterministic linkage is a technique that uses predefined rules or criteria to match records from different data sources based on the exact agreement of key variables, such as identifiers, codes, or hashes3. Deterministic linkage would not be useful in this situation, as the address column may not have consistent or unique values in the internal and external data sources, and a probabilistic linkage (which allows for some variation or uncertainty) might find more accurate matches or avoid false matches.

Genetic linkage is a term used in genetics to describe the tendency of genes or DNA sequences that are located close together on a chromosome to be inherited together4. Genetic linkage is not relevant to this situation, as it has nothing to do with matching records from different data sources based on the address column.

Cuff linkage is a term used in sewing to describe the process of attaching a cuff to a sleeve by stitching or fastening.Cuff linkage is not relevant to this situation, as it has nothing to do with matching records from different data sources based on the address column.

Explanation: The mean of a set of numbers is the sum of the numbers divided by the number of numbers. The median of a set of numbers is the middle value when the numbers are arranged in ascending or descending order. To find the mean and median of the given scores, we can use the following steps: To find the mean, we add up all the scores and divide by 7, the number of students. The mean is (64 + 70 + 80 + 80 + 90 + 98 + 100) / 7 = 582 / 7 = 83.14 To find the median, we arrange the scores in ascending order: 64, 70, 80, 80, 90, 98, 100. Since there are an odd number of scores, the median is the middle score, which is 80. Therefore, the mean and median for the outlined scores are 83.14 and 80, respectively.