Yes, the Y pipe and Mid pipe will make your car noticeably louder.
This one has our full set up.
<iframe width="420" height="315" src="http://www.youtube.com/embed/tSvvv0YZk54" frameborder="0" allowfullscreen></iframe>
As does this one.
<iframe width="560" height="315" src="http://www.youtube.com/embed/PTKzrzUfhU8" frameborder="0" allowfullscreen></iframe>