Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **Answer : 79524**
- ### Explanation
- I found the answer depends on four columns **_Schools,State,School type,$ of Loans Originated** _under DL unsubsidized undergraduate_.
- I googled Filters can be used to select specipic rows from a column and applied fiters for **School Type**- Private nonprofit_ and for **School**- _Text Filter_ "WA".(Learned from **youtube** videos)
- I sorted the **School** column in _descending_ order.
- I copy pasted rows starting with **“s”, “u”, “v” or “w”** to another sheet(**5 Schools**).
- I googled that there is a **Median** function in Excel and applied the _Formula- **=MEDIAN(D6:D10)** onto **$ of Loans Originated** _under DL unsubsidized undergraduate.
Add Comment
Please, Sign In to add comment