Home / Expert Answers / Computer Science / open-the-clean-data-jmp-file-add-a-new-column-called-productivity-assign-a-value-34-above-averag-pa511

(Solved): Open the Clean_Data JMP file. Add a new column called Productivity. Assign a value: "Above Averag ...



Open the Clean_Data JMP file. Add a new column called Productivity. Assign a value: "Above Average" if the company's profit/emp is higher than the average profit/emp for all companies. "Below Average" if the company's profit/emp is lower than the average profit/emp for all companies. "Average" if the company's profit/emp is equal to the average profit/emp for all companies. Hint: replace ?? below with the value of the average profit/emp for all companies from the question above if you copy-and-paste the following into the formula panel of the Productivity column: If( :Name( "profit/emp" ) > ??, "Above Average", If( :Name( "profit/emp" ) < ??, "Below Average", "Average")) Answer the following questions by filling in the blanks with an integer or a number rounded to 2 decimal places as indicated: There are _____ companies having an “Above Average” productivity. (integer) There are _____ companies having a “Below Average” productivity. (integer) There are _____ companies in the computer industry having an “Above Average” productivity. (integer). There are _____ companies in the pharmaceutical industry having an “Above Average” productivity. (integer). There are _____ small companies having a “Below Average” productivity. (integer). Answer 1: 12



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe