How do incomes differ across zip codes

Assignment Help Applied Statistics
Reference no: EM132241738

Assignment -

Part 1: For this assignment, you will use the "Arizona Incomes by Zip Code" dataset. You will use Tableau to create a data story that illustrates the median household incomes of Arizona residents. The data provided includes all zip codes in Arizona. Each record is a unique zip code. The data includes the following columns:

1. Zip_Code: An Arizona zip code.

2. Metro_Area: Whether or not the zip code is within the Phoenix-metro area.

3. City: The city name of the zip code.

4. Median_Income: The median household income of each zip code based on 5-year estimates (2010-2014) from the U.S. Census Bureau.

The marketing manager has asked you to analyze income data for Arizona residents so that leaders in his department can determine the company's advertising strategy. The marketing manager intends to share this data with other decisions makers and the marketing department staff so that everyone has a thorough understanding of how the income information can be used to determine specific target markets in upcoming advertising campaigns. Because most of these individuals do not have a strong understanding of analytics, they must be able gain the information listed below from studying the charts. In the data story, use visualizations, heat maps, boxplots, etc. to describe the following:

1. How do incomes differ across zip codes within the Phoenix-metro area (using geo-mapping)?

2. What is the relative difference in incomes across zip codes within the Phoenix-metro area (use a heat map)?

3. What are the distribution of incomes across Arizona?

4. How do incomes within the Phoenix metro area differ from those outside of that area?

Part 2: Demonstrate the ability to communicate the analytics story to key stakeholders, including the marketing manager, by creating a 6-10 slide PowerPoint presentation (with speaker notes for each slide). Use the charts generated in Tableau to illustrate the data story as it relates to the income of Arizona residents. The slides and speaker notes should address the following for each chart presented.

1. What information is the chart providing to stakeholders?

2. Why is the information in the chart important to key stakeholders?

3. How can this information be used in making decisions about how marketing dollars can be allocated?

Instructions: The PART 1, you will use the Tableau software. And the PART 2, is an power-point presentation.

Attachment:- Assignment Files.rar

Reference no: EM132241738

Questions Cloud

Determine global optimal decision strategy : Mary has recently been assigned to the economic analysis section of Global Oil. Mary needs to determine Global’s optimal decision strategy
Examining historical foundations of major schools of thought : For this assignment, you will be examining the historical foundations of three major schools of thought within the field of psychology: psychoanalysis.
Summarize two service standards the industry uses to meet : Describe how the industry involves the guest in order to provide quality service. Summarize two (2) service standards the industry uses to meet.
Create a payload that when executed along with activity : Create a payload that when executed along with Activity 1 will cause the output of Activity 1 to change from this is normal output to Welcome to Overflow
How do incomes differ across zip codes : For this assignment, you will use the "Arizona Incomes by Zip Code" dataset. How do incomes differ across zip codes within the Phoenix-metro area
Major differences that are brought to healthcare industry : Discuss the major differences that are brought to the healthcare industry by the introduction of ICD-10. How has it helped the industry?
Was participation among the members equalized : Was participation among the members equalized or one-sided? Were there quiet or dominating members in the group?
How do you know that sources used were reliable-accurate : Discuss the accuracy of the facts used in the story. How do you know that the sources used were reliable and accurate?
Provide opportunity to apply the class concepts : Provide an opportunity to apply the class concepts in the solution of practical problems.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Machines continuously process an unending number of jobs

Three machines continuously process an unending number of jobs. The time it takes to process a job on machine A is a Uniform [0,4] random variable, the time it takes to process a job on machine B is Uniform [1,3] random variable, and the time it take..

  Terms of z-scores and areas under the normal curve

Jack weighs 160 pounds and his sister weighs 110 pounds. If themean weight for men his age is 175 with a standard deviation of 14pounds and the mean weight for women is 145 with a standarddeviation of 10 pounds, determine whose weight is closer to "a..

  Water specimens contain nitrates

Water specimens contain nitrates, a solution that is dropped into the water will cause the specimen to turn red 95% of the time. When used on water specimens without nitrates, the solution turns the water red 10% of the time. Past experience in the l..

  Fuel consumption and cars

Fuel Consumption and Cars. The Fiat 500E is an electric car that can travel approximately 80-100 miles on a full charge. The time it takes to fully recharge depends on the percent depleted, but is approximately normal with mean 2.2 hours and standard..

  What statistics from this module would use

As a manager of an organization, what statistics from this module would you use and why if you wanted to estimate your annual employee turnover? In your post, be sure to specifically identify the statistical formulas and what additional data you woul..

  What is the quality of the references

Issues Capstone Poster Project: This was modified from an assignment developed by the Biology Faculty at BC, and derived from the Bio 100 Student Module. What is the quality of the references? Are the references relevant for the topic

  Is there a difference in payments methods

BUS501 - Business Analytics and Statistics Research Report, USC Australia. Is there a difference in payments methods? Which product category costs the most

  Reflection to date

Reflection to date

  What is the best central measure and the best dispersion mea

In a sample of 30 students of the Academy, we obtained the following data which represents the weights of these students 65, 59, 47, 67, 56, 50, 74, 45, 83, 72, 71, 53, 82, 58, 64 79, 55, 88, 56, 69, 50, 68, 66, 62, 59, 52, 72, 63, 56, 91 Answer the ..

  What does last one say about the utility of standard errors

Lab: Exercise your R prowess! Try graphing variance against the inverse of sample size. What does the last one say about the utility of standard errors

  Quantitative analysis for decision making

Internet and the articles database in the library for a real-life illustration of simulation. For hint, type the word "Simulation" followed by a topic of interest to you. Carefully review the search item.

  A random sample of 900 homeowners in delaware county

A random sample of 900 homeowners in Delaware County is taken in order to estimate the average amount of money spent by homeowners on landscaping this spring. It turns out that this group spent an average of $200 with a standard deviation of $..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd