Create a dashboard describing the data by age group

Assignment Help Applied Statistics
Reference no: EM132233880

Assignment -

You need to have the software "Tableau" Your assignment will have a Tableau file showing the dashboard and a word document for the part 2.

Assignment - For this assignment, you will use the "Claims 2" dataset. You will use Tableau to replicate the dashboard you created in the Topic 3 assignment. In addition, you will compare and contrast the Excel and Tableau software.

Part 1: Create a dashboard describing the data by age group (e.g., 21-30 yrs, 31-40 yrs, 41-50 yrs, 51-60 yrs, and 61-70 yrs). The dashboard should include the graphs and charts listed in the locations described. The dashboard should be submitted as a Tableau file. A sample layout is provided in the resource, "Data Visualization With Tableau Screenshot: Preview of the Tableau Dashboard."

1. Top Left: Bar graph showing the average number of ER visits for each of the five age groups. Show the actual average values above each bar.

2. Middle Left: Bar graph showing the average number of procedures for each of the five age groups. Show the actual average values above each bar.

3. Bottom Left: Bar graph showing the average claim cost for each of the five age groups. Show the actual average values above each bar.

4. Top Right: Pie chart showing the percent of the total sum of all claim costs for each of the five age groups. Show the actual percent values of each slice.

5. Bottom Right: Line graph showing the percent of each age group that has one or more ER visits. Show the actual percent values of each group. To create this chart, first create a new calculated column, named "Has ER Visit," that is equal to 1 when the patient has had one or more ER visits; otherwise 0. HINT: The average of a 0-1 column is a percent.

Part 2: In 250 words, compare and contrast the use of Excel and Tableau in data visualization. Include specific discussion about the following in your summary.

1. Software ease of use.

2. Software visualization capabilities.

3. Software limitations.

4. Discussion of when each of these software programs is most appropriate for use.

APA format is not required, but solid academic writing is expected.

Attachment:- Assignment Files.rar

Reference no: EM132233880

What are the expected annual demand and the total revenue

Calculate the mathematical equation for the total revenue (TR), which is the annual demand multiplied by the unit price. What are the expected annual demand and the total reve

Find the probability distribution information

According to the Center on Budget and Policy Priorities article "Curbing Flexible Spending Accounts Could Help Pay for Health Care Reform" (revised June 10, 2009), flexible sp

Blood type ab is found

A.) Blood type AB is found in only 3% of the population. If 165 people are chosen at random, find the probability of the following. (Round your answers to four decimal pla

Does this correlation imply a causal relationship

Examine pairs of variables, using the method of linear regression, to determine if there is any correlation between the variables. Afterwards, you will postulate whether thi

What is the decision boundary

Complete one more epoch and state whether it converged or not. To show your work you may use a table similar to the one used on the slides. What is the decision boundary? Wr

Find probability that there are exactly 2 prescriptions

Find the probability that there are exactly 2 prescriptions for this drug in a given week and find the probability that there are no more than 5 prescriptions for this drug in

A friend has offered to play a gambling game

A friend has offered to play a gambling game with you that involves flipping a coin that he has provided. Since a flip of heads will be to his advantage, you want to test

A bank branch located in a residential area

A bank branch located in a residential area has developed an improved process for serving customers during noon to 1:00 P.M lunch period. The waiting time in minutes (defined

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd