|
| |
|
|
tovington453
Posts: 1
Joined: 6/7/2008
Status: offline
 |
Calculating market shares in access - 6/7/2008 8:57:10
Hi, I am relatively new to Microsoft access.
I am doing a dissertation on the airline industry. I have a database of all domestic flights in the US for each quarter. I would like to calculate the market shares (using passenger numbers) of various airlines for each unique route. Could anyone shed any light on how to do this? I also need to caculate the passenger weighted average market fare for each unique route and airline. The fields in my database include origin, destination, quarter, airline company, passenger numbers and market fare.
Thanks in advance
|
|
|
|
DesiMcK
Posts: 445
Joined: 4/26/2004
From: Essex, UK
Status: offline
|
RE: Calculating market shares in access - 6/7/2008 12:42:40
Personally I would put all the data into Excel and do the calculations. I assume that when you are calculating market share you are finding the percentage of the total that each airline has.
A pivot table would be my choice for a solution.
Do you really need this done with asp?
Desi
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
