Construct a frequency distribution

Assignment Help Finance Basics
Reference no: EM131628106

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: EM131628106

Questions Cloud

How are organizations using social media : What is social media?How are organizations using social media?What are the pros and cons of using social media?
What are the needs and attitudes of your audience : Who are your audience (receiver)? What are the needs and attitudes of your audience? What are you trying to achieve? Consider short and long term goals.
Find first year depreciation if macrs cost-recovery is used : The Genesceo Citrus Farm placed 3,060 tangerine trees into service at a cost of $50 per tree. What is the first year's depreciation if MACRS cost-recovery?
Explain time value of money : Time Value of Money, Pick three of these formulas and explain why you think they are valuable in making real estate decisions
Construct a frequency distribution : Using used Microsoft® Excel® Pivot Tables, construct a frequency distribution showing the number of times during the month that the server.
Provide a summary of what message each writer is trying : Provide a summary of what message each writer is trying to get across, and provide a brief compare and contrast analysis of the two pieces.
Effective managers stay abreast of current hr topics : Some relevant issues facing today's managers include: global HRM, labor relations, social media, whistleblower rules, e-HRM/self-service .
Why would congress have power under the civil rights act : Why would Congress have power under Civil Rights Act of 1964 to require restaurants and hotels to not discriminate against interstate traveler on basis of race.
Find the depreciation using the macrs method : Use the MACRS method to find the depreciation for the 17th year of a municipal sewer that is placed in service at midyear as a 20-year property with a cost.

Reviews

Write a Review

Finance Basics Questions & Answers

  Finding break-even point

Air Filter, Inc., sells its products for $6 per unit. It has the following expenses, Separate the expenses between fixed and variable expenses per unit. Using this information and the sales price per unit of $6, compute the break-even point.

  Calculate the net present value payback profitability

Using a 4.5% discount rate, calculate the Net Present Value, Payback, Profitability Index, and IRR for each of the investment projects below (note, the inflows are for each year). Based on your calculations rank the projects and support you answer

  How many years will it take for you to double your money

You are currently investing your money in a bank account that has a nominal annual rate of 7 percent, compounded annually. How many years will it take for you to double your money?

  Please review listed projects by providing npv

Please review listed projects by providing NPV, IRR, PBP, B/Cratio and do not forget social legitimacy needs and select the ones that should be brought to the attention of the owner for investment consideration.

  What is the inflation premium expected at this time

A. If the real rate of interest is expected to be 3 percent annually, what is the inflation premium expected at this time? B. What is the amount of the total risk premium that Voice River will have to pay? C. If a 1 percent liquidity premium is built..

  Compute the standard deviation

The past five monthly returns for PG&E are -3.55 percent, 4.83 percent, 4.15 percent, 7.04 percent, and 3.96 percent. Compute the standard deviation of PG&E's monthly returns. (Do not round intermediate calculations and round your final answer to ..

  Explain role of cost measurement in maintaining the

explain role of cost measurement in maintaining the operating and capital budgets via variance

  What are the important elements of a project communication

What are the important elements of a Project Communication Plan? Please identify these elements, and briefly discuss their importance.

  Risk premiums of the portfolios

Assume that the S&P 500, with a beta of 1, has an expected return of 10 percent and T-bills provide a risk-free return of 4 percent

  Compute the present value of the stream

A common way to estimate the value an investment opportunity is to model the stream of expected future cash flows, and to compute the present value of the stream. This general method is called:

  What decision did you make and why

Evaluate a major financial decision you have made recently or are considering. (ie buy vs lease car, educational degree, buy vs rent apartment)

  Explain the factors affecting the choice of a minimum cash

explain the factors affecting the choice of a minimum cash balance

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