BAN140-Workshop3 (6)
docx
keyboard_arrow_up
School
Seneca College *
*We aren’t endorsed by this school
Course
140
Subject
Statistics
Date
Feb 20, 2024
Type
docx
Pages
8
Uploaded by DoctorBravery103687
BAN140 Introduction to Data Visualization
WorkShop3
Contents
Contents
.......................................................................................................................................
1
Instructions:
.................................................................................................................................
2
Part One: Introduction
................................................................................................................
3
Line Graphs:
.............................................................................................................................
3
Bar graphs:
..............................................................................................................................
3
Part Two: Line Graphs: Apply Pre-Attentive Attributes to your Line Graph
............................
4
Part Three: Horizontal Bar Chart: Apply Pre-Attentive Attributes to your Bar Chart
..............
6
Deliverables:
................................................................................................................................
8
Page 1
of 8
BAN140 Introduction to Data Visualization
WorkShop3
Instructions:
This workshop is worth 5% of the total course grade and will be evaluated through your written submission.
Please submit the submission file(s) through Blackboard. Page 2
of 8
BAN140 Introduction to Data Visualization
WorkShop3
Part One: Introduction Line Graphs:
The line graph is an excellent tool to visualize change over time. Although this is feasible with a
bar graph, the changing trends over time are not as easy to interpret.
Line graph formatting guidelines:
Ensure data types of data fields are correctly assigned
Remove excess white space by shrinking y-axis interval
Employ color to pertinent categories
Add axis labels as necessary
Title that states a call to action
Remove or light gray gridlines
Use gestalts principle and remove clutter
For more infromation read posts “
3 Ways to Make Lovely Line Graphs in Tableau
“ Bar graphs:
The bar graph is one of the most important tools in the data visualization toolbox. The human
brain can easily compare height, resulting in fast and simple interpretation of what the data
represents, so it is important to understand how to create compelling and easily readable bar
graph visualizations.
Bar graph formatting guidelines:
Ensure data types of data fields are correctly assigned
Decrease bar height due to low variance (difference in bar height) between each bar
Change decimals to percent via Default Properties > Number Format
Add title, remove redundant Location header
Axis rulers for both rows and columns are set to 'none'
Columns: Zero lines and grid lines are set to 'none'
Decrease slightly graph horizontal size
Increase slightly graph vertical size
For more information Watch my video tutorial on bar graph formatting in
Tableau. For more infromation read posts “
3 Ways to Make Beautiful Bar Charts in Tableau
“ Page 3
of 8
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
BAN140 Introduction to Data Visualization
WorkShop3
Part Two: Line Graphs: Apply Pre-Attentive Attributes to your Line Graph Line graph of Years
vs. Average Life Expectancy
Step1. Download LifeExpectancy.xlsx from blackboard. Step2. Open Tableau Desktop, and then connect to Microsoft Excel file
Step3. Select Columns to be Years
Step4. Select rows to be Life expectancy
Step5. Select between 10 and 15 countries of your choice to compare with the United States
and World
data.
Step6. All formatting, such as color for visual cues and simplistic design principles must be complete
Step7. Add your group member name
to the Title
a.
Font size for First line in the title is 20 and type is Tableau Light
Step8. Save your tableau file as WS03_A.twbx
. Hint:
Pay attention to data-to-ink ratio
Add any annotation or labeling that can help you.
Page 4
of 8
BAN140 Introduction to Data Visualization
WorkShop3
Question 1. Copy and Paste the created Line Graphs
here. Replace the figure below.
This is a draft line Chart
Page 5
of 8
BAN140 Introduction to Data Visualization
WorkShop3
Part Three: Horizontal Bar Chart: Apply Pre-
Attentive Attributes to your Bar Chart
Step1. Download ITticketsbylocationmonthfor2017.xlsx from blackboard. Step2. Open Tableau Desktop, and then connect to Microsoft Excel file
Step3. Select one month from 2017 year. Step4. Create calculate field “
Percentage Tickets Processed
” to show the percentage of Ticket Volume processed / Ticket Volume Received ratio. Step5. Change the calculated field properties to percentage with zero decimal places.
Step6. Create horizontal bar chart
to show Location vs. percentage tickets processed. Given the Month you selected in step3
Columns: Processed / received ratio. Rows: Location
Step7. Create a custom reference line “
Target
” using create parameter option. If the location has 60% or more percentage of tickets processed, then this location meet the target. Step8. Color: all the Locations passed the target (60%) as red
. All other locations light gray
To do this you need calculated field.
Step9. All formatting, such as color for visual cues and minimalistic design principles must be complete.
Step10. Add your group member name to the Title
Font size for First line in the title is 20 and type is Tableau Light
Step11. Save your tableau file as
WS03_B.twbx
. Hint:
Pay attention to data-to-ink ratio
Add any annotation or labeling that can help you.
Page 6
of 8
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
BAN140 Introduction to Data Visualization
WorkShop3
Question 2. Copy and Paste the created Bar Chart here. Replace the figure below.
This is a draft Bar chart. Page 7
of 8
BAN140 Introduction to Data Visualization
WorkShop3
Deliverables:
SENECA’S ACADEMIC HONESTY POLICY
As a Seneca student, you must conduct yourself in an honest and trustworthy manner in all
aspects of your academic career. A dishonest attempt to obtain an academic advantage is
considered an offense and will not be tolerated by the College.
Add this declaration to your submission file:
I/WE, -Ajit Singh, declare that the attached assignment is our own work in accordance with the Seneca Academic Honesty Policy
. I/We do not copy any part of this assignment, manually or electronically, from any other source including web sites, unless specified as references. I do not distribute my work to other students.
Name
Task(s)
1
Ajit Singh
All
2
1.
Using Blackboard, submit a PDF file <
StudentID
>_<
Lastname
>_ws3.pdf
Page 8
of 8
Related Documents
Related Questions
Healthy Sleep Duration
The centers for Disease Control and Prevention, CDC, defines a healthy sleep duration to be at least seven hours per day. The CDC reports that the percentage of people who report a healthy sleep duration varies by marital status. The CDC also reports that in 2018, 67% of those who are married report a healthy sleep duration; 62% of those who have never been married report a healthy sleep duration; and 56% of those who are divorced, widowed, or separated report a healthy sleep duration. The file Sleep Habits contains sample data on the sleeping habits of people who have never been married that are consistent with the CDC’s findings. Use this data to answer the following questions.
Develop a point estimate and a 95% confidence interval for the proportion of those who have never been married who report a healthy sleep duration.
Develop a point estimate and a 95% confidence interval for the mean number of hours of sleep for those who have never been married.…
arrow_forward
(Chapter 1 Section 1)The State Education Department requires local school districts to keep these records on all students: age, race or ethnicity, days absent, current grade level, standardized test scores in reading and mathematics, and any disabilities or special educational needs the student may have.Which of the following are categorical (or qualitative) variables in these records?
Student
Days Absent
Race or Ethnicity
Age
Mathematics Test Score
Reading Test Score
Current Grade Level
Disabilities or Special Needs
arrow_forward
Define the term scatterplot?
arrow_forward
Question-based on, "sectors"...
Also, please explain how to find the sector...
I have tried it but still struggling with finding an answer...
Any help would be appreciated.
arrow_forward
Categorical binary , categorical , or quantataive
arrow_forward
Statistical Software Section
Directions: Please use statistical software to make all the calculations. For parts a) – e) there will be no
hand calculations. Please provide all statistical output with this section.
15) The following table gives the total 2004 payroll (on opening day of the season, rounded to the
nearest million dollars) and the percentage of games won during the 2004 season by each of the
American League teams.
Total Payroll
|(millions of $) Percentage
Winning
Team
Angels
101
56.8
Orioles
52
48.1
Red Sox
127
60.5
White Sox
65
51.2
Indians
34
49.4
44.4
Tigers
Royals
47
48
35.8
Twins
54
56.8
Yankees
184
62.3
Athletics
Mariners
Devil Rays
Rangers
Blue Jays
59
56.2
82
38.9
30
43.5
55
54.9
50
41.6
a. Calculate the sample correlation coefficient and interpret.
b. Test at the 5% significance level whether there is a positive correlation between payroll and
wining percentage for the American League teams. Please set-up the null and alternative
hypothesis, state the p-value,…
arrow_forward
Biostatistics is integral to the practice of public health because it allows public health professionals to accurately monitor and track the prevalence of disease within a population.
Group of answer choices
True
False
arrow_forward
College. The number of books is discrete data, since books are counted.
1; 1: 1; 1; 1; 1; 1; 1; 1; 1; 1
2: 2: 2: 2: 2; 2: 2: 2: 2; 2
3: 3: 3: 3: 3; 3; 3: 3: 3; 3: 3; 3; 3; 3; 3: 3
4; 4: 4; 4; 4; 4
5: 5; 5; 5; 5
6; 6
students at The of by 50 at ABC
2/ a for the data: the of bought by 50 college
arrow_forward
College Attendance Rates. The following data show the percentage of 17- to 24-year-olds
who are attending college in several metropolitan statistical areas in four geographic regions
of the United States (U. S. Census Bureau website, https://www.census.gov/data.html).
|Northeast
Midwest
South
West
28.6
36.7
58.2 | 59.9
54.2
16.4
31.5
39.9
33.4
21.0 37.2
31.0
33.5 22.8
31.9
22.8 28.8 28.0
41.9 22.3 34.6
70.2 | 12.4 33.0
22.7| 43.7
46.3
43.8
25.5
41.1
32.5
32.1
73.9 33.9
37.0
14.9
58.3 36.8 18.8
30.7
26.8 33.8
36.8
31.1
28.4 30.3
30.8 57.3 28.7
36.3
64.0 27.2 67.4
21.6
14.3 21.8
37.7
27.6 31.8 32.6
31.5 37.0
56.8 30.0
28.3 39.1
42.2 33.3 29.7
74.7 39.4 29.8 21.6 52.4
58.4
55.5
38.2 28.1
60.6
78.8
40.2
17.5
35.4
32.3
36.5
39.2 23.7
35.5
51.5
28.7
34.0 26.1
25.4
60.4
24.5
32.7
29.6
Use a a = 0.05 to test whether the mean percentage of 17- to 24-year-olds who are attending
college is the same for the four geographic regions.
arrow_forward
The accompanying table contains the number of partners in a cohort of rising accounting firms that have been tagged as "firms to watch." Complete parts (a) through (c) below.
List the five-number summary.
The five-number summary is ___, ___, ____, _____, ____.
arrow_forward
Part c and d?
It says it’s wrong.
arrow_forward
The standard deviations of four data sets are shown in the table below. Which
of the data sets is most spread out?
Data set Standard deviation
Data set A
5.21
Data set B
4.88
Data set C
6.06
Data set D
3.39
arrow_forward
2.6 Global credit cards. There are currently six global credit
card companies that allow worldwide usage-Visa, Mastercard,
American Express, UnionPay, JCB, and Discover. The table
gives a breakdown on the number of purchase transactions
for each company in 2018.
GLOBALCC
Credit Card
Visa
Mastercard
American Express
UnionPay
JCB
Discover
Number of Worldwide
Transactions (billions)
147.9
75.8
7.5
58.6
3.4
2.5
Source: The Nilson Report, January 2, 2020
a. One of the worldwide credit card transactions in 2018
is selected at random, and the credit card company is
determined. What type of data (quantitative or qualita-
tive) is measured?
b. For each credit card company in the table, calculate the
percentage of the 2018 worldwide transactions.
c. Use the percentages from part b to construct a relative
frequency bar graph for the data summarized in the table.
d. Based on the bar graph, make a statement about the
most used credit cards worldwide.
arrow_forward
Construction and building inspectors ensure that construction meets local and national buillding
codes and ordinances, zoning regulations, and contract specifications. They spend considerable
time inspecting worksites, alone or as part of a team. Most work full time during regular business
hours. Many states and local jurisdictions require some type of license or certification. The median
annual wage was $56,040 in May 2014. SOURCE: Bureau of Labor and Statistics, U.S. Department of
Labor, Occupational Outlook Handbook, 2016 - 2017 Edition E, Construction and Building Inspectors
A wheelchalir ramp with a length of 614 Inches has a horizontal distance of 610 Inches. What is the
ramp's vertical distance (height)?
inches
State your response to the nearest 0. 1
Construction laws are very specific when it comes to access ramps for the disabled. Every vertical
rise of 1 inch requires a horizontal run of at least 12 inches. Does the ramp above satisfy the
requirement?
O Yes
O No
arrow_forward
Plzzz explain.
arrow_forward
If you want to win a Nobel Prize, should you study subjects like physics, chemistry, and economics, or should you just eat more chocolate? The table below lists chocolate consumption (kg per capita) and the numbers of Nobel Laureates (per 10 million people) for each of 23 different countries. See Data Set 16 “Nobel Laureates and Chocolate” in Appendix B, where the countries are identified.
Chocolate
Nobel
4.5
5.5
10.2
24.3
4.4
8.6
2.9
0.1
3.9
6.1
0.7
0.1
8.5
25.3
7.3
7.6
6.3
9.0
11.6
12.7
2.5
1.9
8.8
12.7
3.7
3.3
1.8
1.5
4.5
11.4
9.4
25.5
3.6
3.1
2.0
1.9
3.6
1.7
6.4
31.9
11.9
31.5
9.7
18.9
5.3
10.8
Is there a linear correlation between chocolate consumption and the rate of Nobel Laureates? Run a hypothesis test to test the claim that there is a linear correlation.
If there is a correlation between chocolate consumption and the rate of…
arrow_forward
Falls are one source of preventable hospital injury. The data in the table represent the number of patient falls per month over a 28-month period in a 19-bed AIDS unit at a major metropolitan hospital. Complete parts (a) and (b).
Full data set O
Month
3
4
5
6
7
8
9
10
11
12
13
14
Falls
3
4
3
4
3
4
4
10
6
6
Month
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Falls
6
8
5
11
4
7
6
6
7
7
10
a. Construct a c chart for the number of patient falls per month. Do you think that the process is in a state of statistical control? Choose the correct chart below.
OA.
OB.
Oc.
16-
16-
167
14
14
14
Time
Time
Time
Do you think that the process is in a state of statistical control?
O A. Yes. There do not appear to be special causes of variation.
O B. No. There is at least one point outside the control limits.
O C. No. There is a discernable pattern.
O D. No. There are eight consecutive points all above or below the center line.
b. What effect would it have on your conclusions if you knew that the AIDS unit…
arrow_forward
A bookstore at the Hartsfield-Jackson airport in Atlanta sells reading materials (paperback books, newspapers, magazines) as well as snacks (peanuts, pretzels, candy, etc.) A point-of-sale terminal collects a variety of information about customer purchases. The accompanying table shows the number of snack items and the number of items of reading material purchased by the most recent 600 customers.
Reading materials
snacks
0
1
2
0
0
60
18
1
240
90
30
2
120
30
12
please solve parts 2, 3, and 4
Using the data in the table construct an empirical discrete bivariate probability distribution for x = number of snack items and y = number of reading materials for a randomly selected customer purchase. What is the probability of a customer purchase consisting of one item of reading materials and two snack items? What is the probability of a customer purchasing one snack item only? Why is the probability f(x=0, y=0)=0?
Show the marginal probability distribution for the number of…
arrow_forward
Predict the lung cancer index for men who worked in an occupation in England in which the smoking index was 129.
What type of prediction did you just make? Explain
What type of prediction did you just make? Explain
arrow_forward
A study examined the interactions in a children's museum. (Interactions by visitors to the museum included show-and-tell, learning, teaching, refocusing, participatory play, advocating, and disciplining
interactions.) Researchers observed a sample of 180 meaningful interactions, of which 86 were led by children and 94 were led by adult caregivers. Complete parts a through d below.
a. Give a point estimate of the true proportion of all meaningful interactions in a children's museum that are led by children.
The point estimate is.
(Type an integer or decimal rounded to three decimal places as needed.)
arrow_forward
The book The Wall Street Journal. Guide to Information Graphics by Dona M. Wong gives strategies for using graphs and charts to display information effectively. One popular graph discussed is the donut pie chart. The donut pie chart is simply a pie chart with the center removed. A recent Harris Poll asked adults about their opinions regarding whether books should be banned from libraries because of social, language, violent, sexual, or religious content. The responses by education level to the question "Do you think that there are any books which should be banned completely?" are shown in the following donut pie charts.
(a) What feature of Keith's graph makes it difficult to visually compare the responses of those with some college to those shown in the other graphs? (Select all that apply.)
a)The graphs made by Keith and Ramon compare groups across education level.
b)The graphs made by Keith and Ramon are all donut pie charts.
c)The graphs do not have data labels showing the…
arrow_forward
please help.
arrow_forward
The higher education department of Holmes Institute recorded data on the number of students enrolled in the different study majors for the years 2018 and 2019.
Study major
2018
2019
Statistics
1700
2250
Business law
700
900
Accounting
1300
1450
Economics
750
1000
Finance
1450
1758
Marketing management
1069
1189
Auditing
360
351
Use an appropriate graphical technique or chart to compare the number of enrolment in 2018 and 2019 of the different study major. Display the chart.
Use an appropriate graphical technique or chart to display the percentage value of the number of enrolment of the different study major in 2018 and 2019. Display the chart.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337282291/9781337282291_smallCoverImage.gif)
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Related Questions
- Healthy Sleep Duration The centers for Disease Control and Prevention, CDC, defines a healthy sleep duration to be at least seven hours per day. The CDC reports that the percentage of people who report a healthy sleep duration varies by marital status. The CDC also reports that in 2018, 67% of those who are married report a healthy sleep duration; 62% of those who have never been married report a healthy sleep duration; and 56% of those who are divorced, widowed, or separated report a healthy sleep duration. The file Sleep Habits contains sample data on the sleeping habits of people who have never been married that are consistent with the CDC’s findings. Use this data to answer the following questions. Develop a point estimate and a 95% confidence interval for the proportion of those who have never been married who report a healthy sleep duration. Develop a point estimate and a 95% confidence interval for the mean number of hours of sleep for those who have never been married.…arrow_forward(Chapter 1 Section 1)The State Education Department requires local school districts to keep these records on all students: age, race or ethnicity, days absent, current grade level, standardized test scores in reading and mathematics, and any disabilities or special educational needs the student may have.Which of the following are categorical (or qualitative) variables in these records? Student Days Absent Race or Ethnicity Age Mathematics Test Score Reading Test Score Current Grade Level Disabilities or Special Needsarrow_forwardDefine the term scatterplot?arrow_forward
- Question-based on, "sectors"... Also, please explain how to find the sector... I have tried it but still struggling with finding an answer... Any help would be appreciated.arrow_forwardCategorical binary , categorical , or quantataivearrow_forwardStatistical Software Section Directions: Please use statistical software to make all the calculations. For parts a) – e) there will be no hand calculations. Please provide all statistical output with this section. 15) The following table gives the total 2004 payroll (on opening day of the season, rounded to the nearest million dollars) and the percentage of games won during the 2004 season by each of the American League teams. Total Payroll |(millions of $) Percentage Winning Team Angels 101 56.8 Orioles 52 48.1 Red Sox 127 60.5 White Sox 65 51.2 Indians 34 49.4 44.4 Tigers Royals 47 48 35.8 Twins 54 56.8 Yankees 184 62.3 Athletics Mariners Devil Rays Rangers Blue Jays 59 56.2 82 38.9 30 43.5 55 54.9 50 41.6 a. Calculate the sample correlation coefficient and interpret. b. Test at the 5% significance level whether there is a positive correlation between payroll and wining percentage for the American League teams. Please set-up the null and alternative hypothesis, state the p-value,…arrow_forward
- Biostatistics is integral to the practice of public health because it allows public health professionals to accurately monitor and track the prevalence of disease within a population. Group of answer choices True Falsearrow_forwardCollege. The number of books is discrete data, since books are counted. 1; 1: 1; 1; 1; 1; 1; 1; 1; 1; 1 2: 2: 2: 2: 2; 2: 2: 2: 2; 2 3: 3: 3: 3: 3; 3; 3: 3: 3; 3: 3; 3; 3; 3; 3: 3 4; 4: 4; 4; 4; 4 5: 5; 5; 5; 5 6; 6 students at The of by 50 at ABC 2/ a for the data: the of bought by 50 collegearrow_forwardCollege Attendance Rates. The following data show the percentage of 17- to 24-year-olds who are attending college in several metropolitan statistical areas in four geographic regions of the United States (U. S. Census Bureau website, https://www.census.gov/data.html). |Northeast Midwest South West 28.6 36.7 58.2 | 59.9 54.2 16.4 31.5 39.9 33.4 21.0 37.2 31.0 33.5 22.8 31.9 22.8 28.8 28.0 41.9 22.3 34.6 70.2 | 12.4 33.0 22.7| 43.7 46.3 43.8 25.5 41.1 32.5 32.1 73.9 33.9 37.0 14.9 58.3 36.8 18.8 30.7 26.8 33.8 36.8 31.1 28.4 30.3 30.8 57.3 28.7 36.3 64.0 27.2 67.4 21.6 14.3 21.8 37.7 27.6 31.8 32.6 31.5 37.0 56.8 30.0 28.3 39.1 42.2 33.3 29.7 74.7 39.4 29.8 21.6 52.4 58.4 55.5 38.2 28.1 60.6 78.8 40.2 17.5 35.4 32.3 36.5 39.2 23.7 35.5 51.5 28.7 34.0 26.1 25.4 60.4 24.5 32.7 29.6 Use a a = 0.05 to test whether the mean percentage of 17- to 24-year-olds who are attending college is the same for the four geographic regions.arrow_forward
- The accompanying table contains the number of partners in a cohort of rising accounting firms that have been tagged as "firms to watch." Complete parts (a) through (c) below. List the five-number summary. The five-number summary is ___, ___, ____, _____, ____.arrow_forwardPart c and d? It says it’s wrong.arrow_forwardThe standard deviations of four data sets are shown in the table below. Which of the data sets is most spread out? Data set Standard deviation Data set A 5.21 Data set B 4.88 Data set C 6.06 Data set D 3.39arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337282291/9781337282291_smallCoverImage.gif)
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage