In a high school with 3000 students, counselors are putting together a math tutoring program for the neighboring middle school. they plan to invite high school students with high average test scores to tutor middle school students, and they would like to offer gift cards to the student tutors. the counselors have a spreadsheet showing each student’s average test scores, and in order to find out how many gift cards they should purchase, the counselors need to count how many students would qualify to become tutors. which type of function would best the counselors determine the number of eligible students? sumif round countif averageif

Elon musk is the ceo of tesla motors. musk also serves as chairman of tesla's board. according to corporate governance theory, which of the following is a logical reason why musk should serve on the board? 1. he serves on many other boards, including that of a major client of tesla.2. his is an independent director who is well positioned to monitor the company's management.3. he can easily fire board members that are shirking their duties.4. he can provide the board with valuable inside information about the firm and the industry.

Your mother's well-diversified portfolio has an expected return of 12.0% and a beta of 1.20. she is in the process of buying 100 shares of safety corp. at $10 a share and adding it to her portfolio. safety has an expected return of 15.0% and a beta of 2.00. the total value of your current portfolio is $9,000. what will the expected return and beta on the portfolio be after the purchase of the safety stock?

Consider how health insurance affects the quantity of health care services performed. suppose that the typical medical procedure has a cost of $160, yet a person with health insurance pays only $40 out of pocket. her insurance company pays the remaining $120. (the insurance company recoups the $120 through premiums, but the premium a person pays does not depend on how many procedures that person chooses to undergo.) consider the following demand curve in the market for medical care. use the black point (plus symbol) to indicate the quantity of procedures demanded if each procedure has a price of $160. then use the grey point (star symbol) to indicate the quantity of procedures demanded if each procedure has a price of $40. q d at p=$160 q d at p=$40 0 10 20 30 40 50 60 70 80 90 100 200 180 160 140 120 100 80 60 40 20 0 price of medical procedures quantity of medical procedures demand if the cost of each procedure to society is truly $160, the quantity that maximizes total surplus is procedures. economists often blame the health insurance system for excessive use of medical care. given your analysis, the use of care might be viewed as excessive because consumers get procedures whose value is than the cost of producing them.