Business Finance
QRB501 University of Phoenix Cloud Data Services Project

QRB501

University of Phoenix

Question Description

About Your Signature Assignment

This signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The signature assignment may be graded with an automated rubric that allows the University to collect data that can be aggregated across a location or college/school and used for program improvements.

Purpose of Assignment

The purpose of this assignment is for students to synthesize the concepts learned throughout the course, provide students an opportunity to build critical thinking skills, develop businesses and organizations, and solve problems that require data.

Assignment Steps

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.

Case 2:

Note: Although you will be studying the concept of CPI in more detail in your ECO/561 class; for the purpose of this case, you need to use the concepts of percentages, percentage increase/decrease, and creating and interpreting line charts to compute the inflation rate in the US economy and determine which time period experienced the highest inflation rate.

Follow the steps below to complete this signature assignment:

  1. Search for the Federal Reserve Bank of St. Louis (FRED).
  2. On the home page of the website, you will see a search box.
  3. Type in CPI- AUCSL in the search box and press the return key.
  4. The first result of the search will be "Consumer Price Index for All Urban Consumers: All Items." Click on this result link.
  5. Click on the Download link and download the data in Excel®.
  6. On the Excel® file, the second column gives you the CPI values for each period starting from 1947.
  7. Go to the last row and notice the last date and the CPI value. Go back 6 years from this last date. For example, if the last date is 2016-11-01, then the date 6 years ago would be 2010-11-01.
  8. Copy and paste this six years data into a separate Excel® tab.
  9. Using Excel®, calculate the percentage change in CPI from a year earlier for each observation, beginning with the observation one year later than the first observation. To make this calculation, click on the blank cell next to the observation corresponding to that date and then use Formula 1, located in the Signature Assignment Excel® Formulas document (note that in Excel®, the symbol for multiplication is *), where t-1 is the first observation and t is the observation one year later. For example, to find the percentage change in CPI from 2010-11-01 to 2010-10-01, refer to Formula 2 located in the Signature Assignment Excel® Formulas document. Convert this value to a percentage in Excel®. Repeat this process for the remaining observations (you can use the copy and paste functions to avoid having to retype the formula).
  10. This new column contains the national inflation rate.
  11. Create a line graph of the percentage changes (inflation rates) from a year earlier.
  12. Which period experienced the highest inflation rate? What was the inflation rate during that period?

Format your assignment consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

Unformatted Attachment Preview

Date 11/01/16 11/02/16 11/03/16 11/04/16 11/07/16 11/07/16 11/07/16 11/07/16 11/10/16 11/10/16 11/11/16 11/14/16 11/16/16 11/18/16 11/18/16 11/18/16 11/21/16 11/22/16 11/27/16 11/30/16 11/28/16 11/28/16 Problem Experienced Lockups Lockups Memory Errors Lockups Weekly Virus Scan Lockups Memory Errors Memory Errors Slow Startup Weekly Virus Scan Memory Errors Memory Errors Manual Re-start Memory Errors Weekly Virus Scan Lockups Memory Errors Memory Errors Memory Errors Weekly Virus Scan Memory Errors Lockups Downtime Minutes 25 35 10 40 60 30 35 20 45 60 30 10 20 35 60 25 35 20 40 60 15 25 Signature Assignment Formulas QRB/501 Version 10 University of Phoenix Material Signature Assignment Formulas Formula One Formula Two Copyright © 2017 by University of Phoenix. All rights reserved. 1 ...
Purchase answer to see full attachment

Final Answer

Hello, I have attached the answer, kindly confirm, thanks

