Question: Question 1) answer the following questions by using the conditional statistical functions: (20 points) a. Write a function/formula in cell D24 to calculate the number

Question 1) answer the following questions by

Question 1) answer the following questions by using the conditional statistical functions: (20 points) a. Write a function/formula in cell D24 to calculate the number of applicants who are from the department of finance or the department of marketing. b. Write a function/formula in cell E24 that returns the average GPA of applicants who are from the department of finance or the department of marketing. Delete v LU O Peste 47 OA Merge Center & Conditional Format Cell Formatting as Table Styles Format Sort & Filter O Find & a Select Sensitivity Analyze Data SUM : x fc =COUNTIFS/B2:B23,">650",C2:C23,"Finance")+COUNTIFS(B2:B23,D26>650",C2;p23, "Marketing") Cancel C D E F H

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

SHOW FULL FUNCTION for both parts a&b Question 1) answer the following questions by using the conditional statistical functions: ( 20 points) a. Write a function/formula in cell D24 to calculate the...

i need the formulas for answers 1-8 Important notes: - If your function doesn't work, remove the equal sign "=" from your function to recelve partial credit. Question 1) answer the following...

Assignment 2 Important notes: . If your function doesn't work, remove the equal sign "=" from your function to receive partial credit. Question 1) answer the following questions by using the...

Question 1) answer the following questions by using conditional summary functions (20 points). a) Make a table with cells A1 to I21 with name EmpTable, a heading row, banding rows, no total row, and...

B C D E F H M Answers 3 Points 0.5 5 0.5 2 6 0.75 3 T 0.75 4 1 5 3 EvTel wants to expand its business abroad to capture more of the market. Milos, the Vice-President of Kitchen Appliances at EvTel,...

Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a...

Math215 Statistical Concepts Franklin University Coin Toss Project Part One: Subjective Probability (Your Guesses) Before tossing the coins, make the following predictions. Remember the rule of a...

Duress. In 2005, Salser Granite Co. hired Darryl Leiberger under an employment contract that stated he was entitled to six months severance pay if he was laid off. The company would not have to pay...

Morgan Inc. and Parker Company are considering entering into a joint venture arrangement. Under IFRS, what accounting alternatives are available to Morgan and Parker with respect to this joint...

Chris Krankipanz, holding 5 0 % of the corporate shares in Don t Worry Be Happy Corp. and serving as its president ( CEO ) , sought a $ 2 5 0 , 0 0 0 personal loan from Rainon Myparaid Bank. The bank...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...