Ordering and Grouping Data Using Excel and SPSS Paper
Ordering and Grouping Data Using Excel and SPSS Paper
Data management
Part 1: Ordering and Grouping Data Using Excel and SPSS
Order (sort) observations according to age
Figure 1. Excel screenshot for observations sorted according to age
Figure 2. SPSS screenshot for observations sorted according to age
Group observations by sex and investigate the age and income for males and females
Figure 3. Excel screenshot for group observations by gender for age and annual income
Figure 4. SPSS screenshot for group observations by gender for age and annual income Ordering and Grouping Data Using Excel and SPSS Paper
Exercise group
Figure 5. Excel screenshot for exercise grouping
BUY NOW A PLAGIARISM-FREE PAPER HERE
Part 2: Data Interpretation
Study the results of the dataset grouping and ordering. Discuss the following in a 500-750 word summary:
Describe the measurement levels for each of the variables in the dataset.
Nine variables were presented. The first variable is the participants’ ID that used numeric type of data presented in interval measurement level with the distance between variables being meaningful. The second variable is the participants’ gender (sex) that used string type of data presented in nominal measurement level with the attributes only named without a numerical value. The third variable is the participants’ smoking status that used string type of data presented in nominal measurement level with the attributes only named without a numerical value. The fourth variable is the participants’ education level that used numeric type of data presented in nominal measurement level with the attributes only named without a numerical value. The fifth variable is the number of minutes participants used exercising, which used numeric type of data presented in nominal measurement level with the attributes only named without a numerical value. The sixth variable is the participants’ age that used numeric type of data presented in interval measurement level with the distance between variables being meaningful. The seventh variable is the participants’ employment status that used string type of data presented in nominal measurement level with the attributes only named without a numerical value. The eighth variable is the participants’ annual income that used numeric type of data presented in interval measurement level with the distance between variables being meaningful. The final variable is the participants’ neighborhood that used string type of data presented in nominal measurement level with the attributes only named without a numerical value (Dytham, 2011). Ordering and Grouping Data Using Excel and SPSS Paper
Discuss what you learned from ordering the data by age and why this information is important.
Meaningfully ordering the data offers two advantages. Firstly, it enabled efficient data searches since it makes it easier to visualize, analyze and understand the data. Secondly, it allows for the data to be processed sequentially thus making it easier to visualize the link between variables.
Describe the process you used to group the data in Excel and SPSS.
Excel process for grouping data was conducted through a four step process. The first step was to determine the data ranges. The second step was to create a new column for grouping the exercise data. The third step was to copy and paste the data on exercise minutes into the new column. The final step was to replace the data with the grouping labels.
SPSS process for grouping data was conducted through three steps. The first step was to click on the transform tab and select decide into different variables options. The second step was to select exercise minutes as the numeric variable and exercise group as the output variable. The third step was to change the old and new values with the ranges identified and values input for the grouping. Running these commands creates the desired grouping.
Describe what you learned by grouping the variables by category of exercise.
Grouping the data improved the efficiency of conducting estimations. In addition, it helped with visualizing the data and identifying trends. Also, it helped in identifying significant subpopulations that would act as the focus of attention.
Are these data from a correlational study, experimental study, or quasi-experimental (observational) study? Discuss your rationale and identify a study question appropriate for this dataset.
The data is collected from a correlational study. This is based on the fact that the participants are not subjected to any treatment. Rather, the research sought to understand the relationships between the naturally occurring variables (Creswell, 2013).
References
Creswell, J. (2013). Research design: qualitative, quantitative, and mixed method approaches. Thousand Oaks, CA: Sage Publications.
Dytham, C. (2011). Choosing and using statistics: a biologist’s guide (3rd ed.). Hoboken, NJ: Wiley-Blackwell. Ordering and Grouping Data Using Excel and SPSS Paper