Category: Excel

The purpose of this project is to understand the features of a set of economic or financial variables and be able to find how they are related linearly by using regression methods. Use Excel to perform calculations.
My company is BP.L (Energy, UK). I have attached a brief and I also attached the Excel file that I started working on. You should know how to do calculations in excel, such as regression, covariance etc.
I also need a report (2000 words), I can create another order for that or you can increase the price. The report is based on the results conducted in Excel.

1. In Column E, determine OverheadRate using ProjectCost
2. In Column F, calculate Overhead Cost by multiplying ProjectCost times Overhead Rate
3. In Column G, calculate FinalCost by adding OverheadCost to ProjectCost
3. Calculate Min, Max, and Average FinalCost
4. In Column H, determine “Reject” if FinalCost is more than 325000 otherwise “Accept”
5. Draw a chart that depicts totals for Funding
6. Draw a chart that shows Funding totals brokendown by Division
7. Draw a chart that shows Funding totals relative to the Funding overall total
8. Create a pivot table that for each Funding source shows ProjectCost values for Division within Manager
9. In K21, count the number of projects that were rejected

Criminal organizations destroy lives and wreak havoc on communities. They are also increasingly difficult to combat, particularly when they extend beyond neighborhoods to regional, national, international, and transnational territories. Therefore, strong efforts to prevent the development and growth of these organizations is crucial. The most effective preventative strategies address psychological and/or sociological root causes of criminal organizations and include the cooperation of multiple law enforcement agencies, social service agencies, neighborhoods, and even businesses. Some community-based strategies are designed to quell the development of gangs and organized crime groups from the inside out by preventing adolescents from joining these criminal groups. Others seek to open lines of communication between community members and law enforcement so that community members feel comfortable providing information to the police.
In this Discussion, you consider strategies to prevent the creation, development, and growth of criminal organizations in your community. 
Post a letter to the editor of your local newspaper that addresses the following:
Explain what law enforcement is or should be doing to prevent new criminal organizations from entering your community.
Recommend an effective strategy to prevent the development and growth of criminal organizations in your community.
If your community has not been exposed to criminal organizations, explain what you would do to prevent them from taking root.
https://ojjdp.ojp.gov/sites/g/files/xyckuh176/files/media/document/gang_prevention.pdf
https://ctb.ku.edu/en/table-of-contents/advocacy/direct-action/letters-to-editor/main