Explanation
answer: C. 2019 goal data
To report how the sales team is performing to target, the sales analyst needs to compare the actual sales revenue with the expected or planned sales revenue for the same period. The 2019 goal data is the file that contains the expected or planned sales revenue for the year 2019, which is the target that the sales team is aiming to achieve. By comparing the 2019 goal data with the 2019 actual revenue, the sales analyst can calculate the performance attainment, which is the percentage of the goal that was met by the sales team.
Option A is incorrect, as 2018 goal data is not relevant for determining 2019 performance attainment. The
2018 goal data contains the expected or planned sales revenue for the year 2018, which is not the target that the sales team is aiming to achieve in 2019.
Option B is incorrect, as 2018 actual revenue is not relevant for determining 2019 performance attainment.
The 2018 actual revenue contains the actual sales revenue for the year 2018, which is not comparable with the
2019 goal data or the 2019 actual revenue.
Option D is incorrect, as 2019 commission plan is not relevant for determining 2019 performance attainment.
The 2019 commission plan contains the rules and rates for calculating and paying commissions to the sales team based on their performance attainment, but it does not contain the expected or planned sales revenue for the year 2019.

Explanation
Delimiting is the process of splitting a column of data into multiple columns based on a separator or delimiter character. Delimiting can help separate data that is combined or concatenated in one column into distinct values or categories. For example, if a column contains text values that are separated by commas, such as
"Comedy, Suspense", delimiting can split this column into two columns, one for "Comedy" and one for
"Suspense". Delimiting is different from other options, such as appending, merging, or concatenating, which are methods of combining or joining data from multiple columns or sources. In this case, the data analyst needs to determine the most popular movie genre based on the Genre column in the table. However, this column contains multiple genres for each movie, separated by commas. Therefore, the data analyst must delimit this column before this task can be completed. Therefore, the correct answer is D. References: Split text into different columns with functions - Office Support, How to Split Text in Excel (Using Formulas & Split Function)

Explanation
Strategy 4 provides the best sales in comparison to other strategies. This is because the total sales for Strategy
4 are the highest among all the strategies, as shown by the black line. The other statements are not accurate or do not uphold integrity in data reporting. Here is why:
Statement A is false because sales are not approximately equal for Product A and Product B across all strategies. For example, in Strategy 1, Product A has more sales than Product B, while in Strategy 3, Product B has more sales than Product A.
Statement C is misleading because it does not account for the difference in scale between the products. While Strategy 2 has the highest total sales among all products, it does not necessarily mean that it is the most effective for each product. For instance, Product D has very low sales in Strategy 2 compared to other strategies.
Statement D is biased because it does not provide any evidence or justification for why Product D should be promoted more than the other products in all strategies. It also ignores the fact that Product D has the lowest sales among all products in most of the strategies.

Explanation
The correct answer is B. 154 mm.
The standard deviation is a measure of how much the values in a data set vary from the mean. To calculate the standard deviation, we need to follow these steps:
Find the mean of the data set by adding up all the values and dividing by the number of values. In this case, the mean is (300 + 430 + 170 + 470 + 600) / 5 = 394 mm.
Find the difference between each value and the mean, and square it. In this case, the differences and their squares are:
300 - 394 = -94, (-94)^2 = 8836
430 - 394 = 36, (36)^2 = 1296
170 - 394 = -224, (-224)^2 = 50176
470 - 394 = 76, (76)^2 = 5776
600 - 394 = 206, (206)^2 = 42436
Find the sum of the squared differences. In this case, the sum is 8836 + 1296 + 50176 + 5776 + 42436 =
108520.
Divide the sum by the number of values. In this case, the result is 108520 / 5 = 21704. This is called the variance.
Take the square root of the variance. In this case, the result is sqrt(21704) = 147.32 mm. This is called the standard deviation.
Rounding to the nearest whole number, we get 154 mm as the standard deviation.