Open the Fortune500 file in EXCEL and study the Data and Metadata worksheets, then fill in the blanks of each of the following questions with an integer: 1. The column heading starts at row 2. There are fields 3. There are records 4. There are numeric fields 5. There are categorical fields 6. There are industry types 7. There are company sizes 8. There are calculated fields (i.e., the values of the field is derived from other fields) Open the Data JMP file that you saved above to answer the following questions by filling in the blanks with an integer: 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 1. There are companies in Kentucky. (integer) 2. There are companies in the computer industry. (integer) 3. There are companies have less than $1,000 millions in sales. (integer) 4. There are companies have 20,000 or more employees. (integer) 5. There are companies have between $5,000 and $10,000 millions in assets. (integer) 6. The average sales of companies in the computer industry is (2 decimal places) 7. The average profits of companies in the pharmaceutical industry is (2 decimal places) 8. The average number of employees for medium size companies is (2 decimal places) 9. The average assets for small size companies is (2) decimal places) 10. The average profit/emp for all companies is (2 decimal Answer the following questions by filling in the blanks with an integer or a number rounded to 2 decimal places as indicated: 1. There are companies having an "Above Average" productivity. (integer) 2. There are companies having a "Below Average" productivity. (integer) 3. There are companies in the computer industry having an "Above Average" productivity. (integer). 4. There are companies in the pharmaceutical industry having an "Above Average" productivity. (integer). 5. There are small companies having a "Below Average" productivity. (integer)
