Cloud Data Services (CDS)

User Generated

Vffnnoryyn

Mathematics

Description

Resources: Data Analytics Problem Set Excel® Template, Excel® 2016 Essential Training

Resources: Quantitative Techniques in Financial Valuation Problem Set Excel® Template

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.

Unformatted Attachment Preview

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 25.880 25.920 25.990 25.930 25.910 25.860 26.030 26.160 26.320 26.470 26.450 26.410 26.390 26.460 26.470 26.530 26.680 26.690 26.630 26.690 26.690 26.710 26.640 26.590 26.630 26.690 26.700 26.770 26.790 26.850 26.890 26.950 26.850 26.870 26.940 26.990 26.930 26.860 26.930 26.940 26.860 26.850 26.810 1954-10-01 1954-11-01 1954-12-01 1955-01-01 1955-02-01 1955-03-01 1955-04-01 1955-05-01 1955-06-01 1955-07-01 1955-08-01 1955-09-01 1955-10-01 1955-11-01 1955-12-01 1956-01-01 1956-02-01 1956-03-01 1956-04-01 1956-05-01 1956-06-01 1956-07-01 1956-08-01 1956-09-01 1956-10-01 1956-11-01 1956-12-01 1957-01-01 1957-02-01 1957-03-01 1957-04-01 1957-05-01 1957-06-01 1957-07-01 1957-08-01 1957-09-01 1957-10-01 1957-11-01 1957-12-01 1958-01-01 1958-02-01 1958-03-01 1958-04-01 1958-05-01 1958-06-01 1958-07-01 1958-08-01 1958-09-01 1958-10-01 1958-11-01 1958-12-01 1959-01-01 26.720 26.780 26.770 26.770 26.820 26.790 26.790 26.770 26.710 26.760 26.720 26.850 26.820 26.880 26.870 26.830 26.860 26.890 26.930 27.030 27.150 27.290 27.310 27.350 27.510 27.510 27.630 27.670 27.800 27.860 27.930 28.000 28.110 28.190 28.280 28.320 28.320 28.410 28.470 28.640 28.700 28.870 28.940 28.940 28.910 28.890 28.940 28.910 28.910 28.950 28.970 29.010 1959-02-01 1959-03-01 1959-04-01 1959-05-01 1959-06-01 1959-07-01 1959-08-01 1959-09-01 1959-10-01 1959-11-01 1959-12-01 1960-01-01 1960-02-01 1960-03-01 1960-04-01 1960-05-01 1960-06-01 1960-07-01 1960-08-01 1960-09-01 1960-10-01 1960-11-01 1960-12-01 1961-01-01 1961-02-01 1961-03-01 1961-04-01 1961-05-01 1961-06-01 1961-07-01 1961-08-01 1961-09-01 1961-10-01 1961-11-01 1961-12-01 1962-01-01 1962-02-01 1962-03-01 1962-04-01 1962-05-01 1962-06-01 1962-07-01 1962-08-01 1962-09-01 1962-10-01 1962-11-01 1962-12-01 1963-01-01 1963-02-01 1963-03-01 1963-04-01 1963-05-01 29.000 28.970 28.980 29.040 29.110 29.150 29.180 29.250 29.350 29.350 29.410 29.370 29.410 29.410 29.540 29.570 29.610 29.550 29.610 29.610 29.750 29.780 29.810 29.840 29.840 29.840 29.810 29.840 29.840 29.920 29.940 29.980 29.980 29.980 30.010 30.040 30.110 30.170 30.210 30.240 30.210 30.220 30.280 30.420 30.380 30.380 30.380 30.440 30.480 30.510 30.480 30.510 1963-06-01 1963-07-01 1963-08-01 1963-09-01 1963-10-01 1963-11-01 1963-12-01 1964-01-01 1964-02-01 1964-03-01 1964-04-01 1964-05-01 1964-06-01 1964-07-01 1964-08-01 1964-09-01 1964-10-01 1964-11-01 1964-12-01 1965-01-01 1965-02-01 1965-03-01 1965-04-01 1965-05-01 1965-06-01 1965-07-01 1965-08-01 1965-09-01 1965-10-01 1965-11-01 1965-12-01 1966-01-01 1966-02-01 1966-03-01 1966-04-01 1966-05-01 1966-06-01 1966-07-01 1966-08-01 1966-09-01 1966-10-01 1966-11-01 1966-12-01 1967-01-01 1967-02-01 1967-03-01 1967-04-01 1967-05-01 1967-06-01 1967-07-01 1967-08-01 1967-09-01 30.610 30.690 30.750 30.720 30.750 30.780 30.880 30.940 30.910 30.940 30.950 30.980 31.010 31.020 31.050 31.080 31.120 31.210 31.250 31.280 31.280 31.310 31.380 31.480 31.610 31.580 31.550 31.620 31.650 31.750 31.850 31.880 32.080 32.180 32.280 32.350 32.380 32.450 32.650 32.750 32.850 32.880 32.920 32.900 33.000 33.000 33.100 33.100 33.300 33.400 33.500 33.600 1967-10-01 1967-11-01 1967-12-01 1968-01-01 1968-02-01 1968-03-01 1968-04-01 1968-05-01 1968-06-01 1968-07-01 1968-08-01 1968-09-01 1968-10-01 1968-11-01 1968-12-01 1969-01-01 1969-02-01 1969-03-01 1969-04-01 1969-05-01 1969-06-01 1969-07-01 1969-08-01 1969-09-01 1969-10-01 1969-11-01 1969-12-01 1970-01-01 1970-02-01 1970-03-01 1970-04-01 1970-05-01 1970-06-01 1970-07-01 1970-08-01 1970-09-01 1970-10-01 1970-11-01 1970-12-01 1971-01-01 1971-02-01 1971-03-01 1971-04-01 1971-05-01 1971-06-01 1971-07-01 1971-08-01 1971-09-01 1971-10-01 1971-11-01 1971-12-01 1972-01-01 33.700 33.900 34.000 34.100 34.200 34.300 34.400 34.500 34.700 34.900 35.000 35.100 35.300 35.400 35.600 35.700 35.800 36.100 36.300 36.400 36.600 36.800 36.900 37.100 37.300 37.500 37.700 37.900 38.100 38.300 38.500 38.600 38.800 38.900 39.000 39.200 39.400 39.600 39.800 39.900 39.900 40.000 40.100 40.300 40.500 40.600 40.700 40.800 40.900 41.000 41.100 41.200 1972-02-01 1972-03-01 1972-04-01 1972-05-01 1972-06-01 1972-07-01 1972-08-01 1972-09-01 1972-10-01 1972-11-01 1972-12-01 1973-01-01 1973-02-01 1973-03-01 1973-04-01 1973-05-01 1973-06-01 1973-07-01 1973-08-01 1973-09-01 1973-10-01 1973-11-01 1973-12-01 1974-01-01 1974-02-01 1974-03-01 1974-04-01 1974-05-01 1974-06-01 1974-07-01 1974-08-01 1974-09-01 1974-10-01 1974-11-01 1974-12-01 1975-01-01 1975-02-01 1975-03-01 1975-04-01 1975-05-01 1975-06-01 1975-07-01 1975-08-01 1975-09-01 1975-10-01 1975-11-01 1975-12-01 1976-01-01 1976-02-01 1976-03-01 1976-04-01 1976-05-01 41.400 41.400 41.500 41.600 41.700 41.800 41.900 42.100 42.200 42.400 42.500 42.700 43.000 43.400 43.700 43.900 44.200 44.200 45.000 45.200 45.600 45.900 46.300 46.800 47.300 47.800 48.100 48.600 49.000 49.300 49.900 50.600 51.000 51.500 51.900 52.300 52.600 52.800 53.000 53.100 53.500 54.000 54.200 54.600 54.900 55.300 55.600 55.800 55.900 56.000 56.100 56.400 1976-06-01 1976-07-01 1976-08-01 1976-09-01 1976-10-01 1976-11-01 1976-12-01 1977-01-01 1977-02-01 1977-03-01 1977-04-01 1977-05-01 1977-06-01 1977-07-01 1977-08-01 1977-09-01 1977-10-01 1977-11-01 1977-12-01 1978-01-01 1978-02-01 1978-03-01 1978-04-01 1978-05-01 1978-06-01 1978-07-01 1978-08-01 1978-09-01 1978-10-01 1978-11-01 1978-12-01 1979-01-01 1979-02-01 1979-03-01 1979-04-01 1979-05-01 1979-06-01 1979-07-01 1979-08-01 1979-09-01 1979-10-01 1979-11-01 1979-12-01 1980-01-01 1980-02-01 1980-03-01 1980-04-01 1980-05-01 1980-06-01 1980-07-01 1980-08-01 1980-09-01 56.700 57.000 57.300 57.600 57.900 58.100 58.400 58.700 59.300 59.600 60.000 60.200 60.500 60.800 61.100 61.300 61.600 62.000 62.300 62.700 63.000 63.400 63.900 64.500 65.000 65.500 65.900 66.500 67.100 67.500 67.900 68.500 69.200 69.900 70.600 71.400 72.200 73.000 73.700 74.400 75.200 76.000 76.900 78.000 79.000 80.100 80.900 81.700 82.500 82.600 83.200 83.900 1980-10-01 1980-11-01 1980-12-01 1981-01-01 1981-02-01 1981-03-01 1981-04-01 1981-05-01 1981-06-01 1981-07-01 1981-08-01 1981-09-01 1981-10-01 1981-11-01 1981-12-01 1982-01-01 1982-02-01 1982-03-01 1982-04-01 1982-05-01 1982-06-01 1982-07-01 1982-08-01 1982-09-01 1982-10-01 1982-11-01 1982-12-01 1983-01-01 1983-02-01 1983-03-01 1983-04-01 1983-05-01 1983-06-01 1983-07-01 1983-08-01 1983-09-01 1983-10-01 1983-11-01 1983-12-01 1984-01-01 1984-02-01 1984-03-01 1984-04-01 1984-05-01 1984-06-01 1984-07-01 1984-08-01 1984-09-01 1984-10-01 1984-11-01 1984-12-01 1985-01-01 84.700 85.600 86.400 87.200 88.000 88.600 89.100 89.700 90.500 91.500 92.200 93.100 93.400 93.800 94.100 94.400 94.700 94.700 95.000 95.900 97.000 97.500 97.700 97.700 98.100 98.000 97.700 97.900 98.000 98.100 98.800 99.200 99.400 99.800 100.100 100.400 100.800 101.100 101.400 102.100 102.600 102.900 103.300 103.500 103.700 104.100 104.400 104.700 105.100 105.300 105.500 105.700 1985-02-01 1985-03-01 1985-04-01 1985-05-01 1985-06-01 1985-07-01 1985-08-01 1985-09-01 1985-10-01 1985-11-01 1985-12-01 1986-01-01 1986-02-01 1986-03-01 1986-04-01 1986-05-01 1986-06-01 1986-07-01 1986-08-01 1986-09-01 1986-10-01 1986-11-01 1986-12-01 1987-01-01 1987-02-01 1987-03-01 1987-04-01 1987-05-01 1987-06-01 1987-07-01 1987-08-01 1987-09-01 1987-10-01 1987-11-01 1987-12-01 1988-01-01 1988-02-01 1988-03-01 1988-04-01 1988-05-01 1988-06-01 1988-07-01 1988-08-01 1988-09-01 1988-10-01 1988-11-01 1988-12-01 1989-01-01 1989-02-01 1989-03-01 1989-04-01 1989-05-01 106.300 106.800 107.000 107.200 107.500 107.700 107.900 108.100 108.500 109.000 109.500 109.900 109.700 109.100 108.700 109.000 109.400 109.500 109.600 110.000 110.200 110.400 110.800 111.400 111.800 112.200 112.700 113.000 113.500 113.800 114.300 114.700 115.000 115.400 115.600 116.000 116.200 116.500 117.200 117.500 118.000 118.500 119.000 119.500 119.900 120.300 120.700 121.200 121.600 122.200 123.100 123.700 1989-06-01 1989-07-01 1989-08-01 1989-09-01 1989-10-01 1989-11-01 1989-12-01 1990-01-01 1990-02-01 1990-03-01 1990-04-01 1990-05-01 1990-06-01 1990-07-01 1990-08-01 1990-09-01 1990-10-01 1990-11-01 1990-12-01 1991-01-01 1991-02-01 1991-03-01 1991-04-01 1991-05-01 1991-06-01 1991-07-01 1991-08-01 1991-09-01 1991-10-01 1991-11-01 1991-12-01 1992-01-01 1992-02-01 1992-03-01 1992-04-01 1992-05-01 1992-06-01 1992-07-01 1992-08-01 1992-09-01 1992-10-01 1992-11-01 1992-12-01 1993-01-01 1993-02-01 1993-03-01 1993-04-01 1993-05-01 1993-06-01 1993-07-01 1993-08-01 1993-09-01 124.100 124.500 124.500 124.800 125.400 125.900 126.300 127.500 128.000 128.600 128.900 129.100 129.900 130.500 131.600 132.500 133.400 133.700 134.200 134.700 134.800 134.800 135.100 135.600 136.000 136.200 136.600 137.000 137.200 137.800 138.200 138.300 138.600 139.100 139.400 139.700 140.100 140.500 140.800 141.100 141.700 142.100 142.300 142.800 143.100 143.300 143.800 144.200 144.300 144.500 144.800 145.000 1993-10-01 1993-11-01 1993-12-01 1994-01-01 1994-02-01 1994-03-01 1994-04-01 1994-05-01 1994-06-01 1994-07-01 1994-08-01 1994-09-01 1994-10-01 1994-11-01 1994-12-01 1995-01-01 1995-02-01 1995-03-01 1995-04-01 1995-05-01 1995-06-01 1995-07-01 1995-08-01 1995-09-01 1995-10-01 1995-11-01 1995-12-01 1996-01-01 1996-02-01 1996-03-01 1996-04-01 1996-05-01 1996-06-01 1996-07-01 1996-08-01 1996-09-01 1996-10-01 1996-11-01 1996-12-01 1997-01-01 1997-02-01 1997-03-01 1997-04-01 1997-05-01 1997-06-01 1997-07-01 1997-08-01 1997-09-01 1997-10-01 1997-11-01 1997-12-01 1998-01-01 145.600 146.000 146.300 146.300 146.700 147.100 147.200 147.500 147.900 148.400 149.000 149.300 149.400 149.800 150.100 150.500 150.900 151.200 151.800 152.100 152.400 152.600 152.900 153.100 153.500 153.700 153.900 154.700 155.000 155.500 156.100 156.400 156.700 157.000 157.200 157.700 158.200 158.700 159.100 159.400 159.700 159.800 159.900 159.900 160.200 160.400 160.800 161.200 161.500 161.700 161.800 162.000 1998-02-01 1998-03-01 1998-04-01 1998-05-01 1998-06-01 1998-07-01 1998-08-01 1998-09-01 1998-10-01 1998-11-01 1998-12-01 1999-01-01 1999-02-01 1999-03-01 1999-04-01 1999-05-01 1999-06-01 1999-07-01 1999-08-01 1999-09-01 1999-10-01 1999-11-01 1999-12-01 2000-01-01 2000-02-01 2000-03-01 2000-04-01 2000-05-01 2000-06-01 2000-07-01 2000-08-01 2000-09-01 2000-10-01 2000-11-01 2000-12-01 2001-01-01 2001-02-01 2001-03-01 2001-04-01 2001-05-01 2001-06-01 2001-07-01 2001-08-01 2001-09-01 2001-10-01 2001-11-01 2001-12-01 2002-01-01 2002-02-01 2002-03-01 2002-04-01 2002-05-01 162.000 162.000 162.200 162.600 162.800 163.200 163.400 163.500 163.900 164.100 164.400 164.700 164.700 164.800 165.900 166.000 166.000 166.700 167.100 167.800 168.100 168.400 168.800 169.300 170.000 171.000 170.900 171.200 172.200 172.700 172.700 173.600 173.900 174.200 174.600 175.600 176.000 176.100 176.400 177.300 177.700 177.400 177.400 178.100 177.600 177.500 177.400 177.700 178.000 178.500 179.300 179.500 2002-06-01 2002-07-01 2002-08-01 2002-09-01 2002-10-01 2002-11-01 2002-12-01 2003-01-01 2003-02-01 2003-03-01 2003-04-01 2003-05-01 2003-06-01 2003-07-01 2003-08-01 2003-09-01 2003-10-01 2003-11-01 2003-12-01 2004-01-01 2004-02-01 2004-03-01 2004-04-01 2004-05-01 2004-06-01 2004-07-01 2004-08-01 2004-09-01 2004-10-01 2004-11-01 2004-12-01 2005-01-01 2005-02-01 2005-03-01 2005-04-01 2005-05-01 2005-06-01 2005-07-01 2005-08-01 2005-09-01 2005-10-01 2005-11-01 2005-12-01 2006-01-01 2006-02-01 2006-03-01 2006-04-01 2006-05-01 2006-06-01 2006-07-01 2006-08-01 2006-09-01 179.600 180.000 180.500 180.800 181.200 181.500 181.800 182.600 183.600 183.900 183.200 182.900 183.100 183.700 184.500 185.100 184.900 185.000 185.500 186.300 186.700 187.100 187.400 188.200 188.900 189.100 189.200 189.800 190.800 191.700 191.700 191.600 192.400 193.100 193.700 193.600 193.700 194.900 196.100 198.800 199.100 198.100 198.100 199.300 199.400 199.700 200.700 201.300 201.800 202.900 203.800 202.800 2006-10-01 2006-11-01 2006-12-01 2007-01-01 2007-02-01 2007-03-01 2007-04-01 2007-05-01 2007-06-01 2007-07-01 2007-08-01 2007-09-01 2007-10-01 2007-11-01 2007-12-01 2008-01-01 2008-02-01 2008-03-01 2008-04-01 2008-05-01 2008-06-01 2008-07-01 2008-08-01 2008-09-01 2008-10-01 2008-11-01 2008-12-01 2009-01-01 2009-02-01 2009-03-01 2009-04-01 2009-05-01 2009-06-01 2009-07-01 2009-08-01 2009-09-01 2009-10-01 2009-11-01 2009-12-01 2010-01-01 2010-02-01 2010-03-01 2010-04-01 2010-05-01 2010-06-01 2010-07-01 2010-08-01 2010-09-01 2010-10-01 2010-11-01 2010-12-01 2011-01-01 201.900 202.000 203.100 203.437 204.226 205.288 205.904 206.755 207.234 207.603 207.667 208.547 209.190 210.834 211.445 212.174 212.687 213.448 213.942 215.208 217.463 219.016 218.690 218.877 216.995 213.153 211.398 211.933 212.705 212.495 212.709 213.022 214.790 214.726 215.445 215.861 216.509 217.234 217.347 217.488 217.281 217.353 217.403 217.290 217.199 217.605 217.923 218.275 219.035 219.590 220.472 221.187 2011-02-01 2011-03-01 2011-04-01 2011-05-01 2011-06-01 2011-07-01 2011-08-01 2011-09-01 2011-10-01 2011-11-01 2011-12-01 2012-01-01 2012-02-01 2012-03-01 2012-04-01 2012-05-01 2012-06-01 2012-07-01 2012-08-01 2012-09-01 2012-10-01 2012-11-01 2012-12-01 2013-01-01 2013-02-01 2013-03-01 2013-04-01 2013-05-01 2013-06-01 2013-07-01 2013-08-01 2013-09-01 2013-10-01 2013-11-01 2013-12-01 2014-01-01 2014-02-01 2014-03-01 2014-04-01 2014-05-01 2014-06-01 2014-07-01 2014-08-01 2014-09-01 2014-10-01 2014-11-01 2014-12-01 2015-01-01 2015-02-01 2015-03-01 2015-04-01 2015-05-01 221.898 223.046 224.093 224.806 224.806 225.395 226.106 226.597 226.750 227.169 227.223 227.842 228.329 228.807 229.187 228.713 228.524 228.590 229.918 231.015 231.638 231.249 231.221 231.612 232.985 232.299 231.795 231.916 232.374 232.889 233.323 233.632 233.718 234.121 234.723 235.385 235.672 235.978 236.471 236.832 237.029 237.424 237.256 237.486 237.506 237.118 236.290 234.913 235.489 235.989 236.201 236.891 2015-06-01 2015-07-01 2015-08-01 2015-09-01 2015-10-01 2015-11-01 2015-12-01 2016-01-01 2016-02-01 2016-03-01 2016-04-01 2016-05-01 2016-06-01 2016-07-01 2016-08-01 2016-09-01 2016-10-01 2016-11-01 2016-12-01 2017-01-01 2017-02-01 2017-03-01 237.419 237.876 237.811 237.467 237.792 238.153 237.846 238.106 237.808 238.078 238.908 239.362 239.842 239.898 240.389 241.006 241.694 242.199 242.821 244.158 244.456 243.752 1982-1984=100, Monthly, Seasonally Adjusted Date CPI Percent Change Percent Change Using % Formatting Within Excel 3/1/2011 4/1/2011 5/1/2011 6/1/2011 7/1/2011 8/1/2011 9/1/2011 10/1/2011 11/1/2011 12/1/2011 1/1/2012 2/1/2012 3/1/2012 4/1/2012 5/1/2012 6/1/2012 7/1/2012 8/1/2012 9/1/2012 10/1/2012 11/1/2012 12/1/2012 1/1/2013 2/1/2013 3/1/2013 4/1/2013 5/1/2013 6/1/2013 7/1/2013 8/1/2013 9/1/2013 10/1/2013 11/1/2013 12/1/2013 1/1/2014 2/1/2014 3/1/2014 4/1/2014 5/1/2014 6/1/2014 7/1/2014 8/1/2014 9/1/2014 10/1/2014 11/1/2014 12/1/2014 1/1/2015 2/1/2015 3/1/2015 4/1/2015 5/1/2015 6/1/2015 7/1/2015 223.046 224.093 224.806 224.806 225.395 226.106 226.597 226.75 227.169 227.223 227.842 228.329 228.807 229.187 228.713 228.524 228.59 229.918 231.015 231.638 231.249 231.221 231.612 232.985 232.299 231.795 231.916 232.374 232.889 233.323 233.632 233.718 234.121 234.723 235.385 235.672 235.978 236.471 236.832 237.029 237.424 237.256 237.486 237.506 237.118 236.29 234.913 235.489 235.989 236.201 236.891 237.419 237.876 0.469409898 0.318171473 0 0.262003683 0.315446217 0.217154786 0.067520753 0.184785006 0.023770849 0.272419605 0.213744612 0.209347039 0.166078835 -0.206818013 -0.082636317 0.028880993 0.580952798 0.477126628 0.269679458 -0.167934449 -0.01210816 0.169102287 0.592801755 -0.294439556 -0.21696176 0.052201299 0.197485296 0.221625483 0.186354873 0.132434436 0.036810026 0.172430023 0.257131996 0.282034568 0.121927905 0.129841475 0.20891778 0.152661426 0.083181327 0.166646275 -0.070759485 0.0969417 0.008421549 -0.163364294 -0.349193229 -0.582758475 0.245197158 0.212324143 0.089834696 0.292124081 0.222887319 0.192486701 0.469409898% 0.318171473% 0.000000000% 0.262003683% 0.315446217% 0.217154786% 0.067520753% 0.184785006% 0.023770849% 0.272419605% 0.213744612% 0.209347039% 0.166078835% -0.206818013% -0.082636317% 0.028880993% 0.580952798% 0.477126628% 0.269679458% -0.167934449% -0.012108160% 0.169102287% 0.592801755% -0.294439556% -0.216961760% 0.052201299% 0.197485296% 0.221625483% 0.186354873% 0.132434436% 0.036810026% 0.172430023% 0.257131996% 0.282034568% 0.121927905% 0.129841475% 0.208917780% 0.152661426% 0.083181327% 0.166646275% -0.070759485% 0.096941700% 0.008421549% -0.163364294% -0.349193229% -0.582758475% 0.245197158% 0.212324143% 0.089834696% 0.292124081% 0.222887319% 0.192486701% 8/1/2015 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016 1/1/2017 2/1/2017 3/1/2017 237.811 237.467 237.792 238.153 237.846 238.106 237.808 238.078 238.908 239.362 239.842 239.898 240.389 241.006 241.694 242.199 242.821 244.158 244.456 243.752 -0.027325161 -0.144652686 0.136861122 0.151813349 -0.128908727 0.10931443 -0.125154343 0.113536971 0.34862524 0.190031309 0.200533084 0.023348705 0.204670318 0.256667318 0.285470071 0.208941885 0.256813612 0.550611356 0.122052114 -0.287986386 -0.027325161% -0.144652686% 0.136861122% 0.151813349% -0.128908727% 0.109314430% -0.125154343% 0.113536971% 0.348625240% 0.190031309% 0.200533084% 0.023348705% 0.204670318% 0.256667318% 0.285470071% 0.208941885% 0.256813612% 0.550611356% 0.122052114% -0.287986386% 0.800000000% The Period 1/1/13 highest inflation rate. The inflation rate was .592801755 0.600000000% 0.400000000% 0.200000000% -0.400000000% -0.600000000% -0.800000000% 6/1/2014 4/1/2014 2/1/2014 12/1/2013 10/1/2013 8/1/2013 6/1/2013 4/1/2013 2/1/2013 12/1/2012 10/1/2012 8/1/2012 6/1/2012 4/1/2012 2/1/2012 12/1/2011 8/1/2011 10/1/2011 -0.200000000% 6/1/2011 4/1/2011 0.000000000% 2/1/2017 12/1/2016 10/1/2016 8/1/2016 6/1/2016 4/1/2016 2/1/2016 12/1/2015 10/1/2015 8/1/2015 6/1/2015 4/1/2015 2/1/2015 12/1/2014 10/1/2014 8/1/2014 6/1/2014 Period 1/1/13 - 2/1/13 experienced the ghest inflation rate. The inflation rate was Instructions: Week 5 Individual Assignment Total Number of Questions - 12 Total Points: 6 1. You have twelve problems - on each tab of this Excel file. 2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria back and partial credit (if appropriate). Find the interest paid on a loan of $1,200 for three years at a simple interest rate of 5% per year. How much money will you pay after three years? Principal Rate Time Simple Interest (SI) Maturity Value =PRODUCT(B4:B6) =Principal + SI Find the maturity value of a loan of $1,750 for 28 months at 9.8% simple interest per year. Principal Rate Time Simple Interest (SI) Maturity Value -- Please make sure that the time periods for Time and Rate match. =PRODUCT(B3:B5) =Principal + SI Find the simple interest rate of a loan of $5,000 that is made for three years and requires $1,762.50 in interest. Principal Time SI Rate 762.50 in interest. A loan of $16,840 is borrowed at 9% simple interest and is repaid with $4,167.90 interest. What is the duration of the loan? Principal Rate SI Time How much money is borrowed if the interest rate is 9.25% simple interest and the loan is made for 3.5 years and has $904.88 interest? SI Rate Time Principal Find the ordinary and exact interest for a loan of $1000 at a 5% annual interest rate. The loan was made on March 15 and is due May 15. Loan date Loan Due Date Exact time days =B5-B4 Principal Rate Time Loan date Loan Due Date Exact time days Principal Rate Time Ordinary Simple Interest (SI) Exact Simple Interest (SI) =PRODUCT(B8:B10) =PRODUCT(G8:G10) =G5-G4 =PRODUCT(G8:G10) Find the bank discount and proceeds using ordinary interest for a loan to Michelle Anders for $7,200 at 8.25% annual simple interest from August 8 to November 8. Loan date Loan Due Date Exact time days Face Value (F) Discount Rate (D) Time Period (T) Bank Discount (B) years --> 'Convert Exact time in days to years =PRODUCT(B8:B10) OR =B8*B9*B10 Proceeds (P) =B8-B11 =B5-B4 What is the effective interest rate of a simple discount note for $8,000, at an ordinary bank discount rate of 11%, for 120 days? Face Value (F) Discount Rate (D) Time Period (T) Bank Discount (B) years --> 'Convert Exact time in days to years =PRODUCT(B4:B6) OR =B4*B5*B6 Proceeds (P) =B4 - B7 Rate =B7/PRODUCT(B9, B6) SOLVED EXAMPLE What is the effective interest rate for the first year for a loan of $20,000 for three years if the interest is compounded quarterly at a rate of 12%? Quoted Rate 12.00% quarterly No. of compounding periods per year EAR 4 For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo 12.55% =EFFECT(B5, B6) 1. Ross Land has a loan of $8,500 compounded quarterly for four years at 6%. What is the effective interest rate for the first y Quoted Rate No. of compounding periods per year EAR For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo =EFFECT(B11, B12) 2. Find the effective interest rate for the first year for a loan for four years compounded semiannually at an annual rate of 2% Quoted Rate No. of compounding periods per year EAR For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo =EFFECT(B17, B18) 3. What is the effective interest rate for the first year for a loan of $5,000 at 10% compounded daily for three years? Quoted Rate No. of compounding periods per year EAR For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo =EFFECT(B23, B24) 4. Depending on the issuer, a typical credit card agreement quotes an interest rate of 18 percent APR. Monthly payments are What is the actual interest rate you pay on such a credit card? Quoted Rate No. of compounding periods per year EAR For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo =EFFECT(B30, B31) 5. Find the effective interest rate for a loan of $3,500 at 10% interest compounded quarterly. Quoted Rate No. of compounding periods per year EAR For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo =EFFECT(B36, B37) SOLVED EXAMPLE Tim Bowling has $20,000 invested for three years at a 5.25% annual rate compounded daily. How much interest will he earn? Initial Investment (PV) Quoted Rate Compounding Frequency Number of compoundings (m) Quoted Rate divided by m = RATE Number of Years NPER (Num. of years * m) Ending Amount (FV) Compound Interest $20,000 5.25% Daily 365 0.0144% 3 1095 $23,411.35 $3,411.35 Choose one For Quarterly, type 4; for semiannually, type 2; for a Exercise Find the future value of a $15,000 money market investment at 2.8% annual interest compounded daily for three years. Initial Investment (PV) Quoted Rate Compounding Frequency Number of compoundings (m) Quoted Rate divided by m = RATE Number of Years NPER (Num. of years * m) Ending Amount (FV) Compound Interest Choose one For Quarterly, type 4; for semiannually, type 2; for a for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365 for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365 SOLVED EXAMPLE The Holiday Boutique would like to put away some of the holiday profits to save for a planned expansion. A total of $8,000 is needed in three years. How much money in a 5.2% three-year certificate of deposit that is compounded monthly must be invested now to have the $8,000 in three years? Future Value Needed (FV) Quoted Rate Compounding Frequency Number of compoundings (m) Quoted Rate divided by m = RATE Number of Years NPER (Num. of years * m) Amount Invested Now (PV) $8,000 5.2% Monthly 12 0.4333% 3 36 $6,846.78 Choose one For Quarterly, type 4; for semiannually, type 2; for a Exercise How much should be invested now to have $15,000 in six years if interest is 4% compounded quarterly? Future Value Needed (FV) Quoted Rate Compounding Frequency Number of compoundings (m) Quoted Rate divided by m = RATE Number of Years NPER (Num. of years * m) Amount Invested Now (PV) Choose one For Quarterly, type 4; for semiannually, type 2; for a r semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365 r semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365 Jamie Juarez needs $12,000 in 10 years for her daughter’s college education. How much must be invested today at 2% annual interest compounded semiannually to have the needed funds? Future Value Needed (FV) Quoted Rate Compounding Frequency Number of compoundings (m) Quoted Rate divided by m = RATE Number of Years NPER (Num. of years * m) Amount Invested Now (PV) Choose one For Quarterly, type 4; for semiannually, type 2; for annually, ty A loan of $8,000 for two acres of woodland is compounded quarterly at an annual rate of 6% for five years. Find the compound amount and the compound interest. Initial Investment (PV) Quoted Rate Compounding Frequency Number of compoundings (m) Quoted Rate divided by m = RATE Number of Years NPER (Num. of years * m) Ending Amount (FV) Compound Interest Choose one For Quarterly, type 4; for semiannually, type 2; for annually, ty ually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365 ually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365 Instructions: Week 4 Individual Assignment Total Number of Questions - 12 1. You have twelve problems - one on each tab of this Excel file. 2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria back and partial credit (if appropriate). Fifty business students were given a project to complete. The bar graph below shows the number of days it took the students to complete the assignment. 1. How many students took 4 days to comple 2. How many students completed the projec 3. What percent of students completed the p ny students took 4 days to complete the assignment? ny students completed the project in 3 days or less? rcent of students completed the project in 3 days or less? State the answer as a percentage with one digit after decimal. The bar graph below shows the Quarterly Dollar Volume of Batesville Tire Company. Refer to the bar graph below and answer the questions. 1. Which quarter had the highest dollar volum 2. What percent of the yearly sales were the 3. What was the percent of increase in sales rcent of the yearly sales were the sales for October–December? State the answer as a percentage with one digit after decimal. as the percent of increase in sales from the first to the second quarter? State the answer as a percentage with one digit after decimal. git after decimal. The line chart below shows data for Automobile Gasoline Mileage Comparisons for full-size and compact cars. Refer to the chart and answer the questions. 1. What speed gave the highest g 2. What speed gave the lowest ga 3. At what speed did the first not Which car showed this decrease? 1. What speed gave the highest gasoline mileage for both types of automobiles? 2. What speed gave the lowest gasoline mileage for both types of automobiles? 3. At what speed did the first noticeable decrease in gasoline mileage occur? Choose one The line chart below shows Dale Crosby's Salary History. Refer to this chart and answer the questions. 1. Calculate the amount and percent of increase in Dale’ Amount of increase 2. What is the percent of increase in Dale’s salary from 2 Percentage of increase 3. Calculate the amount and percent of increase in Dale’ Amount of increase 4. If the cost-of-living increase was 10% from 2011 to 20 salary for this period of time kept pace with inflation. Hint: For part 4, follow the steps below: Step 1: Find the amount of salary increase from 2011 to Step 2: Find the percentage increase from 2011 to 2016 Step 3: If the percentage increase from Step 2 is greater Dale's salary kept pace with inflation, otherwise no. Step 1: Amount of salary increase from 2011 to 2016 Step 2: Percentage increase from 2011 to 2016 Step 3: Did the salary keep pace with inflation? nd percent of increase in Dale’s salary from 2014 to 2015. Percentage of increase State the answer as a percentage with one digit after decima increase in Dale’s salary from 2012 to 2013? State the answer as a percentage with one digit after decimal. nd percent of increase in Dale’s salary from 2016 to 2017. Percentage of increase State the answer as a percentage with one digit after decima ease was 10% from 2011 to 2016, determine if Dale’s me kept pace with inflation. of salary increase from 2011 to 2016. ge increase from 2011 to 2016. increase from Step 2 is greater than 10% cost-of-living increase, then th inflation, otherwise no. increase from 2011 to 2016 State the answer as a percentage with no decimal. (Choose one) with one digit after decimal. with one digit after decimal. The pie chart below shows the family budget. Refer to the chart and answer the following questions. 1. What is the total take-home pay? 2. What percent of the total take-home pay 3. What percent of the take-home pay is allo 4. What percent of take-home pay is spent fo 5. What percent of take-home pay is spent fo savings, and miscellaneous funds are combin Total of education, savings, and miscellaneou Percentage of take-home pay spent on this c rcent of the total take-home pay is allocated for transportation? State the answer as a percentage with one digit after decimal. rcent of the take-home pay is allocated for food? State the answer as a percentage with one digit after decimal. rcent of take-home pay is spent for education? State the answer as a percentage with one digit after decimal. rcent of take-home pay is spent for education when education, d miscellaneous funds are combined to be used for education? e of take-home pay spent on this combined total State the answer as a percentage with one digit after decimal. with one digit after decimal. The bar chart shows the distribution of tax dollars. Refer to the chart and answer the following questions. 1. What expenditure is expected to be the sa 2. What two expenditures are expected to in 3. What two expenditures are expected to d 4. What expenditure was greatest both years penditure is expected to be the same next year as this year? The Canmark Research Center Airport Customer Satisfaction Survey uses an online questionnaire to provide airlines and airpo customer satisfaction ratings for all aspects of the customers’ flight experience (airportsurvey website, July 2012). After comp flight, customers receive an e-mail asking them to go to the website and rate a variety of factors, including the reservation pr the check-in process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, on-time a and so on. A five-point scale, with Excellent, Very Good, Good, Fair, and Poor, is used to record customer ratings. Assume that passengers on a delta Airlines flight from Myrtle beach, South Carolina, to Atlanta, Georgia, provided the following rating question, “Please rate the airline based on your overall experience with this flight.” The sample ratings are shown below. Rating Excellent Excellent Very Good Good Excellent Excellent Good Very Good Excellent Excellent Good Very Good Very Good Very Good Very Good Very Good Excellent Fair Excellent Very Good Very Good Excellent Very Good Very Good Excellent Excellent Very Good Excellent Excellent Poor Very Good Excellent Very Good Very Good Excellent Very Good Excellent Excellent Credit: Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2017). Statistics f 1. Use the pivot table feature in Microsoft Excel and create a frequency distribution with two column 2. Use Excel to create a bar chart (or a pivot bar chart) 3. Use Excel to create a pie chart (or a pivot pie chart) 4. Interpret information from the charts and the frequency distribution. Very Good Very Good Very Good Excellent Good Very Good Poor Excellent Very Good Excellent Very Good Very Good & Cochran, J. J. (2017). Statistics for business & economics 13e. Boston: Cengage Learning. The data below shows the total sales per day of the week by four salespersons. Use Microsoft Excel to construct a line chart (graph)showing total sales by the days of the week for Happy's Gift Shoppe. Mon Tue Wed Thu Fri Sat Sales $233,94 $352,55 $355,16 $542,18 $369,01 $611,77 Which day of the week constituted highest sales? Use Excel to find the mean, median, and mode of the scores given below. 92 68 72 83 72 95 88 76 72 89 89 96 74 72 Mean Median Mode After your MBA, you are employed as a business analyst for a company that makes household products, which are sold by part-time salespersons who work during their spare time. The company has four salespersons employed. Let us denote these salespersons by A, B, C, and D. The sales records (in dollars) for the past 6 weeks for these four salespersons are shown in the table below. Week 1 2 3 4 5 6 A 1774 1808 1890 1932 1855 1726 B 2205 1507 2352 1939 2052 1630 C 1330 1295 1502 1104 1189 1441 D 1402 1665 1530 1826 1703 1498 Your supervisor has asked you to prepare a brief analysis comparing the sales volumes and the consistency of sales of these four salespersons. Use the mean sales for each salesperson to compare the sales volumes, and then choose an appropriate statistical measure to compare the consistency of sales. Week 1 2 3 4 5 6 A 1774 1808 1890 1932 1855 1726 B 2205 1507 2352 1939 2052 1630 C 1330 1295 1502 1104 1189 1441 D 1402 1665 1530 1826 1703 1498 Mean Median MIN MAX Range Std Dev Variance Case Adapted from Introductory Statistics, 8e, Mann old products, ds (in dollars) the consistency e sales volumes, The data below shows personal income for Quarters 2014: II - 2015: III in millions of dollars, seasonally adjusted at annual rate. Quarter II, 2014 Quarter III, 2014 Quarter IV, 2014 Quarter I, 2015 Quarter II, 2015 Quarter III, 2015 $14.603.925 $14.784.309 $14.925.215 $15.056.970 $15.254.088 $15.449.647 After plotting the line graph, answer the following questions: 1. Is the graph exhibiting an increasing, decreasing, or fluctuating trend? Choose one 2. Which quarter showed the highest personal income? Construct a pie chart (circle graph) showing the distribution of market share using the data below. The data represents the percent dollar market of comics and magazine sales for September (Rounded to the nearest whole percent). Publisher Marvel Comics DC Comics Image Comics Dark Horse Comics Dreamweave Productions All others Market Share 35% 32% 5% 4% 4% 20% After plotting the pie chart, answer the following questions. 1. What percent of market share is held by the largest three compa 2. What was Image Comics' sales for September if the total market 3. If the total market had $80,000,000 in comics and magazine sales
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Kindly see attached filesPPT file corresponds to the presentation (case 1)XLS file corresponds to the analysis of the national inflation rate (case 2)As requested, I've included speaking notes as part of the presentation which might help you in case you need to really present it out loud. They're included together with each slide using the notes feature in PowerPoint. Let me know if you have any trouble reading them to copy them into a word file instead

CLOUD DATA
SERVICES CASE STUDY
(NAME)
(COURSE)
(DATE)
(UNIVERSITY)

DESCRIPTION OF THE PROBLEM
Data regarding the latest problems have been collected and analyzed. In this regard, the
gathered data contain information such as the date, the exact problem that had cause the
server to be unavailable and the downtime.

An analysis of this information is useful for the evaluation of the quality of the server, as it
might help us to identify any potential event that triggers the server to become unavailable.
This information can be used by the IT department Cloud Data Services to optimize the
systems as it helps identify possible problems related to server management such that they
can be solved.

WHICH ARE THE MAIN PROBLEMS ORIGINATING
THE SERVER DOWNTIME?

WHICH IS THE IMPACT OF THE SERVER
DOWNTIMES?
Statistic

Result

Mean downtime

33.4 minutes

Median

32.5 minutes

Standard deviation

15.5 minutes

Variance

240

CONCLUSION
• According to the analysis carried out, the leading cause that explains why the servers at
the Cloud Data Services are down is the repeated memory errors and lockups. In this
regard, a total of 10 memory errors and 6 lockups have happened during the month of
November, representing a 45% and 27% of the total problems registered.
• The calculated average server downtime is of approximately 33.4 minutes. This result
should be closely taken into account considering that it might be annoying for our
customers to have to wait for more than half an hour for the server services to be
available again.


