PUB 550 New York University Week 2 Descriptive Stats and Frequency Tables Paper IMPORTANT NOTE REGARDING WORD LIMIT REQUIREMENTS: Please note that each an

PUB 550 New York University Week 2 Descriptive Stats and Frequency Tables Paper IMPORTANT NOTE REGARDING WORD LIMIT REQUIREMENTS:

Please note that each and every assignment has its own word limit.

Don't use plagiarized sources. Get Your Custom Essay on
PUB 550 New York University Week 2 Descriptive Stats and Frequency Tables Paper IMPORTANT NOTE REGARDING WORD LIMIT REQUIREMENTS: Please note that each an
Just from $13/Page
Order Essay

The purpose of this assignment is to compare basic functions in Excel and SPSS to calculate descriptive statistics and use this information to describe the sample.

For this assignment, students will utilize Excel with the Data Analysis ToolPak and SPSS Statistics and the “Example Dataset” to complete the assignment. Refer to the links below for assistance with enabling the Data Analysis ToolPak on a Mac or PC.

Part 1:

Complete the following steps in both Excel and IBM SPSS Statistics.

Calculate mean, median, and mode for the variables “Annual Income” and “Age.” Show the appropriate summary tables for these measures from both Excel and SPSS. Include the other descriptive statistics that are a part of the summary output in Excel and SPSS.
Create histograms to show the distribution for “Annual Income” and “Age.” Copy and paste the histograms from Excel and export the histogram from SPSS into the Word document for this assignment.
Create frequency tables that include counts and percentages for smoking status, employment status, exercise level, and education level. Show the tables in the Word document for this assignment.

Part 2:

Based upon the Part 1 activities, write a 250-500 word interpretation that addresses the following.

Discuss the sampling strategy used in this study and if it resulted in a representative sample.
Discuss what you are able to ascertain about the sample from the descriptive statistics.
Explain what other variables the research team could have included to gain a better understanding of the population.

General Requirements

Submit one Word document for the Part 1 assignment content and a second Word document for Part 2 of the assignment.

You are required to cite at least FOUR sources to complete this assignment. Sources must be published within the last 5 years and appropriate for the discussion question criteria and public health content.

Prepare this assignment according to the guidelines found in the APA Style Guide. An abstract is not required.

While APA style is required, solid academic writing is expected as well, and documentation of sources should be presented using APA formatting guidelines.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

PLEASE make sure APA citation and permalink for articles are complete and correct.

PLEASE add the links/sites below to the reference list if you use any of these readings and make sure everything is in proper APA format.

https://apastyle.apa.org/learn/quick-guide-on-refe…

Read Chapters 4 and 5 in Using and Interpreting Statistics: A Practical Text for the Behavioral, Social, and Health Sciences.

URL:

http://www.gcumedia.com/digital-resources/macmillan-learning/2016/using-and-interpreting-statistics_a-practical-text-for-the-behavioral-social-and-health-sciences_ebook_3e.php

View “The Best Stats You’ve Ever Seen,” by Rosling (2006), located on the TED website.

URL:

View the following tutorials from the SPSS Tutorials media.

Frequency Tables and Histograms
Descriptive Statistics

URL:

http://lc.gcumedia.com/psy380/spss-tutorials/v1.1/

View the following terms in The Visual Learner: Statistics media.

Confounding
Histogram

View the following calculations in The Visual Learner: Statistics media.

Frequency Distribution
Measure of Center ‘Mean’
Measure of Center ‘Median’
Measure of Center ‘Mode’
Range and Standard Deviation
Variance

URL:

http://lc.gcumedia.com/hlt362v/the-visual-learner/the-visual-learner-v2.1.html

The “Sampling Distribution” simulation, located on the Rice Virtual Last in Statistics website, will be used for a discussion question in this topic.

URL:

http://onlinestatbook.com/stat_sim/sampling_dist/index.html

For assistance with using Excel software, use the “Excel Training: Create and Format PivotTables and Pivot Charts” video library, located on the Microsoft website.

URL:

https://support.office.com/en-us/article/Video-Create-PivotTables-74ce8afc-2446-4816-80ee-20ca7fb71793?ui=en-US&rs=en-US&ad=US

MUST have at least 4 citations with the page numbers and 4 references in APA format.(The List of References should not be older than 2016 and should not be included in the word count.)

Be sure to support your postings and responses with specific references to the Learning Resources.

It is important that you cover all the topics identified in the assignment. Covering the topic does not mean mentioning the topic BUT presenting an explanation from the context of ethics and the readings for this class

I am a stickler for good organization in everything. I do not want to have to dig for your answers. For instance, if an assignment asks you to provide three examples of something, I suggest that you number them 1-3 so I can find them easily. I also expect that when you submit something as a narrative, you pay attention to how you organize your thoughts: use paragraphs with a topic sentence and supporting sentences; and change paragraphs whenever you introduce a new idea. Also, if there are multiple parts to an assignment, use sub-heads within the paper to organize them.

To get maximum points you need to follow the requirements listed for this assignments 1) look at the word/page limits 2) review and follow APA rules 3) create subheadings to identify the key sections you are presenting and 4) Free from typographical and sentence construction errors.

