Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Import the Data worksheet of the Fortune 5 0 0 Download Fortune 5 0 0 excel file into JMP Pro. ( Hint: select only the
Import the Data worksheet of the Fortune Download Fortuneexcel 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 CompanySize Hint: Cols New Columns Assign a value:
"small" if the company has less than employees
"medium" if the company has or more but less than employees
"big" if the company has or more employees.
Hint: Use the following formula, which you can copyandpaste directly into the formula panel of the newly added column called CompanySize:
If :Name# Employees"
"small",
If :Name# Employees"
"medium",
"big"
Save the above data table as a JMP file called Data Hint: File Save As
Flag question: Question
Question 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 firstHint: 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started