Group4_ws4
pdf
keyboard_arrow_up
School
Centennial College *
*We aren’t endorsed by this school
Course
MISC
Subject
Statistics
Date
Jan 9, 2024
Type
Pages
14
Uploaded by BarristerDog3387
BAN140 Introduction to Data Visualization WorkShop4
Page 1
of 14
Contents Instructions:
................................................................................................................................
2
Part One: Download Dataset
.....................................................................................................
3
Part Two: Pie Chart
.....................................................................................................................
3
Part Three: Donut chart
.............................................................................................................
5
Part Four: Create a Bullet Chart
.................................................................................................
9
Part Five: Create Your own Chart
............................................................................................
12
Deliverables:
.............................................................................................................................
14
BAN140 Introduction to Data Visualization WorkShop4
Page 2
of 14
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 WorkShop4
Page 3
of 14
Part One: Download Dataset Step1.
Download Hospital Visits.xlsx from blackboard. Step2.
Download DepartmentGoals.xlsx from blackboard. Step3.
Open Tableau Desktop, and then connect to Microsoft Excel file
Part Two: Pie Chart Step1.
Create new worksheet and named it “
PieChart
”.
Step2.
Select both Department Type
and
Revenue
, then from Show Me Card choose pie chart
. a.
Note the Marks card. Step3.
Drag the dimension Department Type
to Label in the Marks Card. a.
Do not forget to change the size from Standard
to Entire View
Step4.
Drag the measure Revenue to Label in the Marks Card. Then, right-click on the measure Revenue and select Quick Table Calculation
and then Percent of Total
. Step5.
Change title to “
Hospital Revenue Per Department Type
” Step6.
Add your group member name
to the Title a.
Font size for First line in the title is 20 and type is Tableau Light Step7.
Change the size of Label to 15 and allow label to overlap Step8.
Select Size and drag the slider to the Right. So, the size of pie chart increase Step9.
Save your tableau file as WS04.twbx
. Keep the file open, you will be using this file for other parts
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 WorkShop4
Page 4
of 14
Question 1.
Copy and Paste the created Pie Chart
here. Replace the figure below.
BAN140 Introduction to Data Visualization WorkShop4
Page 5
of 14
Part Three: Donut chart Tableau has no Show Me!
for the donut chart, which can make it a little inaccessible for some people. Step1.
Create new worksheet and renamed it as “DonutChart”. Step2.
Double-click on Rows
and write avg(0)
. Step3.
In front of the field you just created, double-click and write avg(0)
again.
BAN140 Introduction to Data Visualization WorkShop4
Page 6
of 14
Step4.
You should now have two Marks
cards: Step5.
On the first Marks
card (1), change the mark type from automatic to Pie
chart:
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 WorkShop4
Page 7
of 14
Step6.
On the first Marks card (1), bring your dimension Department Type
to Color,
and drag measure Revenue
to Angle
Step7.
Drag the measure Revenue
and the dimension Department Type
to the Label card. Click on the Label card and select Show mark labels.
Step8.
Right-click on the measure Revenue
field that you just added to the Label card, and select Quick Table Calculation
and then Percent of Total
Step9.
On the second Marks card (2), change the mark type to Circle
. Use the Size and Color cards to adjust the size and color of the circle, Click Color and choose white.
Step10.
Now, on the Rows
, right-click on the second avg(0)
field and select Dual Axis.
Step11.
Select Size and drag the slider to the left. Your donut should appear. Step12.
Also, Select the size for the first pie chart. Step13.
Change title to “Hospital Revenue Per Department Type” Step14.
Change the size of Label to 15 and allow label to overlap Step15.
Select Size and drag the slider to the Right. Step16.
Add your group member name to the Title a.
Font size for First line in the title is 20 and type is Tableau Light b.
Do not forget to hide the y-axis. Step17.
Save your tableau file as WS04.twbx
. Now you have two worksheets in your tableau book.
BAN140 Introduction to Data Visualization WorkShop4
Page 8
of 14
Question 2.
Copy and Paste the created Donut Chart
here. Replace the figure below.
BAN140 Introduction to Data Visualization WorkShop4
Page 9
of 14
Part Four: Create a Bullet Chart A bullet chart
is a great way to visually compare a measure with a goal, target, or threshold. Let's assume that hospital administration has set some goals regarding the time to service, that is, the number of minutes between the time a patient arrives at the hospital and the time they start receiving care. Administration knows that each department has unique capabilities and requirements, so they have defined different goals for each department. Check the excel file named “
DepartmentGoals.xlsx
”.
Our Your goal is to create a visualization that shows the actual averages per department in comparison to the goals that have been set by administration. In this part, we will use two data sources “
Hospital Visits.xlsx
” and “
DepartmentGoals.xlsx
”.
Step1.
Create new worksheet and renamed it as “
BulletChar
t
”. Step2.
Click on Data Source tab, then click add to connect to “
DepartmentGoals.xlsx
”.
Then, make relationship between two tables and Join between these two tables.
Step3.
Using the Hospital Visits
Table, create a basic horizontal bar chart
of the average Minutes to Service per Department
. (hint: use the drop-down arrow on the Minutes to Service
field on Columns to select Measure, then change aggregation to Average). Step4.
Drag and drop the dimension Department to Rows.
Step5.
Sort Department from highest to lowest.
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 WorkShop4
Page 10
of 14
Step6.
In the left-hand data pane, select the DepartmentGoals
Table and then click to select the Minutes to Service Goal
field in the data pane under Measures. Step7.
Open Show Me
and select the bullet graph
. At this point, Tableau will have created a bullet chart using the fields in the view and the Minutes to Service Goal
field you selected. ➢
You may need to right click on the x-axis and select “Swap Reference Line Fields”
Step8.
Click on Analysis and select Create Calculated Field. Name the calculated field Over Service Time Goal?
with the following formula The calculation returns true when the Average Minutes to Service
values is greater than the goal value, and false otherwise. Step9.
drag the new Over Service Time Goal? field from the data pane and drop it on Color. Step10.
Save your tableau file as WS04.twbx
. Now you have three worksheets in your tableau book.
Step11.
Add your group member name to the Title ➢
Font size for First line in the title is 20 and type is Tableau Light ➢
Do not forget to change the size from Standard
to Entire View
BAN140 Introduction to Data Visualization WorkShop4
Page 11
of 14
Question 3.
Copy and Paste the created Bullet Char
t
here. Replace the figure below.
BAN140 Introduction to Data Visualization WorkShop4
Page 12
of 14
Part Five: Create Your own Chart In this part, you will create your own chart to answer the following question How many patients did each doctor see? Step1.
Create new worksheet and renamed it as “
YourOwnChart
”. ----- Create your own chart Save your tableau file as WS04.twbx. Now you have four worksheets in your tableau book. Hints: ➢
You may find the Week4 lecture material helpful. ➢
Do not forget to add your group member name to the Title o
Font size for First line in the title is 20 and type is Tableau Light Question 4.
Copy and Paste the created Chart here.
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 WorkShop4
Page 13
of 14
BAN140 Introduction to Data Visualization WorkShop4
Page 14
of 14
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 Made Pie Chart 2 Arvind Simon Made Donut Chart 3 Rajat Veswani Made Bullet Chart 4 Alwin Sam Made Your Own Chart 5 Kehinde Yunus Reviewed all the Charts 6 Prasad Talokar Reviewed All the Charts Using Blackboard, submit the following files 1.
Report as Pdf file 2.
WS04.twbx Save your group work as <
GroupName
>_ws4.???
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
Can you please answer the question below, including all parts in a and b. Thank you.
arrow_forward
Determine the interval(s) BH Which the function is constant.
Write your answer as an interval or list of intervals.
When writing a list of intervals, make sure to separate each interval with a comma and to use as few intervals as possible.
Click on "None" if applicable.
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
(Devore: Section 2.3 #41) An ATM personal identification number (PIN) consists of four digits,
each a 0, 1, 2, ..., 8 or 9, in succession.
(a) How many different possible PINs are there if there are no restrictions on the choice of digits?
(b) According to a representative at the author's local branch of Chase Bank, there are in fact
restrictions on the choice of digits. The following choices are prohibited: (i) all four digits
identical (ii) sequences of consecutive ascending or descending digits, such as 6543 (iii) any
sequence starting with 19 (birth years are too easy to guess). So if one of the PINs in (a) is
randomly selected, what is the probability that it will be a legitimate PIN (that is, not be one
of the prohibited sequences)?
(c) Someone has stolen an ATM card and knows that the first and last digits of the PIN are 8 and
1, respectively. He has three tries before the card is retained by the ATM (but does not realize
that). So he randomly selects the 2nd and 3rd digits for…
arrow_forward
Sammy Davi...
Duncan Toys...
Launch Meet...
Louis Vuitto.
Performance Matters
The history...
Welcome, Demario Hudson!
X Performane
Connection Status: Good O
All changes saved
Question 2 of 17 -
? r
20-21_AA_Fall_Grade 10 Academic Approach: Section 3 - Math Test – No Calculator - 25 MINUTES, 17 QUESTIONS
Submit Test
Question: 3-2
Tim is attending a taco festival that charges $10 for admission and $3 for each taco. Which of the following equations gives the number of tacos Tim bought,
x, if he spent $34 at the festival?
3(10 + x) = 34
O 3x + 10 = 34
10x + 3 = 34
13x = 34
Next
Previous
arrow_forward
...... ................ ...........
Before 1918, approximately 55% of the wolves in a region were male, and 45% were female. However, cattle ranchers in this area have made a determined effort to
exterminate wolves. From 1918 to the present, approximately 65% of wolves in the region are male, and 35% are female. Biologists suspect that male wolves are more likely
than females to return to an area where the population has been greatly reduced. (Round your answers to three decimal places.)
n USE SALT
(a) Before 1918, in a random sample of 10 wolves spotted in the region, what is the probability that 7 or more were male?
What is the probability that 7 or more were fertale?
What is the probability that fewer than 4 were female?
(b) For the period from 1918 to the present, in a random sample of 10 wolves spotted in the region, what is the probability that 7 or more were male?
What is the probability that 7 or more were female?
What is the probability that fewer than 4 were female?
Need…
arrow_forward
A quasi-independent variable is most similar to and consistent with which of the following terms?
A. control group
B. manipulation
C. Non-equivalent groups research study
D. pre-post research study
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
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
Subject:Practical research 2
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_forwardCan you please answer the question below, including all parts in a and b. Thank you.arrow_forwardDetermine the interval(s) BH Which the function is constant. Write your answer as an interval or list of intervals. When writing a list of intervals, make sure to separate each interval with a comma and to use as few intervals as possible. Click on "None" if applicable.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(Devore: Section 2.3 #41) An ATM personal identification number (PIN) consists of four digits, each a 0, 1, 2, ..., 8 or 9, in succession. (a) How many different possible PINs are there if there are no restrictions on the choice of digits? (b) According to a representative at the author's local branch of Chase Bank, there are in fact restrictions on the choice of digits. The following choices are prohibited: (i) all four digits identical (ii) sequences of consecutive ascending or descending digits, such as 6543 (iii) any sequence starting with 19 (birth years are too easy to guess). So if one of the PINs in (a) is randomly selected, what is the probability that it will be a legitimate PIN (that is, not be one of the prohibited sequences)? (c) Someone has stolen an ATM card and knows that the first and last digits of the PIN are 8 and 1, respectively. He has three tries before the card is retained by the ATM (but does not realize that). So he randomly selects the 2nd and 3rd digits for…arrow_forwardSammy Davi... Duncan Toys... Launch Meet... Louis Vuitto. Performance Matters The history... Welcome, Demario Hudson! X Performane Connection Status: Good O All changes saved Question 2 of 17 - ? r 20-21_AA_Fall_Grade 10 Academic Approach: Section 3 - Math Test – No Calculator - 25 MINUTES, 17 QUESTIONS Submit Test Question: 3-2 Tim is attending a taco festival that charges $10 for admission and $3 for each taco. Which of the following equations gives the number of tacos Tim bought, x, if he spent $34 at the festival? 3(10 + x) = 34 O 3x + 10 = 34 10x + 3 = 34 13x = 34 Next Previousarrow_forward
- ...... ................ ........... Before 1918, approximately 55% of the wolves in a region were male, and 45% were female. However, cattle ranchers in this area have made a determined effort to exterminate wolves. From 1918 to the present, approximately 65% of wolves in the region are male, and 35% are female. Biologists suspect that male wolves are more likely than females to return to an area where the population has been greatly reduced. (Round your answers to three decimal places.) n USE SALT (a) Before 1918, in a random sample of 10 wolves spotted in the region, what is the probability that 7 or more were male? What is the probability that 7 or more were fertale? What is the probability that fewer than 4 were female? (b) For the period from 1918 to the present, in a random sample of 10 wolves spotted in the region, what is the probability that 7 or more were male? What is the probability that 7 or more were female? What is the probability that fewer than 4 were female? Need…arrow_forwardA quasi-independent variable is most similar to and consistent with which of the following terms? A. control group B. manipulation C. Non-equivalent groups research study D. pre-post research studyarrow_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 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
- 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_forwardSubject:Practical research 2arrow_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
