Need serious help with this excel question. If the slightest idea would be usefu

Question

Need serious help with this excel question. If the slightest idea would be useful here. Thank you.

0 TABLE 2. Average Tuition and Fees and Room and Board (Enrollment-Weighted) in Current Dollars and in 2017 Dollars, 1971-72 to 2017-18 Tuition and Fees in 2017 Dollars Tuition and Fees and Room and Board in 2017 Dollars Check Check Tuition Tuition and Fees Check Check and Fees and Board Both Public Four Year 58.570 58,970 59,240 59,310 $9,400 $9,670 59.840 59,970 Private Nonprofit Four-Year $40.940 $41,140 $42,150 $42,920 43,610 $45,010 $46,150 46,950 Public Two Public Four Year $18,160 $18,590 $19,040 $19,260 $19450 $20,070 $20,500 $20,770 Academic Private Nonprofit Year 10-11 11-12 12-13 13-14 14-15 15-16 0 16-17 1 17-18 Four-Year S30,050 $30,210 S30,970 S31,570 S32,140 533,180 $34,100 S34,740 Year 53,080 $3.220 $3,370 $3,400 $3,430 $3.490 $3,530 $3,570 Either 3 2 NOTE: Average tuition and fee prices reflect in-district charges for public two-year institutions and in-state charges for public four-year institutions SOURCES: 1987-88 and after data from Annual Survey of Colleges, the College Board, weighted by full-time undergraduate enrollment: 1986-87 and pnior: data from Integrated Postsecondary Education Data System (PEDS), U.S. Department of Education, National Center for Education Statistics, weighted by full-time equivalent 3 enrollment This table was prepared in October 2017

Explanation / Answer

Formula Used:

Column-6 : =IF(C4>=0.29*B4,">29","")

Column-7 : =IF(E4>=0.45*D4,">45","")

Column-8 : =IF(AND(F4=">29",G4=">45"),"Both","")

Column-9 : =IF(OR(F4=">29",G4=">45"),"*","")

Tuition and fees in 2017 Dollars Tuition and fees and room and board in 2017 Dollars Academic Year Private Non-profit 4 Yr Public 4 Yr Private Non-profit 4 Yr Public 4 Yr Check Tuition and fees Check Tuition and fees and board Check Both Check Either 1 2 3 4 5 6 7 8 9 2010-11 30050 8570 40940 18160 2011-12 30210 8970 41140 18590 >29 >45 Both * 2012-13 30970 9240 42150 19040 >29 >45 Both * 2013-14 31570 9310 42920 19260 >29 * 2014-15 32140 9400 43610 19450 >29 * 2015-16 33180 9670 45010 20070 >29 * 2016-17 34100 9840 46150 20500 2017-18 34740 9970 46950 20770

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.