Name: (Order) Unit 6 Self-Check Assignment: Milligan, Chapter 12 - Shop.GetBrainful.com
Price: 156.89 USD
Availability: InStock

Unit 6 Self-Check Assignment: Milligan, Chapter 12

Students Name:

Professors Name:

Date: 23/09/2025

Welcome to your hands-on activity! This assignment invites you to work with Tableau using a mix of generated and real-world data. To complete this activity, you will follow these instructions:

Download the attached spreadsheets and upload the datasets into Tableau.
Go through this document, and use Tableau to answer all the questions listed below. Where applicable, paste screenshots into the template below.
When you are ready, complete the online quiz, which verifies your homework. You are welcome to refer to this document as you complete the quiz.
You are welcome to use the quiz results to update your homework file.
Remember, you can always reach out for help to your FA or instructor if needed.
If you need to adjust the size of your visualizations to match the options in the questions, use the “Format”->”Cell size” options. For example, “Ctrl+Shift+B” on a Windows computer will make the visualization bigger, and “Ctrl+Up” will make it taller.

You will find four attachments required for this exercise:

Baltimore City Crime Data June 2023 (3 worksheets)
San Francisco Real Estate Sales
University Courses and Room Capacities (2 worksheets)
University Floor Plan (image)

Question 1: Makepoint() and Makeline() functions

You are working for an analytics company that has contracted with the City of Baltimore to evaluate the locations of crimes. The city has provided information about crimes committed during June 2023. They have provided the locations of the police stations in the city as well. When a crime is logged in the system, there is a district assigned to the crime record.

The city has a headquarters and nine police stations in districts located around the city. They are trying to determine how to deploy the police force in the vicinity of each district.

First, you will visualize all of the crimes committed within the city of Baltimore. Load the Baltimore City Crime Data June 2023 Excel sheet and pick the first worksheet: All Districts.

Click on the latitude and longitude data points, and then click on “Show Me” to select a symbol map.

Alt text: Symbol map

Go up to the top menu bar under “Analysis” and turn off “Aggregate Measures.” You should now have a map with many dots:

Alt text: Map of dots

Drag the “District” dimension onto Color in the Marks tab. Your map should now have dots with nine colors. Add the “District” onto Label in the Marks tab. Use your mouse to hover over the districts so that you can learn where they are located.

Alt text: District map

You can immediately see that the outer perimeter districts (Northwest, Southwest, Southern, Northern, Northeast, and Southeast) are bigger, spread –out districts. The Western, Central, and Eastern districts are smaller. This is probably happening because there are more people in the middle of the city, and when you get further away from the center, the population is more dispersed.

While this map is helpful to get an idea of where crimes are committed, it is difficult to understand the relationship to the police department locations.

For that reason, you are going to create lines for one district to visualize how far away some crimes are committed from the district’s police department location. Load the Central District worksheet from the Baltimore City Crime Data June 2023 file. Create a new worksheet and create another map by selecting the Latitude and Longitude dimensions. Then select the map option under “Show Me” (the same procedure to make the map above). Again, turn off “Aggregate Measures” under the “Analysis” tab.

Alt text: Analysis map

Next, you’ll create two calculated fields: one for the police department latitude and another for the longitude. You will use the Fixed function to look at all the records and pick out any that are the type “Police Department.” First, create a calculated field by clicking on the “Analysis” menu and selecting “Create Calculated Field” (you can also right-click on the “Tables” tab) and name it “Police dept Latitude.” Input the LOD (level of detail) calculation below:

{FIXED : MIN(IF [Type] == “Police Department” THEN [Latitude] END)}

Do the same thing again to create another calculated field named “Police dept Longitude” with the following LOD formula:

{FIXED : MIN(IF [Type] == “Police Department” THEN [Longitude] END)}

Now, you will use the fixed data to create two points and a line using the MakePoint and MakeLine functions. Create another new calculated field called “Line,” and enter the formula below.

Alt text: latitude and longitude

MAKELINE(

MAKEPOINT([Police dept Latitude], [Police dept Longitude]),

MAKEPOINT([Latitude], [Longitude])

)

Now, drag the “Type” over to the Colors Mark and change the Marks type to “Circle.” You should now have solid circles with at least 1 color that is different. The circle with the different color is the police department location. Use the annotation (right-click on the orange dot) to annotate the point.

Alt text: Tableau book

Alt text: Dot map

Next, take the “Line” calculated field that you created, and drag it into the Marks area (defaults to Detail), then change the Marks type to “Map.” Your map will now change to a collection of lines that are measured from the Central Police Department to each crime location.

Alt text: map

Alt text: Line map

This visualization immediately shows us that the central police district doesn’t look very centrally located within its district.

The police department has now asked you to perform this same visualization for the Eastern District. Follow the same steps you used for the Central district but use the “Eastern District” worksheet provided in Baltimore City Crime Data June 2023.

Which of the following visualizations matches the Eastern District?

Alt text: District line maps

Question 1 Answer:

Option 8

<<insert your screenshot>>

