Statistics - Excel Projects

Analzye the data from the Chase and Dummer study (see attached case) The Role of Sports as a Social Determinant

Analzye the data from the Chase and Dummer study (see attached case) The Role of Sports as a Social Determinant for Children

Here are the data: (the raw data is also included in an excel file)

Number of cases: 478

Variables:

Gender:	Boy or girl
Grade:	4, 5 or 6
Age:	Age in years
Race:	White, Other
District:	Rural, Suburban, or Urban school district
School:	Elm, Brentwood Elementary, Brentwood Middle, Ridge, Sand, Brown, Main, Portage, Westdale Middle
Goals:	Student's choice in the personal goals question where options were: 1 = Make Good Grades, 2 = Be Popular, 3 = Be Good in Sports
Grades:	Rank of "make good grades" (1=most important for popularity, 4=least important)
Sports:	Rank of "being good at sports" (1=most important for popularity, 4=least important)
Looks:	Rank of "being handsome or pretty" (1=most important for popularity, 4=least important)
Money:	Rank of "having lots of money" (1=most important for popularity, 4=least important)

Your project tasks:

Following the instructions in Presentation 1: Data Entry , enter the data into an SPSS file.
Following the instructions in Presentation 2: Descriptive Statistics calculate basic descriptive statistics for the six demographic variables (Gender, Grade, Age, Race, District, and School), getting histograms for interval variables as well.
Calculate the distribution of Race in each of the three kinds of districts, and by school. Anything interesting there? Calculate the distribution of Goals in each of the three kinds of districts. Anything interesting there? [NOTE: we haven't yet reached tests of statistical significance, so this question isn't about that -- it's just about overall first impressions given to you by the shape of the data. "Interesting" here just means something different enough from what you'd normally expect that it's worth the effort of keyboarding about it...]
Overall, what do the data say is most important to these kids? Least important? What can you say about the phenomenon of "popularity" as a result of looking at these data?
Following the instructions in Presentation 5: Reports 1 , transfer your output to an MSWord ^® file. Add appropriate annotations regarding interpretation and explanation to any tables you copy in. Precede your report tables with a paragraph or so explaining what you did, and conclude your report with a paragraph or so evaluating the entire exercise in terms of what you have learned and what parts of the exercise, if any, are still unclear to you.