The data from Exhibit 3 is also in the Excel data file on the course website. Use Excel, along with this file, to determine Mrs. Cook's real income for the last fifteen years. Do this by first converting each price index from percent by dividing by 100. Then, divide gross income by your converted (adjusted) price index. Using Excel, find the mean, median, standard deviation, and variance of her past real income. Explain the meaning of these statistics. Can you use the mean income to forecast future earnings? Take into account both statistical and non-statistical considerations.

Case Link: https://www.csun.edu/sites/default/files/Art%20Vector%20-%20Case%20Text%20Rev_0.pdf

Excel data link: https://www.csun.edu/nazariancollegeadvisement/materials in this page find

----> Art Vector - Student Data Spreadsheet (.xlsx)

I need a explanation as well, page or page and half. And please in 4 to 5 sentences explain what you did overall. Thank you for your help. Good review will be after;))