Reference no: EM132277204

SPSS Analysis Assignment -

This assignment consists of a series of tasks that generally should be completed sequentially.

SPSS Assignment Information and Tasks -

Data Information/Background - The table in attached file provides information on the variables in this dataset. The data was collated by a not-for-profit organisation named Gapminder, who aim to promote sustainable global development by increased use and understanding of statistics.

While the data is real, the experimental scenarios and research questions herein may not be factual and may have been manipulated for educational purposes.

Note: for the purpose of this assignment, id is not considered a variable, but is instead simply a unique country identification number.

You will need to submit your final dataset (file extension .sav) at the end of this assignment. Your output (tables and graphs) files directly in SPSS (.spv extension) will also need to be submitted, but will not necessarily be marked (they're there for verification purposes only). The task descriptions below will indicate which tables and/or graphs are necessary for you to include in each section of your assignment document for your submission.

Task 1 - Data Preparation

1. Open the dataset called SPSS_Assign_Pt1.sav in SPSS.

2. Go to the Variable View. You will see that the variable names are given, but no variable labels or value labels for categorical variables have been assigned.

3. Enter the variable and/or value labels as per the table in the Information/Background section. These variable/value label assignments must be used in all further analyses.

4. Check that the Measures (or variable types; namely, Scale, Nominal or Ordinal) are correct. If necessary, change these to the correct setting.

5. To demonstrate that you have completed this task correctly, post a screenshot of your Variable View in your task submission (under the Task 1 heading in the Template document). Your screenshot should show the full list of variables, and all columns of the Variable View. It should be readily readable by the markers (check the resolution and size of the screenshot at 100% zoom).

Task 2 - Describing Your Dataset

1. Replace the [.....] fields below with the correct values/quantities, then post your completed sentences:

There are [.....] variables in the dataset. Of these, [.....] are quantitative and [.....] are qualitative.

There are [.....] countries included in the study.

2. Please bold and/or change the colour of the numbers you added.

Task 3 - Generating and Interpreting Boxplots

1. Generate a simple boxplot for life expectancy in 1977 (lifeExp77) in each of the categories of the Hemisphere variable (hemisphere), with any outliers/extreme outliers labelled by their Country ID.

Note: you should generate a single image, not a separate graph/image for each of the categories of the hemisphere variable.

2. Paste this boxplot image in your assignment submission.

3. Identify any outlier(s) and/or extreme outlier(s) present: describe in your post how you know these are outliers and/or extreme outliers, and list the Country ID number(s) (not Case Number) of these outliers or extreme outlier(s) you identified.

4. Briefly describe in no more than one to two sentences some of the key observations you can make about these data, based on this boxplot graph (note any symmetry, skewness, any descriptive statistics you can estimate by eye, perhaps comparing these between the two groups etc).

Task 4 - Generating the Five-number Summary

In Task 3, you generated a simple boxplot for life expectancy in 1977 in each category of the hemisphere variable.

For this task, you need to use SPSS to generate the five-number summary (i.e. the minimum, maximum, median, first quartile and third quartile) in a single table for life expectancy of countries in the Northern hemisphere.

Post the table generated in your assignment submission.

Task 5 - Generating Histograms (Part I)

Use the Graphs menu (not the Explore option) to generate histograms of lifeExp77 across each of the categories of hemisphere. For this question, a single image should be produced, with the histograms shown as a single column of images, over two rows (not columns).

Insert this image into your assignment submission.

Task 6 - Generating Histograms (Part II)

Here, you will again produce histograms of lifeExp77 across each of the categories of hemisphere. However, for this task, you must use the Split File option to produce separate histogram images for each of the categories being compared.

Post your images of the Northern hemisphere and Southern hemisphere histograms produced. Comment on the following (referring to each group individually, and then compare/contrast across the two groups):

• Measure(s) of central tendency given on each graph (what is the type of measure of central tendency provided? And what is its value?) - does this match the measure of central tendency shown in the boxplots from task 3? (It may or may not match - just mention whether they are similar or not)
• Measure(s) of variability given (what is the type measure of variability provided? And what is its value?)
• Sample size given
• Observed symmetry (or lack thereof) - does this match what you were expecting from your boxplots in task 3?
• Observed outliers (or lack thereof) - does this match what you were expecting from your boxplots in task 3?
• Observed mode(s) - exact value not necessary - range of values is acceptable.

Task 7 - Converting a Quantitative Variable to a Qualitative Variable

For this task, you must first convert the lifeExp77 variable into a new categorical age variable (lifeExp_cat), which converts the lifeExp data into two categories:

• Life expectancy up to and including 60 years old should be reassigned as a '0'
• Life expectancy greater than 60 years should be recoded into '1'

Appropriate variable labels and value labels should be assigned to this new variable.

In your post, succinctly describe the method you used to complete this task (dot points are fine). Screenshots (maximum of 2) should be used and included in your submission to show the settings/options that you used to generate this new categorical variable, as well as where/how/what you assigned as value labels.

Also, produce a frequency table that shows the number of countries in each of these life expectancy groups. Include this frequency table in your assignment submission.

Task 8 - Generating Bar Charts

Using the lifeExp_cat variable you generated in Task 7, produce a clustered bar chart that demonstrates the percentage of countries in the two life expectancy groups for quality of life; that is, the data should be clustered by Human Development Index (HDI).

Insert this clustered bar chart into your assignment submission, then comment on any trends you observe regarding HDI across the two life expectancy groups.

Task 9 - Computing a Ratio from Two Quantitative Variables

Create a variable for the rate of population growth (population in 2007 as a ratio from the population in 1977), with variable name popgrowth, computed from the pop77 and pop07 variables. This ratio should represent the fold-change in population over time.

Produce a table that provides at least the minimum, maximum, mean, standard deviation and sample size for your new variable popgrowth. Include this table in your task submission.

Also answer the following (maximum of 3 words necessary for each):

1. If data is missing for 1977 (but not 2007), what value does SPSS generate/calculate for the ratio?

2. If data is missing for 2007 (but not 1977), what value does SPSS generate/calculate for the ratio?

3. If data is missing for both 1977 and 2007, what value does SPSS generate/calculate for the ratio?

4. If 1977 is recorded as zero (instead of missing) for a country (but a non-zero value is present for 2007), what value does SPSS generate/calculate for the ratio?

5. If 2007 is recorded as zero (instead of missing) for a country (but a non-zero value is present for 1977), what value does SPSS generate/calculate for the ratio?

6. If both 1977 and 2007 are recorded as zero (instead of missing) for a country, what value does SPSS generate/calculate for the ratio?

Before proceeding to the next task, appropriately label this new Population Growth Ratio variable.

Task 10 - Assumption Testing

Use the Explore function to test the assumptions of Homogeneity of Variance, and normality (graphically and numerically) for the life expectancy in 2007 between the Northern and Southern hemisphere.

Post the following to your assignment submission:

• Tests of Normality table
• Test of Homogeneity of Variance Table
• Histograms (with normal curve overlayed)
• Trended Q-Q plots

If necessary, convert p-values less than 0.001 into scientific notation (do this in SPSS; do NOT do it manually).

Finally, comment on each table/graph as they relate to the assumptions that are being tested (e.g. describe if the image suggests the data is normally distributed, and why) and then come to a conclusion about whether the assumption of homogeneity of variance and the assumption of normality (conclusion for each) have been met or violated overall (when considering all the evidence from these output). Note: each of these assumptions are independent of the other. One can be violated when the other is not violated, and vice-versa.

Attachment:- Assignment Files.rar