Hey please help me answer this question please add steps you followed to generate the data in excel.

URGENT

Thanks

Year	Males	Females	CPI
1997	18.1	13.21	90
1998	20.1	12.64	90.6
1999	19.86	13.99	92.1
2000	21.36	14.78	95.3
2001	22.16	17.04	97.1
2002	23.73	17.13	100
2003	24.6	18.67	103.4
2004	23.32	16.93	105.3
2005	24.97	18.8	108.2
2006	25.27	17.78	110.4
2007	26.24	19.78	112.5
2008	24.9	19.54	115.9
2009	28.33	22.29	115.7
2010	29.09	22.42	118.2
2011	26.98	21.31	122.7
2012	28.34	22.83	125.1
2013	29.4	22.09	126.6
2014	31.93	25.24	128.8
2015	29.66	23.69	129.3
2016	33.16	24.32	130.9
2017	31.38	27.85	132.4
2018	32.45	28.01	135.3
2019	33.95	26.99	137.5

Part A: The Cost of Living For this part, use the file WageXYZ.csv, where XYZ is the number that is assigned to you by the Quiz on Learn. The file contains annual series of average nominal hourly wages for males and females in a particular province and industry expressed in dollars per hour. The specific province and industry for your dataset is described in the WageDescriptions.csv file. Look for the row associated by your assigned number. The file also contains the annual series of the consumer price index base 100 = 2002 in that province (Statistics Canada, 2020). 1. Plot the evolution of the hourly nominal wage for males and females on the same chart. Interpret what you see: what kind of trending behaviour, is there a difference between males and females in terms of trends or fluctuations, etc. 2. Plot the evolution of hourly real wage in dollars of 2002 for males and females on the same chart. Interpret what you see and compare this chart with the one you obtained in the previous question. Which chart between this one and the one produced in the previous question provides a better picture of the evolution of the standard of living of individuals working in that industry? Explain. 3. Fit a linear trend to both real wage series and plot the two trends on the same graph. Interpret what you see: is the wage gap changing on average? What is the annual change on average over that period for males and females? Discuss (Hint: To answer the question, you can look at the coefficient of time of the trend equations). 4. Detrend the real wage series using the linear trends computed in the previous question. Since the series are annual, the detrended series are the cyclical components. Using a scatter plot, analyze the comovement between the two cyclical components. Try to explain your results: e.g. why there is a positive, negative or no comovement between the two variables