do excel 04

/in /by

1

Download and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has automatically added your last name to the beginning of the filename.

2

Freeze Panes so the first row containing column headings (Row 5) on the SupportCalls worksheet will remain static when scrolling. Ensure that Rows 1-4 are visible.

3

Convert the data to a table, name the table SupportCalls, and apply the Gold, Table Style Medium 12.

4

Remove duplicate records.

5

Add a new column to the table named Duration.

6

Create a formula using unqualified structured references to calculate the days required to resolve the incident (Date Resolved – Date Created).

7

Add a total row to display the Average days required to resolve an issue.

8

Sort the table by Agent Name in alphabetical order, add a second level to sort by Description, and create a custom sort order as follows: Won’t power on, Virus, Printing Issues, Software Update, Forgotten Password. Add a third level to sort by Duration smallest to largest. (Mac users, to create the custom list, from the Excel menu, click Preferences. In the dialog box, click Custom Lists.)

9

Filter the table to only display closed incidents as indicated in the status column.

10

Use Quick Analysis to apply Data Bars conditional formatting to the Duration column (range I6:I85). Mac users, on the Home tab, click Conditional Formatting, and under Solid Fill, click Blue Data Bar.

11

Create a new conditional format that applies Red fill and bold font to incident (range A6:A85) that required 30 or more days to resolve.

12

Change page breaks so page 2 begins with the Computer ID column (column E).

13

Set the print scale to 85%.

14

Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

15

Save and close the workbook. Submit the workbook as directed.

seccurities calculation

/in /by

  1. (25 pts) Choose a company that has recently (in 2019) had an initial public offering of its common stock.
  2. What company did you choose and what was your reason for choosing it? Go to yahoo finance.com and then put in the name or ticker symbol of your company. Below is what you would see if you chose Lyft, for instance. https://finance.yahoo.com/quote/LYFT?p=LYFT&.tsrc=fin-srch (Links to an external site.)

Please provide, as part of the project, a screen shot of the summary page you will see when you open the site.

  1. Which investment banking firm served as the managing underwriter? Explain the services that a managing underwriter provides in an IPO.
  2. What was the performance of the stock immediately after the company went public? Comment on the likely reaction to that performance by the following IPO participants: company management, investors and underwriter?
  3. (25 pts) Suppose you plan to buy 1,000 shares in your company today.
  4. Which market does the company’s stock trade on. Chances are it will be either the NYSE or NASDAQ. What is the difference between those two markets? Speculate on why your company may have made the choice that it did.
  5. Based on the differences between a discount firm and a full service firm, how would you decide which kind of investment firm to use.
  6. (Extra credit: If you purchased your shares through a discount firm that made a profit based on acting as a dealer, what would be your maximum dollar cost of the transaction?)
  7. Would you enter a market order or a limit order? (This can be an arbitrary decision.)
  8. If you decide to purchase the stock through a market order, discuss some of the paths that the order might take to fill your order. What about the path of a limit order?
  9. What are the main kinds of limit orders and what purpose do they serve for the investor?
  10. (Extra credit: From your textbook and/or other sources, describe what dark pools and ECNs are and who uses them.)
  1. (20 pts) Suppose you have a great deal of confidence that the 1,000 shares you want to buy are selling at a real bargain price and you would like to purchase more than 1,000 shares by using a margin account. Assume the call rate is 5% and the Fed has established 50% as the maximum about you can borrow against the stock.
    1. Using the current price of the stock, what will be your annualized return on a 1,000 share investment if the stock goes up in price by 20%, at which time you sell it. What will that return be if the stock goes down by 20% in two months and you sell it then?
    2. Given the facts above, what will be your annualized return if you purchase twice the number of shares by borrowing with a 50% margin. (Make the calculations using the two assumptions in a. above)
  2. (15 pts) Suppose you have the opposite view and you think that the shares will fall in value and that you can make money by entering into a short sale using current prices.
    1. What will be your profit if you are correct and the price of the stock falls by 30% in the next two months, at which time you close out your short position.
    2. What will be your loss if you are wrong and the price of the stock increases by 30?
    3. (Extra credit: Is there a limit to the amount of money you can lose if you guess wrong in a short sale. Explain.)
  3. (15 pts) Go to the Yahoo Finance summary page and select “Options” in the top bar.
    1. Select a call option expiring in November allowing exercise at a price slightly higher than today’s price. If the price of the stock goes substantially above the exercise price, will you make a profit? Give an example to illustrate the amount of profit you could make. What will be your profit if the price of the stock does not go above the exercise price prior to expiration
    2. Now select a put option expiring in November. Give an example to illustrate how much money you could make if the price of the stock goes well below the exercise price. What will be your profit if the price of the stock does not go below the exercise price prior to expiration

