Guest User

Untitled

a guest
Mar 20th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. **Answer : 79524**
  2.  
  3. ### Explanation
  4. I found the answer depends on four columns **_Schools,State,School type,$ of Loans Originated** _under DL unsubsidized undergraduate_.
  5. 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)
  6. I sorted the **School** column in _descending_ order.
  7. I copy pasted rows starting with **“s”, “u”, “v” or “w”** to another sheet(**5 Schools**).
  8. 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