Our Services

Get 15% Discount on your First Order

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.

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.

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

URL:

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:

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:

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

URL:

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:

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.

Expert Solution Preview

Introduction:

This assignment aims to compare basic functions in Excel and SPSS to calculate descriptive statistics and utilize the information to describe the sample. The first part requires calculating mean, median, mode, creating histograms and frequency tables for specific variables and demonstrating the appropriate summary tables in both Excel and SPSS. The second part requires interpreting the results obtained from Part 1, discussing the sampling strategy used in this study, and explaining what other variables the research team could have included to gain a better understanding of the population.

The sampling strategy used in this study is not specified in the assignment instructions. Therefore, it is unsure of what type of sampling strategy was used. Random sampling ensures that every member of the population has an equal chance of being selected. A representative sample means that the sample characteristics represent the population from which it was drawn. The assignment does not provide enough information to determine if the sample is representative or not.

Interpreting the descriptive statistics that were calculated in Part 1 provides information about the sample’s central tendency, dispersion, and shape. By looking at the mean, median, and mode of variables, such as “Annual Income” and “Age,” one can understand the central tendency of the sample. The histogram shows the distribution of each variable, indicating if the data is skewed, bimodal, or normal. The frequency table provides insights into the count and percentage of categorical variables, such as smoking status, employment status, exercise level, and education level, in the sample.

Other variables that the research team could have included are health-related variables, such as blood pressure, cholesterol levels, and body mass index (BMI) to assess the overall health status of the sample. Also, psychological variables, such as stress level and quality of life, would provide a better understanding of the sample beyond just demographics. Including these variables would provide a comprehensive overview of the physical and psychological health of the sample.

In conclusion, this assignment allowed us to compare basic functions in Excel and SPSS to calculate descriptive statistics and to interpret the results. Additionally, the assignment provided insights into the sampling strategy used in the study and variables that could have been included to gain a better understanding of the population.

Expert Solution Preview

The sampling strategy used in this study was not specified in the assignment instructions, thus, it is unclear what type of sampling strategy was implemented. A representative sample ensures that the sample characteristics represent the population from which it was drawn, however, there is not enough data provided to determine if the sample is representative. By interpreting the descriptive statistics calculated in Part 1, we can glean information on the sample’s central tendency, dispersion, and shape. Calculating the mean, median, and mode of variables such as “Annual Income” and “Age” can provide insight into the central tendency of the sample. Additionally, the histogram can reveal the distribution of each variable, indicating skewness, bimodality, or normality, while the frequency table displays the count and percentage of categorical variables, such as smoking status, employment status, exercise level, and education level, in the sample. Other important variables that could have been included for a comprehensive overview of the sample’s physical and psychological health are blood pressure, cholesterol levels, BMI, stress level, and quality of life. These variables would provide a better understanding of the sample beyond demographics.

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

STUDENT 1 Purpose To practice using literary devices and preparing to use them in our Spark Grant Proposals Tasks Choose three literary devices from

STUDENT 1 Purpose To practice using literary devices and preparing to use them in our Spark Grant Proposals Tasks Choose three literary devices from the class list(Word document ) and create original examples for each of those devices. Ideally, these examples should relate to your Spark Grants topic and can be used verbatim

This Mid-Course Reflection Paper is a synopsis of your thoughts and comprehension of concepts learned thus far in the course. Your paper should be created

This Mid-Course Reflection Paper is a synopsis of your thoughts and comprehension of concepts learned thus far in the course. Your paper should be created using APA format (title page, double spaced, references, etc.). Your paper should be a minimum of two pages and include the following components. Identify all

Please see the attached document for specific instructions and related questions.  Instructions Format – Examine the

Please see the attached document for specific instructions and related questions.  Instructions Format – Examine the different career counseling theories, and present them in below format. – Name the theorists associated with the theories. – Explain the main elements of the theories. – Discuss the ethical considerations associated with the

Subject: Centers for Disease Control and Prevention. Power point presentation slides :Identify the benefits and risks of use.

Subject: Centers for Disease Control and Prevention. Power point presentation slides :Identify the benefits and risks of use.

Para hablar con una persona en Volaris, sigue estos pasos: Prepara tu información: Ten a mano tu número de reserva y datos personales. Visita el sitio

Para hablar con una persona en Volaris, sigue estos pasos: Prepara tu información: Ten a mano tu número de reserva y datos personales. Visita el sitio web de Volaris: Ve a www.volaris.com. Navega a ‘Contáctanos’: Al final de la página principal, haz clic en ‘Contáctanos’1-888-829-1330 OTA. Encuentra el número

How did Starbucks create its uniqueness in the first place? Why was the uniqueness so successful? To be a source of competitive advantage over

How did Starbucks create its uniqueness in the first place? Why was the uniqueness so successful? To be a source of competitive advantage over time, core competencies need to be continuously honed and upgraded. Why and how did Starbucks lose its uniqueness and struggle in the mid-2000s? What strategic

After reading the case “Willamette” on pages 173-184 of your text, you are to respond in this discussion area with your observations of the case. Do

After reading the case “Willamette” on pages 173-184 of your text, you are to respond in this discussion area with your observations of the case. Do not discuss eventual outcomes of the case. Sufficient elaboration on the topic is needed. In-text citations and references are needed. Please use the APA

The Census and Race/Ethnicity * Read through these instructions first. Then proceed through this document, starting at the top. Step 3 contains

The Census and Race/Ethnicity * Read through these instructions first. Then proceed through this document, starting at the top. Step 3 contains the actual post questions. Step 1: Open up two tabs for these sites so you can go back and forth: The first link above is the U.S. Census

The purpose of this activity is to interview local coaches or sport administrators to learn how their organizations are implementing principles of

The purpose of this activity is to interview local coaches or sport administrators to learn how their organizations are implementing principles of athlete talent development. Select and interview a local coach or sports administrator. Use the list on worksheet 5.9 as an interview guide      Video (2:27) “Carolina Basketball:

The topic is Incorporating Social Emotional Learning (SEL) and Biblical Worldview in Christian Schools  also follow the advanced side of the grading

The topic is Incorporating Social Emotional Learning (SEL) and Biblical Worldview in Christian Schools  also follow the advanced side of the grading rubric

Stringer, E. T., & Aragón, O. A. (2020).  Action research (5th ed.). SAGE Publications, Inc. ISBN: 9781544355948. Read chapters 6 & 7.

Stringer, E. T., & Aragón, O. A. (2020).  Action research (5th ed.). SAGE Publications, Inc. ISBN: 9781544355948. Read chapters 6 & 7. Discussion Question: Must be at least 250 words. Why is it important to build a community with a prescribed vision within the AR project? Describe a time when developing a

Justify your answers with appropriate research and reasoning. Comment on 2 Reponses that is on attachment   Ex plain why Pavlov’s experiments in

Justify your answers with appropriate research and reasoning. Comment on 2 Reponses that is on attachment   Ex plain why Pavlov’s experiments in reflexology were an important part in the development of psychology. De scribe behaviorism from Watson’s perspective; then, compare and contrast his viewpoints with operational positivism and the

Just 3-5 sentences to answer the question Reply to Destini in a few 2-3 sentences

Just 3-5 sentences to answer the question Reply to Destini in a few 2-3 sentences

After reading and watching the content for this module, respond to the following questions: 1. What did you already know about social and emotional

After reading and watching the content for this module, respond to the following questions: 1. What did you already know about social and emotional development in infants and toddlers? 2. Did you learn anything new about social and emotional learning and how it influences later development? 3. Do you think

I just someone to check my work, i have already done all of them but there is missing stuff i didn’t solve  FOR Lab one  what i want  On page 7i need Part

I just someone to check my work, i have already done all of them but there is missing stuff i didn’t solve  FOR Lab one  what i want  On page 7i need Part A : single melting point determination of unknown sample  Table  Page 8 all page, page 9all pages,

ASSIGNMENT 1:Complete the POA/HAC for the given scenarios. The beginning of Chapter 4 gives a quick review of POA/HAC. The attached AHIMA article gives

ASSIGNMENT 1:Complete the POA/HAC for the given scenarios. The beginning of Chapter 4 gives a quick review of POA/HAC. The attached AHIMA article gives more details. Be sure to read it.Campbell, Angela; D’Amato, Cheryl; Rugg, Donna. “Managing the Present on Admission Reporting Process (2016 update)” Journal of AHIMA 87, no.9

Otitis Media Top of Form Bottom of Form Module 08 Content 1. Top of Form An 8-year-old girl comes to your ambulatory care clinic with complaints of

Otitis Media Top of Form Bottom of Form Module 08 Content 1. Top of Form An 8-year-old girl comes to your ambulatory care clinic with complaints of left ear pain for the past 3 days. She had respiratory infection a week ago. On physical examination, the tympanic membrane is bulging. Answer

Instructional Design Prospectus Project Title: Company: · Name: · Staff: · Experience: Introduction: Work to be accomplished: Steps to be

Instructional Design Prospectus Project Title: Company: · Name: · Staff: · Experience: Introduction: Work to be accomplished: Steps to be followed with timeline Deliverables (relate to timeline): Budget Overview: · Personnel · Materials · Travel · Overhead · Resources · Other References: Date: