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, time spent in destination, pilot film full determine and purchased price. According to these data, Id care to analyze some business situation about my company, analogous the cities we mostly travel to, the departments that travel the most, the prices of air tickets between companys agency or outdoor agency, as closely as the time spent in the destination.
Illustrate every(prenominal) the columns meaning.
Please see the original data in the accustomed table, there are in total 8 columns, including:
? discover: employees name
? Department: the employee works for
? Hierarchy: the position train of the employee
? terminal figure: the city the employee travels to
? Time: the time spent in the destination
? Class: economy, super economy or business
? Full price: original price before discount
? Purchased price: the actual make up of price
Set no less than five analysis tasks by yourself, as practical significant as possible.
1) Top 6 cities by frequency: Xian, Chong Qing, Yin Chuan, Cheng Du, Tai Yuan, Haerbin.
| | |
|No.
: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 yuan |9 |
|Xian...If you deprivation to get a full essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment