tablueu dah
docx
School
North Lake College *
*We aren’t endorsed by this school
Course
2301
Subject
Health Science
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by Dannastudies14
The goal of this homework is to give you hands-on experience with Tableau.
Please give your charts a title that includes your name
. An example would be “Profits by State (Jane Smith).”
Please use different color schemes than I do in my videos
when possible.
Remember that you are not allowed to share files with one another; this includes Tableau files. That constitutes academic dishonesty and can result in a referral to the Office of Student Conduct.
Part of your exams will involve Tableau work, so you want to make sure you have adequate
practice.
Question 1: Top Donors by Degree
Complete the exercise on the worksheet called 1 – Top Donors by Degree, paste the chart below, and answer the associated questions.
a.
(12 pts.) Paste the chart here.
b.
(4 pts.) Answer the following questions about the chart.
i.
Alumni from which degree have the highest average pledge amount? Master of Kinesiology ii.
Alumni from which degree have the highest number of donations? Master of Kinesiology with 351044 Question 2: Funds by Type
Complete the exercise on the worksheet called 2 – Funds by Type, paste the chart below, and answer the associated questions.
c.
(12 pts.) Paste the chart here.
d.
(4 pts.) Answer the following questions about the chart.
i.
Which fund type has the highest pledge amounts across all years? scholarship
ii.
What is the total pledge amount of the Prizes fund type in 2005? 284827
Question 3: Major Gift Donors
Complete the exercise on the worksheet called 3 – Major Gift Donors, paste the chart below, and answer the associated questions.
e.
(12 pts.) Paste the chart here.
f.
(4 pts.) Answer the following questions about the chart.
i.
What is the highest pledge amount by a donor?
180,000
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
ii.
The highest pledge amount is what percentage of all Major Gift Donors’ total pledges?
12.36%
Question 4: Faculty KPIs
Complete the exercise on the worksheet called 4 – Faculty KPIs, paste the chart below, and answer the associated questions.
g.
(12 pts.) Paste the chart here.
h.
(4 pts.) Answer the following questions about the chart.
i.
Which faculty group has the highest fulfillment percentage? Faculty of Medicine
ii.
How many faculty groups out of the 10 total meet an 80% fulfillment threshold? 7
Question 5: Top Funds
Complete the exercise on the worksheet called 5 – Top Funds, paste the chart below, and answer the associated questions.
i.
(12 pts.) Past the chart here.
j.
(6 pts.) Answer the following questions about the chart.
i.
What is the Fund name of the fund with the highest pledge amount?
Rubeus Hagrid Study of Dangerous Animals – Scholarship ii.
What is the Pledge Amount of the Sybill Trelawny Divination Scholarship?
398907
iii.
What is the Received Amount of the Sybill Trelawny Divination Scholarship? 368471
Question 6: Pledged vs Received
Complete the exercise on the worksheet called 6 – Pledged vs Received, paste the chart below, and answer the associated questions.
k.
(12 pts.) Paste the chart here.
l.
(6 pts.) Answer the following questions about the 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
i.
What is the regression equation, when Received Amount is the y variable, and Pledge Amount is the x variable?
0.859125 * Pledge Amount + 6.13366
ii.
How much of the variation in Received Amount is explained by Pledge Amount?
Click or tap here to enter text.
iii.
Is there a statistically significant relationship between Received Amount and Pledge Amount? yes