Excel $1\mathrm{.}1$ Data visualization and anlysis can be used to analyze trends in Net

Income.

Inditex is able to maintain a high and stable Net Income over this time period.

Management should be quite pleased with this during a tough time in retail

globally. Another measure of success, revenue per employee, can provide

management with even more insight concerning its Net Income.

Inditex's net Income in millions and the number of employees from $2007$ through

$2018$ are presented here.

Note Efffecitve tax rate

Use Excel to perform the following. There are four parts to this problem.

a$.$ Calculate Net Income per employee for each year.

b$.$ Graph the Net Income per employee over the $12-$year period using a

clustered column chart with a trend line. Include axes labels, proper

monetary formatting on the axes, and a descriptive chart title.

c$.$ Provide and explaination on the difference between relative

refernces and absolute references

d$.$ Calculate the Net Income after tax per employee for $2018$ and $2017$ using

an absolute reference