2 pages writing 10

/in /by

Hello,

this is a 2 pages writing , please read the instructions carefully before writing.

download the zipped file for the information and PLEASE when you finish upload in a ZIP or RAR file otherwise I will not take it.

Thank you

summarize a court s interpretation in a case involving online protection of a patent cite both the case and statute using standard legal notation

/in /by

Please write an essay of not less than 500 words, summarizing a court’s interpretation in a case involving online protection of a patent. Cite both the case and statute using standard legal notation.

Please include a hyperlink to the three cases.

APA Format

business management capstone project

/in /by

IT Capstone Proposal

ASSIGNMENT: 1

Choosing a capstone IT project. Provide an overview of the research or information technology project that you would like to do for your capstone. This research/project should be something new and achievable within the current semester.

Suggested research might be some technology that is influencing your organization.

Suggested projects may include: A project proposal to introduce a new technology into your organization. While this may be a project, APA style formatting and academic research components will still be included in this document.

OUTLINE SHOULD LOOK LIKE THIS:

Cover Page (1 page)

Body of the paper should include these sections

Introduction – what is it that you’re going to tell the reader. Introduce your intent.

Description of the problem addressed

Research – discuss why you are researching this topic and the benefit to the organization

Project – discuss the organizational problem that the implementation of your project will address.

Conclusion. Sum up what you told the reader. Close out your intent and next steps.

** Keep in mind that this research/project paper is only a proposal and that the research. You will be setting up a research proposal or a project proposal but won’t be implementing. This should be a document that you could take to work and

Length: 6-8-page APA written paper (this does not include the cover and references page)

Points: 125/1000 points



Assignment: – 2

STATUS REPORT

This 1-2-page document (single spaced) is an opportunity for you to discuss where you are on your research/project proposal. Discuss things such as:

Items you are currently working on

Research you’ve conducted so far – share references (in APA format) and tell me how the research is going

What you’d like to have completed by the end of the module and a timeline for completion

If there’s anything you need from me in order to move forward.

This status report may not be submitted late. It is intended to submit by the end of this current module.

Blackboard Submission: This assignment will be submitted through this Blackboard link.

Length: 1-2-page status report.

Points: 25/1000 points

phil110 discussion response 2

/in /by

Hello,

I need two responses of at least 150 words each for the below students discussions for this week. Also in the bold below are the questions the students at answering.

Goal: Reflect on how different professions use critical thinking.

Hopefully, you all have this by now, please post to the thread provided.

Description:

All professions use critical thinking to get the job done. No matter who you are or what job you have, every day brings problems that need to be rectified using critically thinking.

– Go the Program Guide in the APUS Library and find your program or the program you intend to study. If you are working toward a general studies degree or cannot find your exact program guide, see if you can find one that is close. If you are unable to do that, then just talk about your job or profession.

– Think of a problem that occurs or might occur in that profession and describe the critical thinking steps that would need to be taken to remediate or resolve the problem. Consider how the person determines the problem, the information needed, tools, options, and possible outcomes, as well as criteria used to make the decision.

– While completing the forum consider the Week 4 trigger questions.

How does critical thinking differ in varied professions?

How does critical thinking in an emergency room compare with that in a court room?

How do professions arrive at their

decision-making strategies?

What does a good argument look like?

What is a thesis statement?

How does evidence relate to a thesis statement?

What can you learn from reading an essay written by an expert in a field?

How is such an essay reviewed?

Student one:

Markedly, critical thinking is where one improves the qualities of a task by the use of analysis. It is usually required in operational activities since operation of an individual and other professions are detailed and necessitated to analyzing choices and steps deemed critical. Additionally, it consists assuming and identifying challenges, recognizing and understanding important for the context. Notably, various people possess abilities in landing great jobs and applying critical thinking effectively and successfully.

Since it is never an inherited quality, it develops with time because of the human instincts which ensures us in thinking. For one to make best choices, a person needs to recognize and realize available information plus precise methods of evaluating the type of information. Furthermore, advancement in critical thinking can be performed by emphasizing processes that easily require a lot of pressure. For instance, I was not good in doing homework perfectly in my early education levels because I never knew the tools and techniques. Through passing time, I perfected my abilities of critical thinking and lucky to have amazing teachers and supportive guardians who always helped me.

