el $1\mathrm{.}1$ Data visualization and anlysis can be used to analyze ds in Net Income.

tex is able to maintain a high and stable Net Income over this period. Management should be quite pleased with this during a h time in retail globally. Another measure of success, revenue per bloyee, can provide management with even more insight concerning Vet Income.

itex's net Income in millions and the number of employees from $7$ through $2018$ are presented here.

$\backslash$table$[[$Year$,\backslash$table$[[$Net$],[$Income$]],\backslash$table$[[$Number of$],[$Employees$]]],[2007,$$$94,350,79,517],[2008,104,070,89,112],[2009,110,840,92,301],[2010,125,270,100,138],[2011,137,930,109,512],[2012,159,460,120,314],[2013,167,240,128,313],[2014,181,170,137,054],[2015,209,000,152,854],[2016,233,110,162,450],[2017,253,360,171,839],[2018,261,450,174,386]]$

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

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

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

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