Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

33. Hwan needs to identify the number of projects that have an estimate of more than $50,000. In cell J11, create a formula using the

image text in transcribed
image text in transcribed
33. Hwan needs to identify the number of projects that have an estimate of more than $50,000. In cell J11, create a formula using the DCOUNT function to count the number of projects with estimates of more than $50,000, using the data in the entire Projects table (Projects[#AN) and counting the values in the column of estimates ("Estimate") that are equal to the values in the range 19:110. D E G H K D Projects Total Estimates Avg Estimates State NE NE WY NE SD ND Category Bridge Highway Paving Site development NE 2 3 Category 4 Highway 5 Hilway 6 Beide 7 Site development 8 Site development 9 Paving 10 Bridge 11 Site development 12 Site development 13 Paving 14 Paving 15 Paving 16 Paving 17 Patung 18 Budge 19 Pathing Estimate $50,000 Projects WY NE ND ACT NE SD MT WY ND Project Start 1/12/2021 1/20/2021 2/16/2021 2/22/2021 2/22/2021 3/1/2021 3/12/2021 3/20/2021 3/23/2021 3/24/2021 3/30/2021 4/2/2021 4/2/2021 4/5/2021 4/5/2021 4/14/2021 A. Estimate $30,562 $14,500 $54,672 $107,654 $38,750 $48,932 $72,358 $24,505 $34,756 $68,900 $42,350 $27,800 $28,500 $70,347 $19,576 $78,400 Paid to Date $30,562 $12.000 $50,000 $57,654 $30,000 $45,932 $72,358 $24,505 $34,756 $34,900 $4250 $17,000 528,500 $30,400 $10,576 $38,400 euro Chent ID W-0138 Total paid Projects lry State MIT ND

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

Students also viewed these Databases questions