PUB 550 NYU Wk1 Health & Medical Describing Sample Data Project

practice organizing data through ordering and grouping variables.

Data often appear disordered and it is difficult to see any connections or relationships. Ordering the data by certain variables or grouping variables into specific categories, such as age or sex categories, can help bring clarity to the data. Knowing how to organize data is an important skill to initiate the analytical process.

students will use Excel and SPSS Statistics to order variables. Using the “Example Dataset,” complete the steps below using both Excel and SPSS Statistics. View the Excel and SPSS tutorials for assistance in completing this assignmen

t.

Submit one Word document and include a screen shot of the data after completing the first two steps of Part 1 in Excel and SPSS to compare your results. Use a second Word document to complete Part 2 of the assignment.

Part 1: Ordering and Grouping Data Using Excel and SPSS

For Part 1, accomplish the following:

  • Order (sort) observations according to age.
  • Group observations by sex and investigate the age and income for males and females.
  • Create a new variable titled “Exercise Group” based on the variable “Minutes Exercise.” Use the following categories to create your groups: 1 = 0-30 minutes; 2 = 31-60 minutes; 3 = 61-90 minutes; 4 = 91-120 minutes; and 5 = 120+ minutes.
  • Part 2: Data Interpretation

    Study the results of the dataset grouping and ordering. Discuss the following in a word summary:

  • Describe the measurement levels for each of the variables in the dataset.
  • Discuss what you learned from ordering the data by age and why this information is important.
  • Describe the process you used to group the data in Excel and SPSS.
  • Describe what you learned by grouping the variables by category of exercise.
  • 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.
  • t. Course Code
    PUB-550
    Class Code
    PUB-550-O500
    Criteria
    Content
    Percentage
    100.0%
    Part 1 – Excel and SPSS Screenshots
    20.0%
    Part 2 – Measurement Levels
    15.0%
    Part 2 – Ordering the Data
    15.0%
    Part 2 – Process Used for Grouping Data
    15.0%
    Part 2 – Grouping Variables by Category
    15.0%
    Part 2 – Study Discussion
    15.0%
    Mechanics of Writing (includes spelling,
    punctuation, grammar, language use)
    5.0%
    Total Weightage
    100%
    Assignment Title
    Data Management
    Unsatisfactory (0.00%)
    Screenshots illustrating the use of Excel and SPSS to order
    and group variables are not included.
    Description of the measurement levels for each of the
    variables in the dataset is not included.
    Discussion of what was learned from ordering the data by age
    and why this information is important is not included.
    Description of the process used to group the data in Excel and
    SPSS is not included.
    Description of what was learned from grouping variables by
    the category of exercise is not included.
    Discussion of whether study is correlational, experimental, or
    quasi-experimental; the rationale for the study type; and
    identification of a study question appropriate for the dataset
    is not included.
    Surface errors are pervasive enough that they impede
    communication of meaning. Inappropriate word choice or
    sentence construction is used.
    Total Points
    40.0
    Less than Satisfactory (74.00%)
    Screenshots illustrating the use of Excel and SPSS to order
    and group variables are incomplete or incorrect.
    Description of the measurement levels for each of the
    variables in the dataset is incomplete or incorrect.
    Discussion of what was learned from ordering the data by age
    and why this information is important is incomplete or
    incorrect.
    Description of the process used to group the data in Excel and
    SPSS is incomplete or incorrect.
    Description of what was learned from grouping variables by
    the category of exercise is incomplete or incorrect.
    Discussion of whether study is correlational, experimental, or
    quasi-experimental; the rationale for the study type; and
    identification of a study question appropriate for the dataset
    is incomplete or incorrect.
    Frequent and repetitive mechanical errors distract the
    reader. Inconsistencies in language choice (register) or word
    choice are present. Sentence structure is correct but not
    varied.
    Satisfactory (79.00%)
    Screenshots illustrating the use of Excel and SPSS to order
    and group variables are partially complete and correct.
    Description of the measurement levels for each of the
    variables in the dataset is included but lacks explanation and
    relevant details.
    Discussion of what was learned from ordering the data by age
    and why this information is important is included but lacks
    explanation and relevant details.
    Description of the process used to group the data in Excel and
    SPSS is included but lacks explanation and relevant details.
    Description of what was learned from grouping variables by
    the category of exercise is included but lacks explanation and
    relevant details.
    Discussion of whether study is correlational, experimental, or
    quasi-experimental; the rationale for the study type; and
    identification of a study question appropriate for the dataset
    is included but lacks explanation and justification.
    Some mechanical errors or typos are present, but they are
    not overly distracting to the reader. Correct and varied
    sentence structure and audience-appropriate language are
    employed.
    Good (87.00%)
    Screenshots illustrating the use of Excel and SPSS to order
    and group variables are mostly complete and correct.
    Description of the measurement levels for each of the
    variables in the dataset is complete and includes explanation
    and relevant details.
    Discussion of what was learned from ordering the data by age
    and why this information is important is complete and
    includes explanation and relevant details.
    Description of the process used to group the data in Excel and
    SPSS is complete and includes explanation and relevant
    details.
    Description of what was learned from grouping variables by
    the category of exercise is complete and includes explanation
    and relevant details.
    Discussion of whether study is correlational, experimental, or
    quasi-experimental; the rationale for the study type; and
    identification of a study question appropriate for the dataset
    is complete and includes explanation and justification.
    Prose is largely free of mechanical errors, although a few may
    be present. The writer uses a variety of effective sentence
    structures and figures of speech.
    Excellent (100.00%)
    Screenshots illustrating the use of Excel and SPSS to order
    and group variables are complete and correct.
    Description of the measurement levels for each of the
    variables in the dataset is extremely thorough with
    substantial explanation and relevant details.
    Discussion of what was learned from ordering the data by age
    and why this information is important is extremely thorough
    with substantial explanation and relevant details.
    Description of the process used to group the data in Excel and
    SPSS is extremely thorough with substantial explanation and
    relevant details.
    Description of what was learned from grouping variables by
    the category of exercise is extremely thorough with
    substantial explanation and relevant details.
    Discussion of whether study is correlational, experimental, or
    quasi-experimental; the rationale for the study type; and
    identification of a study question appropriate for the dataset
    is extremely thorough and includes substantial explanation
    and justification.
    Comments
    Writer is clearly in command of standard, written, academic
    English.
    Points Earned
    A local community organization was interested in learning about general health behaviors in the area and the
    relationships between health behaviors and environmental and social determinants. They decided to conduct a
    brief survey based on a convenient sample of people visiting the local shopping mall. They offered a $5 incentive
    for completing the survey. The Topic 1 Example dataset includes 30 observations from this survey. Use this data to
    complete the relevant assignments in this course.
    Education Level
    1
    2
    3
    Less than High School
    Graduated High School
    Graduated College
    Annual Income = US Dollars
    ehaviors in the area and the
    ts. They decided to conduct a
    all. They offered a $5 incentive
    from this survey. Use this data to
    ID
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    Sex
    Female
    Male
    Female
    Male
    Female
    Female
    Female
    Male
    Female
    Male
    Female
    Male
    Female
    Male
    Male
    Male
    Female
    Male
    Male
    Female
    Female
    Female
    Male
    Male
    Female
    Male
    Female
    Female
    Male
    Male
    Smoker
    No
    No
    Yes
    No
    Yes
    Yes
    No
    Yes
    Yes
    No
    No
    No
    Yes
    No
    No
    No
    No
    Yes
    Yes
    No
    Yes
    No
    No
    No
    No
    Yes
    Yes
    No
    No
    Yes
    Education_Level***
    2
    2
    3
    1
    1
    2
    3
    1
    2
    2
    3
    1
    1
    3
    2
    1
    2
    3
    2
    1
    2
    3
    2
    1
    1
    3
    3
    1
    3
    3
    Minutes_Exercise
    90
    50
    65
    20
    50
    25
    110
    50
    40
    80
    120
    80
    60
    150
    75
    80
    110
    80
    100
    0
    50
    200
    60
    65
    40
    65
    70
    45
    75
    50
    Age
    45
    58
    31
    54
    30
    18
    39
    37
    44
    24
    42
    50
    20
    35
    61
    59
    36
    35
    29
    32
    26
    42
    52
    49
    21
    48
    40
    53
    46
    42
    Employed
    Yes
    No
    Yes
    No
    Yes
    No
    Yes
    Yes
    Yes
    No
    Yes
    Yes
    No
    Yes
    Yes
    No
    Yes
    Yes
    No
    No
    No
    Yes
    No
    No
    No
    Yes
    Yes
    No
    Yes
    Yes
    Annual_Income*Neighborhood
    51000
    B
    23000
    C
    35000
    B
    10000
    C
    28000
    B
    5000
    C
    46000
    A
    36000
    B
    51000
    C
    12000
    A
    78000
    A
    34000
    D
    15000
    B
    28000
    B
    28000
    A
    24000
    B
    55000
    D
    62000
    B
    32000
    D
    7000
    C
    17000
    B
    64000
    D
    5000
    A
    14000
    D
    20000
    C
    72000
    A
    85000
    A
    15000
    B
    64000
    C
    27000
    B

    How to place an order?

    Take a few steps to place an order on our site:

    • Fill out the form and state the deadline.
    • Calculate the price of your order and pay for it with your credit card.
    • When the order is placed, we select a suitable writer to complete it based on your requirements.
    • Stay in contact with the writer and discuss vital details of research.
    • Download a preview of the research paper. Satisfied with the outcome? Press “Approve.”

    Feel secure when using our service

    It's important for every customer to feel safe. Thus, at HomeworkGiants, we take care of your security.

    Financial security You can safely pay for your order using secure payment systems.
    Personal security Any personal information about our customers is private. No other person can get access to it.
    Academic security To deliver no-plagiarism samples, we use a specially-designed software to check every finished paper.
    Web security This website is protected from illegal breaks. We constantly update our privacy management.

    Get assistance with placing your order. Clarify any questions about our services. Contact our support team. They are available 24\7.

    Still thinking about where to hire experienced authors and how to boost your grades? Place your order on our website and get help with any paper you need. We’ll meet your expectations.

    Order now Get a quote