observation_date CPIAUCSL
2011-09-01
226.597
2011-10-01
226.750
2011-11-01
227.169
2011-12-01
227.223
2012-01-01
227.842
2012-02-01
228.329
2012-03-01
228.807
2012-04-01
229.187
2012-05-01
228.713
2012-06-01
228.524
2012-07-01
228.590
2012-08-01
229.918
2012-09-01
231.015
2012-10-01
231.638
2012-11-01
231.249
2012-12-01
231.221
2013-01-01
231.612
2013-02-01
232.985
2013-03-01
232.299
2013-04-01
231.795
2013-05-01
231.916
2013-06-01
232.374
2013-07-01
232.889
2013-08-01
233.323
2013-09-01
233.632
2013-10-01
233.718
2013-11-01
234.121
2013-12-01
234.723
2014-01-01
235.385
2014-02-01
235.672
2014-03-01
235.978
2014-04-01
236.471
2014-05-01
236.832
2014-06-01
237.029
2014-07-01
237.424
2014-08-01
237.256
2014-09-01
237.486
2014-10-01
237.506
2014-11-01
237.118
2014-12-01
236.290
2015-01-01
234.913
2015-02-01
235.489
2015-03-01
235.989
2015-04-01
236.201
2015-05-01
236.891
2015-06-01
237.419

