1- Data in this file show in the picture 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) A column chart year 2015 data of the following categories:

* Hours

* Employment

* Output per employee

* Labor compensation

b) A line chart for Capital from 2012 to 2020.

c) A pie chart that shows the percentage of each slice for the year 2020 including the following elements:

* Multifactor productivity

* Labor productivity

* Intermediate purchases

* Capital

d) A radar chart for combined inputs from 2012 through 2020.

2- Download Ford Motor Company (F) historical stock market data from Yahoo Finance website. This should be monthly data from the past 12 months.

• Create a heat map including columns Open, High, Low, 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.
• Use another copy of the line chart. Filter out Open, High, Adj Close, and Close lines from the chart. Leave only Low and Volume. This line chart has trend lines only for Low and Volume.
• 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. Make vertical axis minimum and maximum value options Same for all sparklines.

AutoSave OFF SESU escel24 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) Insert v v 11 = = = General 28 Ou 5 2. Delete v Paste a. A ~ BI E V Ideas $ %) E OOO Conditional Format Cell Formatting as Table Styles Sort & Filter Format v Find & Select Sensitivity K25 X fx C D E F G J K L . N 0 o P Q R S T U V V 2014 1 Annual Rates 2 3 Multifactor productivity Labor productivity 5 Output 6 Combined inputs 7 Capital 8 Hours 9 Intermediate purchases 10 Capital productivity 11 Intermediate purchases productivity 12 Employment 13 Output per employee 14 Labor compensation 15 16 17 18 19 20 21 22 23 24 2012 96.918 94.977 ro 100.504 103.700 100.454 scene 105.819 104.697 100.049 95.995 105.378 95.374 102.991 2013 97.116 101.100 104.153 107.246 102.507 103.020 ... 109.440 101.606 95.170 105.777 98.465 101.714 96.872 98.439 . 101.528 ... 104.806 103.334 103.138 105.286 98.252 96.431 101.793 2015 93.345 90.672 97.372 104.314 103.101 107.389 104.295 . 94.444 93.362 103.785 93.821 105.707 2016 88.093 87.468 98.862 112.224 105.304 113.027 114.199 93.882 86.569 112.151 88.150 112.438 2017 86.550 89.382 101.653 117.451 106.796 113.729 120.938 95.184 84.054 117.729 86.345 115.661 2018 85.376 91.487 105.837 123.966 109.822 115.685 128.993 96.371 82.048 110.956 95.386 118.152 2019 84.225 90.470 111.465 132.342 113.782 123.207 139.026 97.964 80.176 115.339 96.642 120.992 2020 83.577 92.957 112.163 134.203 117.731 120.661 140.443 95.271 79.864 117.331 95.596 127.039 99.740 107.030 25 26 27 28 29 30 31 32 33 Annual Rates + + 100%