basic excel homework 1

/in /by

merge the two excel datasets then

  • Go to the GINI coefficient dataset and delete all irrelevant columns as well as all data preceding the year 1990
  • Use the V-Look up or Match-Index combination to merge each country with its appropriate geographic region. There may be countries/country codes that are misspelled and some entries that are not countries that need to be removed. You need to take care of both issues.Feel free to remove any entries that give you a lot of trouble, but try to avoid that as much as possible.
  • Once you have every country matched with its corresponding region, create a list of GINI coefficients averaged out for each year for a given region. You can do that using filters and sorting functions. Feel free to use any other method. Ignore the missing values in the average.
  • Finally, you will end-up with a list of the world regions and a GINI coefficient average for each year. Graph that on one graph.

GRADING:

  • A sheet showing the following after the merge:(4 – 6 pages maximum) (5 pts for organization)
    • A column numbering the rows. 1,2,3,….,etc.(2 pts)
    • The country Code(2 pts)
    • The country name (abbreviated if necessary) (1 pts)
    • Region (5 pts)
    • The country data for the following years: 1990, 2000, 2010, and 2014(10 pts)
  • One sheet showing the aggregated averages over all years between 1990 – 2014 for the different World Regions. For submission, you will need to transpose this so that the Years are on the rows and the regions are the columns. (Less than 4 pages). (20 pts)
  • One sheet displaying the graph of all the trends from 1990 – 2014 for all world regions(10 pts)
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

i need to make powerpoint presentation for my paper 1

/in /by

I already write my paper and I need you to make the presentation as the the following

You must follow the direction 100%

This assignment involves making a Powerpoint presentation of 15-20 slides (not counting the title slide and reference slide-so really your slide range needs to be 17-22).

Use the slides to teach your classmates about your problem: its historical underpinnings and its contemporary existence, what social policies have been promoted to address your problem and which policies have been suggested if not implemented, public perception of your social problem, as well as media depiction.

Make your presentations visually engaging but stimulating-this involves a mix of meaningful images, charts and graphs, and text. I am requiring the following:

1.Must include at least 3 charts/graphs

2. Must include 5 references to source material (your sources used in Blog 2/final paper)

3. Must include 2 relevant hyperlinks-this could be to a video, news story, podcast

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

discussion 2 critical thinking challenges

/in /by

Data is collected, used, and presented in various ways in order to describe situations or events. When reviewing statistics, one must often filter through the presentation in order to get to the true story of what the data means.

To prepare for this Discussion, explore the unique Cancer.org calculator in this week’s Learning Resources to see an example of a filter that uses statistical data presented in a way to which most people can immediately relate.

Post a short, 200- to 250-word report that analyzes the cost of cigarettes in your area. Research the average cost of a pack of cigarettes in your area. Then, using the Cancer.org calculator, determine the cost per day for 1 year of smoking. Be sure to mention the brand of cigarettes that you used for your calculation.


https://www.cancer.org/healthy/stay-away-from-toba…

http://home.ubalt.edu/ntsbarsh/Business-stat/opre5…

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

discussion 912

/in /by

Globally disbursed organizations have a wealth of resources that are available to them, especially when it comes to implementing its business continuity plan to continue operations. Apart from the unlimited availability of funds, many of these organizations have brand recognition and can resume its services based on its name alone, if it needs to relocate. Small businesses do not have the same financial, technology, personnel resources availability. Furthermore, they are deficient in brand recognition outside of its immediate demographic location. So when disasters occur, it often cripples a small businesses ability to continue its operations, and a number of these smaller operations closes its doors.

Because small businesses do not have the financial resources, it is possible for them to develop a business continuity plan? Being mindful of its financial limitations, what are five components that a small business should focus on in its business continuity plan? Explain why these components are essential. If a business continuity plan is not financially achievable for a small business explains why it is not economically feasible. What options will they have? Think about Federal or state government assistance and support. Is the government obligated to help smaller businesses restore its operations? If yes, explain. If not, explain. Is the government obligated to offer small companies assistance on a personal level, business level, or both? Explain your answer. What government resources can assist small businesses after a disaster strikes? Are small businesses guaranteed to secure these resources?

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

can someone fill out the assumptions and reasoning for the assumptions for the given data for southwest airlines

/in /by

Table 1

Assumptions for ValuePro.net Valuation

Company Name – Southwest Airlines (LUV)

ValuePro.net Assumptions

Your Assumptions

Explain the Reasoning for Your Assumptions

Excess Return Period (Years) (10 years is appropriate)

10

Revenues ($ mil) (From Income Statement)

17182.00

Growth Rate (%) (Estimated Annual Growth Rate in Earnings in Future)

14.00

Net Operating Profit Margin (%) (EBIT from Income Statement)

4.01

Tax Rate (%) (From Income Statement: Taxes / Earnings Before Taxes)

38.54

Stock Price ($) (Current Price per Share)

59.37

