Regarding coil pack and engine diagnostic reading

Thanks guys, did have the scanner erase the computer both times, first time was with battery disconnect. Have taken into Dealership to see if they have a more thorough scanner/computer to diagnose, $45.00 to 98.00 I dont have. Dont know where the throttle plate is located. If code is showing misfiring on cylinder 2, then why would compression be the issue? Sorry newbie to these newer engines, give me an older engine and I can tear it apart and put back together in 1 day.

Thanks. After paying 45.00 at the dealership, the best they could come up with was the same readout I got when taken to autozone and done for free. One mechanic did try to narrow it down for me and stated it is one of three things, bad spark plug(which I just changed out to new ones before taking it in, no change, so thats not it), then he said possibly bad wiring connection to number two cylinder(looked at it, looks brand new all way down), then he said lastly it may be a fouled up or bad fuel injector(very possible but entails taking alot of the engine apart just to get to them). For a very detailed pinpoint inspection, would run 250.00 from dealership. If is fuel injector, would be an additional 250.00 labor not including fuel injector. If wiring, would be additional 150.00 labor not including new wire harness. Thanks for your advices, I do not have a tool unfortunately to check compression right now. I was told by the Mazda person I should consider trading in the vehicle because they have very bad circumstances with those vehicles engines. Will check the throttle plate as my final option before finding a reliable mechanic that can do whatever work, not going back to dealer, very rude people except for the one mechanic who they all kept staring at to leave.

Mechanic12a did you find a solution - we have the eact same problem - any help would be greatly apprecaited as we are currently running around in circles with this issue?

Hi all have still had no luck with our mazda its been at machincs for a while. They have replace vvt as it had the loud rattle to it and chain etc still having the miss fire fault. They have checked the coils compression fuel pressure changed spark plug still didnt change anything. So then had injectors cleaned as the to fault codes were in cylender 2and 4 both of those enjectors were running at about 40 percent and other two at 100 percent. They got injectors 2 and 4 back to about 80 percent car stopped sending miss fire fault but was lagging due to running at 80 percent. So now I have to change 2and 4 injectors takes about 4 week from ching chong land to arrive so will see if that fixes it its cost me so far 2300 and another 1100 to do injectors so im pritty pissed about it. Il keep you updated

I have similar issues but only on Cyl #1
Took it to dealer,
Diagnostic (Extract from sheet):

DTC P0401 & P0301 Misfire - EGR Incorrect Flow Pending
Found possible cause to be coils and spark plugs and/or fuel injectors causing possible P0301. Need to determine by switching coils around. Customer Declined. Diagnosis Only / No Work Done.

An estimate for replacing the injectors was at 1700.

They also recomended to trade in the car.

Funny.