Construct a frequency distribution showing

Assignment Help Finance Basics
Reference no: EM131624712

Case 1:

Scenario: Cloud Data Services (CDS), headquartered in Memphis, provides information technology services, specifically application hosting services in the cloud for several clients in the southern United States. CDS hosts software applications on their network servers. While CDS has achieved great success and customers rate CDS's services highly, lately, some customers have been complaining about downtime on one of the primary network servers. The given dataset, found in the Signature Assignment Excel® Template, contains the downtime data for the month of November.

Use the data analytics skills learned in Week 3 and analyze the downtime data.

Make a short presentation to CDS's management including the following:

  1. Using used Microsoft® Excel® Pivot Tables, construct a frequency distribution showing the number of times during the month that the server was down for each downtime cause category.
  2. Develop a bar chart that displays the data from the frequency distribution in part 1.
  3. Develop a pie chart that breaks down the percentage of total downtime that is attributed to each downtime cause during the month.
  4. Evaluate the mean, median, standard deviation, and variance of the downtime minutes for the month of November.

Reference no: EM131624712

Questions Cloud

Contraction of a firm current operations : Is it ever possible that a financial plan would call for a decline in sales and thus contraction of a firm's current operations?
Provide the journal entries necessary to account : Provide the journal entries necessary to account for the above transactions and events for the year ended 31 December 2016 for T
Investments and economies of scale considerations : How might "lumpy" capital investments and economies of scale considerations affect how one uses the Percent-of-Sales forecasting method?
Define the case or statutory law : Summarize as briefly as possible the reasons given by the court for its decision or decisions and the case or statutory law
Construct a frequency distribution showing : Using used Microsoft® Excel® Pivot Tables, construct a frequency distribution showing the number of times during the month that the server was down.
Define your data collection strategy : Define your data collection strategy, which includes developing survey questions. Develop six questions for your survey.
Define the given type of third parties : Common Law Liability to Third Parties. Flacco, CPA, conducted the audit of Raven Company and issued an unmodified opinion that concluded that the financial.
What is the per unit opportunity cost of selling : Using the transfer pricing formula, what is the per unit opportunity cost of selling one unit of durian juice concentrate to Juice Division
In what ways have we become more connected with cultures : We have talked about globalization and identity for the past several weeks. In what ways have we become more connected with other cultures?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is npv of plane b on a ten-year equivalent life basis

What is the NPV of plane B on a ten-year equivalent life basis? $27,047,879 $8,143,286 $9,255,576 $21,595,356 $12,677,537.

  What minimum sample size of randomly selected pregnancies

what minimum sample size of randomly selected pregnancies should you select?your criteria changed you randomly sample

  What is the nav of a fund share

The fund itself has 1500 of its own shares outstanding. What is the NAV of a fund's share?

  Record the payment of the note by trico at maturity

On August 1, 2012, Trico Technologies, an aeronautic electronics company, borrows $20 million cash to expand operations. The loan is made by FirstBanc Corp.

  What are the equivalent units of production for conversion

In May, the company started 445,300 and completed 427,500 units. May's ending inventory was 30 percent complete as to conversion.

  What will be the difference after 30 years between two optio

If an investor wants to contribute $15,000 before taxes to an IRA, what will be the difference after 30 years between the two options? Assume that the investor is currently in the 25% tax bracket, and that the IRA will earn 6% per year.

  What is the subscription price

Keira Mfg. is considering a rights offer. The company has determined that the ex-rights price would be $76. The current price is $90 per share, and there are 36 million shares outstanding. The rights offer would raise a total of $60 million. What ..

  Compute the net investment required for project

LISP Corporation is considering to buy a new dubber for $50,000. The new equipment will replace an older mixer that has been fully depreciated but has a salvage value of $5,000.

  Estimate the pre-tax return on capital

a. Estimate the pre-tax return on capital, by year and on average, for the project. b. Estimate the after-tax return on capital, by year and on average, for the project. c. If the firm faced a cost of capital of 12%, should it take this project.

  What is the current bond price

If the YTM on these bonds is 5.3 percent, what is the current bond price?

  Estimates obtained from the credit and collection department

Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 15%; collections during the month following the sale, 65%; collections the second month following the sale, 20%.

  What were specific reasons why gold standard was eliminated

What were the specific reasons why the gold standard was eliminated? How does a floating exchange rate system work? What is managed float or a managed floating exchange rate system?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd