Group4_ws8
pdf
keyboard_arrow_up
School
Centennial College *
*We aren’t endorsed by this school
Course
MISC
Subject
Statistics
Date
Jan 9, 2024
Type
Pages
9
Uploaded by BarristerDog3387
BAN140
Introduction to Data Visualization
WorkShop8
Page
1
of
9
Contents
Contents
......................................................................................................................................
1
Instructions:
................................................................................................................................
2
Part One:
Create Stacked Bar ChartA
.......................................................................................
3
Part Two:
Create Stacked Bar ChartB
.......................................................................................
5
Part Three: Compare
..................................................................................................................
8
Deliverables:
...............................................................................................................................
9
BAN140
Introduction to Data Visualization
WorkShop8
Page
2
of
9
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
WorkShop8
Page
3
of
9
Part One: Create Stacked Bar ChartA
Step1.
Download
Hospital Visits.xlsx
from blackboard.
Step2.
Open Tableau Desktop, and then connect to Microsoft Excel file
Step3.
Create New Sheet, name it as “
StackedBarChartA
”
Step4.
Place
Department
on Rows,
Number of Patient Visits
on Columns, and
Patient Risk
Profile
on Color. You'll now have a single stacked bar chart.
Step5.
Turn on labels by clicking the
T button
on the top toolbar.
Step6.
Pick a Title for your Chart
and 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.
Save your tableau file as
WS08.twbx
.
Hint:
➢
Pay attention to data-to-ink ratio
➢
Apply Pre-Attentive Attributes to your Chart
➢
Apply design concepts to your Chart
➢
Add any annotation or labeling that can help you.
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
WorkShop8
Page
4
of
9
Question 1.
Copy and Paste the created
StackedBarChartA
here. Replace the figure below.
<<<<<This is a draft line Chart>>>>>
BAN140
Introduction to Data Visualization
WorkShop8
Page
5
of
9
Part Two:
Create Stacked Bar ChartB
Step1.
Create New Sheet, name it as “
StackedBarChartB
”
Step2.
Place
Department
on Rows,
Number of Patient Visits
on Columns, and
Patient Risk
Profile
on Color. You'll now have a single stacked bar chart.
Step3.
Using the drop-down menu of the second
Number of Patient Visits
field, select
Quick Table Calculation | Percent of Total.
This table calculation runs a secondary calculation on the values that were returned from the data
source to compute a percent of the total.
Here, you will need to further specify how that total
should be computed.
BAN140
Introduction to Data Visualization
WorkShop8
Page
6
of
9
Step4.
Using the same drop-down menu, select
Compute Using | Patient Risk Profile
. This
tells Tableau to calculate the percent for each Patient Risk Profile within a given
department. This means that the values will add up to 100% for each department.
Step8.
Turn on labels by clicking the
T button
on the top toolbar.
Step9.
Pick a Title for your Chart
and add your
group member name
to the Title
b.
Font size for First line in the title is 20 and type is Tableau Light
Step10.
Save your tableau file as
WS08.twbx
.
Hint:
➢
Pay attention to data-to-ink ratio
➢
Apply Pre-Attentive Attributes to your Chart
➢
Apply design concepts to your Chart
➢
Add any annotation or labeling that can help you.
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
WorkShop8
Page
7
of
9
Question 2.
Copy and Paste the created
StackedBarChartB
here. Replace the figure below.
<<<<<This is a draft line Chart>>>>>
BAN140
Introduction to Data Visualization
WorkShop8
Page
8
of
9
Part Three: Compare
Question 3.
Compare between the two charts:
StackedBarChartB
and
StackedBarChartB.
➢
In
StackedBarChartA
, we use the absolute number.
SL
NO.
DEPARTMENT
NAME
NO. OF HIGH
RISK PATIENTS
NO. OF LOW
RISK PATIENTS
TOTAL NO. OF
PATIENTS
1
Anesthetics
373
138
511
2
Cardiology
449
240
689
3
Diagnostic Imaging
378
240
618
4
ER
611
304
915
5
Gastroenterology
402
155
557
6
General Surgery
742
389
1131
7
Hematology
133
88
221
8
ICU
368
362
730
9
Microbiology
168
132
300
10
Neonatal
38
27
65
11
Neurology
106
87
193
12
Nutrition
188
94
282
13
Urology
90
32
122
➢
In
StackedBarChartB
, we use the percent of total.
SL
NO.
DEPARTMENT
NAME
% OF LOW RISK
PATIENTS
% OF HIGH
RISK PATIENTS
TOTAL % OF
PATIENTS
1
Anesthetics
72.99%
27.01%
100.00%
2
Cardiology
65.17%
34.83%
100.00%
3
Diagnostic Imaging
61.17%
38.83%
100.00%
4
ER
66.78%
33.22%
100.00%
5
Gastroenterology
72.17%
27.83%
100.00%
6
General Surgery
65.61%
34.39%
100.00%
7
Hematology
60.18%
39.82%
100.00%
8
ICU
50.41%
49.59%
100.00%
9
Microbiology
56.00%
44.00%
100.00%
10
Neonatal
58.46%
41.54%
100.00%
11
Neurology
54.92%
45.08%
100.00%
12
Nutrition
66.67%
33.33%
100.00%
13
Urology
73.77%
26.23%
100.00%
BAN140
Introduction to Data Visualization
WorkShop8
Page
9
of
9
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
ALWIN SAM
PART A
2
KENNY
PART A
3
ARVIND SIMON
PART B
4
SHIVAM GOEL
PART B
5
PRASAD TALOKDAR
REVIEWED
6
RAJAT
REVIEWED
Using Blackboard, submit the following files
1.
Report as Pdf file
2.
WS08.twbx
Save your group work as
<
GroupName
>_ws8.???
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
Healthy Sleep Duration. The Centers for Disease Control and Prevention (CDC) define 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 SleepHabits contains sample data on the sleeping habits of people who have never been married that are consistent with the CDC’s findings. Use these 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. For…
arrow_forward
Can you please answer the question below, including all parts in a and b. Thank you.
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
. Primary Data Source and Secondary Data Source ?
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
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
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 between groups.
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
or each predictor variable, state the P-value and determine whether the predictor variable is significant in explaining delivery charges.
Predictor variables P-value Significant in explain
Delivery charges
Distance .................. ..............
Weight .................. ..............
Boxes ............... .................
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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_forwardHealthy Sleep Duration. The Centers for Disease Control and Prevention (CDC) define 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 SleepHabits contains sample data on the sleeping habits of people who have never been married that are consistent with the CDC’s findings. Use these 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. For…arrow_forward
- Can you please answer the question below, including all parts in a and b. Thank you.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 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. Primary Data Source and Secondary Data Source ?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_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_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 between groups.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_forwardor each predictor variable, state the P-value and determine whether the predictor variable is significant in explaining delivery charges. Predictor variables P-value Significant in explain Delivery charges Distance .................. .............. Weight .................. .............. Boxes ............... .................arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL