1. Rows and are duplicates (Note: place the smaller number first). (Hint: Tables > Summary & cast all columns to [ Group ] to create an output table with a column labeled "N Rows") 2. Row is an outlier. (Hint: Analyze > Screening > Explore Outliers & cast only columns contains numeric values to [Y, Columns ) then choose [ Quantile Range Outliers ]) 3. Row has an erroneous value in the Size column. (Hint: Rows > Row Section > Select where; then check the "Compare column" box to compare columns Company _Size and Size) 4. State has a missing value in row 5. Assets ($M) has a missing value in row (Hint: Analyze > Screening > Explore Missing Values) 6. There will be rows of clean data after you delete the duplicate and outlier. 7. There will be columns of clean data afer you delete the Size column. Here is the company metadata H L M N 1 Field 2 Type 3 Size 4 State 5 Sales ($M) 6 Profits ($M) 7 Assets ($M) 8 #Employees 9 profit/emp 10 profit/sales (%) Data Type Explanation Categorical Industry Type: Computer/Pharmaceutical Categorical A small company has less than 20,000 employees. A medium company has between 20,000 to 40,000 employees. A big company has 40,000 or more employees. Categorical One of 50 states in the U.S. Numeric Annual sales in millions of dollars Numeric Annual profits in millions of dollars Numeric Annual assets in millions of dollars Numeric #employees Numeric Profit per employee Numeric Profit per sales in % Here is the company data PIGUI FITTIILIGI VALAISIELLEU FUI LUI JUU cumpares. 2 Use to compare profitability of two company types. 3 4 Type Size State Sales ($M) Profits ($M Assets ($M) #Employee profit/emp profit/sale:1(%) 5 Computer small Ohio 855.1 31 615.2 7523 4120.697 3.625307 6 Pharmaceu big New Jersey 5453.5 859.8 4851.6 40929 21007.11 15.76602 7 Computer small Illinois 2153.7 153 2233.7 8200 18658.54 7.104053 8 Pharmaceu big Massachuse 6747 1102.2 5681.5 50816 21690.02 16.33615 9 Computer small Ohio 5284 454 2743.9 12068 37620.15 8.591976 10 Pharmaceu big Massachuse 9422 747 8497 54100 13807.76 7.928253 11 Computer small Kentucky 2876.1 333.3 2090.4 9500 35084.21 11.58861 12 Computer small Georgia 709.3 41.4 468.1 5000 8280 5.83674 13 Computer small Ohio 2952.1 -680.4 1860.7 18000 -37800 -23.048 14 Computer small Ohio 784.7 89 955.8 4708 18903.99 11.34191 15 Computer small Washingto 1324.3 -119.7 1040.2 13740 -8711.79 -9.03874 16 Pharmaceu medium California 4175.6 939.5 5848 28200 33315.6 22.49976 17 Computer big California 11899 829 10075 95000 8726.316 6.966972 18 Computer small Kentucky 873.6 79.5 808 8200 9695.122 9.100275 19 Pharmaceu big Massachuse 9844 1082 7919 83100 13020.46 10.99147 20 Pharmaceu small Illinois 969.2 227.4 784 3418 66530.13 23.46265 21 Pharmaceu medium California 6698.4 1495.4 6756.7 34400 43470.93 22.32473 22 Computer big California 5956 412 4500 56000 7357.143 6.917394 23 Pharmaceu big Massachuse 5903.7 681.1 8324.8 42100 16178.15 11.53683 24 Computer medium Texas 2959.3 252.8 5611.1 31404 8049.93 8.542561 25 Pharmaceu small Illinois 1198.3 86.5 1791.7 8527 10144.25 7.21856 26 Computer small Ohio 990.5 20.9 624.3 8578 2436.465 2.110045 27 Pharmaceu medium California 3243 471.3 3613.5 21300 22126.76 14.53284 28 Computer small Georgia 1382.3 0.3 1076.8 2900 103.4483 0.021703 29 Computer small Georgia 1014 47.7 977 9100 5241.758 4.704142 30 Computer small 1769.2 60.8 1269.1 10200 5960.784 3.436582 31 Computer small Kentucky 1643.9 118.3 1618.8 9548 12390.03 7.196301 32 Computer big California 1096.9 -639.3 10751 82300 7767.92 -58.2824 33 Pharmaceu medium New Jersey 2916.3 176 3246.9 20100 8756.219 6.035044 34 Computer medium Illinois 3078.4 424.3 2725.7 28334 -14974.9 13.7831 35 Pharmaceu medium California 4272 412.7 3051.6 33000 12506.06 9.660581 36 Computer big 63438 3758 77734 383220 9806.378 5.923894 Ohio 1. Rows and are duplicates (Note: place the smaller number first). (Hint: Tables > Summary & cast all columns to [ Group ] to create an output table with a column labeled "N Rows") 2. Row is an outlier. (Hint: Analyze > Screening > Explore Outliers & cast only columns contains numeric values to [Y, Columns ) then choose [ Quantile Range Outliers ]) 3. Row has an erroneous value in the Size column. (Hint: Rows > Row Section > Select where; then check the "Compare column" box to compare columns Company _Size and Size) 4. State has a missing value in row 5. Assets ($M) has a missing value in row (Hint: Analyze > Screening > Explore Missing Values) 6. There will be rows of clean data after you delete the duplicate and outlier. 7. There will be columns of clean data afer you delete the Size column. Here is the company metadata H L M N 1 Field 2 Type 3 Size 4 State 5 Sales ($M) 6 Profits ($M) 7 Assets ($M) 8 #Employees 9 profit/emp 10 profit/sales (%) Data Type Explanation Categorical Industry Type: Computer/Pharmaceutical Categorical A small company has less than 20,000 employees. A medium company has between 20,000 to 40,000 employees. A big company has 40,000 or more employees. Categorical One of 50 states in the U.S. Numeric Annual sales in millions of dollars Numeric Annual profits in millions of dollars Numeric Annual assets in millions of dollars Numeric #employees Numeric Profit per employee Numeric Profit per sales in % Here is the company data PIGUI FITTIILIGI VALAISIELLEU FUI LUI JUU cumpares. 2 Use to compare profitability of two company types. 3 4 Type Size State Sales ($M) Profits ($M Assets ($M) #Employee profit/emp profit/sale:1(%) 5 Computer small Ohio 855.1 31 615.2 7523 4120.697 3.625307 6 Pharmaceu big New Jersey 5453.5 859.8 4851.6 40929 21007.11 15.76602 7 Computer small Illinois 2153.7 153 2233.7 8200 18658.54 7.104053 8 Pharmaceu big Massachuse 6747 1102.2 5681.5 50816 21690.02 16.33615 9 Computer small Ohio 5284 454 2743.9 12068 37620.15 8.591976 10 Pharmaceu big Massachuse 9422 747 8497 54100 13807.76 7.928253 11 Computer small Kentucky 2876.1 333.3 2090.4 9500 35084.21 11.58861 12 Computer small Georgia 709.3 41.4 468.1 5000 8280 5.83674 13 Computer small Ohio 2952.1 -680.4 1860.7 18000 -37800 -23.048 14 Computer small Ohio 784.7 89 955.8 4708 18903.99 11.34191 15 Computer small Washingto 1324.3 -119.7 1040.2 13740 -8711.79 -9.03874 16 Pharmaceu medium California 4175.6 939.5 5848 28200 33315.6 22.49976 17 Computer big California 11899 829 10075 95000 8726.316 6.966972 18 Computer small Kentucky 873.6 79.5 808 8200 9695.122 9.100275 19 Pharmaceu big Massachuse 9844 1082 7919 83100 13020.46 10.99147 20 Pharmaceu small Illinois 969.2 227.4 784 3418 66530.13 23.46265 21 Pharmaceu medium California 6698.4 1495.4 6756.7 34400 43470.93 22.32473 22 Computer big California 5956 412 4500 56000 7357.143 6.917394 23 Pharmaceu big Massachuse 5903.7 681.1 8324.8 42100 16178.15 11.53683 24 Computer medium Texas 2959.3 252.8 5611.1 31404 8049.93 8.542561 25 Pharmaceu small Illinois 1198.3 86.5 1791.7 8527 10144.25 7.21856 26 Computer small Ohio 990.5 20.9 624.3 8578 2436.465 2.110045 27 Pharmaceu medium California 3243 471.3 3613.5 21300 22126.76 14.53284 28 Computer small Georgia 1382.3 0.3 1076.8 2900 103.4483 0.021703 29 Computer small Georgia 1014 47.7 977 9100 5241.758 4.704142 30 Computer small 1769.2 60.8 1269.1 10200 5960.784 3.436582 31 Computer small Kentucky 1643.9 118.3 1618.8 9548 12390.03 7.196301 32 Computer big California 1096.9 -639.3 10751 82300 7767.92 -58.2824 33 Pharmaceu medium New Jersey 2916.3 176 3246.9 20100 8756.219 6.035044 34 Computer medium Illinois 3078.4 424.3 2725.7 28334 -14974.9 13.7831 35 Pharmaceu medium California 4272 412.7 3051.6 33000 12506.06 9.660581 36 Computer big 63438 3758 77734 383220 9806.378 5.923894 Ohio