{"id":37969,"date":"2025-05-15T15:28:44","date_gmt":"2025-05-15T05:28:44","guid":{"rendered":"https:\/\/myassignmenthelp.info\/assignments\/?p=37969"},"modified":"2025-05-15T15:28:46","modified_gmt":"2025-05-15T05:28:46","slug":"self-check-assignment-milligan-2375411","status":"publish","type":"post","link":"https:\/\/myassignmenthelp.info\/assignments\/self-check-assignment-milligan-2375411\/","title":{"rendered":"Self Check Assignment: Milligan-2375411"},"content":{"rendered":"<p><div class=\"ppw-restricted-content\"><\/p>\n\n\n\n<p>Welcome to your hands-on activity! This assignment invites you to work with Tableau using a mix of generated and real-world data. You will follow these steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Download the attached spreadsheets, and upload those data sets into Tableau. If you need help loading your data sources, refer to the <strong>Unit 1 Self Check Assignment: Milligan Chapter 1<\/strong><\/li>\n\n\n\n<li>Go through this document, and use Tableau to answer all the questions listed below. Where 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. Use the answers you found in this document to answer the questions.<\/li>\n\n\n\n<li>When you have completed the online quiz, submit the Word document.<\/li>\n\n\n\n<li>Remember, you can always ask your instructor for help if needed.<\/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. For example, \u201cCtrl+Shift+B\u201d on a Windows computer will make the visualization bigger, and \u201cCtrl+Up\u201d will make it taller.<\/li>\n<\/ul>\n\n\n\n<p>This assignment contains 7 datasets and 6 icon files:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Pacific West National Park Visitation 2001\u20132022<\/li>\n\n\n\n<li>Monthly Personal Budget (two worksheets: July and August)<\/li>\n\n\n\n<li>Video game sales<\/li>\n\n\n\n<li>2022 NYC Restaurant Inspections<\/li>\n\n\n\n<li>September 2023 Baltimore City Crime Data<\/li>\n\n\n\n<li>University course completion rates<\/li>\n\n\n\n<li>University pass rates<\/li>\n\n\n\n<li>Icon files:<ol><li>Biology<\/li><\/ol><ol><li>Chemistry<\/li><\/ol><ol><li>Computer Programming<\/li><\/ol><ol><li>Data Analytics<\/li><\/ol><ol><li>Math<\/li><\/ol>\n<ol class=\"wp-block-list\">\n<li>Physics<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>Question 1: Bump chart<\/strong><strong><\/strong><\/p>\n\n\n\n<p>You have been asked to help the Northwest National Park system to find trends. Specifically, what do five-year visitation trends look like for the parks? Load the Pacific West National Park Visitation 2001\u20132022 into your data sources. Drag \u201cYear\u201d into the columns and create an ad hoc calculation in the row: SUM (Visitor Count). Then drag \u201cPark Type.\u201d Select <strong>only<\/strong>&nbsp;the \u201cNational Park\u201d park type. Then, drag \u201cYear\u201d into the filters for the years 2018\u20132022. Keep in mind that the year 2020 will have anomalies due to the COVID-19 pandemic shutdown of many parks. Drag \u201cPark Name\u201d onto \u201cColor\u201d in the \u201cMarks\u201d tab and \u201cPark Name\u201d onto \u201cLabel.\u201d Make sure the marks type is set to \u201cLine.\u201d Edit the label so that it shows the \u201cLine Ends.\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-55.png\"><img loading=\"lazy\" decoding=\"async\" width=\"198\" height=\"229\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-55.png\" alt=\"\" class=\"wp-image-37970\"\/><\/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-56.png\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"332\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-56.png\" alt=\"\" class=\"wp-image-37971\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-56.png 557w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-56-300x179.png 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/a><\/figure>\n\n\n\n<p>From this chart, we can see that Yosemite, Olympic, and Death Valley all had [missing word], but they took downturns in 2020. They are rising again, but still not seeing the numbers they had previously. Joshua Tree, Mount Rainier, Hawaii Volcanoes, and Haleakala NP have increased visitors in 2022 compared to 2018.<\/p>\n\n\n\n<p>While this is helpful, the leadership has requested to see a chart with 10 years (2013\u20132022). They also want to see only national parks with at least 1 million visitors annually. Add both filters to your bump chart. Add Visitor Count as a Label.<\/p>\n\n\n\n<p><strong>Question 1A: For the Yosemite NP, was there an increase or decrease between 2013 and 2022?<\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-57.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"308\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-57.png\" alt=\"\" class=\"wp-image-37972\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-57.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-57-300x148.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 1B: What was the highest visitor count for Yosemite NP between 2013 and 2022?<\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 1B Answer:<\/strong><strong><\/strong><\/td><td>It was 5,028,868<\/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-58.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"327\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-58.png\" alt=\"\" class=\"wp-image-37973\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-58.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-58-300x157.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 2: Waterfall <\/strong><strong><em><strong><em><\/em><\/strong><\/em><\/strong><\/p>\n\n\n\n<p>Your friend is always complaining to you that they can\u2019t save any money and their bank account is always going down. You ask your friend to write down all the expenses and income in a month, and you record them in the Monthly Personal Budget: July. For each expense, you have tracked the date, type, whether it is income, fixed, or discretionary, and the amount (negative for expenses and positive for income).<\/p>\n\n\n\n<p>Load the dataset into Tableau and choose the July worksheet to start. Create a waterfall chart of the July data by dragging the \u201cIncome\/Fixed\/Discretionary\u201d and \u201cType\u201d dimensions into the columns. Then drag \u201cAmount\u201d into the rows. Because we want to see the total as the month goes on, we will create a running total calculation using <em>table across<\/em>. To do this, first, right-click \u201cAmount\u201d and select \u201cAdd Table Calculation\u2026\u201d. This should bring up the following<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-59.png\"><img loading=\"lazy\" decoding=\"async\" width=\"289\" height=\"362\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-59.png\" alt=\"\" class=\"wp-image-37974\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-59.png 289w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-59-240x300.png 240w\" sizes=\"auto, (max-width: 289px) 100vw, 289px\" \/><\/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-60.png\"><img loading=\"lazy\" decoding=\"async\" width=\"214\" height=\"330\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-60.png\" alt=\"\" class=\"wp-image-37975\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-60.png 214w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-60-195x300.png 195w\" sizes=\"auto, (max-width: 214px) 100vw, 214px\" \/><\/a><\/figure>\n\n\n\n<p>Drag the \u201cAmount\u201d measure onto Color, Size, and Label in the Marks tab.<\/p>\n\n\n\n<p>Change the chart type to \u201cGantt Bar.\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-61.png\"><img loading=\"lazy\" decoding=\"async\" width=\"188\" height=\"299\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-61.png\" alt=\"\" class=\"wp-image-37976\"\/><\/a><\/figure>\n\n\n\n<p>Double-click on \u201cSUM(Amount)\u201d on Size and edit in the shelf. Add a negative sign before the SUM([Amount]).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-62.png\"><img loading=\"lazy\" decoding=\"async\" width=\"201\" height=\"315\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-62.png\" alt=\"\" class=\"wp-image-37977\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-62.png 201w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-62-191x300.png 191w\" sizes=\"auto, (max-width: 201px) 100vw, 201px\" \/><\/a><\/figure>\n\n\n\n<p><p class=\"MsoNormal\" style=\"padding:0pt 0pt 0pt 0pt ;\"><span style=\"mso-spacerun:'yes';font-family:Calibri;font-size:11.0000pt;\">Change the \u201cSUM(Amount)\u201d on Label to be a Running Total. <\/span><span style=\"mso-spacerun:'yes';font-family:Calibri;font-size:11.0000pt;\"><\/span><\/p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-63.png\"><img loading=\"lazy\" decoding=\"async\" width=\"282\" height=\"359\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-63.png\" alt=\"\" class=\"wp-image-37978\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-63.png 282w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-63-236x300.png 236w\" sizes=\"auto, (max-width: 282px) 100vw, 282px\" \/><\/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-64.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"533\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-64.png\" alt=\"\" class=\"wp-image-37979\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-64.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-64-300x256.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>Now, we can see quickly that your friend spent $794 in the month of July just on discretionary spending. Then by the time they paid their rent, they had spent a total of $4,960 for the month. They make $4,140 from their regular job and another $805 from side gigs. This means that in July, your friend overspent their monthly income by $15 dollars. If they spend like that every month, that means they are overspending $180 a year.<\/p>\n\n\n\n<p>Your friend would really like to start saving money, so you help them go through expenses and try to spend less money. Now, they return with their August expenses (another worksheet in the Monthly Personal Budget), and they want to see the same chart.<\/p>\n\n\n\n<p><strong>Question 2: How much money did your friend save this month? Provide your answer rounded to the nearest dollar (no cents). <\/strong><strong><\/strong><\/p>\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>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>&lt;&lt;insert your screenshot&gt;&gt;<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>Question 3: Step lines<\/strong><\/p>\n\n\n\n<p>For this exercise, you will be using the \u201cVideo game sales\u201d data set to answer questions about how certain genres have performed by global sales in the last five years.<\/p>\n\n\n\n<p>Drag \u201cGenre\u201d over to Columns and \u201cGlobal Sales\u201d into Rows. Add a quick calculation of Running Total to the \u201cGlobal Sales.\u201d<\/p>\n\n\n\n<p>Drag \u201cGlobal Sales\u201d onto Color in the Marks tab.<\/p>\n\n\n\n<p>Filter by Years 2011 to 2016.<\/p>\n\n\n\n<p>Change the Marks type to \u201cLine,\u201d and then click on \u201cPath\u201d and choose \u201cStep.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-65.png\"><img loading=\"lazy\" decoding=\"async\" width=\"263\" height=\"340\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-65.png\" alt=\"\" class=\"wp-image-37980\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-65.png 263w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-65-232x300.png 232w\" sizes=\"auto, (max-width: 263px) 100vw, 263px\" \/><\/a><\/figure>\n\n\n\n<p>Click on <em>Ctrl+Shift+B<\/em>\u00a0(or <em>CMD+Shift+B<\/em>\u00a0if you\u2019re on a Mac) a few times to make the graph wider (this might help to read the bottom axis better).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-66.png\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"445\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-66.png\" alt=\"\" class=\"wp-image-37981\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-66.png 369w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-66-249x300.png 249w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><\/a><\/figure>\n\n\n\n<p>We can see that <strong>shooter games<\/strong>&nbsp;had a significant step within global sales between 2011 and 2016.<\/p>\n\n\n\n<p>However, we can see that action starts around $140. Let\u2019s modify this a bit.<\/p>\n\n\n\n<p>Right-click on \u201cGenre\u201d in the columns area, click on the \u201cSort\u201d function. We want to sort by Field, Ascending, Field Name-Global Sales, and Aggregation type: Sum.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-67.png\"><img loading=\"lazy\" decoding=\"async\" width=\"196\" height=\"236\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-67.png\" alt=\"\" class=\"wp-image-37982\"\/><\/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-68.png\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"523\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-68.png\" alt=\"\" class=\"wp-image-37983\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-68.png 487w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-68-279x300.png 279w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/a><\/figure>\n\n\n\n<p>Now, we can see where the calculation starts in the bottom left corner with <em>Fighting<\/em>&nbsp;and slowly steps up until we get to <em>Action<\/em>&nbsp;and then <em>Shooter<\/em>&nbsp;games, where we see two big jumps. This is a better representation of the step-line chart.<\/p>\n\n\n\n<p>Now, change the years to 2006\u20132010.<\/p>\n\n\n\n<p><strong>Question 3: What is the top-selling genre? What was the amount of global sales for that genre? <\/strong><strong><\/strong><\/p>\n\n\n\n<p>Option A: Role-playing, 316.1<\/p>\n\n\n\n<p>Option B: Shooter, 899.3<\/p>\n\n\n\n<p>Option C: Action, 437.4<\/p>\n\n\n\n<p>Option D: Sports, 209.4<\/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>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>&lt;&lt;insert your screenshot&gt;&gt;<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>Question 4: Sparklines <\/strong><strong><\/strong><\/p>\n\n\n\n<p>You are being asked to find trends about the New York City Health Department Restaurant Inspections. There are over 27,0000 restaurants in the five boroughs of New York City. You need to load the data source: 2022 NYC Restaurant Inspections. This is a rather large data source and may take a little longer to load the data.<\/p>\n\n\n\n<p>When restaurants have violations, they receive scores for each violation. Therefore, restaurants want low scores, and high scores are not desirable. Grades A\u2013C are assigned to restaurants based on their scores. Restaurants with scores of 0 to 13 receive an \u201cA.\u201d If they score between 14 and 27, they receive a \u201cB.\u201d A \u201cC\u201d grade is 28 or more. If you would like to read more, see <a href=\"#!\/faq\">ABCEats<u>-Restaurants<\/u><\/a>.<\/p>\n\n\n\n<p>Drag \u201cInspection Date\u201d into columns and \u201cBoro\u201d into rows. Now pull \u201cScore\u201d into the row, and change the aggregation to \u201cAverage\u201d instead of sum. Change the date from \u201dYear\u201d to \u201dWeek Number\u201d (right-click on the inspection date field in columns).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-69.png\"><img loading=\"lazy\" decoding=\"async\" width=\"168\" height=\"395\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-69.png\" alt=\"\" class=\"wp-image-37984\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-69.png 168w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-69-128x300.png 128w\" sizes=\"auto, (max-width: 168px) 100vw, 168px\" \/><\/a><\/figure>\n\n\n\n<p>Right-click in the line graph area, and click on format. Then click on the Lines icon, and turn off the gridlines.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-70.png\"><img loading=\"lazy\" decoding=\"async\" width=\"198\" height=\"290\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-70.png\" alt=\"\" class=\"wp-image-37985\"\/><\/a><\/figure>\n\n\n\n<p>Widen the \u201cBoro\u201d column to make it easier to read the names of each borough.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-71.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"380\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-71.png\" alt=\"\" class=\"wp-image-37986\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-71.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-71-300x183.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>We can see that this is very sporadic data that doesn\u2019t really show a clear pattern. Add \u201cGrade\u201d to the<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-72.png\"><img loading=\"lazy\" decoding=\"async\" width=\"174\" height=\"243\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-72.png\" alt=\"\" class=\"wp-image-37987\"\/><\/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-73.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"343\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-73.png\" alt=\"\" class=\"wp-image-37988\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-73.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-73-300x165.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 4a: Based on these sparklines, which grade (A, B, or C) has a steady average score throughout the year for each borough (boro)?<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>A<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>B<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>C<\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 4A Answer:<\/strong><strong><\/strong><\/td><td>A<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 4b: Using the sparklines, which grade had the biggest average swings (increases and decreases) over the year?<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>A<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>B<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>C<\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 4B Answer:<\/strong><strong><\/strong><\/td><td>C<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 5: Dumbbell<\/strong><strong><\/strong><\/p>\n\n\n\n<p>In this exercise, you will look for crime patterns in the City of Baltimore that occur inside versus outside. To do this, we will use the dumbbell method. First, load the data source: September 2023 Baltimore City Crime Data: All Districts into Tableau, and start a new worksheet.<\/p>\n\n\n\n<p>Drag the \u201cAll districts (Count)\u201d measure into columns. Repeat this again (you will have two next to each other). Now drag \u201cDistrict\u201d into the rows. Move \u201cInside Outside\u201d into filters, and choose \u201cInside and Outside.\u201d<\/p>\n\n\n\n<p>Right-click on the \u201cCNT(All Districts)\u201d column on the right, and select \u201cDual Axis.\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-74.png\"><img loading=\"lazy\" decoding=\"async\" width=\"140\" height=\"231\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-74.png\" alt=\"\" class=\"wp-image-37989\"\/><\/a><\/figure>\n\n\n\n<p>In the Marks area, change the first CNT(All Districts) to be a line. Drag \u201cInside Outside\u201d onto the path marks area.<\/p>\n\n\n\n<p>Make sure the second CNT(All Districts) mark is a circle. Now, drag \u201cInside Outside\u201d onto the color inside that Marks menu.<\/p>\n\n\n\n<p>You should have dumbbells that look like the following image:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-75.png\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"184\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-75.png\" alt=\"\" class=\"wp-image-37990\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-75.png 570w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-75-300x97.png 300w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 5: Which district has a different pattern of inside crimes versus outside crimes compared to the other districts?<\/strong><strong><\/strong><\/p>\n\n\n\n<p>Option A: Central<\/p>\n\n\n\n<p>Option B: Northeastern<\/p>\n\n\n\n<p>Option C: Western<\/p>\n\n\n\n<p>Option D: Southwestern<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 5 Answer:<\/strong><strong><\/strong><\/td><td>D: Southwestern<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 6: Unit\/symbol<\/strong><strong><\/strong><\/p>\n\n\n\n<p>We will be analyzing enrollment versus room capacity for a university. Load the dataset <em>University courses and completion rates<\/em>. Create a scatterplot by dragging \u201cStudent enrollment\u201d and \u201cStudent Completed\u201d onto columns and rows.<\/p>\n\n\n\n<p>Now, we are going to make groups for each subject. Right-click on the \u201cCourse Number\u201d dimension, &nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-76.png\"><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"269\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-76.png\" alt=\"\" class=\"wp-image-37991\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-76.png 514w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-76-300x157.png 300w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\" \/><\/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-77.png\"><img loading=\"lazy\" decoding=\"async\" width=\"475\" height=\"432\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-77.png\" alt=\"\" class=\"wp-image-37992\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-77.png 475w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-77-300x273.png 300w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/><\/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-78.png\"><img loading=\"lazy\" decoding=\"async\" width=\"569\" height=\"516\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-78.png\" alt=\"\" class=\"wp-image-37993\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-78.png 569w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-78-300x272.png 300w\" sizes=\"auto, (max-width: 569px) 100vw, 569px\" \/><\/a><\/figure>\n\n\n\n<p>Now, drag that new field, \u201cSubjects,\u201d onto the \u201cShapes\u201d mark.<\/p>\n\n\n\n<p>We get a scatterplot that looks like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-79.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"394\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-79.png\" alt=\"\" class=\"wp-image-37994\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-79.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-79-300x189.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>The problem is that our user has to look at the legend on the right to know what the subjects are. Let\u2019s eliminate this problem by adding icons to make it easier for the user to read our graph.<\/p>\n\n\n\n<p>Download the six icon image files that were provided to you in the assignment. You need to save them into your Tableau Repository file.<\/p>\n\n\n\n<p>To find out where that file is, go under File -&gt;Repository Location<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-80.png\"><img loading=\"lazy\" decoding=\"async\" width=\"167\" height=\"249\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-80.png\" alt=\"\" class=\"wp-image-37995\"\/><\/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-81.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"116\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-81.png\" alt=\"\" class=\"wp-image-37996\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-81.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-81-300x56.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>Make a note of the location where your Tableau Repository is located. In the image above, it is located in \u201cDocuments.\u201d Go to the location of your Tableau Repository, and create a new folder called \u201cUniversity subjects.\u201d Then copy and paste the six images provided to you into this folder.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-82.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"170\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-82.png\" alt=\"\" class=\"wp-image-37997\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-82.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-82-300x82.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-83.png\"><img loading=\"lazy\" decoding=\"async\" width=\"569\" height=\"468\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-83.png\" alt=\"\" class=\"wp-image-37998\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-83.png 569w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-83-300x247.png 300w\" sizes=\"auto, (max-width: 569px) 100vw, 569px\" \/><\/a><\/figure>\n\n\n\n<p>Change the Shape Palette from Default to University subjects. If you don\u2019t see the shapes, click on \u201cReload Shapes.\u201d<br>\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-84.png\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"475\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-84.png\" alt=\"\" class=\"wp-image-37999\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-84.png 577w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-84-300x247.png 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/a><\/figure>\n\n\n\n<p>Now, you will assign the data item on the left to the appropriate icon on the right. They are both in alphabetical order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-85.png\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"475\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-85.png\" alt=\"\" class=\"wp-image-38000\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-85.png 577w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-85-300x247.png 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/a><\/figure>\n\n\n\n<p>Click \u201cApply\u201d when you are finished.<\/p>\n\n\n\n<p>Your scatterplot probably has very small icons now:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-86.png\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"503\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-86.png\" alt=\"\" class=\"wp-image-38001\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-86.png 495w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-86-295x300.png 295w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/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-87.png\"><img loading=\"lazy\" decoding=\"async\" width=\"212\" height=\"212\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-87.png\" alt=\"\" class=\"wp-image-38002\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-87.png 212w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-87-150x150.png 150w\" sizes=\"auto, (max-width: 212px) 100vw, 212px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Question 6: Which subject has the lowest number of students enrolled and courses completed?<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>A: Math<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>B: Computer Science<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>C: Data Analytics<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>D: Physics<\/strong><strong><\/strong><\/p>\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>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 7: Marimekko <\/strong><strong><\/strong><\/p>\n\n\n\n<p>The University we have been working with has asked for an analysis of the student pass\/fail rates by major\/nonmajor within six departments. Load the dataset: University pass rates.<\/p>\n\n\n\n<p>Drag \u201cDepartment,\u201d \u201cMajor\/NonMajor,\u201d and \u201cPass\/Fail\u201d into rows. Drag \u201cStudents\u201d onto the Label. You should see a simple table.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-88.png\"><img loading=\"lazy\" decoding=\"async\" width=\"581\" height=\"464\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-88.png\" alt=\"\" class=\"wp-image-38003\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-88.png 581w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-88-300x240.png 300w\" sizes=\"auto, (max-width: 581px) 100vw, 581px\" \/><\/a><\/figure>\n\n\n\n<p>If we want to create a visualization across the three dimensions, we can create a Marimekko chart.<\/p>\n\n\n\n<p>We need to create two calculated fields that will help us to get the right level of detail calculation for this analysis:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u201cStudents per column\u201d Syntax: {EXCLUDE [Pass\/Fail]: SUM([Students])}<\/li>\n\n\n\n<li>\u201c# of students\u201d Syntax:<\/li>\n<\/ol>\n\n\n\n<p>IF FIRST()==0 THEN<\/p>\n\n\n\n<p>MIN([Students per column])<\/p>\n\n\n\n<p>ELSEIF MIN([Department]) != LOOKUP(MIN([Department]),-1) THEN<\/p>\n\n\n\n<p>PREVIOUS_VALUE(0) + MIN([Students per column])<\/p>\n\n\n\n<p>ELSEIF MIN([Major\/NonMajor]) != LOOKUP(MIN([Major\/NonMajor]),-1) THEN<\/p>\n\n\n\n<p>PREVIOUS_VALUE(0) + MIN([Students per column])<\/p>\n\n\n\n<p>ELSE<\/p>\n\n\n\n<p>PREVIOUS_VALUE(0)<\/p>\n\n\n\n<p>END<\/p>\n\n\n\n<p>Move the three dimensions \u201cDepartment,\u201d \u201cMajor\/NonMajor,\u201d and \u201cPass\/Fail\u201d out of the rows and into the detail of the Marks area.<\/p>\n\n\n\n<p>Drag the new calculated field: &#8220;# of students\u201d into columns. Right-click to create a table calculation using across the dimensions \u201cDepartment,\u201d \u201cMajor\/NonMajor,\u201d and \u201cPass\/Fail.\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-89.png\"><img loading=\"lazy\" decoding=\"async\" width=\"250\" height=\"402\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-89.png\" alt=\"\" class=\"wp-image-38004\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-89.png 250w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-89-187x300.png 187w\" sizes=\"auto, (max-width: 250px) 100vw, 250px\" \/><\/a><\/figure>\n\n\n\n<p>Drag the measure \u201cStudents\u201d up into rows. Right-click, add table calculation: <strong>Percent of total,<\/strong>\u00a0and compute using <strong>Pass\/Fail<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-90.png\"><img loading=\"lazy\" decoding=\"async\" width=\"309\" height=\"550\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-90.png\" alt=\"\" class=\"wp-image-38005\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-90.png 309w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-90-169x300.png 169w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/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-91.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"495\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-91.png\" alt=\"\" class=\"wp-image-38006\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-91.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-91-300x238.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-92.png\"><img loading=\"lazy\" decoding=\"async\" width=\"196\" height=\"350\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-92.png\" alt=\"\" class=\"wp-image-38007\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-92.png 196w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-92-168x300.png 168w\" sizes=\"auto, (max-width: 196px) 100vw, 196px\" \/><\/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-93.png\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"503\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-93.png\" alt=\"\" class=\"wp-image-38008\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-93.png 487w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-93-290x300.png 290w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/a><\/figure>\n\n\n\n<p>Drag \u201cStudents per column\u201d into the size marks.<\/p>\n\n\n\n<p>Click on the Size box, and change it to <strong>Fixed<\/strong>&nbsp;and <strong>Right<\/strong>&nbsp;alignment.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-94.png\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"395\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-94.png\" alt=\"\" class=\"wp-image-38009\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-94.png 356w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-94-270x300.png 270w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><\/figure>\n\n\n\n<p>Drag \u201cPass\/Fail\u201d onto the Color mark. You should now have a bar chart like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-95.png\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"498\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-95.png\" alt=\"\" class=\"wp-image-38010\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-95.png 479w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-95-289x300.png 289w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/a><\/figure>\n\n\n\n<p>Set a filter for \u201cmajors\u201d only.<\/p>\n\n\n\n<p>Add \u201cDepartment\u201d to the label.<\/p>\n\n\n\n<p>Change the Label setting to \u201cAllow labels to overlap.\u201d<\/p>\n\n\n\n<p><strong>Question 7a: Which department had the most majors fail? (Hint: hover over the bars to look at the tooltips). <\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>A: Biology<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>B: Chemistry<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>C: Computer Science<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>D: Data Analytics<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>E: Physics<\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 7a Answer:<\/strong><strong><\/strong><\/td><td>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 7b: What percentage of that department (from 7a) failed? (Hint: hover over the bars to look at the tooltips). <\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Question 7b Answer:<\/strong><strong><\/strong><\/td><td>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Question 8: Animated <\/strong><strong><\/strong><\/p>\n\n\n\n<p>For this animation, we will create a scatterplot using the Video game sales dataset. Create a new worksheet. Drag the measures \u201cGlobal Sales\u201d into columns and \u201cRank\u201d into rows. Leave the aggregation as a SUM.<\/p>\n\n\n\n<p>Drag \u201cPlatform\u201d into Color. Change the Mark type to Circle. Click the size button to increase the size.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-96.png\"><img loading=\"lazy\" decoding=\"async\" width=\"175\" height=\"155\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-96.png\" alt=\"\" class=\"wp-image-38011\"\/><\/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-97.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"533\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-97.png\" alt=\"\" class=\"wp-image-38012\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-97.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-97-300x256.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<p>Drag \u201cGenre\u201d and \u201cPlatform\u201d into the filters. Right-click, and select \u201cShow filter\u201d for each. Click \u201cok.\u201d Make sure you have a blank scatterplot by ensuring no filters are selected.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-98.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"329\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-98.png\" alt=\"\" class=\"wp-image-38013\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-98.png 624w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-98-300x158.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-99.png\"><img loading=\"lazy\" decoding=\"async\" width=\"298\" height=\"492\" src=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-99.png\" alt=\"\" class=\"wp-image-38014\" srcset=\"https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-99.png 298w, https:\/\/myassignmenthelp.info\/assignments\/wp-content\/uploads\/2025\/05\/image-99-182x300.png 182w\" sizes=\"auto, (max-width: 298px) 100vw, 298px\" \/><\/a><\/figure>\n\n\n\n<p>In your filters, click \u201cPS\u201d for the Platform and \u201cRole-Playing\u201d for Genre. Make a note of where the dot is located on the graph. What color is the dot?<\/p>\n\n\n\n<p>Now, click \u201cDS\u201d for Platform; you should have two dots. Then click on \u201cPuzzle\u201d for Genre to add it as a filter.<\/p>\n\n\n\n<p><strong>Question 8: What happened to the PS dot? You can unclick the filters and apply them again to watch the animation. <\/strong><strong><\/strong><\/p>\n\n\n\n<p>Option A: Nothing changed<\/p>\n\n\n\n<p>Option B: The PS dot dropped<\/p>\n\n\n\n<p>Option C: The PS dot lifted<\/p>\n\n\n\n<p>Option D: Both drops became equal<\/p>\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>&nbsp;<\/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-37969","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts\/37969","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=37969"}],"version-history":[{"count":1,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts\/37969\/revisions"}],"predecessor-version":[{"id":38015,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/posts\/37969\/revisions\/38015"}],"wp:attachment":[{"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/media?parent=37969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/categories?post=37969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myassignmenthelp.info\/assignments\/wp-json\/wp\/v2\/tags?post=37969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}