Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us : premieredtutorials@gmail.com
PREMIERED TUTORIALS

World’s Biggest Public Companies

World’s Biggest Public Companies

This data shows information produced by Forbes in terms of the World’s Largest Public Companies. In column B, the company’s name is displayed; in column C, the country; in column D, the company’s 2013 sales; in column E, the company’s 2013 profits; in column F, the company’s 2013 assets; in column G, the company’s 2013 market value. In the range I1:M5, you will see the first matrix that you will need to summarize, where the goal is to determine the median value of sales, profits, assets and market value respective to the corresponding country. However, to date, Excel does not feature a MEDIANIFS function. Thus, you will have to use an array formula similar to our learning activity. Executing this statement correctly will produce a median of the desired values in the dataset for the given country of interest.

In the range I7:M11, you will see the second matrix that you will need to summarize, where the goal is to determine the min value of sales, profits, assets and market value respective to the corresponding country. However, to date, Excel does not feature a MINIFS function. Thus, you will have to use an array formula similar to our learning activity. Executing this statement correctly will produce a min of the desired values in the dataset for the given country of interest.

In the range I13:M17, you will see the third matrix that you will need to summarize, where the goal is to determine the max value of sales, profits, assets and market value respective to the corresponding country. However, to date, Excel does not feature a MAXIFS function. Thus, you will have to use an array formula similar to our learning activity. Executing this statement correctly will produce a max of the desired values in the dataset for the given country of interest.

In the range I19:M23, you will see the third matrix that you will need to summarize, where the goal is to determine the standard deviation value of sales, profits, assets and market value respective to the corresponding country. However, to date, Excel does not feature a STDEV.S.IFS function. Thus, you will have to use an array formula similar to our learning activity. Executing this statement correctly will produce a max of the desired values in the dataset for the given country of interest. Please note that the “dot S” portion of the STDEV function indicates that we are taking the standard deviation of a sample. This is a sample since we do not have information from all companies (i.e. population).

Finally, ensure that all values in your summary tables are formatted with an Accounting style with two decimals showing (i.e. \$52.21)

HINT: Be very careful about what cell references are absolute and which are mixed (the row or column absolute and the other relative). Also, remember that you must use a Ctrl+Shift+Enter keystroke in order to implement an array formula in Excel.

Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A ResultsWhy Choose US

6+ years experience on custom writing
80% Return Client
Urgent 2 Hrs Delivery
Unlimited Free Revisions

How to Place an Order

Send the assignment details such as the instructions, due date/deadline, number of pages and college level to the customer support agent online on live chat,  fill in the assignment details at place an order or send the information to our email address premieredtutorials@gmail.com and a customer support agent will respond to you immediately.

Once you place your order, we choose for you the best and competent writer for your assignment based on each writer’s competence in handling a subject.

When the homework is completed, we have a quality assurance team that proofreads the assignment to ensure it meets the required rubric instructions from your professor.

After thorough review of your assignment, we send the paper to the client. In case you need any changes at this point, you can let us know so that we can handle it for you at no extra charge.

Why we should write your Paper

1. Money Return guarantee
2. 0% Plagiarism Rate
3. Guaranteed Privacy
4. Written from scratch by highly qualified writers
5. Communication at Any Time (24/7)
6. Flexible Pricing and Great Discount Programs
7. Timely Deliveries
8. Free Amendments
Looking for a similar assignment and in urgent need for help? Place your order and have excellent work written by our team of professionals to ensure you acquire the best grades.

We are here to assist you.