Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
The purpose of this assignment is to use pivot tables and pivot
charts to aggregate data and to explain the process used for data
For this assignment, you will use the “Claims 2” dataset. Use Excel pivot tables and pivot charts for this exercise.
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
- 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.”
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.
APA format is not required, but solid academic writing is expected.
This assignment uses a grading rubric. Please review the rubric prior
to beginning the assignment to become familiar with the expectations
for successful completion.