Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

https://data.sfgov.org/City-Management-and-Ethics/Vendor-Payments-Purchase-Order-Summary-/p5r5-fd7g (Links to an external site.)

Go to that website and then click on "EXPORT" and then choose "CSV FOR EXCEL". You will then be given the option to save or open the file. This is a large excel file so please only bid if you think you will be able to open it!

I was able to open and save the data on my laptop. So please try to download it right away and let me know if you are able to access it.

Answer the following questions using the City of San Francisco vendor payments dataset (excel). You will need to use Excel’s Pivot Table and Pie Chart features to complete this assignment.

Please complete the following questions only on the company called "NIBBI BROS ASSOCIATES INC" from the excel sheet: (post all on a word doc)

Question 1: How much money did your assigned company earn from the City of San Francisco each fiscal year from 2013 through 2018? Answer this in writing and also with a bar chart in a word doc. (you can complete it on excel and paste on word doc

Question 2: How many transactions did your assigned company have with the City of San Francisco each fiscal year from 2013 through 2018? Answer this in writing and also with a bar chart on word.

Question 3: How many total vendors did the City of San Francisco make payment of $1 or greater to each year from 2013 through 2018? Answer this in writing and also with a bar chart.

Question 4: What is the total spend by the City of San Francisco from 2013 to 2018? Answer this in writing and also with a bar chart.

Question 5: What is the annual spend per organization group (City of San Francisco) for all vendors and what percent of the total annual spend does each group represent? Use a series of pie charts to answer this question (one pie chart per fiscal year).



testimonials icon
I was on the way to Wilmington to see Aunt Carol over the loss of her husband Uncle Tony. Well I...
testimonials icon
Critical thinking1.Living on the CloudCloud computing is becoming more popular, and many users are working from the clo...
testimonials icon
Based on the gender based violence write a little poem, song or something that a verb or repeatations.You can argue, rhyme, sing, tw...
testimonials icon
Deflection. Double Integration Method and Virtual Work Method....
testimonials icon
1. Why is data aggregation useful?a. The data is cross referenced, so specific values or patterns can be locatedeasily.2. Google has so much RAM...
testimonials icon
mber ofhours reading and writing about it.For topic ideas, check the weekly schedule ofthemes in the course syllabus (examples there include Reconstru...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
Please read the Chapter12 text (pp.20...
testimonials icon
THIS PAPER IS DUE TODAY, BY 7 P.M. MUST BE 600 WORDS Tom Regan (1985) and Peter Singer (1989) agree that we have moral responsibilit...
testimonials icon
In Markus Zusak’s The Book Thief investment, one of the three major elements of narrative tension...
testimonials icon
Andrew Jackson was a good president. Andrew Jackson was born in the Carolinas in 1767. Andrew rece...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65