Notifications
Clear all
Topic starter
25/10/2022 4:27 am
James wants to analyze profit based on sales of five different product categories.
His source data set consists of 5.8 million rows with columns including region, product category, product name, and sales price.
How should he manipulate the data to facilitate his analysis?
Choose the best answer.
- A . Transpose by region and summarize.
- B . Transpose by product category and summarize.
- C . Transpose by product name and summarize.
- D . Transpose by sales price and summarize.
Suggested Answer: B
Explanation:
B. Transpose by product category and summarize.
We can transpose this data by product category to perform this analysis broken out by product category.
Transposing by sales price, region, or product name will not further his state analytical goal.
Explanation:
B. Transpose by product category and summarize.
We can transpose this data by product category to perform this analysis broken out by product category.
Transposing by sales price, region, or product name will not further his state analytical goal.