Here is the Company Data

Open the Company Data 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 value of the field is derived from that of other fields) A P Q 1 Field 2 Type 3 Size 4 State 5 Sales (SM) 6 Profits (SM) 7 Assets (SM) 8 #Employees 9 profit/emp 10 profit/sales (%) 11 12 13 14 D F G H 1 L M N o 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 %