National Inflation rate
0
6.75%
18.48%
2.38%
27.24%
21.37%
20.93%
16.61%
-20.68%
-8.26%
2.89%
58.10%
47.71%
26.97%
-16.79%
-1.21%
16.91%
59.28%
-29.44%
-21.70%
5.22%
19.75%
22.16%
18.64%
13.24%
3.68%
17.24%
25.71%
28.20%
12.19%
12.98%
20.89%
15.27%
8.32%
16.66%
-7.08%
9.69%
0.84%
-16.34%
-34.92%
-58.28%
24.52%
21.23%
8.98%
29.21%
22.29%

National inflati
0.8
0.6
0.4
0.2
0
-0.2

1 4 7 10 13 16 19 22 25

-0.4
-0.6
-0.8

The highest recorded inflation rate was of

2015-07-01
2015-08-01
2015-09-01
2015-10-01
2015-11-01
2015-12-01
2016-01-01
2016-02-01
2016-03-01
2016-04-01
2016-05-01
2016-06-01
2016-07-01
2016-08-01
2016-09-01
2016-10-01
2016-11-01
2016-12-01
2017-01-01
2017-02-01
2017-03-01
2017-04-01
2017-05-01
2017-06-01
2017-07-01
2017-08-01

237.876
237.811
237.467
237.792
238.153
237.846
238.106
237.808
238.078
238.908
239.362
239.842
239.898
240.389
241.006
241.694
242.199
242.821
244.158
244.456
243.752
244.158
243.846
243.790
244.048
245.030

19.25%
-2.73%
-14.47%
13.69%
15.18%
-12.89%
10.93%
-12.52%
11.35%
34.86%
19.00%
20.05%
2.33%
20.47%
25.67%
28.55%
20.89%
25.68%
55.06%
12.21%
-28.80%
16.66%
-12.78%
-2.30%
10.58%
40.24%
59.28%

National inflation rate

25 28 31 34 37 40 43 46 49 52 55 58 61 64 67 70 73 76 79 82 85

t recorded inflation rate was of 59.28%. It was recorded on February 2013

Attached for week 4 and week 5. Week 6 it seems that you've already completed it

Instructions:
Week 4 Individual Assignment
Total Number of Questions - 12

1. You have twelve problems - one on each tab of this Excel file.
2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell.
The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria

back and partial credit (if appropriate).

Fifty business students were given a project to complete. The bar graph below shows the number
of days it took the students to complete the assignme...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags