Imagine you are working with a word document that is meant to track the ages of all students in a high school. The sheet contains their name, age, sex, and a few other pieces of information. You want to know how many male students there are for each age group and how many female students there are. However, some students didn’t provide their ages (and thus a “0” is entered for their age), and others gave unusual answers (like “-42” or “100”). Using a basic COUNT function, sorting, and/or filtering how could you use conditional formula logic to get an approximate count of student sex by age, ignoring these outliers?

Jade international is a highly diversified global firm with headquarters in new jersey. it manufactures a variety of products ranging from home security systems to automotive components. jade's 100,000 employees work at facilities located in more than 60 countries around the world. jade frequently sends american managers overseas to manage the firm's foreign facilities. the hr department is considering the idea of redesigning jade's expatriate support services program.which of the following, if true, best supports jade's decision to provide assistance to trailing spouses in finding jobs overseas? a) jade puts great emphasis on promoting the role of women in global management.b) the majority of jade's expatriate managers have long-term international experience.c) jade has lost a significant chunk of its global cadre in the recent past owing to its failure to offer feasible options to address the dual-career couples dilemma.d) female managers at jade have reported discriminatory treatment while on overseas assignments.

What is the relationship between marginal external cost, marginal social cost, and marginal private cost? a. marginal social cost equals marginal private cost plus marginal external cost. b. marginal private cost plus marginal social cost equals marginal external cost. c. marginal social cost plus marginal external cost equals marginal private cost. d. marginal external cost equals marginal private cost minus marginal social cost. marginal external cost a. is expressed in dollars, so it is not an opportunity cost b. is an opportunity cost borne by someone other than the producer c. is equal to two times the marginal private cost d. is a convenient economics concept that is not real

Last year ann arbor corp had $155,000 of assets, $305,000 of sales, $20,000 of net income, and a debt-to-total-assets ratio of 37.5%. the new cfo believes a new computer program will enable it to reduce costs and thus raise net income to $33,000. assets, sales, and the debt ratio would not be affected. by how much would the cost reduction improve the roe? a. 11.51%b. 12.11%c. 12.75%d. 13.42%e. 14.09%