A. Create descriptive statistics spreadsheet 1. Use the Wage data set posted with this assignment. Open your chosen data file using your spreadsheet program. 2. Rename the first tab to "mydata" by double-clicking on the tab at the bottom, or right-clicking and selecting the option to rename the tab. 3. Add a new sheet by clicking the plus sign next to the first tab, or by right-clicking in the tab area and selecting the option to insert a new sheet. (a) Name the new sheet "desc stats" 4. From cell Al of the desc_stats sheet, enter the text shown in the table below so that columns A and B of the desc stats sheet looks like this: A B Variable Name N 3 Min Max 5 Median EWATER Mean 00 - Standard Deviation Skewness 9 Excess Kurtosis 5. Continue with our example above where the data on the mydata sheet start in column A. In the second column of the desc_stats sheet, enter the formulae shown below: A B Variable Name =mydata ! A1 2 N =COUNTA (mydata ! A2 : A1290) CO Min =MIN (mydata! A2 : A1290) Max =MAX (mydata! A2: A1290) Median =MEDIAN (mydata! A2: A1290) Mean =AVERAGE (mydata ! A2 : A1290) Standard Deviation =STDEV (mydata! A2 : A1290) 1 00 Skewness =SKEW (mydata! A2 : A1290) Excess Kurtosis =KURT (mydata! A2: A1290)