Question: Make two different Excel pivot tables and charts for the following Excelsheet. After reviewing the data, you will consider what makes a good chart. Make

  • Make two different Excel pivot tables and charts for the following Excelsheet. After reviewing the data, you will consider what makes a good chart.
    • Make sure to provide a descriptive chart title and axis labels for each chart.
    • Each pivot chart should be on a separate worksheet tab in your Excel file.
    • Provide one sentence that sums up the key point as shown in the chart.
  • Submit your Excel file for grading for this assignment.
CMS Certification Number (CCN) Measure Code Score Footnote Start Date End Date Measure Date Range
NATION L_006_01_NATL_SIR 0.745 - 4/1/2021 3/31/2022 -
NATION L_007_01_NATL_SIR 0.751 - 4/1/2021 3/31/2022 -
NATION L_009_02_NATL_OBS_RATE 99.3 - 7/1/2021 6/30/2022 -
NATION L_010_02_NATL_OBS_RATE 99.4 - 7/1/2021 6/30/2022 -
NATION L_011_04_NATL_OBS_RATE 7.9 - 7/1/2020 6/30/2022 -
NATION L_012_01_NATL_OBS_RATE 0.1 - 7/1/2021 6/30/2022 -
NATION L_014_01_NATL_SIR 0.356 - 4/1/2021 3/31/2022 -
NATION L_015_01_NATL_OBS_RATE 68.1 - 10/1/2021 3/31/2022 -
NATION L_017_01_PPR_PD_NATL_OBS_RATE 14.4 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_017_01_PPR_PD_N_BETTER_NATL 3 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_017_01_PPR_PD_N_NO_DIFF_NATL 325 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_017_01_PPR_PD_N_TOO_SMALL 20 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_017_01_PPR_PD_N_WORSE_NATL 9 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_018_02_DTC_NATL_OBS_RATE 19.4 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_018_02_DTC_N_BETTER_NATL 34 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_018_02_DTC_N_NO_DIFF_NATL 280 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_018_02_DTC_N_TOO_SMALL 17 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_018_02_DTC_N_WORSE_NATL 25 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_019_01_NATL_MSPB_SCORE 1 - 7/1/2019 6/30/2021 07/01/2019 - 12/31/2019; 07/01/2020 - 06/30/2021
NATION L_020_01_NATL_OBS_RATE 95 - 7/1/2021 6/30/2022 -
NATION L_021_01_NATL_OBS_RATE 2.2 - 7/1/2021 6/30/2022 -
NATION L_022_01_NATL_OBS_RATE_C1 94 - 7/1/2021 6/30/2022 -
NATION L_022_01_NATL_OBS_RATE_C2 97.7 - 7/1/2021 6/30/2022 -
NATION L_023_01_NATL_OBS_RATE 55.2 - 7/1/2021 6/30/2022 -
NATION L_024_01_NATL_OBS_RATE 87 - 4/1/2022 6/30/2022 -

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Satellite Data Retrieval, Reference Frames, Numerical and Analytical Orbital Propagation SSD Individual Assignment RMIT University Figure 1: Example errors between a ground truth ephemeris and...

Q:

Bus299 Assignment: West Coast Sales (WCS) Database 1. Each employee at WCS has an email address which is always their L..e@wcs.com. Using text functions, put each employee's email address in column...

Q:

Dissertation Topic: "The Effects of Cybersecurity Measures on the Productivity and Well-being of Teleworkers in the Healthcare Industry". Introduction Draft no more than TWO paragraphs here -...

Q:

Assignment #11 - Excel Lab 2 - Pivot Tables and Charts TASKS: Q1 Go to the AHRQ Datatools websiteLinks to an external site. and select/download a dataset to use. Make sure to reference which dataset...

Q:

QSO 320 Milestone One Guidelines and Rubric Overview Finding out about organizational inefficiencies is the first step to improving performance. To determine what inefficiencies exist, you need to...

Q:

Module 1, Individual Case Analysis - Drout Advertising Research Project Dear International Data Analytics for Business Executives: . Please read the following Data Analytics for Business case...

Q:

QSO 320 Milestone One Guidelines and Rubric Overview Finding out about organizational inefficiencies is the first step to improving performance. To determine what inefficiencies exist, you need to...

Q:

Individual Take-home Learning Test Univariate Analysis Description Before we look for relationships among variables in a data set, we should investigate the data themselves. How many variables do we...

Q:

\begin{tabular}{l|l|l|} \hline 1 & Row Labels & Average of Shipping Cost per Pound \\ \cline { 2 - 3 } & Al-State Trucking & 1.038532547 \\ 3 & BLTN Transport & 0.981646418 \\ 4 & Count on Us &...

Q:

QSo 320 Vinho Winery Scenario The Vinho Winery in Lodi, California, produces about one million cases of wine a year. They sell their wine wholesale to four independent wine distributors in Riverside,...

Q:

d. experimentation. 14. In science, a theory can be described according to all of the following qualities below, except which one? a. It is merely speculative. b. It is systematic. c. It is...

Q:

Two identical long conducting wires AOB and COD are placed at right angle to each other, with one above other such that 'O' is their common point for the two. The wires carry I, and I currents...

Q:

We learned that the current market price of a bond is the total of the present values of ( 1 ) the principal / face / par value ( future value ) of the bond and ( 2 ) the income stream of interest...

Q:

Refer to Table 9.1, treating marijuana use as the response variable. Analyze these data. Table 9.1: Marijuana Use for High School Marijuana Use Alcohol, Cigarette, and Seniors Race = White Female Yes...

Q:

A group of n Ghostbusters is battling n ghosts. Each Ghostbuster carries a proton pack, which shoots a stream at a ghost, eradicating it. A stream goes in a straight line and terminates when it hits...

Q:

Using equation (3.5) describing the Normal distribution and setting = 0 and 2 = 1, graph the distribution for the values x = 2, 1.5, 1, 0.5, 0, 0.5, 1, 1.5, 2. Equation (3.5) Pr(x) 1 e Ov2n

Q:

A person stands on a very sensitive scale and inhales deeply. The reading on the scale a. increases b. does not change c. decreases d. any of the above, depending on how the expansion of the persons...

Q:

Find the values of k for which 3x 2 + 2x + k = 0 has no real roots.

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

=+for the shareholder of the acquiring company?

Q:

=+for the shareholder of the acquired company?

Q:

=+for the acquired company?