Yes this can be done.
- Enable packet trace and run the simulation (run it for short time because logging this file takes time, plus it would be a large file)
- After simulation open packet trace In excel, use format as table option available under Home Tab
- Under transmitted ID column filter to Access point
- Add a new column which would be equal to PHY_LAYER_PAYLOAD(Bytes)*8 / (PHY_LAYER_START_TIME(US)-PHY_LAYER_ARRIVAL_TIME(US)). Since the times are in micro seconds, this will give you the approximate PHY Rate in Mbps that each packet experiences. The exact formula would be
PHY_RATE (802.11a) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 20)
PHY_RATE (802.11b) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 192)
PHY_RATE (802.11g) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 20)
PHY_RATE (802.11n) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 40)
PHY_RATE (802.11ac) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 45)