Search A Ranka, Nishka RN X AutoSave . Off) HW01 (1).xIsx - Excel View Automate Help Acrobat Power Pivot Comments Share File Home Insert Draw Page Layout Formulas Data Review AutoSum & Cut O Calibri v 11 A A ab Wrap Text General Fill Paste [ Copy Conditional Format as Cell Insert Delete Format Sort & Find 8 Analyze Sensitivity E Merge & Center $ % " Format Painter Formatting Table Styles Clear Filter ~ Select v Data Clipboard Alignment Number Styles Cells Editing Analysis Sensitivity Font 110 X V fx W - A B C D E F G H J K L M N O P Q R S T U V 10 9 60.3 2091.422 Female Sign your name: 11 10 62.3 2644.418 Female 12 11 94.2 1211.05 Male 13 12 45.9 416.15 Female (24 points) 14 13 52.6 1773.11 Female 1. Calculate the following using Excell formulas 15 14 82.2 1517.407 Male Sales 16 15 76.7 533.868 Female Income 17 16 66.9 1220.234 Male Min 10.1 37.807 17 12.4 228.996 Female Max 118.3 3397.792 18 19 18 52.6 1052.263 Female Mean 51.44091 1065.073 19 28.3 932.843 Male Median 49.4 894.021 21 20 53.9 1186.123 Male Range 44.45 1094.521 22 21 28.9 830.233 Male StDev 27.38456 737.6208 23 22 15.9 405.62 Female Q1 (exc) 26.775 457.9668 24 23 50.7 156.772 Male Q2 (exc) 49.4 894.021 17.8 588.625 Male Q2 (exc) 71.225 1552.488 24 25 51.3 1423.589 Female 90th Percentile (exc) 90.5 2161.894 27 26 74.4 2478.522 Female Skewness 0.333881 0.81386 28 27 88.2 2748.811 Female Kurtosis -0.82249 -0.06424 29 28 79 2278.836 Female (6 points) 30 29 55.2 1713.624 Female 2. Answer the following questions 31 30 7 414.052 Female 32 31 41.3 932.214 Female What is the skeweness on Income (high, moderate, symmetric, left, right)? Symmetric as it is between -0.5 and 0.5 33 32 65.4 2289.968 Female What is the skeweness on Sales (high, moderate, symmetric, left, right)? |moderate as it is between 0.5 and 1 34 33 29.6 774.1 Male 35 34 49.8 827.344 Female What is kurtosis on Income (flat, normal, peaked)? 36 35 73.7 1273.773 Male What is kurtosis on Sales (flat, normal, peaked)? 37 36 619.438 Female 38 37 833.354 Female How many customers have an Income lower then the median Income? 39 38 51.2 1293.43 Female How many cusomters have an Income more than the 90th percentile income? Sales 40 39 59.4 1699.22 Female Income 41 40 107.3 1566.222 Female Make sure you have the "Data Analysis" add-in under the "Data" tab 42 11 90.7 2265.298 Male To add this, go to Files > Options > Add-Ins > Go Mean 51.44091 Mean 1065.073 43 12 74.4 1892.695 Female Then check thebox for Analysis Toolpak Standard E 0.911806 Standard E 24.56009 Nile 1 - - Enter Ex Accessibility: Investigate G 00% 10:46 PM Type here to search W N G X zea 9/12/2023