Simple question on variables wmy data sources in excel I am
Simple question on variables w/my data sources in excel.
I am currently working on a project for my analytics class where we need the following:
1. 50 observations
2. 11 variables (10 independent, 1 dependent)
I want to be sure that I am not getting the beginning wrong, I plan to use data from different cities so I have something that resembles the following.
###
So I\'m curious if I have 50 locations, then 10 random independent data variables and then 1 dependent where it calculates the percentage change from 1990 to 2010 is that correct? If not, could you please give me an example of a correct table? Time is precious! Thanks.
| Location | Population 2010 | Population 1990 |
|---|---|---|
| Denver, CO | ### | ### |
| Modesto, CA | ### | ### |
| Washington, DC | ### | ### |
| Fresno, CA | ### | ### |
Solution
I think you are taking population as one of the 10 independent random variabes. You can add one more column in the table \"percentage change\".
