Document | Applied Sciences homework help

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.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency