{"id":38034,"date":"2025-05-15T22:03:01","date_gmt":"2025-05-15T12:03:01","guid":{"rendered":"https:\/\/myassignmenthelp.info\/assignments\/?p=38034"},"modified":"2025-05-15T22:03:03","modified_gmt":"2025-05-15T12:03:03","slug":"self-check-assignment-1-milligan-chapter-1-2375403","status":"publish","type":"post","link":"https:\/\/myassignmenthelp.info\/assignments\/self-check-assignment-1-milligan-chapter-1-2375403\/","title":{"rendered":"Self-Check Assignment 1 Milligan Chapter 1-2375403"},"content":{"rendered":"<p><div class=\"ppw-restricted-content\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Welcome to your hands-on activity! &nbsp;This assignment allows you to work with Tableau using some of our real-world data sets. &nbsp;You will:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Download the attached spreadsheet and upload those data sets into Tableau.<\/li>\n\n\n\n<li>Go through this document and use Tableau to answer all the questions listed below. \u00a0\u00a0Where applicable, paste screenshots into the template below.<\/li>\n\n\n\n<li>When you are ready, complete the <strong>online quiz,<\/strong>\u00a0which verifies your homework. \u00a0Use the answers you found in this document to answer the questions.\u00a0\u00a0<\/li>\n\n\n\n<li>When you have completed the online quiz, submit the Word document.\u00a0<\/li>\n\n\n\n<li>Remember, you can always ask your instructor for help if needed.\u00a0\u00a0<\/li>\n\n\n\n<li>If you need to adjust the size of your visualizations to match the options in the questions, use the \u201cFormat\u201d-> \u201cCell size\u201d options.\u00a0 For example, \u201cCtrl+Shift+B\u201d on a Windows computer will make the visualization bigger, and \u201cCtrl+Up\u201d will make it taller.\u00a0<\/li>\n<\/ul>\n\n\n\n<p>The spreadsheet attached to this assignment contains two Excel datasets:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>U.S. State data.xlsx<\/li>\n\n\n\n<li>2022 NYC Restaurant Inspections.xlsx<\/li>\n<\/ol>\n\n\n\n<p>**Save your Tableau file as Chapter 1, you will reuse some of the visualizations in later assignments**<\/p>\n\n\n\n<p><strong>Analyze the US State Data Set<\/strong><strong><\/strong><\/p>\n\n\n\n<p>To begin,<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>First download both the US State and the NYC Restaurant data files from your LEO classroom to your computer.<\/li>\n\n\n\n<li>Launch Tableau and select an Excel file. \u00a0<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-108.png\"><img loading=\"lazy\" decoding=\"async\" width=\"366\" height=\"360\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-108.png\" alt=\"\" class=\"wp-image-38035\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-108.png 366w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-108-300x295.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/a><\/figure>\n\n\n\n<p>Open the US State Data.xlsx Excel file. \u00a0\u00a0You should see the data as follows, and be able to verify the Alabama population is 5,074,296.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-109.png\"><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"397\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-109.png\" alt=\"\" class=\"wp-image-38036\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-109.png 573w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-109-300x208.png 300w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-109-135x93.png 135w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><\/figure>\n\n\n\n<p>You can now click the \u201cSheet 1\u201d tab on the bottom toolbar to create your visualizations. You should create a new worksheet for each question.<\/p>\n\n\n\n<p>Before we jump into building visualizations, let\u2019s look at the data we have loaded. Under the tables area, you should see all the fields in the dataset.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-110.png\"><img loading=\"lazy\" decoding=\"async\" width=\"216\" height=\"301\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-110.png\" alt=\"\" class=\"wp-image-38037\"\/><\/a><\/figure>\n\n\n\n<p>After you have looked carefully at them, answer these questions about the nature of the data we are looking at. As you can see, this is basic information about the states in the United States, including the date it was admitted, the region, the result of the 2020 presidential election, the name, the number of counties, and the population in 2022. Tableau generated latitude and longitude coordinates. The \u201cSheet1 (Count)\u201d and \u201cMeasure Values\u201d are also generated by Tableau. Often, we use these to help us do simple counts on data.<\/p>\n\n\n\n<p><strong>Question 1 \u2013 Measures and dimensions<\/strong><strong><\/strong><\/p>\n\n\n\n<p>In the U.S. States data set, which one of these fields is a measure?<\/p>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>State Name<\/li>\n\n\n\n<li>Population<\/li>\n\n\n\n<li>Date of admission<\/li>\n\n\n\n<li>Region<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 1 Answer: <\/strong><strong><\/strong><\/td><td>B. Population<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 2 \u2013 Discrete and continuous fields<\/strong><strong><\/strong><\/p>\n\n\n\n<p>Which of these fields is continuous in the U.S. States data set?<\/p>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>State name<\/li>\n\n\n\n<li>Population<\/li>\n\n\n\n<li>Date of admission<\/li>\n\n\n\n<li>Region<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 2 Answer:<\/strong><strong><\/strong><\/td><td>B. Population<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 3 \u2013 Bar charts<\/strong><strong><\/strong><\/p>\n\n\n\n<p>For your first visualization, you will create a stacked bar chart. Drag the \u201cregion\u201d field into columns and the \u201cPopulation (2022)\u201d field into rows. You\u2019ll notice that Tableau automatically aggregated the population and created a sum or total of the population. This is fine for now; as you learn more about Tableau, you will learn when using the default aggregations is inappropriate.<\/p>\n\n\n\n<p>Next, add \u201cResult in the 2020 presidential election\u201d to the color area under the Marks setting. You should now have a stacked bar chart.<\/p>\n\n\n\n<p><strong>Question 3 \u2013 Which region had the closest divide between the 2020 Presidential Election results?<\/strong><strong><\/strong><\/p>\n\n\n\n<p>A. Midwest<\/p>\n\n\n\n<p>B. Northeast<\/p>\n\n\n\n<p>C. South<\/p>\n\n\n\n<p>D. West<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 3 Answer:<\/strong><strong><\/strong><\/td><td>A. Midwest<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-111.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"388\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-111.png\" alt=\"\" class=\"wp-image-38038\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-111.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-111-300x187.png 300w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-111-348x215.png 348w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 4 \u2013 Density maps<\/strong><strong><\/strong><\/p>\n\n\n\n<p>We are going to create a map using the U.S. State data. First, ensure that Tableau recognizes the \u201cState Name\u201d as geographic data. You should see a little globe next to the State Name, and you should also have latitude and longitude in your dataset (notice that Tableau automatically added this; it wasn\u2019t in the original dataset).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-112.png\"><img loading=\"lazy\" decoding=\"async\" width=\"281\" height=\"346\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-112.png\" alt=\"\" class=\"wp-image-38039\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-112.png 281w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-112-244x300.png 244w\" sizes=\"auto, (max-width: 281px) 100vw, 281px\" \/><\/a><\/figure>\n\n\n\n<p>At the bottom, click on the \u201c+ Worksheet\u201d to make a new Sheet, Sheet2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-113.png\"><img loading=\"lazy\" decoding=\"async\" width=\"287\" height=\"551\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-113.png\" alt=\"\" class=\"wp-image-38040\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-113.png 287w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-113-156x300.png 156w\" sizes=\"auto, (max-width: 287px) 100vw, 287px\" \/><\/a><\/figure>\n\n\n\n<p>Go to Sheet 2. &nbsp;<\/p>\n\n\n\n<p>Drag \u201cState name\u201d onto your canvas. Tableau should automatically create a symbol map for you, with a dot on each state.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-114.png\"><img loading=\"lazy\" decoding=\"async\" width=\"421\" height=\"252\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-114.png\" alt=\"\" class=\"wp-image-38041\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-114.png 421w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-114-300x180.png 300w\" sizes=\"auto, (max-width: 421px) 100vw, 421px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-115.png\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"258\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-115.png\" alt=\"\" class=\"wp-image-38042\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-115.png 420w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-115-300x184.png 300w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-115-348x215.png 348w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/a><\/figure>\n\n\n\n<p>Next, add \u201c# of Counties\u201d field onto color and you should immediately see a density map.<\/p>\n\n\n\n<p><strong>Question 4 \u2013 &nbsp;For the state with the highest number of counties, how many counties does it have?<\/strong><strong><\/strong><\/p>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>58<\/li>\n\n\n\n<li>254<\/li>\n\n\n\n<li>120<\/li>\n\n\n\n<li>313<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 4 Answer:<\/strong><strong><\/strong><\/td><td>B. 254<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-116.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"389\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-116.png\" alt=\"\" class=\"wp-image-38043\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-116.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-116-300x187.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Analyze the NYC Restaurant Data Set<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>Question 5 \u2013 Line chart<\/strong><strong><\/strong><\/p>\n\n\n\n<p>Now, we will look at the other data set: &nbsp;2022 NYC Restaurant inspections. This dataset is all about the health inspections of restaurants in New York City. &nbsp;<\/p>\n\n\n\n<p>We will keep the US State data source open, and add to it the NYC Restaurant data source. &nbsp;<\/p>\n\n\n\n<p>Go to the Data tab at the top and choose \u201cNew Data Source\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-117.png\"><img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"346\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-117.png\" alt=\"\" class=\"wp-image-38044\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-117.png 396w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-117-300x262.png 300w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/a><\/figure>\n\n\n\n<p>Connect to the Excel file which is the 2022 NYC Restaurant Inspections data. \u00a0You should see the following as a confirmation that Tableau was able to open our restaurant data source. \u00a0Note the \u201cA FEI CHINESE RESTAURANT\u201d should appear in the right bottom.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-118.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"500\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-118.png\" alt=\"\" class=\"wp-image-38045\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-118.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-118-300x240.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>When restaurants have violations, they receive scores for each violation. So, restaurants want low scores, and high scores are not desirable. Grades A-C are assigned to restaurants based on their scores. &nbsp;For restaurants with scores of 0 to 13, they receive an \u201cA\u201d. If they score between 14-27, they receive a \u201cB\u201d. A \u201cC\u201d grade is 28 or more. If you would like to read more, check out <a href=\"#!\/faq\"><u>https:\/\/a816-health.nyc.gov\/ABCEatsRestaurants\/#!\/faq<\/u><\/a>.<\/p>\n\n\n\n<p>Let\u2019s make a new worksheet (ours is called Sheet3). &nbsp;Note the Data will now have two options in it \u2013 our State data and our new Restaurant data. &nbsp;Make sure you choose the restaurant data set and can see data items like Cuisine Description.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-119.png\"><img loading=\"lazy\" decoding=\"async\" width=\"375\" height=\"336\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-119.png\" alt=\"\" class=\"wp-image-38046\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-119.png 375w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-119-300x269.png 300w\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" \/><\/a><\/figure>\n\n\n\n<p>Look through the dataset at the fields; what are the dimensions and measures?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-120.png\"><img loading=\"lazy\" decoding=\"async\" width=\"243\" height=\"397\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-120.png\" alt=\"\" class=\"wp-image-38047\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-120.png 243w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-120-184x300.png 184w\" sizes=\"auto, (max-width: 243px) 100vw, 243px\" \/><\/a><\/figure>\n\n\n\n<p>We now assume you are in a new worksheet with the restaurant data active. &nbsp;<\/p>\n\n\n\n<p>We will create a line chart of the change in score throughout the year. To do this, drag \u201cInspection Date\u201d into the columns (we always have time on the x-axis) and then drag \u201cScore\u201d into the Rows (y-axis). You will see that the date defaults to \u201cYear,\u201d and Tableau, by default, totaled the sum of the scores. This is not a helpful chart. Change the Date to \u201cWeek Number\u201d, and you will now see a line graph.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-121.png\"><img loading=\"lazy\" decoding=\"async\" width=\"264\" height=\"336\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-121.png\" alt=\"\" class=\"wp-image-38048\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-121.png 264w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-121-236x300.png 236w\" sizes=\"auto, (max-width: 264px) 100vw, 264px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-122.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"369\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-122.png\" alt=\"\" class=\"wp-image-38049\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-122.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-122-300x177.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>But if you look at the Score field in rows, you\u2019ll notice it is totaling the scores of the inspections, but it makes more sense to look for average. So, change the Row Measure calculation to Average by clicking on the down arrow.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-123.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"443\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-123.png\" alt=\"\" class=\"wp-image-38050\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-123.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-123-300x213.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 5 \u2013 Is there any obvious pattern of average score behavior over time?<\/strong><strong><\/strong><\/p>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>Yes \u2013 there is an easy pattern to determine<\/li>\n\n\n\n<li>No &#8212; there is no obvious pattern<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-124.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"391\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-124.png\" alt=\"\" class=\"wp-image-38051\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-124.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-124-300x188.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-126.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"391\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-126.png\" alt=\"\" class=\"wp-image-38053\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-126.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-126-300x188.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 6 \u2013 Trendlines<\/strong><strong><\/strong><\/p>\n\n\n\n<p>Let\u2019s see if we can find any trend in the data. Click on the Analytics tab, select Trend Line, and drag it onto the graph. Select \u201cLinear\u201d to create a linear trendline.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-127.png\"><img loading=\"lazy\" decoding=\"async\" width=\"102\" height=\"202\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-127.png\" alt=\"\" class=\"wp-image-38054\"\/><\/a><\/figure>\n\n\n\n<p>Now, you should have your original line chart with the dotted trend line on top.<\/p>\n\n\n\n<p><strong>Question 6-<\/strong>&nbsp;<strong>Now that you have a trendline, how would you describe your findings? Hint: what does a score represent?<\/strong><strong><\/strong><\/p>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>Restaurant inspection scores are getting better over time.<\/li>\n\n\n\n<li>Restaurant inspection scores are getting worse over time.<\/li>\n\n\n\n<li>Both of these<\/li>\n\n\n\n<li>Neither of these<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 6 Answer:<\/strong><strong><\/strong><\/td><td>B. Restaurant inspection scores are getting worse over time<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 7- Show me<\/strong><strong><\/strong><\/p>\n\n\n\n<p>A helpful feature in Tableau is the \u201cShow Me\u201d. When you select fields, Tableau will automatically make recommendations using this feature to guide you. Let\u2019s practice by creating a tree map of New York City Restaurant Inspections. &nbsp;Click on the following fields and hold down the control button to make sure they are all active: \u201cBoro\u201d, \u201cGrade\u201d, and \u201cSheet1 (Count)\u201d. &nbsp;Click on the icon of the TreeMap. Notice that Tableau is telling you how many dimensions and measures you need for each visualization type.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-128.png\"><img loading=\"lazy\" decoding=\"async\" width=\"162\" height=\"403\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-128.png\" alt=\"\" class=\"wp-image-38055\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-128.png 162w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-128-121x300.png 121w\" sizes=\"auto, (max-width: 162px) 100vw, 162px\" \/><\/a><\/figure>\n\n\n\n<p>Drag \u201cGrade\u201d into the filters and ONLY select A, B, and C.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-129.png\"><img loading=\"lazy\" decoding=\"async\" width=\"257\" height=\"361\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-129.png\" alt=\"\" class=\"wp-image-38056\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-129.png 257w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-129-214x300.png 214w\" sizes=\"auto, (max-width: 257px) 100vw, 257px\" \/><\/a><\/figure>\n\n\n\n<p>Drag the \u201cSheet1(Count)\u201d field onto Label.<\/p>\n\n\n\n<p>You should now have a tree map of the NYC Restaurants Inspections that were A, B, or C for each of the boros.<\/p>\n\n\n\n<p>Question 7 \u2013 Which boro had the most \u201cA\u201d grades?<\/p>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>Bronx<\/li>\n\n\n\n<li>Brooklyn<\/li>\n\n\n\n<li>Manhattan<\/li>\n\n\n\n<li>Queens<\/li>\n\n\n\n<li>Staten Island<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 7 Answer:<\/strong><strong><\/strong><\/td><td>C. Manhattan<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-130.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"389\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-130.png\" alt=\"\" class=\"wp-image-38057\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-130.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-130-300x187.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 8 \u2013 Dashboards<\/strong><strong><\/strong><\/p>\n\n\n\n<p>If you created the dashboard below, which of the following could be added to this dashboard? Choose all that apply.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-131.png\"><img loading=\"lazy\" decoding=\"async\" width=\"527\" height=\"419\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-131.png\" alt=\"\" class=\"wp-image-38058\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-131.png 527w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-131-300x239.png 300w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/a><\/figure>\n\n\n\n<ol style=\"list-style-type:upper-alpha\" class=\"wp-block-list\">\n<li>Legends for Questions 6 and 7<\/li>\n\n\n\n<li>A text box for Question 6<\/li>\n\n\n\n<li>A title for the Dashboard<\/li>\n\n\n\n<li>None of these can be added to the dashboard.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 8 Answer:<\/strong><strong><\/strong><\/td><td>A, B, and C: All of these elements can be added to the dashboard.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<p><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[359],"tags":[],"class_list":["post-38034","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts\/38034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/comments?post=38034"}],"version-history":[{"count":1,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts\/38034\/revisions"}],"predecessor-version":[{"id":38059,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts\/38034\/revisions\/38059"}],"wp:attachment":[{"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/media?parent=38034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/categories?post=38034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/tags?post=38034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}