Please complete the following:

Part 1, Chart 1:

  1. Enter the following information about overweight adolescents in 1999-2000 into Excel:
    1. Children less than 2 years old were 11.6 % overweight while children 2-5 years old were 10.4 % overweight, children 6-11 years old were 15.3 % overweight, and children 12-19 years old were 15.5 % overweight.
  2. Create appropriate column and row labels. Values should be formatted to the appropriate data format.
  3. Create a chart based on the information above.
    1. The chart should have a title, a primary horizontal and vertical axis title and legend if you are creating a column chart.
    2. The chart should have a title, data labels and legend if you are creating a pie chart.

Part 2, Chart 2:

In a survey of several hundred children the following number of boys and girls were found to be overweight. Enter the following information into Excel:

  1. In a recent survey, 88 girls aged 6-11 and 70 boys aged 6-11 were overweight. Also, in the same survey, 118 girls aged 12-19 and 98 boys aged 12-19 were overweight.

Complete the following in Excel:

  1. Create appropriate columns and row labels.
  2. Add the Total and find the Average of overweight girls.
  3. Add the Total and find the Average of overweight boys.
  4. Add the Total and find the Average of 6-11 year old children who are overweight. 
  5. Add the Total and find the Average of 12-19 year old children who are overweight.
  6. Figure out of all the children who are overweight, what percentage are girls and what percentage are boys?
  7. Figureout of all the children who are overweight, what percentage are in the 6-11 age group and what percentage are in the 12-19 age group?
  8. Values should be formatted to the appropriate data format.
  9. Create a chart based on the information above.
  1. The chart should have a title, a primary horizontal and vertical axis title and legend if you are creating a column chart.
  2. The chart should have a title, data labels and legend if you are creating a pie chart.

Source info for the charts:

Authors: Cynthia L. Ogden, PhD; Katherine M. Flegal, PhD; Margaret D. Carroll, MS; Clifford L. Johnson, MSPH

Article Title: Prevalence and Trends in Overweight Among US Children and Adolescents, 1999-2000

Website title: JAMA Network

Original ContributionOctober 9, 2002



i have started the assignment but need help filling in the questions and adding references.

Thank you.

Significant Episodes in which an Environmental Hazard Caused Adverse Health Outcomes in Humans. 

The three major and historical events that I have identified are the deadly gas release of Bhopal, nuclear disaster at Chernobyl and the Hiroshima bombing. 

Which environmental hazard, such as the pollutant or pollutants, caused the most adverse health outcomes and why?

The deadly gas release of Bhopal, India was made up of methyl isocyanate (MIC) gases that were expelled into the atmosphere from a factory developing pesticides, which killed 3,800 people. There were several explosions at the Chernobyl nuclear reactor that caused the radiation to leak out. The nuclear disaster in Chernobyl had immediate effects on its victims as well as long term.  The bombing at Hiroshima caused radiation to be emitted and caused radiation to be absorbed into people, crops, animals, etc.

What are the various adverse health outcomes that occurred as a result of exposure to the environmental hazard?

The release of this hazardous gas from the Bhopal incident caused many people to pass away from lung failure and those that were able to live out the first couple of days had severe respiratory complications as well as other life threatening symptoms. The long term effects from inhaling these gas included brain related issues such as headaches, as well as effects on the major systems of the body.

The nuclear disaster at Chernobyl had devastating effects on the people that lived in Chernobyl as well as the outlining countries such as Russia and the Ukraine.  The radiation expelled into the air and caused many people to have radiation poisoning, develop cancers especially thyroid as well other cancers.

The bombing at Hiroshima showed effects on its victims such as radiation sickness and radiation burns on the skin.

What are the steps that were taken to prevent the adverse health outcomes from occurring? Should there be any other step that was necessary to prevent the adverse health outcome? Explain.

Suggest the ways to prevent future occurrences of such episodes.

Is there an association between environmental hazards and adverse health outcomes in humans? Why or why not?

Analyze and explain the exposure-disease relationship for each of these three events.

What do you think is the impact of these events on the communities where they occurred?


  • It is strongly recommended you take time to reflect on the award you have been offered by Delta Scholarship Fund. Feel free to express your appreciation, describe your work toward achieving your goals, your future plans, and any other information you’d like to share.


Assignment 3: Not Just the Beatles

Due Week 5 and worth 240 points

You are the lead singer and manager of a new and quickly rising band, Everyone, from record companies, movie producers, video game producers, magazine editors, and the like, isapproaching you. As described in Chapter 26 of the text, you do not want to make the same mistakes Brian Epstein, the manager of the Beatles, made when they made their first movie easily losing the band millions in lost revenue.  You have been asked to now take your band to support the troops in a number of war zones. You do not want to engender negative press coverage and agree to a contract with the U.S.O. and Armed Forces Radio.

Write a six to eight (6-8) page paper in which you:

  1. Discuss the steps that would have helped a negotiator / manager like Brian Epstein to prevent media and entertainment industries from taking advantage of his / her lack of experience with these industries.
  2. Indicate the basic skills that you believe you need to effectively negotiate with those individuals mentioned in the scenario. Justify your response.
  3. Compare and contrast at least two (2) different negotiation approaches that you would use when negotiating with the individuals mentioned in the scenario. Provide a rationale for your response.
  4. Outline a plan for your contract negotiation in which you specify at least two (2) different strategies that you can utilize, as needed, during the negotiation process.
  5. Stress the fundamental reasons why it is important for you, as a negotiator, to set the terms of the contract for your band, as opposed to allowing the opposing negotiation team to set those terms. Present two (2) reasons why you would not want to allow industry members to write the contract. Justify your response.
  6. You should use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources, but they may contain links to quality resources.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. Include a references page in proper APA format. The cover page and the references page are required but not included in the required assignment page length.