Question 2: Distance calculation

Next, let’s calculate the actual distances between each crime committed and the district’s police station.

Go back to the worksheet on which you displayed the Central District map: the collection of lines measuring the distance from the Central District police station to each crime.

In this worksheet, create a new calculated field called “Distance from police dept” using the formula below. (Be sure you’re on the Central District sheet.)

Alt text: Latitude and longitude

DISTANCE(

MAKEPOINT([Police dept Latitude], [Police dept Longitude]),

MAKEPOINT([Latitude], [Longitude]),

‘mi’)

Drag that new calculated field onto the Marks area Tooltip. The calculated field will now show in the Tooltip when you hover over a line.

Alt text: tooltip
While this is interesting, it isn’t helpful in terms of analysis.

Let’s try to add distance to another visualization.

Go to a brand new worksheet, choose Central as your data source, and select the “Distance from police dept” and “Description” measures. Under the “Show Me” menu, pick the Treemap option.

Alt text: treemaps

When you look in the Marks area, you will see the default aggregation is set to SUM for the distance from the police station. Change the default aggregation to average for both the size and the color. (Note: If you see multiple different treemaps, you might have Aggregate Measures turned off in the Analysis toolbar menu.)

Now, you have a visualization that is showing the crimes that are farthest away from the police station. This might help to prompt the leadership to consider increasing a police presence in the areas farther away from the police station.

Now, let’s add another measure to this treemap to understand how many of these crimes are happening at what average distance away. Drag the measure “Central District (Count)” onto the size marks (it should remove the Average Distance from the Police Department). Now, the visualization is using the count of crimes by description to create the size and color based on the distance from the police station.

Hover over the largest block in the treemap, Common Assault. You will see that the count of the Central District was 119, and it was an average of 0.714 miles away from the police station.

Find the “Auto Theft” crime. What was the count and the average distance from the police station in the Central District?

Option A: Count 91, Average distance .902

Option B: Count 91, Average distance 82.04

Option C: Count 119, Average distance 84.99

Option D: Count 59, Average distance 1.009

Question 2 Answer:

Option A: Count 91, Average distance .902

<<insert your screenshot>>

Question 3: Buffer function

The leadership at the Baltimore Police Department would like to see how many crimes are committed one mile away from a police district building. Therefore, you will start with the Central District. Make a new worksheet, load the Central District data, click on the latitude

Note: Full answer to this question is available after purchase.

and longitude data points, and then click on show me to select a symbol map.

Go to the top menu bar under “Analysis,” and turn off “Aggregate Measures.” You should now have a map with many dots.

Create a calculated field called “Police Radius” with the following formula:

Alt text: Formula

IF [Type] == “Police Department”

THEN BUFFER(MAKEPOINT([Latitude], [Longitude]), 1, ‘mi’)

END

Drag the calculated fields, “Police Radius” and “Longitude,” into the Marks area. This should create a blue circle that is centered at the Central District headquarters (note: if there is no blue circle, then click on Map in the Marks area). You’ll see a large group of crimes in the northwest corner of the county that are more than 1 mile away from the headquarters.

Now, let’s look at the Eastern District. Create the same buffer map with a circle radius for the Eastern District. Change the radius to 1.5 miles in your calculated field.

Where is there a large group of crimes committed that are more than 1 mile away from the Eastern District police department? This is because there is only one police department and its averagely located far (1.5miles away) from the eastern parts.

Look at the buffer map (1.5 miles from the Eastern District police department). Which direction would police need to travel further to get to the crime scenes?

Option A: North

Option B: West

Option C: South

Option D: East

Question 3 Answer:

Option D: East

<<insert your screenshot>>

Question 4: Ad hoc custom areas

We are going to change topics and examine the San Francisco Sales Data source. This contains real estate data from San Francisco, California. In this scenario, you have been asked to help create sales territories for the real estate sales agents.

Create a new sheet in Tableau and load the data source.

Select the “Zip” and “Sale Price” measures, and click on the Filled map option in “Show Me.”

Alt text: Symbol map

In the Marks area, change the aggregation from Sum to Average for the sales price.

Alt text: region map

You will now create groups of zip codes based on locations on the map. You are going to make six areas. See the image below to see the six areas.

Alt text: region map

First, click on the top left menu on the map, and make sure you’re on the “rectangle selection” option (see the image below in yellow).

Alt text: rectangle selection

Now, you can start to draw rectangles around different areas. Below is how you selected the three zip codes in Area 1.

Alt text: Draw rectangles

Alt text: Drawing map

Once you have selected these three areas, hover over the area, and you will get a pop-up window (you might have to practice doing this to make sure you get the area selected correctly). In this case, the area is correct because you selected 3 items. Click on the paper clip icon (highlighted in yellow). This will allow you to create a group of the three zip codes.

Now, you will see that those three areas are a different color than the other zip code areas. Tableau automatically created a zip code group in your Marks area and added a color to that new field.

Alt text: drawing map

Now, finish the other 5 areas:

Alt text: color areas

Note that you need to pay close attention to the borders that are being highlighted. Areas 4 and 5 closely border each other, so be careful to make the bottom of the rectangle just above the area line.

Now, drag Sale Price onto the Label Mark, and change the aggregation from Sum to Average. Your map will look like the following:

Alt text: population

Tableau is calculating the average sales for each zip code in the group. But the real estate company wants to know the average for each of the six areas that you created. Now, drag “Zip” OUT of the Marks area.

You should now see the average for each of the six areas. Here is an example of Area 1:

Alt text: Population

What is the average for Area 6 (refer back to the map at the start of the question for reference)?

Option A: $1,300,960

Option B: $25,886,506,752

Option C: $1,556,667

Option D: $8,448,600

Question 4 Answer:

Option C: $1,556,667

<<insert your screenshot>

Question 5: Formatting

The real estate company is happy with the areas that have been created, and now they want to add more context for their real estate agents. Duplicate the worksheet you created in the last question and rename it “Areas with Streets.”

Go to the top menu, and select “Map,” then “Background Maps,” then “Streets.”

Alt text: Map menu

Your map should have changed from the default “Light” to a map that includes streets, highways, and city names.

Alt text: Map light

Next, you are going to explore the map. Change how you interact with your mouse by changing the menu from rectangle selection to “Pan.” This action lets you use your mouse to move around the map.

Alt text: pan

Now, you can click on an area and then double-click to zoom or click the plus sign.

Alt text: Plus sign

In the area that has the city of Woodside assigned to it, what is the average Sales Price?

Option A: $357,333

Option B: $1,056,075

Option C: $1,300,960

Option D: $1,556,667

Question 5 Answer:

Option D: $1,556,667

<<insert your screenshot>>

Question 6: Custom background

A university is trying to plan out the use of classroom space in their buildings. One of the concerns is that some more popular courses are outgrowing their assigned number of classrooms. They would like a quick method to visually see any classrooms that might have courses that are overcapacity. The university has provided the schedule of courses, which includes enrollment and the room capacities (C.2 University courses and room capacities). You will first use the worksheet titled “MWF 0930_1015.” The information on that worksheet is just the university’s Monday, Wednesday, Friday courses from 9:30 a.m. to 10:15 a.m. They’ve also provided an image that is the layout of the classrooms (University Classes Floor Plan). You have been asked to create a visualization that the university can use quickly to scan and find rooms that need to be changed. To create the visualization, you made a grid of the image on a 45×45 plot. The coordinates (X,Y) for each room are included in the data source.

First, create a new sheet, and load the data source. Create a calculated field called “Capacity status” with the following formula:

Alt text: capacity status

If [Student Enrollment]> [Room capacity] then “Over capacity”

Else “Within Capacity” END

Next, select the X and Y measures, and create a scatterplot (turn off Aggregate Measures) using the “Show Me” tab. This action creates a scatterplot of dots. Make sure X is in the columns and Y is in the rows (you might need to swap these yourself).

Alt text: marks

Now, drag the calculated field, “Capacity status,” over to Color in the Marks tab. Drag the “Student Enrollment” onto the Size Mark. Change the Marks type to circle to make them solid.

Alt text: data source

Now, you are ready to add our background map of the floor plan. Go to the Map menu item and select Background Images. Then select the data source you are working in: MWF 0930_1015, University Courses and Room Capacities. Click Add Image. Then find the image of the floor plan using the browse button.

Alt text: add image

Change the X field: Right to 45 and the Y field: Top to 45. This matches the plot you used to create the XY coordinates in the Excel document.

Alt text: add background

Alt text: background map

This looks great except that the capacity status dots are orange and blue. Because the background map is orange, it is difficult to quickly see. Therefore, you will change the color palette. Click on Color in the Marks area, then click edit. Change the “over capacity” status to red and the “within capacity” to blue. This makes the contrast easier to visualize. Let’s make the circles bigger. Click on Size in the Marks area and move the marker to halfway.

Alt text: rooms and sizes

The new circle sizes make it much easier to see the two rooms that are overcapacity: 1120 and 1109.

Now, the university likes this visualization so much that they would like you to create another for MWF 10:30–11:15 (included in your data source).

Which classroom is overcapacity on MWF, 10:30–11:15?

Answer:

Question 6 Answer:

1110

<<insert your screenshot>>

Order This Paper

Reviews

There are no reviews yet.

Be the first to review “(Order) Unit 6 Self-Check Assignment: Milligan, Chapter 12”

(Order) Unit 6 Self-Check Assignment: Milligan, Chapter 12

Unit 6 Self-Check Assignment: Milligan, Chapter 12

Unit 6 Self-Check Assignment: Milligan, Chapter 12

Reviews

Related products

[BUY] Unit 4 Assignment: Time Series

[BUY] LED410 Assignment 1: Team Conflict

[BUY] Assignment 1: Role of the Advanced Nurse Paper (24 points)

The House Painter Patient Evaluation & Management Plan: A 52-year-old male patient who is a house painter presents to the office reporting chronic fatigue and “mild” chest pain.