The purpose of this assignment is to filter and sort data, identify


The purpose of this assignment is to filter and sort data, identify patterns and relationships within data, and use those findings to address business needs.

For this assignment, you will use the “Adult Incomes” data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows.

  1. Sex: Gender
  2. Relationship: Relationship status
  3. Education: Highest level of education completed
  4. Hours _Per _Week: Number of weekly hours that the individual works
  5. Capital _Gain: Amount of capital gains from tax records
  6. Income: Income of the individual – either “>50K” or “<=50K”

The marketing department in your organization believes that customers with more education have higher incomes than those with less education, and the department director wants to formulate an ad campaign targeting customers with a specific income level. While the assumption stands to reason, having data to support this hypothesis is necessary in order for the department to justify the new advertising campaign strategy. The department director has asked you to determine several specific numbers and percentages along with calculating to what degree educational level is correlated with income. Based upon your finding, the marketing department will determine whether or not its idea for marketing specifically to those customers is likely to create a positive return on investment.

Question 1: Use Excel and various pivot tables and charts to calculate the following information. When summarizing categorical data, sometimes it is easier to create a new indicator (0/1) variable to obtain a percentage (the average of an indicator is a percent). Create a new indicator variable “Income_GT50” where the variable is equal to 1 when the income is greater than $50,000; otherwise use 0. Using this indicator variable, calculate the overall percent of individuals who earn more than $50,000 annually.

Question 2: You are interested in understanding the demographics of a particular cohort in your data set: those who have at least a “Bachelors,” “Masters,” or “Doctorate” degree whose occupation is also “Exec-managerial.” Filter the data to include only these individuals, and report the count of individuals who meet the criteria along with their average age and the percentage who earn more than $50,000 annually.

Question 3: Many times age does not have a purely linear relationship with the dependent variable, so it is separated into age brackets. Create a new variable categorizing age into brackets as follows. Include the pivot table output when submitting the answer.

  1. “<25”: If age less than 25
  2. “25-34”: If age between 25 and 34 inclusive
  3. “35-44”: If age between 35 and 44 inclusive
  4. “45-54”: If age between 45 and 54 inclusive
  5. “55-64”: If age between 55 and 64 inclusive
  6. “65+”: If age is 65 or more

Question 4: Calculate the percentage of customers who earn more than $50,000 annually for each age bracket. Create a pivot chart showing the results and include the chart when submitting the answer. Is the effect of age on income a linear or quadratic relationship?

Question 5: Using a pivot table, calculate the percent of customers earning more than $50,000 annually by education level? Include the pivot table and pivot chart outputs and refer to them as you address whether or not the marketing department’s belief that customers with more education have higher incomes than those with less education. Present your findings in the form of a 250-word executive summary that includes relevant data, charts, and tables.

General Requirements:

Submit the answers to Questions 1-4 and the executive summary as Word documents.

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

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:
The price is based on these factors:
Academic level
Number of pages
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

STAY HOME, SAVE LIVES. Order your essay today and save 20% with the discount code ATOM