Reference no: EM132394138
Assignment: 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 Requirements: Submit 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.
Population of students partici-pating in the program
: Construct a 95% confidence interval for the mean number of months elapsed since the last visit to a dentist for the population of students.
|
Knee replacements to fix an artificial joint in place
: Acrylic bone cement is sometimes used in hip and knee replacements to fix an artificial joint in place. The force required to break an acrylic bone cement
|
What solutions you recommend to alleviate the imbalance
: Compose a well-written response paper to the following question: The ratio of physicians to population continues to increase beyond estimated needs.
|
How might employee access differ from customer access
: The three primary factors of authentication are something you know, How might employee access differ from customer access?
|
Discuss the sampling strategy used in the study
: 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.
|
Examples of societal problems are unemployment-pollution
: Examples of societal problems are unemployment, pollution, water quality, safety, criminality, well-being, health, and immigration.
|
Prepare an income statement for the year ending December
: Prepare an income statement for the year ending December 31, 2009. Prepare a retained earnings statement for the year ending December 31, 2009\
|
State what the metaphor refers to
: State what the metaphor refers to. What does it mean? (Try your best to do this without using another metaphor, although you may find this very difficult).
|
Discuss the laboratory testing that can be done
: Discuss the laboratory testing that can be done. Describe if chromosomal analysis is/was indicated, and detail the chromosomal change that caused the disease.
|