Case 1: Cloud Data Services (CDS
Name
Institution
Date

Frequency of the problems
Frequency chart
Problem experienced

Weekly Virus Scan
Slow Startup
Memory Errors
Total

Manual Re-start

Lockups
0

5
10
Frequency

15

• Memory errors
occurred more
frequently
compared to the
other problem.
• Manual restart
caused downtime
the least number
of times.

Downtime minutes per cause
Percentages of total downtime
Lockups
24%
33%

Manual Restart
3%

6%
34%

Memory Errors
Slow Startup

• Memory errors
caused much of the
downtime
accounting for 34%
followed closely by
Lockups with 33%
of the weekly virus
scan.
• Manual restart
accounted for the
least downtime
with 3% compared
to the other
problems

Descriptive statistics
Downtime minutes

Mean
Medium
Standard deviation
Variance

33.41
32.50
15.84
250.92

Observably, the mean is greater compared to the median signifying
that the data is skewed to the right. However, the value of standard
deviation indicates that downtime minutes is largely spread out
around 15.84 minutes from the mean.

Thank you!


Date
11/01/16
11/02/16
11/03/16
11/04/16
11/07/16
11/07/16
11/07/16
11/07/16
11/10/16
11/10/16
11/11/16
11/14/16
11/16/16
11/18/16
11/18/16
11/18/16
11/21/16
11/22/16
11/27/16
11/30/16
11/28/16
11/28/16

Problem Experienced
Lockups
Lockups
Memory Errors
Lockups
Weekly Virus Scan
Lockups
Memory Errors
Memory Errors
Slow Startup
Weekly Virus Scan
Memory Errors
Memory Errors
Manual Re-start
Memory Errors
Weekly Virus Scan
Lockups
Memory Errors
Memory Errors
Memory Errors
Weekly Virus Scan
Memory Errors
Lockups

Mean
Medium
Standard deviation
Variance

Downtime Minutes
25
35
10
40
60
30
35
20
45
60
30
10
20
35
60
25
35
20
40
60
15
25

33.41
32.50
15.84
250.92

Count of Downtime Minutes
6
1
10
1
4
22

Frequency chart
Problem experienced

Row Labels
Lockups
Manual Re-start
Memory Errors
Slow Startup
Weekly Virus Scan
Grand Total

Weekly Virus Scan
Slow Startup
Memory Errors
Manual Re-start
Lockups
0

2

4

6
Axis Title

8

y chart

Total

8

10

12

Row Labels
Lockups
Manual Re-start
Memory Errors
Slow Startup
Weekly Virus Scan
Grand Total

Sum of Downtime Minutes
180
20
250
45
240
735

Percentages of total downtime

33%

Problem Experienced
Lockups

24%

Manual Re-start
3%

Memory Errors
Slow Startup

6%
34%

Weekly Virus Scan

roblem Experienced
Manual Re-start
Memory Errors
Slow Startup
Weekly Virus Scan


FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fred.stlouisfed.org/help-faq
Economic Research Division
Federal Reserve Bank of St. Louis
CPIAUCSL

Consumer Price Index for All Urban Consumers: All Items, Index 1982-1984=100, Monthly, Seasona

Frequency: Monthly
observation_date
CPIAUCSL
1947-01-01
1947-02-01
1947-03-01
1947-04-01
1947-05-01
1947-06-01
1947-07-01
1947-08-01
1947-09-01
1947-10-01
1947-11-01
1947-12-01
1948-01-01
1948-02-01
1948-03-01
1948-04-01
1948-05-01
1948-06-01
1948-07-01
1948-08-01
1948-09-01
1948-10-01
1948-11-01
1948-12-01
1949-01-01
1949-02-01
1949-03-01
1949-04-01
1949-05-01
1949-06-01
1949-07-01
1949-08-01
1949-09-01
1949-10-01
1949-11-01
1949-12-01
1950-01-01
1950-02-01
1950-03-01
1950-04-01
1950-05-01

21.480
21.620
22.000
22.000
21.950
22.080
22.230
22.400
22.840
22.910
23.060
23.410
23.680
23.670
23.500
23.820
24.010
24.150
24.400
24.430
24.360
24.310
24.160
24.050
24.010
23.910
23.910
23.920
23.910
23.920
23.700
23.700
23.750
23.670
23.700
23.610
23.510
23.610
23.640
23.650
23.770

1950-06-01
1950-07-01
1950-08-01
1950-09-01
1950-10-01
1950-11-01
1950-12-01
1951-01-01
1951-02-01
1951-03-01
1951-04-01
1951-05-01
1951-06-01
1951-07-01
1951-08-01
1951-09-01
1951-10-01
1951-11-01
1951-12-01
1952-01-01
1952-02-01
1952-03-01
1952-04-01
1952-05-01
1952-06-01
1952-07-01
1952-08-01
1952-09-01
1952-10-01
1952-11-01
1952-12-01
1953-01-01
1953-02-01
1953-03-01
1953-04-01
1953-05-01
1953-06-01
1953-07-01
1953-08-01
1953-09-01
1953-10-01
1953-11-01
1953-12-01
1954-01-01
1954-02-01
1954-03-01
1954-04-01
1954-05-01
1954-06-01
1954-07-01
1954-08-01
1954-09-01

23.880
24.070
24.200
24.340
24.500
24.600
24.980
25.380
25.830
2...

Tutor_Booth (14952)
UCLA

Anonymous
Top quality work from this tutor! I’ll be back!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Anonymous
Thank you! Reasonably priced given the quality

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors