Balance Gig is a company that matches independent workers for short-term engagements with businesses in the construction, automotive, and high-tech industries. The gig employees work only for a short period of time, often on a particular project or a specific task. A manager at Balance Gig extracts the employee data from their most recent work engagement, including the hourly wage (Hourly Wage), the clients industry (Industry), and the employees job classification (Job). A portion of the Gig data set is shown in Table 2.3.

TABLE 2.3 Gig Employee Data

The manager suspects that data about the gig employees are sometimes incomplete, perhaps due to the short engagement and the transient nature of the employees. She would like to find the number of missing observations for the Hourly Wage, Industry, and Job variables. In addition, she would like information on the number of employees who (1) worked in the automotive industry, (2) earned more than $30 per hour, and (3) worked in the automotive industry and earned more than $30 per hour. Finally, the manager would like to know the hourly wage of the lowestand the highest-paid employees at the company as a whole and the hourly wage of the lowest- and the highest-paid accountants who worked in the automotive and the tech industries. Use counting and sorting functions in Excel and R to find the relevant information requested by the manager, and then summarize the results.

Important: Due to different fonts and type settings, copying and pasting Excel or R functions from this text directly into Excel or R may cause errors. When such errors occur, you may need to replace special characters such as quotation marks and parentheses or delete extra spaces in the functions.