Question

I need help with the following by 11:30pm if possible- thank you!! Spreadsheet, Using Excel: On...

I need help with the following by 11:30pm if possible- thank you!!

Spreadsheet, Using Excel:

  1. On a nursing unit there are several employees. Use a spreadsheet to enter the data below.

Type of Employee

Number

Full Time Radiology Technician

24

Part Time Radiology Technician

22

Full Time Sonographer

20

Part Time Sonographer

16

Full Time MRI Technician

20

Part Time MRI Technician

12

Social Worker/Community Health

6

Laboratory/Phlebotomist

3

Registered Nurse

2

Pharmacist

1

  1. Determine the total number of employees on this nursing unit by creating a formula.
  2. Determine the percentage of each type of employee.
  3. Represent this data in three types of graphs/charts:
    1. a.      Bar Graph/Column Chart
    2. b.      Pie Chart
    3. c.      Line Chart
  4. Each graph or chart should including:
    1. chart title;
    2. x axes title for the bar and line graphs; and
    3. data labels for the bars or column, pie slices, and points on the line graph.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

g alpabet to esh fyre of erplare as at, 126 emplayes type ce empterdeon(Total No、of employee Alo of one tupe of empeyees x loieof each tye €) fultfrne ④ PastTione Radology Technician, 2느 Xtoo 이1,46% empng RadiologyTechnician-12cLx100。19.or% 2 ( 12-6y-axis 2.2.1 ( On 12-y each tire of 10 AL

from the above graph

FTRT- full time radiology technicians

PTRT- part time radiology technicians

FTS- full time sonographer

PTS-part time sonographer

FTMT- full time MRI technicians

PTMT- part time MRI technicians

SW- social worker

RN- registered nurse

Add a comment
Know the answer?
Add Answer to:
I need help with the following by 11:30pm if possible- thank you!! Spreadsheet, Using Excel: On...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • plz help asap Excel Spreadsheet: Part A: Use Excel to generate a spreadsheet with the following information. Co...

    plz help asap Excel Spreadsheet: Part A: Use Excel to generate a spreadsheet with the following information. Column A Enter the measured masses of sodium carbonate from data page #1 в Using stoichiometry, calculate the theoretical number of moles of CO2 that can be produced from each reactant entry. C Using the ideal gas law, measured volume, and temperature, calculate the theoretical pressure of CO2(g) that can be produced from the theoretical moles of CO2(8) D Actual measured pressures of...

  • Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank...

    Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank you so much. Cooper Pharmaceuticals, a specialty pharmaceutical company, has made significant investments to develop several product lines of 3D printed drugs. However, with patents on some of its most popular brand-name drugs expiring in the near future, the company is expecting a significant financial hit. As a result, the Finance Department has determined that only two of the five product lines under...

  • Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank...

    Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank you so much. Cooper Pharmaceuticals, a specialty pharmaceutical company, has made significant investments to develop several product lines of 3D printed drugs. However, with patents on some of its most popular brand-name drugs expiring in the near future, the company is expecting a significant financial hit. As a result, the Finance Department has determined that only two of the five product lines under...

  • COMPLETE THE FOLLOWING USING THE ATTACHED DOCUMENTS In this exercise, you will perform a financial statement...

    COMPLETE THE FOLLOWING USING THE ATTACHED DOCUMENTS In this exercise, you will perform a financial statement analysis for Water Feature Designers Inc. You will perform horizontal/vertical analyses and create charts to highlight key information from these analyses. You will also calculate financial ratios and insert cell comments. Use this information to complete the ratio analysis. Ratio Current Ratio Debt-to-Equity Ratio Profit Margin 2016 7.62 0.17 .186 2015 3.45 0.28 292 2014 8.21 0.18 255 1. Open EA9-A2-FSA from your Chapter...

  • need part 3, 4, 6, 7 help All work must be completed using this Excel spreadsheet....

    need part 3, 4, 6, 7 help All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form. Reference your textbook and past courses for examples or templates to mod Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the Excel Notes section below....

  • Please help me write in C++ language for Xcode. Thank you. In this lab you are...

    Please help me write in C++ language for Xcode. Thank you. In this lab you are going to write a time card processor program. Your program will read in a file called salary.txt. This file will include a department name at the top and then a list of names (string) with a set of hours following them. The file I test with could have a different number of employees and a different number of hours. There can be more than...

  • please do all steps. i really need help thank you! PR 4-6B Complete accounting cycle Obj....

    please do all steps. i really need help thank you! PR 4-6B Complete accounting cycle Obj. 4,5 For the past several years, Jeff Horton has operated a part-time consulting business from his home. As of April 1, 20Y6, Jeff decided to move to rented quarters and to operate the business, which was to be known as Rosebud Consulting, on a full-time basis. Rosebud entered into the following transactions during April: Apr. 1. The following assets were received from Jeff Horton...

  • sseument Part& Pretected Viei)Word Mailings Review View Help Tell me what you want to do Enable Editing ruses. Unless you need to edit, it's safer to stay in Protected View 1. Two va...

    sseument Part& Pretected Viei)Word Mailings Review View Help Tell me what you want to do Enable Editing ruses. Unless you need to edit, it's safer to stay in Protected View 1. Two variables have a strong negative correlation. Which of the following statements is not true? a. the dependent variable decreases as the independent variable increases b. the trend of the data exhibits an irregular decline c. the line of best fit has a negative slope d. most data points...

  • I need help to write a nice introduction for experiment 6 please ( no hands write ) typing Thank you HEAT TREATMENT OF STEELS EXPERIMENT 6 EXPERIMENT 6 HEAT TREATMENT OF STEELS THEORY The Ef...

    I need help to write a nice introduction for experiment 6 please ( no hands write ) typing Thank you HEAT TREATMENT OF STEELS EXPERIMENT 6 EXPERIMENT 6 HEAT TREATMENT OF STEELS THEORY The Effect of Cooling Rate One of the most convenient methods for controlling the properties of a given steel, i.e., a steel whose composition is already fixed, consists of austenizing the steel and ten cooling to room temperature at some predetermined rate. A variation of cooling rates...

  • could you please help me with this problem, also I need a little text so I...

    could you please help me with this problem, also I need a little text so I can understand how you solved the problem? import java.io.File; import java.util.Scanner; /** * This program lists the files in a directory specified by * the user. The user is asked to type in a directory name. * If the name entered by the user is not a directory, a * message is printed and the program ends. */ public class DirectoryList { public static...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT