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

## CO2 Emissions

CO2 Emissions

You will find information regarding a 2011 study on CO2 Emissions for the United States. Included in this
report is the population (i.e. column B), CO2 emissions per capita measured in tons (i.e. column C) for all
50 states (i.e. column A). Based on the template provided you are asked to complete the following tasks:
1. For the range in E1:F6, you are asked to compute various descriptive statistics for the CO2 Emissions
found in column C. Implement the correct formula in Excel to calculate the various statistics that
summarize all of the 50 states.
a. Hint: For the Grand Total, calculate the total CO2 emissions per capita from column C.
2. For the range E8:F15, you are asked to find the Bottom 5 CO2 emissions per capita. In other words,
you need to find the smallest value (i.e. minimum) in cell F9, second smallest value in cell F10, third
smallest value in F11, fourth smallest value in F12, and the fifth smallest in F13. To achieve this,
write a formula in cell F9 that can be filled down to F13, where the formula references the Bottom 5
values in E9:E13 respectably. Format these values as a comma style value with one decimal (i.e.
7,929.1).
3. In cell F14, calculate the total (i.e. sum) of the Bottom 5 values found in the previous step. Format
these values as a comma style value with one decimal (i.e. 7,929.1).
4. In cell F15, calculate the percent of the grand total, which would be a ratio of the sub total found in
the previous step and the grand total found in cell F6. Format this cell with yellow fill, bold text, and
a percentage with two decimals (i.e. 25.32%)
5. For the range E17:F24, you are asked to find the Top 5 CO2 emissions per capita. In other words, you
need to find the largest value (i.e. maximum) in cell F18, second largest value in cell F19, third
largest value in F20, fourth largest value in F21, and the fifth largest in F22. To achieve this, write a
formula in cell F18 that can be filled down to F22, where the formula references the Top 5 values in
E18:E122 respectably. Format these values as a comma style value with one decimal (i.e. 7,929.1).
6. In cell F23, calculate the total (i.e. sum) of the Top 5 values found in the previous step. Format these
values as a comma style value with one decimal (i.e. 7,929.1).
7. In cell F24, calculate the percent of the grand total, which would be a ratio of the sub total found in
the previous step and the grand total found in cell F6. Format this cell with yellow fill, bold text, and
a percentage with two decimals (i.e. 25.32%).
8. For the range E26:F29, you are asked to compute a summary based off your previous analysis. For
example, in cell F27, you are asked to reference the sub total that you calculated for the Bottom 5
States from your above. Similarly, in cell F28, you are asked to reference the sub total that you
calculated for the Top 5 States form your work above. However, in cell F29, you are asked to
calculate the remaining CO2 emissions from the remaining states not represented in the Bottom or
Top summaries. Thus, this will be a calculated value, which can be computed by subtracting the sub
totals of the Bottom (F14) and Top 5 (F23) from the Grand Total Value in F6.
9. Based on the sub totals appearing in F27:F29, you are to construct a pie chart, where the three
horizontal categories will include cells E27, E28, and E29, and the values appearing in the chart
should be F27, F28, and F29 respectively. Name this chart “CO2 Emissions Study” and roughly place
the top left corner of chart in H15 and the bottom right corner in O29. Ensure that a legend appears
in the right side of your chart. Also, ensure that data labels are present in the chart. For the data
labels, show only percentages with two decimal showing (i.e. 5.43%)
Now would be a good time to save your work.

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
Unlimited Free Revisions

#### Looking for a similar assignment. Place your order for a similar paper now and have excellent work written by our team of professionals to ensure you acquire the best grades.

If you find it difficult to balance your work and your studies because you are overwhelmed by other responsibilities, you have come to the right place . With the help of our dependable and simple-to-use essay and research writing service, students are able to focus on work or non-academic-related duties that they are required to carry out and complete all their school work on time .

We assist students who are struggling with their academic endeavors by allowing them to obtain essay assistance from  professional essay writers. We are never late for a deadline. When you ask our writer to write your paper, the assignment can be completed in as little as 12 hours or as long as 2 weeks. The order’s deadline is entirely up to you.

Place an order of your assignment if you are in urgent need of assistance because your essay is due in a few hours/days or you do not know how to complete your professor’s academic assignment. We are here to assist you. You are guaranteed of high grades through our services.

#### How to Place an Order

When you want Premiered Tutorials to do your homework for you, you 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.

Premiered Tutorials has competent writers to handle any of your assignments. 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 Premiered Tutorials?

If you need professional online homework help at a cheap price from professional and thoroughly vetted online homework helpers, reach out to the best homework help website, Premiered Tutorials.

Whether you are in high school, undergraduate, masters or PhD level, we have the best academic writers to assist you with your homework. We thoroughly vet all our online homework helpers to ensure they are competent to handle our clients’ tasks. Some of the requirements we have is ensuring that they are English Native speakers, have all attended colleges and had high grades in their undergraduate, Masters and PhD classes and have worked as academic writers and delivered high results.

We are a reliable and best essay writing website in the market. Our assignment help services or rather what our clients ask us to do for them include take my online class for me, order an essay cheap, pay someone to write my essay, help with my assignments, history homework help, college homework help, essay writing help online, answers for your homework, pay someone to do my homework for me, homework answers math, pay someone to take my proctored exams and nursing homework assignment help online. As the best website for homework answers, our homework doers also offer cheap essay writing services, online assignment help for all classes

• Law/ Criminal Law
• Nursing
• Information Technology
• Psychology
• Statistics
• Sociology
• History
• Communication
• Culture and Society
• Biology
• Astronomy
• Engineering

The courses indicated above are just but a small group of the types of classes Premiered Tutorials handles.

We have competent homework writers that can handle all academic disciplines regardless of the level of education of our clients.

When we do your homework for you, we write it from scratch to ensure you receive a unique paper. It also ensures that every homework we do for you is free from plagiarism and will help the client to get the highest grades in his or her classes. Any client who manages to consistently use our homework help services is guaranteed of always having the best grades and being one of the top students in the class because we always deliver the best quality for any homework we do for you.

When we complete working on your homework, we deliver the paper to you on time as we are well aware that the work we handle, is time sensitive. Timely deliveries of assignments help our clients get the highest grades because missed deadlines on assignments can result to deductions of marks for late submissions. Therefore, you will always be assured of quality online homework help through Premiered Tutorials whenever you ask us to do your homework for you.

#### 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