+1(978)310-4246 credencewriters@gmail.com
Select Page

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

Measures of Central Tendency
25 points
Criteria Description
Measures of Central Tendency (Mean, Median and Mode)
5. 5: Excellent
25 points
Measures of central tendency are calculated.
4. 4: Good
21.25 points
N/A
3. 3: Satisfactory
18.75 points
Measures of central tendency are mostly calculated, but one required calculation is missing.
2. 2: Less Than Satisfactory
16.25 points
Measures of central tendency are partially calculated, but two required calculations are missing.
1. 1: Unsatisfactory
0 points
Measures of central tendency are not calculated.
collapse Measures of Variation assessment
Measures of Variation
25 points
Criteria Description
Measures of Variation (Variance, Standard Deviation and Range)
5. 5: Excellent
25 points
Measures of central variation are calculated for variance and standard deviation. Range is
identified.
4. 4: Good
21.25 points
N/A
3. 3: Satisfactory
18.75 points
Measures of central variation are mostly calculated, but one required calculation is missing.
2. 2: Less Than Satisfactory
16.25 points
Measures of central variation are partially calculated.
1. 1: Unsatisfactory
0 points
Measures of variation are not calculated.
collapse Analysis of Descriptive Statistics assessment
Analysis of Descriptive Statistics
25 points
Criteria Description
Analysis of Descriptive Statistics
5. 5: Excellent
25 points
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.
4. 4: Good
21.25 points
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.
3. 3: Satisfactory
18.75 points
Analysis of the descriptive statistics for differences and health outcome recommendations
between the groups is included but lacks accuracy, explanation, or supporting details.
2. 2: Less Than Satisfactory
16.25 points
Analysis of the descriptive statistics for differences and health outcome recommendations
between the groups is incomplete or incorrect.
1. 1: Unsatisfactory
0 points
Analysis of the descriptive statistics for differences and health outcome recommendations
between the groups is not included.
collapse Excel Formulas assessment
Excel Formulas
20 points
Criteria Description
Excel Formulas
5. 5: Excellent
20 points
Excel formulas are complete and correct for all problems.
4. 4: Good
17 points
Excel formulas are included for all problems and contain only minor errors.
3. 3: Satisfactory
15 points
Excel formulas are mostly included and contain minor errors.
2. 2: Less Than Satisfactory
13 points
Excel formulas are partially included or contain significant errors that affect problem solutions.
1. 1: Unsatisfactory
0 points
Excel formulas are incomplete or incorrect.
collapse Mechanics of Writing assessment
Mechanics of Writing
5 points
Criteria Description
Mechanics of Writing (includes spelling, punctuation, grammar, language use)
5. 5: Excellent
5 points
Writer is clearly in command of standard, written, academic English.
4. 4: Good
4.25 points
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.
3. 3: Satisfactory
3.75 points
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.
2. 2: Less Than Satisfactory
3.25 points
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.
1. 1: Unsatisfactory
0 points
Surface errors are pervasive enough that they impede communication of meaning. Inappropriate
word choice or sentence construction is used.