Create a dashboard describing the data by age group

Assignment Help Applied Statistics

Reference no: EM132231266

Assignment -

The purpose of this assignment is to use pivot tables and pivot charts to aggregate data and to explain the process used for data aggregation. For this assignment, you will use the "Claims 2" dataset. Use Excel pivot tables and pivot charts for this exercise.

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 a separate tab in Excel that only includes the five items below. A sample layout is provided below the dashboard description.

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.

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.

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

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.

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. Refer to the example in the resource "Visual Representation of Data Screenshot: Preview of the Excel Dashboard."

Part 2: Interpret the dashboard and the story it is attempting to tell users by writing a 250-word summary that clearly describes the merits of each of the charts used on the dashboard. For example, discuss why a pie chart might be more appropriate than a bar graph for highlighting the information you want key stakeholders to obtain by studying that content on the dashboard. Include specific discussion about why each specific chart is used to illustrate the data it represents.

Attachment:- Assignment Files.rar

Reference no: EM132231266

Questions Cloud

How could an organization measure the effectiveness : "Pay for Performance" has made inroads in business, but has remained a hard sell in public school systems. There are some successful examples where teacher pay.

Which location provides polaris the greatest advantage : Which location provides Polaris the greatest advantage? What factors should be considered in making this decision.

Considered in the context of managing people performance : What are some of the legislative and regulatory issues that should be considered in the context of managing people performance? List six.

Most admired companies : In 1990, Proctor and Gamble were listed in the top 20 of Fortune's "Most Admired Companies".

Create a dashboard describing the data by age group : The purpose of this assignment is to use pivot tables and pivot charts to aggregate data and to explain the process used for data aggregation

Requirement for managerial success : Some people have suggested that understanding human behavior at work is the single most important requirement for managerial success.

Discuss the various reasons system implementation fails : Discuss the various reasons system implementation fails. Compare and contrast various change models. Then select a change model to use during system.

What do you think are the most important things a manager : What do you think are the most important things a manager? Is how a manager does these things also important? Why or why not?

Provide examples of the following : 1) A decision support system you have used or would be willing to use. 2)An expert system you have used or would be willing to use

Reviews

len2231266

2/10/2019 9:47:10 PM

Instructions- Please find attached and please read through the instruction very well. Thank you. The purpose of this assignment is to use pivot tables and pivot charts to aggregate data and to explain the process used for data aggregation. For this assignment, you will use the "Claims 2" dataset. Use Excel pivot tables and pivot charts for this exercise. APA format is not required, but solid academic writing is expected.

Write a Review

Required(*) Message

User Account

All Pages