No it is the pipe diameter of the whole system (cat back) that matters, tip is just there for the looks...
What I mean is, standard micra exhaustdiameter is about 35-38mm, and especially on the 1.0, if you put an exhaust on the car with say 50mm diameter, you will lose a lot of torque and power...