# compare basic functions in Excel and SPSS to calculate descriptive statistics and use this information to describe the sample

SECTION ONE
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.

1. 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.
2. 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.
3. 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.

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

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

SECTION TWO
The purpose of this assignment is to practice calculating confidence intervals.For this assignment, students will utilize Excel and SPSS Statistics and the “Example Dataset.”Using the “Example Dataset,” complete the following:

1. Based on a normal distribution curve, calculate the probability of an individual being 60 years or older in this population. Show the Excel and SPSS formulas or your hand calculations. Include screenshots as needed to illustrate this.
2. Using the sample standard deviation of age as an estimate of the population standard deviation, calculate by hand the standard error of the mean. Show your calculations and the answer.
3. Calculate by hand a 95% confidence interval for “Age” based on the sample mean. Use SPSS to verify your answer. Include your calculations and screenshots of the SPSS output.
4. Interpret the confidence interval for age and explain the three pieces of information needed to calculate a confidence interval.

Submit one Word document that includes all of the assignment deliverables.

## Background

 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 Less than High School 2 Graduated High School 3 Graduated College Annual Income = US Dollars

## Original

 ID Sex Smoker Education_Level*** Minutes_Exercise Age Employed Annual_Income* Neighborhood 101 Female No 2 90 45 Yes 51000 B 102 Male No 2 50 58 No 23000 C 103 Female Yes 3 65 31 Yes 35000 B 104 Male No 1 20 54 No 10000 C 105 Female Yes 1 50 30 Yes 28000 B 106 Female Yes 2 25 18 No 5000 C 107 Female No 3 110 39 Yes 46000 A 108 Male Yes 1 50 37 Yes 36000 B 109 Female Yes 2 40 44 Yes 51000 C 110 Male No 2 80 24 No 12000 A 111 Female No 3 120 42 Yes 78000 A 112 Male No 1 80 50 Yes 34000 D 113 Female Yes 1 60 20 No 15000 B 114 Male No 3 150 35 Yes 28000 B 115 Male No 2 75 61 Yes 28000 A 116 Male No 1 80 59 No 24000 B 117 Female No 2 110 36 Yes 55000 D 118 Male Yes 3 80 35 Yes 62000 B 119 Male Yes 2 100 29 No 32000 D 120 Female No 1 0 32 No 7000 C 121 Female Yes 2 50 26 No 17000 B 122 Female No 3 200 42 Yes 64000 D 123 Male No 2 60 52 No 5000 A 124 Male No 1 65 49 No 14000 D 125 Female No 1 40 21 No 20000 C 126 Male Yes 3 65 48 Yes 72000 A 127 Female Yes 3 70 40 Yes 85000 A 128 Female No 1 45 53 No 15000 B 129 Male No 3 75 46 Yes 64000 C 130 Male Yes 3 50 42 Yes 27000 B