REMEMBER IN APA FORMAT JOURNAL TITLES AND VOLUME NUMBERS ARE ITALICIZED. Course Code
PUB-550
Class Code
PUB-550-O500
Criteria
Content
Percentage
100.0%
Part 1 – Summary Tables
20.0%
Part 1 – Histograms
15.0%
Part 1 – Frequency Table
15.0%
Part 2 – Sampling Strategy
15.0%
Part 2 – Descriptive Statistics
15.0%
Part 2 – Other Variables
15.0%
Mechanics of Writing (includes spelling,
punctuation, grammar, language use)
5.0%
Total Weightage
100%
Assignment Title
Practicing Application of Descriptive Statistics in Excel and SPSS
Unsatisfactory (0.00%)
Summary tables illustrating mean, median, and mode for the
Annual Income and Age variables in Excel and SPSS are not
included.
Histograms showing the distribution of Annual Income and
Age in Excel and SPSS are not included.
Calculations for the frequency table, including counts and
percentages for smoking status, employment status, exercise
level, and education level in Excel and SPSS, are not included.
Discussion of the sampling strategy used and whether it
resulted in a representative sample is not included.
Discussion about what was able to be ascertained about the
sample from the descriptive statistics is not included.
Explanation of other variables the research team could have
included to gain better understanding of the population 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%)
Summary tables illustrating mean, median, and mode for the
Annual Income and Age variables in Excel and SPSS are
incomplete or incorrect.
Histograms showing the distribution of Annual Income and
Age in Excel and SPSS are incomplete or incorrect.
Calculations for the frequency table, including counts and
percentages for smoking status, employment status, exercise
level, and education level in Excel and SPSS, are incomplete
or incorrect.
Discussion of the sampling strategy used and whether it
resulted in a representative sample is incomplete or
incorrect.
Discussion about what was able to be ascertained about the
sample from the descriptive statistics is incomplete or
incorrect.
Explanation of other variables the research team could have
included to gain better understanding of the population 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%)
Summary tables illustrating mean, median, and mode for the
Annual Income and Age variables in Excel and SPSS are
partially complete and correct.
Histograms showing the distribution of Annual Income and
Age in Excel and SPSS are partially complete and correct.
Calculations for the frequency table, including counts and
percentages for smoking status, employment status, exercise
level, and education level in Excel and SPSS, are partially
complete and correct.
Discussion of the sampling strategy used and whether it
resulted in a representative sample is included but lacks
explanation and justification.
Discussion about what was able to be ascertained about the
sample from the descriptive statistics is included but lacks
explanation and relevant details.
Explanation of other variables the research team could have
included to gain better understanding of the population is
included but lacks relevant details 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%)
Summary tables illustrating mean, median, and mode for the
Annual Income and Age variables in Excel and SPSS are mostly
complete and correct.
Histograms showing the distribution of Annual Income and
Age in Excel and SPSS are mostly complete and correct.
Calculations for the frequency table, including counts and
percentages for smoking status, employment status, exercise
level, and education level in Excel and SPSS, are mostly
complete and correct.
Discussion of the sampling strategy used and whether it
resulted in a representative sample is complete and includes
explanation and justification.
Discussion about what was able to be ascertained about the
sample from the descriptive statistics is complete and
includes explanation and relevant details.
Explanation of other variables the research team could have
included to gain better understanding of the population is
complete and includes relevant details 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%)
Summary tables illustrating mean, median, and mode for the
Annual Income and Age variables in Excel and SPSS are
complete and correct.
Histograms showing the distribution of Annual Income and
Age in Excel and SPSS are complete and correct.
Calculations for the frequency table, including counts and
percentages for smoking status, employment status, exercise
level, and education level in Excel and SPSS, are complete and
correct.
Discussion of the sampling strategy used and whether it
resulted in a representative sample is extremely thorough
with substantial explanation and justification.
Discussion about what was able to be ascertained about the
sample from the descriptive statistics is extremely thorough
with substantial explanation and relevant details.
Explanation of other variables the research team could have
included to gain better understanding of the population is
extremely thorough and includes substantial relevant details
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

Purchase answer to see full
attachment

Homework Writings Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Why should I choose Homework Writings Pro as my essay writing service?

We Follow Instructions and Give Quality Papers

We are strict in following paper instructions. You are welcome to provide directions to your writer, who will follow it as a law in customizing your paper. Quality is guaranteed! Every paper is carefully checked before delivery. Our writers are professionals and always deliver the highest quality work.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Reasonable Prices and Free Unlimited Revisions

Typical student budget? No problem. Affordable rates, generous discounts - the more you order, the more you save. We reward loyalty and welcome new customers. Furthermore, if you think we missed something, please send your order for a free review. You can do this yourself by logging into your personal account or by contacting our support..

Essay Delivered On Time and 100% Money-Back-Guarantee

Your essay will arrive on time, or even before your deadline – even if you request your paper within hours. You won’t be kept waiting, so relax and work on other tasks.We also guatantee a refund in case you decide to cancel your order.

100% Original Essay and Confidentiality

Anti-plagiarism policy. The authenticity of each essay is carefully checked, resulting in truly unique works. Our collaboration is a secret kept safe with us. We only need your email address to send you a unique username and password. We never share personal customer information.

24/7 Customer Support

We recognize that people around the world use our services in different time zones, so we have a support team that is happy to help you use our service. Our writing service has a 24/7 support policy. Contact us and discover all the details that may interest you!

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our reputation for excellence in providing professional tailor-made essay writing services to students of different academic levels is the best proof of our reliability and quality of service we offer.

Essays

Essay Writing Service

When using our academic writing services, you can get help with different types of work including college essays, research articles, writing, essay writing, various academic reports, book reports and so on. Whatever your task, homeworkwritingspro.com has experienced specialists qualified enough to handle it professionally.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our professional editor will check your grammar to make sure it is free from errors. You can rest assured that we will do our best to provide you with a piece of dignified academic writing. Homeworkwritingpro experts can manage any assignment in any academic field.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.