2. In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for Oracle Corporation (NASDAQ: ORCL) below: Fiscal Year Total Revenue Net Income 2019 39,506 11,083 2018 39,831 3,825 2017 37,728 9,335 2016 37,047 8,901 2015 38,226 9,938 a. Calculate the net profit margin for each year. b. Calculate the compound average annual growth rates (CAGR) for revenue and net income using the GEOMEAN function. Is net income growing more slowly or faster than total revenue? Is this a positive for your investment in the company? c. Calculate the average annual growth rate of total revenue using the AVERAGE function. Is this result more or less accurate than your result in the previous question? Why? d. Create a Column chart of total revenue and net income. Be sure to change the chart so that the x-axis labels contain the year numbers, and format the axis so that 2019 is on the far right side of the axis.

The following table shows the approximate number of wireless telephone subscriptions in recent years.

Walmart predicted the following end-of-year earnings from 2003 - 2012 in billions of dollars (9.5, 9.8, 10.2, 10.7, 10.5, 11.0, 12.1, 14.7, 16.3, 18.7). Their actual end-of- year earnings for the same years are as follows: 9.1, 9.2, 10.6, 10.3, 9.9, 10.4, 11.6, 11.8, 13.1, 22.7). In testing the claim that the mean predicted value is the same as the mean actual value, which p-value is correct? 0.228 0.456 0.779 0.05 4

Need a Net balance graph for the given data

Find out the next month after april income by using the forecasting method  of the moving average method

Official unemployment rates for the U.S. population are reportedon a monthly basis by the Bureau of Labor Statistics.For the period October, 2011, through January, 2012, theofficial unemployment rates were 8.9% (Oct.), 8.7% (Nov.),8.5% (Dec.), and 8.3% (Jan.). (Source: U.S. Bureau of LaborStatistics, www.bls.gov.) If the unemployment rateswere to continue to decrease following a linear model,(a) predict the unemployment rate on January, 2013.(b) predict when the United States would reach a zero unemploymentrate.

The following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors (aaii.com, February 2002). Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts. Click on the datafile logo to reference the data. For the Exchange variable, show the "frequency and the percent frequency" for AMEX, NYSE, and OTC. Frequency & Percent Frequency for each: AMEX (? ) (? ), NYSE (? ) (? ), OTC ( ? ) ( ? ) Total (? ) (? )

The following table shows a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008. . The data set includes the following five variables: Use Excel to answer the following question: a. Prepare a crosstabulation of the data on Fund Type (row variable) and the average annual return over the past 5 years (column variable). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for the 5-Year Average Return (%) (Class width is 10). B. Construct frequency distributions for Fund Type and 5-Year Average Return (%) respectively. Based on the frequency distributions of the two variables, which of the following answers is wrong? Group of answer choices Out of the 45 mutual funds, there are 2 funds with 5-year average return of 30 - 40 (%).  Out of the 45 mutual funds, there are 28 funds with 5-year average return of 10 - 20 (%). Out of the 45 mutual funds, there are 28 DE type of funds.  Out of the 45 mutual funds, there are 10…

JOYFUL Fashion Company is reviewing the monthly sales in year 2021. The monthly sales (in millions) of each month were as below: Jan: $2.2 Jul: $3.4 Feb: $2.5 Aug: $3.7 Mar: $2.0 Sep: $2.1 Apr: $2.8 Oct: $2.5 Мay: $1.9 Nov: $2.3 Jun: $0.9 Dec: $4.6 (a) Find the mean, mode, standard deviation, and range of the above data. (b) Comment on the skewness of the above data. Explain your answer with the comparison of quartiles. The JOYFUL Fashion Company will issue a Gold Membership to customers with accumulated spending in January 2022 over 1% of 2021's average monthly sales and a Platinum Membership to customers with accumulated spending in January 2022 over 1% of the 80th percentile of 2021's monthly sales. (c) Mrs. Robinson has spent $27,450 in January 2022. Will she be qualified for the Gold Membership? Will she be qualified for the Platinum Membership? Explain your answers. (d) It is known that the average monthly sales from Jul 2020 to Dec 2020 were $1.9 millions. Find the average…

what are the three categories of business analytics