Using the tips dataset, first calculate the average tip amou…

Using the tips dataset, first calculate the average tip amount. Then create a new column called Tip Category with the following rules: If a tip amount is less than the average, label it as “Below Average”. If a tip amount is greater than or equal to the average, label it as “Not Below Average”. What number of customers fall into the two categories (i.e., Below Average and Not Below Average?) Categories Count of Tip Category Below Average Not Below Average

In the tips dataset, when cust_id is in its original ascendi…

In the tips dataset, when cust_id is in its original ascending order and the named range DataRange includes only the data (not the headers), where column 1 is total_bill and column 2 is tip, what result does the following INDEX() formula return? =INDEX(DataRange, 4, 2)

“The chip famine is starving the global auto industry and pu…

“The chip famine is starving the global auto industry and putting car buyers on a strict diet. So far this year, seven million cars that were supposed to be produced haven’t been, according to IHS Markit data. Auto companies are shutting down production lines for weeks at a time and furloughing employees as a result of the chip shortage. Toyota has slashed its production 40% in September.” (wsj.com Sept. 22, 2021) According to this excerpt, what is the main factor limiting the auto industry production Capacity?