[ANSWERED] Using the data on the National Cancer Institute Data Excel spreadsheet, calculate

Last Updated on January 3, 2023 by Admin

Take a moment to review the details of this assignment below and gather any necessary files. Once you\’re ready to submit your assignment, move on to Step 2.

Assessment Description

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:

  1. Measures of Central Tendency: Mean, Median, and Mode
  2. Measures of Variation: Variance, Standard Deviation, and Range (a formula is not needed for Range).
  3. 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.

You are not required to submit this assignment to LopesWrite.

Expert Answer and Explanation

Descriptive Statistics
American Indian / Alaska Native (includes Hispanic) Asian / Pacific Islander (includes Hispanic) Black (includes Hispanic) Hispanic (any race) White (includes Hispanic)
Rate per 100,000 Rate per 100,000 Rate per 100,000 Rate per 100,000 Rate per 100,000
32 34 57.4 26 53.2
36.6 34.4 60.5 26.8 55.4
38.7 36.6 61.3 28.2 56.3
39.6 36.6 64.1 28.8 57.5
39.9 36.7 64.3 29.4 58.5
40.1 37 67.8 30.3 60.4
42.4 38.5 70.8 31.8 63.1
43.1 38.8 71.2 32 63.9
44.6 39 71.6 32.2 65.2
45 39.8 73.4 32.7 65.8
45.7 40.2 73.7 33.8 65.8
46.4 40.4 75.1 34.1 65.9
47.9 40.5 75.8 34.1 67.1
48.7 40.9 77.3 34.2 68
50 41 77.8 34.5 68.7
51.7 41.8 79 35 68.8
Measures of central tendency Mean 43.275 38.5125 70.06875 31.49375 62.725
Median 43.85 38.9 71.4 32.1 64.55
Mode #N/A 36.6 #N/A 34.1 65.8
Measures of variance Variance 25.986875 5.32484375 42.58964844 7.874335938 24.526875
Sandard deviation 5.097732339 2.307562296 6.526074504 2.806124719 4.952461509
Range 19.7 7.8 22.4 9 15.6
Summary of data
The descriptive analysis presented was done on data collected by the National Cancer Institute indicating the revalance of lung and bronchus cancer in the United States. The data was collected from 2000 to 2015. The analysis is presented in summary as follows; The first analysis was measures of central tendency. There were three measures that were used, that is mean, mode and median. The analysis indicated that Blacks (include Hispanics) had the highest mean in terms of the number of lung and bronchus cancer with a mean of 70.06875. They were followed by Whites (includes Hispanics) with a mean of 62.725. The group with the lowest mean of lung and bronchus cancer were Hispanics who had an average of 31.49375. The calculated median for lung and bronchus cancer for the indicated period for each population groups were as follows; American Indian / Alaska Native (includes Hispanic) 43.85, Asian / Pacific Islander (includes Hispanic) 38.9. For Blacks (includes Hispanic), the median was 71.4, Hispanic (any race) had a median of 32.1, and the Whites (includes Hispanic) had a median of 64.55.
In the analysis of variance, Blacks (includes Hispanics) were noted to have the highest  variance of 42.58965, followed by American Indian / Alaska Native (includes Hispanic) with a variance of 25.986875. The  lowest variance was from the Asian / Pacific Islander (includes Hispanic) with a variance of 5.32484375. Since standard deviation (SD) represents the squre root of variance, the trend was similar as was in variance across the different racial/ethnic  groups. The widest range was also noted from Black population (includes Hispanics) at 22.4. The smallest range was recorded among the Asian / Pacific Islanders (Includes Hispanics) with a range of 7.8.

Place your order now for the similar assignment and get fast, cheap and best quality work written by our expert level  assignment writers.Using the data on the \"National Cancer Institute Data\" Excel spreadsheet, calculate the descriptive statistics indicated below for each of the Race/Ethnicity groups

Use Coupon Code: NEW30 to Get 30% OFF Your First Order

Other Answered Questions:

SOLVED!! Describe the clinical manifestations present in

SOLVED!! Post an explanation of at least two opportunities

SOLVED!! Select a patient that you examined during the last

SOLVED! Sabrina is a 26 year old female who has just been

SOLVED! Describe the characteristics of the aging process

SOLVED!! Develop 3–4 new SMART goals for this quarter and

SOLVED! An 83-year-old resident of a skilled nursing

SOLVED! Identify your specialty area of NP practice

What our customers say

[testimonialrecent set=”1″]

error: protected!!