Question: 3. please answer fast, i will leave a like! Open these two JMP files: NYC Restaurant and NYC Inspection , then: - Combine all columns

Open these two JMP files: NYC Restaurant and NYC Inspection , then: - Combine all columns from the NYC_Restaurant file with the corresponding columns from the NYC_Inspection file. Do not include any redundant column in the combined table. - Export the combined table as an EXCEL file ONLY if you want to use Tableau as the tool for data visualization. - Use the combined table to complete the statements below: 1. GRADE has levels. 2. is the second most issued VIOLATION CODE. 3. has the highest number of CRITICAL FLAG at As a Business Analyst for C&A Consulting, your current project involves making sense of the financial well-being and health-safety status of restaurants in New York City. You have acquired two JMP files: NYC_Restaurant and NYC_Inspection. The metadata of each file is described below: NYC_Restaurant contains data about restaurants in New York City: NYC_Inspection contains data about results of the Health Department's inspection of restaurants in New York City: Open these two JMP files: NYC Restaurant and NYC Inspection , then: - Combine all columns from the NYC_Restaurant file with the corresponding columns from the NYC_Inspection file. Do not include any redundant column in the combined table. - Export the combined table as an EXCEL file ONLY if you want to use Tableau as the tool for data visualization. - Use the combined table to complete the statements below: 1. GRADE has levels. 2. is the second most issued VIOLATION CODE. 3. has the highest number of CRITICAL FLAG at As a Business Analyst for C&A Consulting, your current project involves making sense of the financial well-being and health-safety status of restaurants in New York City. You have acquired two JMP files: NYC_Restaurant and NYC_Inspection. The metadata of each file is described below: NYC_Restaurant contains data about restaurants in New York City: NYC_Inspection contains data about results of the Health Department's inspection of restaurants in New York City
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
