Practical Analytics Chapter 1 | Exercise 1 | Edition 2

Nitin Kalé & Nancy Jones © 2020 1 of 2

1.1 Data Exploration Using Publicly Available Data Nitin Kalé, University of Southern California

Nancy Jones, San Diego State University

OBJECTIVE Self-service data exploration of publicly available data from the U.S. Census.

ACTIVITIES

Explore data with charts and tables.

Filter, sort, and rank data to gain insights.

SOFTWARE PREREQUISITES

Web browser

Scenario Kumar is a new intern at Global Bike. He is working in the sales department with Nina Kane’s team. On

the first day at work, he is tasked with analyzing U.S. census data to understand the demographics of

his home state. The demographic data will be used to help the team devise a targeted marketing plan.

Kumar is alone in the office with only the administrative staff since the sales team is out of town all

week at a trade show. His report needs to be to Nina by next week.

Analysis

a. Access the U.S. Census data at this url: https://www.census.gov

b. Familiarize yourself with the Census website.

c. Go to the Explore Data tab → Explore Data Main page to start your data exploration.

Practical Analytics Chapter 1 | Exercise 1 | Edition 2

Nitin Kalé & Nancy Jones © 2020 2 of 2

d. Identify the most current data for the city and/or state in which your school is located to

answer the questions listed below. If you are not in a metro area, choose the closest metro

area for which you can find data.

e. Include screen shots of the census data visualizations and tables that support your answers.

Question 1: What is the average travel time (commute) to work for individuals in your metro area?

Question 2: What is the median household income for individuals within your state?

Question 3: How does the median income in your state compare to other states? (Hint: Use a chart or map.)

Question 4: What is the population of your state?

Question 5: Is the population in your state growing or shrinking? By how much?

Question 6: What percent of the population within your state is between the ages of 20 and 60?

Question 7: How many vehicles are available to the households within your state?

Question 8: How many individuals in your state take alternative methods cabs or bicycles to get to work?

Question 9: Create a dashboard of two or more charts that you accessed on the website and paste a screen shot here.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order