Sign In
Not register? Register Now!
Essay Available:
Pages:
1 page/β‰ˆ275 words
Sources:
Check Instructions
Style:
APA
Subject:
Accounting, Finance, SPSS
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 5.27
Topic:

Descriptive Statistics in Excel/SPSS

Essay Instructions:


Practicing Application of Descriptive Statistics in Excel and SPSS

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 Topic Materials 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.
APA style is not required, but solid academic writing is expected.

Essay Sample Content Preview:

Descriptive Statistics
Your Name
Subject and Section
Professor’s Name
Part 2
Despite the considerable size of the population, the sample population in this study is not representative of the whole population. As stated in the data sheet, the collection was done within a shopping mall for convenience purposes. This creates a possible bias towards those individuals who do not have work during the time of the survey or those who are frequent mall goers. It must be noted that not all individuals go to the mall during their rest days. Thus, the sampling method employed in this study fails to capture a representative sample of the citizens within the same city.
Nevertheless, an analysis of the age and income of the participants would show that those who are surveyed are distributed evenly when it comes to age. The histogram presented below would show a normal ‘bell-shaped’ distribution for age, which supports this conclusion. In contrast, an analysis of their annual income would show that those who are earning less are more than those who are earning more, as evident from the left-skewed distribution. Accordingly, this is reflective of reality that shows that those who earn the most comprise the least number in the society.
In order to gain a better understanding of the population the researchers could have gathered more information based on random sampling instead. Additionally, it would be best if the researchers have included “political inclination” of the population.
Part 1 – Charts and Histograms
* SPSS
Smoker


Frequency

Percent

Valid Percent

Cumulative Percent

Valid

No

18

60.0

60.0

60.0


Yes

12

40.0

40.0

100.0


Total

30

100.0

100.0


Education_Level***


Frequency

Percent

Valid Percent

Cumulative Percent

Valid

1

10

33.3

33.3

33.3


2

10

33.3

33.3

66.7


3

10

33.3

33.3

100.0


Total
...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Essay Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now