Unit 6 Homework Part to Whole Analysis RUBRIC

doc

School

Chuka University College *

*We aren’t endorsed by this school

Course

CBS4

Subject

Computer Science

Date

Nov 24, 2024

Type

doc

Pages

Uploaded by Pacer-Hub

Unit 6 Homework: Part to Whole And Ranking Analysis (RUBRIC) In this exercise, you will use the data in the file “children mother only status.xlsx” available in Canvas on the homework page for this Unit. You will only be using the Year and the values found under the columns: Divorced , Married Spouse Absent, Widowed, Never Married so I have only included those in the wrangled file. Whenever there was more than one row for a single year, I kept the revised values. The wrangled file contains four columns: Year is the year of the observation. Date is the Year converted into a full month/day/year format. Remember, if you don’t do this Tableau will not recognize the column as a date 1 . Status contains a string: either Divorced , Married Spouse Absent, Widowed, or Never Married. Children(K ) is the number of children (in thousands, thus the K) for the specific year and status. 1. Import the data file into a new Tableau workbook named “part to whole-XXX” where XXX is your initials. Remember to save your work regularly. 1 To do this in Excel, I entered the formula =Date(A2, 1, 1) into cell B2 and then filled this formula down for every data row in column B.

2. Create a line chart showing each value for all of the years of data. Call the tab “Time series”. Note that the image below shows the legend to the right, but on your worksheet it will instead appear below the Marks card. This is the standard location for Tableau worksheets. I made the image below by right clicking on the graph, selecting Copy Image… and then the option to include the legend. You don’t need to do this for the assignment. We will grade your worksheet, so we understand that the legend will be below the Marks card. (10 points) – Line chart (5 points) – Color (5 points) – x-axis (5 points) – y-axis Date 0K 1K 2K 3K 4K 5K 6K 7K 8K Status Divorced Married Spouse Absent Never Married Widowed

3. Create a bar chart showing the percentage of each family type along with a slider filter for the year of Date. Sort the bars from highest to lowest and be sure that sorting is dynamic—meaning that order of the Status bars will change with the data as you slide through the years. Name the tab “Bar chart”. For instance, here is the bar chart with the slider set to 1973: (10 points) – bar chart (5 points) – slider filter (5 points) – Dynamic sorting (5 points) x- and y-axis Status Married Spous.. Divorc.. Wido.. Never Married 0% 5% 10% 15% 20% 25% 30% 35% 40% And here is the slider filter:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4. Create a Pareto chart along with another slider filter for the year of Date. Call the tab “Pareto”. Here is the chart for 1960. Note that the axes are synchronized with the same 0 to 100% scale and the bars are also dynamically sorted from highest to lowest percent. (10 points) – Pareto chart (5 points) – slider filter (5 points) – Dynamic sorting (5 points) – axes synchronized Status Married Spous.. Wido.. Divorc.. Never Married 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%

5. Now create a bump chart showing how the ranking (based on Children(K)) of each type of family has changed over time. Call the tab “Bump chart”. Be sure that your ranking axis starts with 1 at the top. Here is what it should look like: (10 points) – bump chart (5 points) – color (5 points) – ranking axis starts with 1 at top (5 points) - legend Date 0 1 2 3 4 5 Status Divorced Married Spouse Absent Never Married Widowed 6. Save your workbook as a Tableau packaged workbook and submit it through the assignment in Canvas.

Related Documents

Module Four Lesson Two Assignment English.pdf

Multimedia systems.edited.edited.docx

Lab3+-+CEG3585-S20.pdf

Digital Photography I Unit 4 Exam.pdf

Tarea #3 - Densidad.docx

Long Quiz 004 - (2).png

Assignment 8.docx

1ST-quarter-test (1).docx

Assignment 4 (page 1 of 8).pdf

CelsiusTemperature.txt..cpp

W03 QUIZ IPA.docx

Screenshot 2023-11-11 at 12.48.25 PM.png

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

A Guide to SQL

Computer Science

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Course Technology Ptr

CMPTR

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage