Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us :

US Charities

Start with the Excel workbook (spreadsheet) US Charities –

Based on a 2012 study by Forbes, the starting worksheet contains four columns of information, which relate to top 100 charities in the United States. In terms of the information provided, Column A lists the Name of the organization; Column B is the value the charity received in private support; Column C lists each charity’s total revenue for 2012, and Columns D through F represent he percent of fundraising efficiency and charitable commitment respectively.

For this problem, you are to first complete the descriptive statistics summary starting in cell H2. To complete this portion of the problem, you will need to utilize functions such as MIN, AVERAGE, MEDIAN, MAX, and SUM. For example, H2 will represent the minimum private support out of the 100 organizations listed in range A2:E101, I2 will represent the minimum total revenue of the 100 organizations and so forth. In a similar fashion, you will fill out the table for the remaining descriptive statistics for the entire table listed in A2:E101.

Next, for the 4 columns of information (i.e. Private Support, Total Revenue, Fundraising Efficiency, and Charitable Commitment, you are to fill out the Bottom 5 table, which starts in H9. In order to fill out the majority of the table (i.e. range H9:K13) you will need to use the SMALL function in Excel. You are then asked to fill in the correct formulas in the range H14:I15. In terms of the sub total for this portion of the table, you will use the SUM function of the Bottom 5 values above, and you will reference this sub-total and the grand total above to determine the percentage.

Similar to the instructions above for the Bottom 5 table, you will fill out the remaining cells with formulas for the Top 5 table. For the range H18:K22, you will need to use the LARGE function in Excel.

Finally, ensure all dollar values summarized are formatted as an Accounting value with no decimal places (i.e. $3,903). In addition to dollar values reported, ensure that percentages are all formatted as a percentage with two extra decimals (i.e. 89.64%)

NOTE: The dataset was downloaded directly from Forbes and was not modified. There does seem to be a slight problem with the dataset in that there are no values reported for World Help in row 96. Please include this row in your calculations, even though the values are missing

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

Why Choose US   

    6+ years experience on custom writing
    80% Return Client
    Urgent 2 Hrs Delivery
    Your Privacy Guaranteed
    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 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. 

Homework Help Website

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.


Statistics about Us

130 New Projects
235 Projects in Progress
315 Inquiries
420 Repeat clients

© 2021 Premiered Tutorials
All rights reserved. We provide online custom written papers, such as term papers, research papers, thesis papers, essays, dissertations and other custom writing services.

All papers inclusive of research material are strictly intended to be used for research and study purposes only. Premiered Tutorials does not support or condone plagiarism in any form. These custom papers should be used with proper reference.

Place an Order
error: Content is protected !!