Shares of Stock Outstanding (mil.) (Be careful with decimal)

722.30

10 Yr. Treasury Bond Yield (%)

5

Bond Spread to Treasury (%) (1.5 is appropriate)

1.5

Preferred Stock Yield (%)

7.5

Depreciation Rate (%) (Percentage of Revenue; Calculate)

4.94

Investment Rate (%) (Percentage of Revenue for Capital Expenditures – Calculate)

7.89

Working Capital (%) (Percentage of Revenue – WC is Current Assets; Calculate)

-1.79

Short Term Assets ($ mil.) (Current Assets from Balance Sheet)

4514

Short-Term Liabilities ($ mil.) (Current Liabilities from Balance Sheet)

5708

Equity Risk Premium % (Should be between 5% and 6%)

3

Company Beta for Stock (Number) (Look up Beta)

1.05

Value (Book) of Debt Outstanding ($ mil.) (L-T + S-T Debt from Balance Sheet)

2708

Value Preferred Stock Outstanding ($ mil)

0

Company WACC (%) (Look up or Calculate)

7.9
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

inventory and purchasing considerations

/in /by

Based on your Learning Team’s earlier work, your department’s forecasting recommendation has made vast improvements to the Hangzhou, China on-time deliveries. However, the company president has concerns the resin inventory levels are not ordered in the most optimal quantities. The purchasing department needs your team’s help on when and how much to order.

Prepare a 700-word paper defining inventory management and how inventory relates to costs. Conclude with a recommendation to use an inventory ordering strategy keeping in mind the certainty or uncertainty of the customer demand at the Hangzhou, China location.

Only Provide a 200 Word Response to the following for the above:

Identify and discuss the strategies of when to order (re-order points – ROP) and how to order (economic order quantities – EOQ).

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

crm project 3

/in /by

Based on the CRM work you have done throughout this course, you are now called on to act as a consultant to apply your knowledge to other industries that have an existing CRM program that would be beneficial to employees and organizations to reduce human error and improve employee efficiency.

Select one agency that employs a CRM program.

Research how this agency employed a CRM program in a similar or different way than was identified in the aviation article from Week 2.

Write a 1,400- to 1,750-word paper in which you provide evidence of how this CRM program was implemented. Include the following in your response:

  • Distinguish between various team concepts as they relate to performance during and after this training program.
  • Explain the difference between leaders and managers, as well as the influence and power they may have on the success of this program.
  • Evaluate at least two theories of leadership and the role that leaders utilizing these theories play in facilitating this program.
  • Analyze the general effects on the organization that may result from this program, referencing the concepts of organizational development and various organizational theories.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

explain the concept of true collaboration in health care and describe the benefits of effective interdisciplinary

/in /by

Overview

Explain the concept of true collaboration in health care and describe the benefits of effective interdisciplinary collaboration. Then, describe the characteristics required for effective collaboration, describe barriers to collaboration, and offer evidence-based strategies to overcome those barriers.

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

