8 Exercise 4-15 (Algo) (LO4-4) Listed below are the commissions earned ($000) last year by a sample of 15 sales representatives at Furniture Patch Inc. $ 3.9 $ 5.7 $ 7.3 $10.6 $12.0 $13.6 $14.4 $14.8 $17.0 $17.4 $17.6 $22.3 $35.3 $43.2 $78.3 Book Click here for the Excel Data File In ferences a. Determine the mean, median, and the standard deviation. (Round your answers to 2 decimal places.) Mean Median Standard deviation b. Determine the coefficient of skewness using Pearson's method. (Round your answer to 3 decimal places.) Coefficient of skewness c. Determine the coefficient of skewness using the software method. (Round your answer to 3 decimal places.) Coefficient of skewnessBook1 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Cut Calibri 11 Wrap Text General E AutoSum En Copy Fill Paste Format Painter 3 . A FF Merge & Center 7 % Conditional Format Cell Insert Delete Format Sort & Find & Formatting * as Table * Styles 2 Clear Filter Select - Clipboard Font Alignment Number Styles Cells Editing A17 fac Document Recovery A B C D E F G H J K L M N Excel has recovered the following files. Save 1 Commissions the ones you wish to keep. 3.9 Available files 3 5.7 Book1 (version 1).xlsb [Autos... 4 7.3 Version created from the last ... 10.6 5:43 AM Tuesday, May 2, 2023 6 12 7 13.6 8 14.4 9 14.8 10 17 11 17.4 12 17.6 13 22.3 14 35.3 15 43.2 16 78.3 17 18 Coefficient of Skewness 2.271498 19 20 21 22 @ Which file do I want to save? 23 24 Close 14 4 Sheet1 Sheet2 Sheet3 ReadyBook1 - Microsoft Excel - 0 Home Insert Page Layout Formulas Data Review View - * Cut 11 - A A" Wrap Text E AutoSum - General En Copy Fill Paste BIUMA F a Merge & Center - $ % Conditional Format Cell Insert Delete Format Sort & Find & Format Painter Formatting * as Table * Styles 2 Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing SUM vox v fx =ske Document Recovery A B C D E F G H I J K L M N O Excel has recovered the following files. Save 1 Commissions the ones you wish to keep. 3.9 Available files 5.7 Book1 (version 1).xlsb [Autos... 4 7.3 Version created from the last ... 5 10.6 5:43 AM Tuesday, May 2, 2023 6 12 7 13.6 8 14.4 9 14.8 10 17 11 17.4 12 17.6 13 22.3 14 35.3 15 43.2 16 78.3 17 18 Coefficient of Skewness =ske 19 & SKEW Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean 20 21 22 @ Which file do I want to save? 23Book1 - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View * Cut 11 - A A Wrap Text E AutoSum General En Copy Fill Paste Conditional Format Cell Insert Delete Format Sort & Find & Format Painter BIUMA Merge & Center - $ % $68 408 Formatting * as Table * Styles 2 Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing SUM YO XV f =SKEW(A2:A16 Document Recovery A B C D E F G H J K L M N O Excel has recovered the following files. Save 1 Commissions the ones you wish to keep. IN 3.9 Available files 5.7 Book1 (version 1).xlsb [Autos... 7.3 Version created from the last ... 5 10.6 5:43 AM Tuesday, May 2, 2023 6 12 13.6 8 14.4 9 14.8 10 17 11 17.4 12 17.6 13 22.3 14 35.3 15 43.2 16 78.3 17 18 Coefficient of Skewness =SKEW(A2:A16) 19 SKEW(number1, [number2], ...) 20 21 22 @ Which file do I want to save? 23 24Book1 - Microsoft Excel Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 A A Wrap Text General En Copy Paste Format Painter BIUT A Merge & Center - $- % " Conditional Format Cell Ins Formatting * as Table * Styles Clipboard Font Alignment Number Styles C19 fc Document Recovery A B C D E F G H Excel has recovered the following files. Save Commissions the ones you wish to keep. 3.9 Available files 5.7 Book1 (version 1).xlsb [Autos... 4 7.3 Version created from the last ... 5 10.6 5:43 AM Tuesday, May 2, 2023 6 12 7 13.6 8 14.4 9 14.8 10 17 11 17.4 12 17.6 13 22.3 14 35.3 15 43.2 16 78.3 17 18 Coefficient of Skewness | 2.271498 19 20 21 22