Group4_ws3
pdf
keyboard_arrow_up
School
Centennial College *
*We aren’t endorsed by this school
Course
MISC
Subject
Statistics
Date
Jan 9, 2024
Type
Pages
6
Uploaded by BarristerDog3387
BAN140
Introduction to Data Visualization
WorkShop3
Page
1
of
6
Contents
Instructions:
................................................................................................................................
2
Part One: Bar Graphs
.................................................................................................................
3
Part Two: Line Graphs
................................................................................................................
4
Deliverables:
...............................................................................................................................
6
BAN140
Introduction to Data Visualization
WorkShop3
Page
2
of
6
Instructions:
•
The workshop can be completed in
group of four (recommended)
.
•
All members should work together to complete the workshop and they will receive the same
mark.
•
This workshop is worth 2.5% of the total course grade and will be evaluated through your
written submission.
•
Please submit the submission file(s) through Blackboard.
•
Only one person must submit for the group and only the last submission will be marked
.
BAN140
Introduction to Data Visualization
WorkShop3
Page
3
of
6
Part One: Bar Graphs
Step1.
Download WS03_1.tde from blackboard.
Step2.
Open Tableau Desktop.
➢
Choose Open > File and select WS03_1.tde.
Question 1.
Create the following bar graph, with all details as shown below
.
➢
Add your group number to the title of the chart.
➢
Paste the image here to replace the given figure.
➢
Save your tableau file as
WS03_A.twbx
and then you will submit this file with your pdf
report through blackboard.
Hints:
-
Drag and drop Fund Balance to Marks > Color.
-
Right click the highest bar and choose Annotate > Mark. Edit the recommended text (without
writing the actual data values). (Font Size is 10)
-
Do not forget to change the size from
Standard
to
Entire View
-
Font size for First line in the title is 20 and type is Tableau Light
-
Font size for second line in the title is 15 and type is Tableau Light
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
Page
4
of
6
Part Two: Line Graphs
Step1.
Download WS03_2.tde from blackboard.
Step2.
Open Tableau Desktop.
➢
Choose Open > File and select WS03_2.tde.
Question 2.
Create the following line graph, with all details as shown below
.
➢
Add your group number to the title of the chart.
➢
Paste the image here to replace the given figure.
➢
Save your tableau file as
WS03_B.twbx
and then you will submit this file with your
pdf report through blackboard.
Hints:
-
Read about how tableau can blend axes for multiple measures into a single axis. So,
Measures can share a single axis so that all the marks are shown in a single pane.
-
To blend multiple measures, drag one measure or axis and drop it onto an existing axis
-
Right click the rightmost point on each line and choose Annotate > Point to add the
legend next to each line series (Font Size is 15)
o
Choose the text color by More colors > Pick Screen Color and clicking on the
legend colors
o
Format the annotation and turn off shading and line
-
Do not forget to change the size from
Standard
to
Entire View
-
Font size for First line in the title is 20 and type is Tableau Light, Bold
-
Font size for second line in the title is 15 and type is Tableau Light
BAN140
Introduction to Data Visualization
WorkShop3
Page
5
of
6
BAN140
Introduction to Data Visualization
WorkShop3
Page
6
of
6
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, ------------ (mention your names), 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
Shivam Goel
Task 1
2
Arvind Simon
Task 1
3
Rajat Vaswani
Task 2
4
Alwin Sam
Task 2
5
Kehinde Yunus Adesanya
Review the document
6
Prasad Balasaheb Talokar
Review the document
Using Blackboard, submit the following files
1.
Report as Pdf file
2.
WS03_A.twbx
3.
WS03_B.twbx
Save your group work as
<
GroupName
>_ws3.???
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
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
Can you please answer the question below, including all parts in a and b. Thank you.
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
Negotiating in trade means you are
arrow_forward
Categorical binary , categorical , or quantataive
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
9th Grade 10th grade 11th grade 12th grade
6 10 17 15
9 12 8 16
6 11 11 12
7 11 14 12
7 14 15 12
Calculate the degrees of freedom within group.
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
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 snack items purchased. Compute…
arrow_forward
PART B
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
SEE MORE QUESTIONS
Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill

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_forwardCan you please answer the question below, including all parts in a and b. Thank you.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_forwardNegotiating in trade means you arearrow_forwardCategorical binary , categorical , or quantataivearrow_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_forward9th Grade 10th grade 11th grade 12th grade 6 10 17 15 9 12 8 16 6 11 11 12 7 11 14 12 7 14 15 12 Calculate the degrees of freedom within group.arrow_forwardA 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 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 snack items purchased. Compute…arrow_forward
- PART Barrow_forward2.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
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill

Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage