HLT362V GCU National Cancer Institute Data Descriptive Statistics Paper There is often the requirement to evaluate descriptive statistics for data within t

HLT362V GCU National Cancer Institute Data Descriptive Statistics Paper There is often the requirement to evaluate descriptive statistics for data within the organization or for health care information. Every year the National Cancer Institute collects and publishes data based on patient demographics. Understanding differences between the groups based upon the collected data often informs health care professionals towards research, treatment options, or patient education.

Using the data on the “National Cancer Institute Data” Excel spreadsheet, calculate the descriptive statistics indicated below for each of the Race/Ethnicity groups. Refer to your textbook and the Topic Materials, as needed, for assistance in with creating Excel formulas.

Provide the following descriptive statistics:

Measures of Central Tendency: Mean, Median, and Mode
Measures of Variation: Variance, Standard Deviation, and Range (a formula is not needed for Range).
Once the data is calculated, provide a 150-250 word analysis of the descriptive statistics on the spreadsheet. This should include differences and health outcomes between groups.

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

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. Asian / Pacific
American Indian /
Islander
Alaska Native
(includes
(includes Hispanic)
Hispanic)
Year of Diagnosis
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
Rate per 100,000
45.7
47.9
44.6
50
51.7
48.7
46.4
43.1
45
40.1
42.4
39.6
36.6
39.9
32
38.7
Black (includes
Hispanic)
Hispanic (any
race)
Rate per 100,000 Rate per 100,000
41.8
41
40.4
40.9
40.5
40.2
39.8
38.8
38.5
39
37
36.6
36.7
36.6
34
34.4
77.8
79
75.8
77.3
75.1
73.7
73.4
71.2
70.8
71.6
67.8
64.1
64.3
60.5
61.3
57.4
Rate per
100,000
34.2
34.1
34.1
34.5
35
33.8
32
32.7
32.2
31.8
30.3
29.4
28.2
28.8
26.8
26
White (includes
Hispanic)
Rate per 100,000
68.8
68.7
68
67.1
65.8
65.9
65.8
65.2
63.9
63.1
60.4
58.5
57.5
56.3
55.4
53.2
National Cancer Institute (2018) Lung and bronchus cancer. Retrieved from Janary 8, 2019
https://seer.cancer.gov/explorer/application.php?site=47&data_type=1&graph_type=2&compareBy=race&chk_sex_
_4=4&chk_race_3=3&chk_race_6=6&chk_race_2=2&chk_age_range_1=1&chk_data_type_1=1&advopt_precision
ataFor=sex_1_and_age_range_1_and_data_type_1
ed from Janary 8, 2019 from
areBy=race&chk_sex_1=1&chk_race_5=5&chk_race
1=1&advopt_precision=1&advopt_display=1&showD
ype_1
Course Code
HLT-362V
Class Code
HLT-362V-O501
Criteria
Content
Percentage
100.0%
Measures of Central Tendency (Mean, Median
and Mode)
25.0%
Measures of Variation (Variance, Standard
Deviation and Range)
25.0%
Analysis of Descriptive Statistics
25.0%
Excel Formulas
20.0%
Mechanics of Writing (includes spelling,
punctuation, grammar, language use)
5.0%
Total Weightage
100%
Assignment Title
Summary and Descriptive Statistics
1: Unsatisfactory (0.00%)
Measures of central tendency are not calculated.
Measures of variation are not calculated.
Analysis of the descriptive statistics for differences and health
outcome recommendations between the groups is not
included.
Excel formulas are incomplete or incorrect.
Surface errors are pervasive enough that they impede
communication of meaning. Inappropriate word choice or
sentence construction is used.
Total Points
100.0
2: Less Than Satisfactory (65.00%)
Measures of central tendency are partially calculated, but
two required calculations are missing.
Measures of central variation are partially calculated.
Analysis of the descriptive statistics for differences and health
outcome recommendations between the groups is
incomplete or incorrect.
Excel formulas are partially included or contain significant
errors that affect problem solutions.
Frequent and repetitive mechanical errors distract the
reader. Inconsistencies in language choice (register) or word
choice are present. Sentence structure is correct but not
varied.
3: Satisfactory (75.00%)
Measures of central tendency are mostly calculated, but one
required calculation is missing.
Measures of central variation are mostly calculated, but one
required calculation is missing.
Analysis of the descriptive statistics for differences and health
outcome recommendations between the groups is included
but lacks accuracy, explanation, or supporting details.
Excel formulas are mostly included and contain minor errors.
Some mechanical errors or typos are present, but they are
not overly distracting to the reader. Correct and varied
sentence structure and audience-appropriate language are
employed.
4: Good (85.00%)
N/A
N/A
Analysis of the descriptive statistics for differences and health
outcome recommendations between the groups is complete
and mostly accurate and contains explanation and supporting
details.
Excel formulas are included for all problems and contain only
minor errors.
Prose is largely free of mechanical errors, although a few may
be present. The writer uses a variety of effective sentence
structures and figures of speech.
5: Excellent (100.00%)
Measures of central tendency are calculated.
Measures of central variation are calculated for variance and
standard deviation. Range is identified.
Analysis of the descriptive statistics for differences and health
outcome recommendations between the groups is extremely
thorough and accurate and includes substantial explanation
and supporting details.
Excel formulas are complete and correct for all problems.
Writer is clearly in command of standard, written, academic
English.
Comments
Points Earned

Purchase answer to see full
attachment