PDA

View Full Version : Excel question

warriorshame
02-03-2008, 05:24 AM
first off, forgive me if this is not an appropriate question

a little background:
I'm working on my senior undergard thesis and I'm trying to create a data set in an excel spread sheet, however I'm a complete novice when in comes to microsoft excel. My thesis has to do with competitive balance and collective bargaining agreements in the national basketball association.

what I need help on:
I need some way to list all the different games played in a given year, with a team in each column (without double counting matchups i.e. counting teams who play each other twice a year as playing each other 4 times because we count from each teams point of view).

for example

A B
row1 Chicago New York
row2 Chicago New York
row3 Chicago Orlando
row4 Chicago Orlando

So pretty much I want to , for a given number of teams and schedule structure, write down each game and every game within a season with a team in each column. Is this possible in excel or stata? right now I'm stuck entering them in by hand and it's killing me!

C152dude
02-03-2008, 05:33 AM
How many teams, and what is the schedule? Each team plays every other team? Is it consistent every year? Why did you double list the games?

This is really easy to do in Excel, just let us know the above.

warriorshame
02-03-2008, 05:51 AM
It's the national basketball association (not trying to imply it should be obvious, but if you are familiar with it already then....)

-there are 30 teams split up into two conferences.

-each conference is then broken down into 3 divisions of 5 teams.

-each team plays every other team in their division 4 times, and every team within their conference but NOT in their division 3 times

-each teams plays every team not in their conference two times

-this is consistent every year, however, if I wanted to tweak it (it was slightly different, say, ten years ago), would that take a lot of work?

-I double listed the games because I eventually want to run a probit/logit regression of probability of winning a particular game based on a couple of factors. I suppose I didn't need to double list the games, but it wouldn't hurt.

here's a link to the way the league is structured if you are not familiar:
ESPN - NBA Standings, Pro Basketball Standings, NBA Team Records (http://sports.espn.go.com/nba/standings)

thank you so much for your help, you get special mention in my paper unless you don't want your name on a piece of garbage :)

C152dude
02-03-2008, 05:56 AM
Oh oh oh, I didn't see 'all' in your post. I thought you were doing something hypothetical, and didn't know which teams. Anyways, I will start doing this and probably send you a pm tomorrow or something.

warriorshame
02-03-2008, 06:04 AM
wow, thanks a lot man. geez, and who said economists are evil?:tup:[clap]

Smileysquared
02-03-2008, 01:36 PM
I think you should think about taking a course in Excel because wherever you go to work in the Business world you will have to work with spread sheets. Microsoft offers short courses and you can get specialist certification from them. I did one of their exams already and I have 1 more to do. It's not bad at all and then you have the added bonus of including it as specialist training on your resume.
Take care and all the best.

C152dude
02-03-2008, 05:25 PM
If I knew VBA beyond the level of a caveman, that probably would have not taken an hour... oh well. It's done.

PM sent.