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

Report

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