Question
Using Data Visualization to Analyze Financial Information DA 6.1 Data visualization can be used to compare changes over time. The millions of pounds of products
Using Data Visualization to Analyze Financial Information DA 6.1 Data visualization can be used to compare changes over time. The millions of pounds of products reacquired at end-of life received from customers, and the percentage of actual end-of-life returns and materials that were usable as recycling materials by Caterpillar during 2016 through 2019 are presented here. Measure 2016 2017 2018 2019 Weight in millions of pounds of end-of-life returned materials received 125 130 155 153 Percentage of actual end-of-life returns usable for recycling 91% 92% 92% 91% Instructions There are three parts to this problem. Use Excel or the visualization software of your or your instructors choice to perform the following: a. Create a combination column and line chart that graphs the pounds of product materials received from 2016 to 2019 as bars on the primary vertical axis, and the percentage of the materials received that are usable as a line on the secondary vertical axis. Include a descriptive chart title, axes labels, properly formatted axes, and a legend. b, What information does the chart provide? Explain. c. What do you think that management can do to increase its gross profit as it relates to the end-of-life materials received from customers?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started