5. In column M, Camille wants to calculate the average cost of each project type. Determine the average costs as follows: a. In cell M3, enter a formula using the AVERAGEIF function that averages the cost for Expansion| projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J , and that the formula averages all the final costs (Projects[Final Cost]). b. Fill the range M4:M7 with the formula in cell M3. 1 3 K L M N p \begin{tabular}{|l|rr|r|} \hline Project Type & Number & Total Cost & Average Cost \\ \hline Expansion & 5 & $743 , 687 & $148 , 737 \\ \hline Landscape & 8 & $510 , 261 & $63 , 783 \\ \hline New Construction & 7 & $4 , 292 , 507 & $613 , 215 \\ Renovation & 10 & $1 , 183 , 113 & $118 , 311 \\ \hline Upgrade & 3 & $369 , 037 & $123 , 012 \\ \hline \end{tabular} Final Cost > 100000 Number of Projects: 16 Completed 2019 Number of Projects: 9 Campus: Newburgh Totaicost $1 , 925 , 559 Campus Hempstead Average Cont $232 , 285