Import the Data worksheet of the Fortune$500$ Download Fortune$500$excel file into JMP Pro. $($Hint: select only the Data Worksheet to open and adjust the "Column headers start on row" to match the header row number of the Data Worksheet.$)$

Add a new categorical column called Company$\_$Size $($Hint: Cols $>$ New Columns$).$ Assign a value:

"small" if the company has less than $20,000$ employees

"medium" if the company has $20,000$ or more but less than $40,000$ employees

"big" if the company has $40,000$ or more employees.

Hint: Use the following formula, which you can copy$-$and$-$paste directly into the formula panel of the newly added column called Company$\_$Size:

If$($ :Name$("$# Employees" $)<20000,$

"small",

If$($ :Name$("$# Employees" $)<40000,$

"medium",

"big"$))$

Save the above data table as a JMP file called Data $($Hint: File $>$ Save As$).$

Flag question: Question $2$

Question $20\mathrm{.}3$ pts

Open the Data JMP file that you saved above to answer the following questions by filling in the blanks with an integer:

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"$)$

Row $\_\_\_\_\_$

is an outlier. $($Hint: Analyze $>$ Screening $>$ Explore Outliers & cast only columns contains numeric values to $[$ Y$,$ Columns $]$ then choose $[$ Quantile Range Outliers $])$

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$)$

State has a missing value in row $\_\_\_\_\_.$

Assets $($$M$)$ has a missing value in row $\_\_\_\_\_.$

$($Hint: Analyze $>$ Screening $>$ Explore Missing Values$)$

There will be $\_\_\_\_\_$

rows of clean data after you delete the duplicate and outlier.

There will be $\_\_\_\_\_$

columns of clean data afer you delete the Size column.