SHOW LESS

  • Competency 1: Explain the principles and practices of highly effective interdisciplinary collaboration.
    • Explain the concept of collaboration in health care.
    • Describe the characteristics and concepts required for effective interdisciplinary collaboration.
    • Describe barriers to effective interdisciplinary collaboration.
    • Identify evidence-based strategies to overcome barriers to effective interdisciplinary collaboration.
  • Competency 3: Explain the internal and external factors that can affect the health of individuals, families, communities, and populations.
    • Describe the benefits of effective collaboration and teamwork in health care for patients, organizations, and team members.

    Context

    Every day, in every patient setting, health care professionals must interact with other health care professionals, as well as with providers from other professions to share information, conduct safety and quality checks, and work with patients in a variety of ways to make sure they understand their health care needs and will be more likely to comply with treatment plans.

    Research consistently shows that interdisciplinary collaboration and teamwork improves the quality and safety of patient care by recognizing the skills and experience of each team member, allowing the team to function more effectively and efficiently.

  • Assessment Instructions

    You are part of an interdisciplinary team that has been highly effective. Your supervisor asks you to write a short article about why the team has been so successful and submit it to the organizational newsletter for publication.

    Preparation

    Search the Capella library and the Internet for peer-reviewed journal articles on collaboration and teamwork in health care. You will need at least 3 articles to support your work on this assessment.

    Directions

    In the article you write for this assessment, be sure you do the following:

    • Explain the concept of true collaboration in health care.
    • Describe the benefits of effective collaboration and teamwork in health care for the following groups:
      • Patients.
      • Organizations.
      • Team members.
    • Describe the characteristics and concepts required for effective interdisciplinary collaboration.
    • Describe barriers to effective interdisciplinary collaboration.
    • Identify evidence-based strategies to overcome barriers to effective interdisciplinary collaboration.
    • Format this assessment according to current APA style and formatting guidelines.

    Additional Requirements

    • Include a title page and reference page.
    • Ensure your assessment is 3–4 pages.
    • Use double-spaced, 12-pt., Times New Roman font.

    Collaboration and Teamwork in Health Care Scoring Guide

    CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED
    Explain the concept of collaboration in health care. Does not explain the concept of collaboration in health care. Explains the concept of collaboration but not in the context of health care, or the explanation is missing key elements. Explains the concept of collaboration in health care. Explains the concept of collaboration in health care and describes the unique aspects of collaboration in health care.
    Describe the benefits of effective collaboration and teamwork in health care for patients, organizations, and team members. Does not describe the benefits of effective collaboration and teamwork in health care for patients, organizations, and team members. Describes the benefits of effective collaboration and teamwork in health care for patients, organizations, or team members (or two of these) but not all three. Describes the benefits of effective collaboration and teamwork in health care for patients, organizations, and team members. Describes the benefits of effective collaboration and teamwork in health care for patients, organizations, and team members and considers the consequences of ineffective collaboration and teamwork.
    Describe the characteristics and concepts required for effective interdisciplinary collaboration. Does not describe the characteristics and concepts required for effective interdisciplinary collaboration. Lists the characteristics and concepts required for effective interdisciplinary collaboration. Describes the characteristics and concepts required for effective interdisciplinary collaboration. Describes the characteristics and concepts required for effective interdisciplinary collaboration and explains how each contributes to more effective collaboration.
    Describe barriers to effective interdisciplinary collaboration. Does not describe barriers to effective interdisciplinary collaboration. Identifies barriers to effective interdisciplinary collaboration. Describes barriers to effective interdisciplinary collaboration. Describes barriers to effective interdisciplinary collaboration and considers possible causes for the barriers.
    Identify evidence-based strategies to overcome barriers to effective interdisciplinary collaboration. Does not identify evidence-based strategies to overcome barriers to effective interdisciplinary collaboration. Identifies strategies to overcome barriers to effective interdisciplinary collaboration but does not provide supporting evidence. Identifies evidence-based strategies to overcome barriers to effective interdisciplinary collaboration. Identifies evidence-based strategies to overcome barriers to effective interdisciplinary collaboration and suggests methods for implementing the strategies.
    Write content clearly and logically, with correct use of grammar, punctuation, and mechanics. Does not write content clearly, logically, or with correct use of grammar, punctuation, and mechanics. Writes with errors in clarity, logic, grammar, punctuation, or mechanics. Writes content clearly and logically, with correct use of grammar, punctuation, and mechanics. Writes clearly and logically, with correct use of spelling, grammar, punctuation, and mechanics; uses relevant evidence to support a central idea.
    Correctly format paper, citations, and references using current APA style. Does not correctly format paper, citations, and references using current APA style. Uses current APA to format paper, citations, and references but with numerous errors. Correctly formats paper, citations, and references using current APA style with few errors. Correctly formats paper, citations, and references, with no errors.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

big data assignment

/in /by

its about big data assignment please see the file that i attach THANKS

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

analyzing data and writing your report 1

/in /by

I attached the previous paper you wrote for the last part of this course project.

In this portion of the course project, you will analyze your data in the following ways:

  1. Effectively record data, back-up the data and store a master copy – keeping original data intact.
  2. Sum the number of ratings, rankings, yes or no, etc. for each question.
  3. Find the mean, or average, for each question.
  4. Find the standard deviation and the z-score for each question.
  5. Infer results or draw conclusions.

Note: You do not need to submit your analysis separately, instead, you will include your analysis in your written report (the tenth element of the written report). Remember that your analysis can (and likely should!) include important visual aids for your readers, including charts, graphics, and tables.

Based upon your analysis, develop recommendations, think about limitations of the research, and write your final report. The report should include the following elements:

  1. Cover page
  2. Executive summary
  3. Table of contents
  4. Introduction
  5. Problem statement
  6. Research objectives
  7. Background research/literature review
  8. Sampling design
  9. Research design
  10. Data analysis (may include visual aids – bars, charts, graphs, etc).
  11. Limitations
  12. Findings
  13. Conclusions
  14. Recommendations
  15. References

Be sure to distinguish between the various sections of the report by utilizing headings. Each of the 15 elements will be a major heading, which should be bolded and centered. If minor headings are used, they should be bolded and aligned left. The cover page, executive summary, table of contents, and reference page should all be on stand-alone pages.

Keep in mind, a number of these elements were previously submitted. Be sure to review the feedback you received from your instructor and make recommended edits or updates. Also, consider restructuring the written elements as needed in order to include them in the final report (for example your problem statement may have stated what you will research, and now it is something you have researched, so your tense may change).

The report should be written according in APA style. Learn more about APA formatting here.

There is no length requirement, but most reports will be approximately 8 pages; your report may be longer depending on the demands of research and analysis conducted. The cover page, table of contents, and references page are should not be included in the page count. The executive summary may be included in the page count.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!