Fill in order details

  • Submit your instructions
    to writers for free!

Chat with the writer

  • Chat with preferred expert writers
  • Request a preview of your paper
    from them for free


  • Project edited by the quality evaluation department

Download Your Completed Project

  • Download the completed project from your account or have it sent to your email address

[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

Ishita M.Ishita M.
Great Job! Thank you so much for your work. You got it done faster than I imagined and everything is perfect. Will definitely be using you again!
Megan J.Megan J.
"As a wife, mother, and full-time student, I was struggling to try to go back to school and take care of my responsibilities. Sometimes you just need a little help, and I appreciate all the help I have gotten from Academic Research Bureau. My papers are on-time and the writers are easy to work with. Thanks for the support!"
Rajab M.Rajab M. has saved me a lot of time. I was tired of taking the same classes many times over again. As an ESL student, my professors were taking points off of my assignments for my grammar mistakes. It made it very hard to feel encouraged to continue with my studies. Thankful for having found an answer for better grades."
Frank N.Frank N.
As a working student, I just really don't have the time to write paper after paper and complete assignment after assignment. Working full-time and going to school was nearly impossible until I was able to feel comfortable with the writers on this site. They make me feel secure enough to trust them with my papers. While I'm busy with life, they are busy writing my papers. They always do an outstanding job!
Courtney B.Courtney B.
Thank you! You were really patient with me and my needs. This was my first time using you guys, however, I will definitely be using you again!
John H.John H.
I cannot tell you enough how amazing your company is! Your writers are superb, on time, excellent content, so very thankful you reached out to me that day! Lifesaver for sure! Couldn’t be happier with the results I’ve gotten from my first 2 papers with you, I have 4 papers left to go and I’ll be using your company for them all!
Rebecca T.Rebecca T.
After I ordered a dissertation from your writing service, the first paper that I was given did not met my professor’s demand. I set the paper on revision and the writer made the revision for free meeting all my requirements and I was very satisfied
Thomas R.Thomas R.
I was shocked by how your writers managed to deliver my paper on time, and I was among the best in our class in that paper. Thank you so much and I will never hesitate to use you
error: protected!!