Pivotable

Introduction: My study is based on my confederations air tickets purchasing situation during from 1st April to 20th May. I extracted 100 data including names, department, hierarchy, destination, condemnation spent in destination, voyage film full determine and purchased footing. According to these data, Id care to analyze some business situation nearly my company, analogous the cities we mostly travel to, the departments that travel the most, the prices of air tickets betwixt companys agency or outdoor agency, as closely as the time spent in the destination. garnish every(prenominal) the columns meaning. Please see the original data in the abandoned table, there are in total 8 columns, including: ? diagnose: employees name ? Department: the employee works for ? Hierarchy: the prospect train of the employee ? terminal figure: the city the employee travels to ? Time: the time spent in the destination ? Cla ss: rescue, super economy or business ? Full price: original price before discount ? Purchased price: the actual make up of price Set no less than five abbreviation tasks by yourself, as practical significant as possible. 1) crystallize 6 cities by frequency: Xian, Chong Qing, Yin Chuan, Cheng Du, Tai Yuan, Haerbin. | | | | none

:Destination |? | |Destination |Total | |Bao Tou |7 | |Cheng Du |9 | |Chong ! Qing |10 | |Da Lian |4 | |Gui Yang |2 | |Haerbin |9 | |Kun Ming |2 | |Qing Dao |2 | |Qiqihaer |7 | |Shang Hai |7 | |Shen Yang |5 | |Tai kwai |9 | |Xian...If you deprivation to get a full essay, wander it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper