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?

Ineed this asap miguel's boss asks him to distribute information to the entire staff about a mandatory meeting. in 1–2 sentences, describe what miguel should do.

During the year, the delph company had no beginning or ending inventories and it started, completed, and sold only two jobs—job d-75 and job c-100. it provided the following information related to those two jobs: job d-75: molding fabrication total direct materials cost $ 375,000 $ 325,000 $ 700,000 direct labor cost $ 200,000 $ 160,000 $ 360,000 machine-hours 15,000 5,000 20,000 job c-100: molding fabrication total direct materials cost $ 300,000 $ 250,000 $ 550,000 direct labor cost $ 175,000 $ 225,000 $ 400,000 machine-hours 5,000 25,000 30,000delph had no overapplied or underapplied manufacturing overhead during the year. assume delph uses a plantwide overhead rate based on machine-hours.1-a. compute the predetermined plantwide overhead rate.1-b. compute the total manufacturing costs assigned to job d-70 and job c-200.1-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 1-d. what is delph's cost of goods sold for the year? assume delph uses departmental overhead rates based on machine-hours.2-a. compute the predetermined departmental overhead rates.2-b. compute the total manufacturing costs assigned to job d-70 and job c-200.2-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 2-d. what is delph's cost of goods sold for the year?

Frost corporation incurred the following transactions during its first year of operations. (assume all transactions involve cash.) 1) acquired $1,900 of capital from the owners. 2) purchased $435 of direct raw materials. 3) used $290 of these direct raw materials in the production process. 4) paid production workers $490 cash. 5) paid $290 for manufacturing overhead (applied and actual overhead are the same). 6) started and completed 250 units of inventory. 7) sold 140 units at a price of $6 each. 8) paid $130 for selling and administrative expenses. the amount of raw material inventory on the balance sheet at the end of the accounting period would be: