$1-$ Data in this file Download this file includes annual rates of productivity, output, capital, and related factors from $2012$ to $2020.$ Create the following charts using the existing data table. Do not copy partial data in your file. Select and filter data where you need to and create all charts in the same worksheet:

a$)$ Create a bar chart for year $2018$ data of the following categories, with horizontal axis starting at $0$:

$*$ Multifactor Productivity

$*$ Labor Productivity

$*$ Capital Productivity

$*$ Intermediate Purchases Productivity

b$)$ Create a column chart for years $2018-2022$ looking at Employment. Vertical axis must start at $0.$

c$)$ Create a radar chart for years $2015-2019$ for the following categories:

$*$ Output

$*$ Hours

$*$ Employment

$*$ Output per Employee

d$)$ A pie chart that shows the percentage of each slice for the year $2022$ including the following elements:

$*$ Combined inputs

$*$ Capital

$*$ Intermediate Purchases

$*$ Labor Compensation

PART TWO

$2-$ Download the Apple Inc. $($AAPL$)$ historical stock market data from Yahoo Finance website. This should be monthly data from the past $12$ months. Save the file out as $.$xlsx before completing the rest of the work.

Create a heat map $($conditional formatting$)$ for columns Open, High, Low, Close, Adj Close for the year.

Create a line chart for all columns. Volume is the largest of all numbers and its line will stand out. Other lines lay flat along the horizontal axis and make it impossible to see variations. Use the chart secondary axis for projecting volume. This will transform your chart to show variations of all numbers.

Copy the previous line chart and paste into the worksheet. Volume should still be on the secondary axis. Use the chart filtering tool to show only High, Low and Volume. Add trendlines for both High and Low.

Create line sparklines for Open, High, Low, and Close columns. Show green and red points at High and Low of each sparkline respectively. Create column sparklines for Open, High, Low and Close columns. Show green and red points at High and Low of each sparkline respectively.