18. Dean also wants to identify the number of projects that have less than $5,000 of funding and calculate the average funding amount of commercial projects. Create formulas that provide this information as follows: a. Use the DCOUNT function in cell H8 to count the number of projects with funding amounts less than $ 5,000. Use the entire Lookup table (Lookup [#All]) as the database, Funding as the field, and the range G6:G7 as the criteria. b. Use the DAVERAGE function in cell H13 to average the funding amounts for commercial projects. Use the entire Lookup table as the database, Funding as the field, and the range G11:G 12 as the criteria.

18. Dean also wants to identify the number of projects that have less than $5,000 of funding and calculate the average funding amount of commercial projects. Create formulas that provide this information as follows: a. Use the DCOUNT function in cell H8 to count the number of projects with funding amounts less than $ 5,000. Use the entire Lookup table (Lookup [#All]) as the database, Funding as the field, and the range G6:G7 as the criteria. b. Use the DAVERAGE function in cell H13 to average the funding amounts for commercial projects. Use the entire Lookup table as the database, Funding as the field, and the range G11:G 12 as the criteria.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

In a study, causation can be best established by: A) considering a single explanation. B) evaluating the methodologies used. C) accounting for competing explanations. D) analyzing the scope of the study.
, peruse articles from databases in the library and gather pro and con arguments in favor of and against the use of Crispr in humans. You will be using the articles from the databases in the body paragraphs of the paper about the positive and negative points about using Crispr in Humans--two database articles in each body paragraph. In a Discussion Board you will post an outline using database articles--at least two in each body paragraph. Always include an intro and conclusion and Works Cited. For each of the library database articles you found, you will post a summary and explain the following: The author(s)' main idea and subtopics, indicating the pro and con arguments for using Crispr in humans. This should be in paragraph form--approximately a half-page entry for each of the articles. Please be specific. After you post your outline containing four body paragraphs, respond to two of your peers' posts indicating the usefulness of their authors' information. Could you use…
Think about a $250 or greater purchase you've made (can’t be textbooks or tuition). Answer the following questions using complete sentences (no one word or single phrase answers.) Example: The product I purchased was a Corvette. I thought I needed a Corvette because . . . . . etc. Be sure to answer each question thoroughly to demonstrate that you understand the stages of the purchase process and related influences.
Don't use Ai
is a soft dimension of specification quality a. Communication b. Performance c. Reliability d. Aesthetics
WH FRAMEWORK The H in this framework stands for Group of answer choices How each stakeholder is affected How much profit the business may make How to keep the decision secret from the public none of the above