Besides, I was not hesitant in seeking help and asking questions that easily confused me. For example, I got keener in realizing and knowing answers of asked quiz and gaining proper attitudes for exploring solutions to challenges. With Perry model, I believe that relativism level of mine relate to points mentioned and absolute truths never exist in this universe as it is subjective and not included in objective things. Also, objectivity of truths are felt by using critical thinking models. In addition, every individual possess methods of analyzing and thinking on certain arguments and situations.

-Devlin

Student two:

My desired career route, and degree plan, is that of Business Management. Often times when I say that to people they ask me, if I plan on going the entrepreneurial route. I don’t think so at first, but possibly at one point or another in the future. My primary plan is to apply my degree in a federal agency capacity. Primarily I’d like to be involved in the ATF (Alcohol, tobacco, firearm and explosives). With this being a goal of mine due to their involvement in many issues. For my response to this week’s topic question. I can see many different scenarios that could be dealt with by critically thinking. For instance during a case building process, and having to build up a case file, so that I might either convict or confiscate said good(s). It may involve having to gain enough from that specific case, scene, and or individuals, so from that I might’ve been granted a search warrant or even an arrest warrant. Another scenario might be one of having to serve a warrant. One option might be to just serve it with my partner or consider having a larger force accompany us. Depending on the severity or criminal histories. I believe that this, is as equally impactful as many other federal agencies. A recent headline or fiasco that the ATF was involved with was the “Fast and Furious” events. The government had released guns as a form of sting operation, so that they would be able to track cartel activities. With this being a huge failure. Critical thinking suggests that it had a positive intent. Great topic question this week! Thanks for reading. I look forward to you responses!

Sources:

https://www.google.com/amp/s/amp.cnn.com/cnn/2013/…

https://www.google.com/amp/s/www.nationalreview.co…

https://www.atf.gov/

-Jonathan

benchmark article review

/in /by

Benchmark – Article Review

For this assignment, select a peer-reviewed journal article relating to an area of problem solving, decision making, or an intelligence theory that was discussed in class (e.g., fluid or crystalline intelligence, primary/secondary reinforcers, biases, or effective problem-solving strategies).

The article must meet the following criteria:
1.The article must be from a peer-reviewed journal.
2.The article must be obtained from the GCU Library.
3.The article must be a research study, rather than a literature review (i.e., the article has to have methods, results, and discussion sections).
4.The article must utilize a cognitive or behavioral theory, model, or effect.
5.The purpose of this article review is to get you to think critically about an area of cognition or learning. After reading your chosen article, address the following questions. Use subheadings to differentiate between the various aspects of your review. Remember, APA guidelines can be found in the APA Style Guide, located in the Student Success Center.

Major Findings/Conclusions:
1.Be sure to include the major findings of the study.
2.What conclusions did the researchers draw from the data?

Implications for the Field of Psychology (how the findings could be used/applied in the field):
1.Include how the results of the study can be applied (e.g., why are the findings of the study important?). These may be the implications the authors put forth, or your own ideas (be sure to cite if they are not your ideas).
2.How would psychology/education/counseling professionals benefit (learn) from the findings?
3.How might the results improve knowledge or application in the field? What should psychology professionals “take away” from the findings?

Method/Participants:
1.Describe the basics of how the study was conducted. What procedures were used?
2.Who were the participants?

Strengths/Limitations of the Study:
1.Include at least one strength AND one limitation you saw in the study.
2.Explain why you believe each is a strength or limitation. Hint: study findings are not “strengths” in and of themselves.

The article review should be 1,000-1,250 words. Include a minimum of three scholarly articles.

Prepare this assignment according to the guidelines found in the APA Style Guide

content delivery network providers

/in /by

Topic: Content Delivery Network providers

Question: Descriptive Comparison of each service provider listed below.

  • Microsoft Azure
  • Akamai

Need to Focus on:

  • Major Differences
  • Which provider do you think works best for hosting a real estate company located on the East Coast of the U.S based on price, performance, and features?

Instructions:

  • Need minimum 500 words
  • Need 5 APA References (Use 2015 and above sources)
  • No Plagiarism please

data analysis 01 company spreadsheet

/in /by

Assignment -Properly formatted Balance sheet and income statement from your foreign company based in the country you will do the Country analysis on, must be in Excel spreadsheet and all formulas working.

The foreign company is Poland

2 3 page paper describe the metric s you will use to evaluate the organization s productivity

/in /by

Read Case 3: Physician Care Services, Inc., including Tables 3.2 and 3.3. Review the issues that surround provider productivity, to evaluate whether the organization can be successful in the new era of health care reform.

The Assignment:

In 2–3 pages, describe the metric(s) you will use to evaluate the organization’s productivity. Explain how you will use the metric in evaluating productivity, and how the data will help measure the potential of the organization’s success in the new era of health care reform.