Question: Having convinced the board members that a stratified sample is the most appropriate, you collect data from the 80 schools. The spreadsheet provided contains the collected data in the tab labeled "Data." The difference between average school test scores three years ago and average school test scores today is recorded as "chgtestscores." Positive values of chgtestscores indicate an increase in test scores at the school as compared to 3 years ago, while a negative number indicates that the school is now performing worse on these tests. In addition to this variable, there are three more variables in this data set. The first is "curriculum" which can have a value of either "old" or "new," where new implies the experimental curriculum. Next is "income($000)," which represents the average annual income (in thousands of dollars) of the households of students from each school. Finally, there is a variable called "school" which is simply ID number of the elementary school. The first step to this analysis is to generate some descriptive measures.

For each of the following points, create the chart and/or graph that best displays the data:
a) Show the breakdown of your sample by curriculum type (old vs. new/experimental)
b) Show the distribution of the change in test scores across all schools.
c) Show the distribution of income across all schools.

Additionally, you want to generate some tables of summary statistics.
d) Create one table that calculates summary measures of the change in test scores and income variables across all 80 schools.
e) Create a second table that calculates summary measures of the change in test scores and income variables broken out by curriculum type.

Based on the graphs and tables created in parts a-e:
f) What preliminary conclusions can you draw regarding the effectiveness of the experimental curriculum?

Price: $2.99

Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document