MIS 660 Topic 3 Visual Representation of Data GCU

MIS 660 Topic 3 Visual Representation of Data GCU

MIS 660 Topic 3 Visual Representation of Data GCU

$22

In stock

$22

  • Description
  • Reviews (0)

Description

MIS 660 Topic 3 Visual Representation of Data GCU

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.

  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. 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.

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.

You are not required to submit this assignment to LopesWrite.

 

 

Course Tutor helps in providing the best essay writing service. If you need 100% original papers for MIS 660 Topic 3 Visual Representation of Data GCU, then contact us through call or live chat.

MIS 660 Topic 3 Visual Representation of Data GCU

Best MIS 660 Topic 3 Visual Representation of Data GCU

MIS 660 Topic 3 Visual Representation of Data GCU

ACCT 553 DeVryBIAM 500 DeVryCIS 500 STRCIS 558 STRENG 105 GCUFIN 390 DeVryFIN 504 GCUHCA 545 GCUHCA 699 GCUHLT 306 GCUHLT 362 GCUHLT 555 GCUHLT 610 GCUHLT 665 GCUHOSP 594 DeVryHRM 600 DeVryMAT 144 GCUMGMT 600MGT 599 STRMGT 655 GCUMKT 373 GCUPSY 362 GCUPSY 565 GCUPSY 575 GCUPSY 665 GCUSOC 102 GCUSOC 320 GCUSOC 372 GCUSOC 412 GCUNSG 6440 SUHIM 515 GCUNSG 4029 SUHIM 615 GCUNSG 3029 SUNSG 4055 SUNSG 6630 SUNSG 6005 SUCRMJ 310PSY 510 GCUCRMJ 300 DevryCRMJ 425SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCUMGT 640 GCUCIS 527 STRSOC 436 GCU,ACC 502 GCUFIN 504 GCU , MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVryNETW 203 DeVryNETW 205 DeVryECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU  ,BIAM 570 DeVryPSY 402 GCU , SOC 480 GCU , BIAM 530 DeVry,  DNP 810 GCU , DNP 820 GCU , DNP 825 GCU , ECN 450 GCU , DNP 830 GCU , LDR 804 GCU , MAT 105 GCU , ECS 501 GCUECS 555 GCU , TSL 552 GCU , ECS 560 GCU , NRS 493 GCU , ECS 570 GCU , BUS 352 GCU , MIS 660 GCU

 

Reviews

There are no reviews yet.


Only logged in customers who have purchased this product may leave a review.