Instructions Deliverables: For this assignment you will enter several datasets into one Excel workbook and create the different graphs described below.Submit one Excel workbook containing one graph pe

Instructions

Deliverables:

For this assignment you will enter several datasets into one Excel workbook and create the different graphs described below.
Submit one Excel workbook containing one graph per worksheet. So just put each graph on the worksheet with the data. To get full credit you must label the chart axis and have a chart title.
Also save your copy of the workbook as an adobe(.PDF) file before you upload to Brightspace.
If you need a review on creating charts there is a link to several chart tutorials at the assignment link. https://qrfellowssps.commons.gc.cuny.edu/teach-yourself-excel/

Here are the graphs to create:

1. Bar graph: Create a worksheet named Bar-Graph. Enter the data found on pg. 89 Table 5.3 into this worksheet. Use this data to recreate the 2 bar charts shown in Figure 5.15 Bar graph comparison of patient profile data. (3 points)

2. Pie chart: Create a worksheet named Pie-Chart. Enter the data found on pg. 90 Table 5.4 into this worksheet. Use this data to recreate the 2 pie charts shown in Figure 5.16 Pie chart Comparison of patient profile data. (3 poins)

3. Scatter plot: Enter the data on pg. 80 (first listing of values) which is 15 observations of systolic blood pressure. Use this data to create the scatter plot shown in Figure 5.8 page 81. Hint: you will want to input the data in one column not one row as show in the text. And create a column header. You need two columns, one for each distinct (i.e. unique) blood pressure reading like 115 and one showing the frequency which is how many readings there are in the data for that distinct value. For example the frequency for 116 is two. (4 points)

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

In 2–3 pages: ANTISOCIAL PERSONALITY DISORDER Explain the controversy that surrounds your selected disorder.Explain your professional beliefs about this disorder, supporting your rationale with at l

In 2–3 pages: ANTISOCIAL PERSONALITY DISORDER Explain the controversy that surrounds your selected disorder. Explain your professional beliefs about this disorder, supporting your rationale with at least three scholarly references from the literature. Explain strategies for maintaining the therapeutic relationship with a patient that may present with this disorder.

Writing Sample for entry into graduate school for PMHNP-DNP. I have worked in pediatric emergency for six months (july 2024-feb 2025 RN) and home health care pediatric for 6 months, this coming janua

Writing Sample for entry into graduate school for PMHNP-DNP. I have worked in pediatric emergency for six months (july 2024-feb 2025 RN) and home health care pediatric for 6 months, this coming january 2026 (current job private duty RN). A document using APA rules of grammar. First person is permitted;

6- SOAP NOTES 1-Benign Prostate Hyperplasia 2-Asthma 3-Obesity 4-failure to thrive 5- anemia 6-Gastroenteritis

Complete the Question below:Explain why there is legal protections for occurrence reporting and peer review activities and how this facilitates performance improvement activities.Make sure you provid

Complete the Question below: Explain why there is legal protections for occurrence reporting and peer review activities and how this facilitates performance improvement activities. Make sure you provide a minimum of three references Submit as a Word document.

6- SOAP NOTES 1-Benign Prostate Hyperplasia 2-Asthma 3-Obesity 4-failure to thrive 5- anemia 6-Gastroenteritis

SOAP NOTES/APA FORMAT 1-Heart failure 2-Anemia 3- Lupus 4-Appendicitis 5-Pancreatitis 6-Hypothyoidism

For this assignment, you will read the below articles and then answer questions. List each question as a heading in your essay. Articles: How medical practices can continue the journey toward diversit

For this assignment, you will read the below articles and then answer questions. List each question as a heading in your essay. Articles: How medical practices can continue the journey toward diversity Inclusion, Diversity, Anti-Racism, and Equity (IDARE) Questions: Give an overall summary of this article. What is the main

Search the internet for “patient activation”. Define the term and determine how consumer informatics is related to patient activation? (1 page – APA style)

Soap notes 1-Heart failure 2-Anemia 3-BPH( Benign Prostatic Hyperplasia) 4-Hypothyroidism 5-Psoriasis 6-Lupus

Instructions You are the Privacy Officer at Happy Hospital. On 5/2/24 a local politician was admitted. He was discharged on 5/5/24. You have been monitoring access closely to ensure privacy was mainta

Instructions You are the Privacy Officer at Happy Hospital. On 5/2/24 a local politician was admitted. He was discharged on 5/5/24. You have been monitoring access closely to ensure privacy was maintained. You have received the Audit Trail for 5/5/24. Review the report and compile a list of which employees

Deliverables: Review Chapter 19 Case Study on page pg 386.Complete questions 1, 2 and 3TipsAnswer the questions fully.Have you ever worked in an organization that combined departments.Submit this assi

Deliverables: Review Chapter 19 Case Study on page pg 386. Complete questions 1, 2 and 3 Tips Answer the questions fully. Have you ever worked in an organization that combined departments. Submit this assignment as a Word document.Case Study Faced with rising costs and declining revenues, the board of directors

15 slide PowerPoint on Best practices for Spontaneous Breathing Trail in mechanical ventilation in respiratory care in the hospital , and how to prevent patient harm to our patients . Please include

15 slide PowerPoint on Best practices for Spontaneous Breathing Trail in mechanical ventilation in respiratory care in the hospital , and how to prevent patient harm to our patients . Please include pictures and valid information .

Respiratory Care 15 slide power point t on Best Practices for Spontaneous Breathing Trail in Mechanical ventilation ,and how to prevent patient harm. Slides Needs to be detailed with pictures , and v

Respiratory Care 15 slide power point t on Best Practices for Spontaneous Breathing Trail in Mechanical ventilation ,and how to prevent patient harm. Slides Needs to be detailed with pictures , and valid information.

Write a 4–6 page analysis of your previously selected current problem or issue in healthcare, including a proposed solution and possible ethical implications. Use scholarly information to explain a he

Write a 4–6 page analysis of your previously selected current problem or issue in healthcare, including a proposed solution and possible ethical implications. Use scholarly information to explain a he Write a 4–6 page analysis of your previously selected current problem or issue in healthcare, including a proposed solution and

MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONS OVERVIEW The Malpractice Apology Annotated Bibliography and the Malpractice Apology Research Paper are related assignments that require you to M

MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONS OVERVIEW The Malpractice Apology Annotated Bibliography and the Malpractice Apology Research Paper are related assignments that require you to MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONSOVERVIEWThe Malpractice Apology Annotated Bibliography and the Malpractice Apology ResearchPaper are related assignments that require you to research the existing literature and

Create a 2-4 page report on an interview you have conducted with a health care professional colleague. You will identify an issue from the interview that could be improved with an interdisciplinary ap

Create a 2-4 page report on an interview you have conducted with a health care professional colleague. You will identify an issue from the interview that could be improved with an interdisciplinary ap Create a 2-4 page report on an interview you have conducted with a health care professional colleague.