1. From 2013-2016, what was the total spending in each of the four calendar years? In each of the years 2013 - 2016, how much was spent in each of the three categories of government (Education, General Government, and Public Works)? 2. In 2016, which account (use the field "Account Desc" for this answer) was the largest in the General Government category? 3. In 2016, who was Somerville's largest vendor as measured by total dollars spent? How many separate payments did the city make to this vendor? What was the average amount of each payment to this vendor? Why did the city pay this vendor? 4. How much in expenditures did Somerville have related to Property, Plant and Equipment (use the field "Item Class" for this answer) in the General Government category in each of the years 2013 - 2016? How much in expenditures in each of those years were related to repairs and maintenance? 5. Prepare a pivot table that shows a line chart of Somerville's expenditures in each of the three categories of government (Education, General Government, and Public Works) for the years 2013 - 2016. Prepare a pivot chart using the line chart type of this information on the same worksheet. Analyze the pivot chart and summarize the trends. 6. As a separate document, create a memo about what you found in the pivot tables and charts. Assume that the readers of the memo will be both city officials who are knowledgeable about the city but not about data analytics or necessarily how to interpret data. You should make this a standalone document. That is, the person should not need to go back and forth between your memo and your analysis. You are free to copy any information you wish from your analysis to make this possible.
1. From 2013-2016, what was the total spending in each of the four calendar years? In each of the years 2013 - 2016, how much was spent in each of the three categories of government (Education, General Government, and Public Works)? 2. In 2016, which account (use the field "Account Desc" for this answer) was the largest in the General Government category? 3. In 2016, who was Somerville's largest vendor as measured by total dollars spent? How many separate payments did the city make to this vendor? What was the average amount of each payment to this vendor? Why did the city pay this vendor? 4. How much in expenditures did Somerville have related to Property, Plant and Equipment (use the field "Item Class" for this answer) in the General Government category in each of the years 2013 - 2016? How much in expenditures in each of those years were related to repairs and maintenance? 5. Prepare a pivot table that shows a line chart of Somerville's expenditures in each of the three categories of government (Education, General Government, and Public Works) for the years 2013 - 2016. Prepare a pivot chart using the line chart type of this information on the same worksheet. Analyze the pivot chart and summarize the trends. 6. As a separate document, create a memo about what you found in the pivot tables and charts. Assume that the readers of the memo will be both city officials who are knowledgeable about the city but not about data analytics or necessarily how to interpret data. You should make this a standalone document. That is, the person should not need to go back and forth between your memo and your analysis. You are free to copy any information you wish from your analysis to make this possible.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Subpart 6. The answer, please.
Transcribed Image Text:1. From 2013 - 2016, what was the total spending in each of the four calendar years? In each of the years 2013 - 2016, how much was spent in each of the
three categories of government (Education, General Government, and Public Works)?
2. In 2016, which account (use the field "Account Desc" for this answer) was the largest in the General Government category?
3. In 2016, who was Somerville's largest vendor as measured by total dollars spent? How many separate payments did the city make to this vendor? What
was the average amount of each payment to this vendor? Why did the city pay this vendor?
4. How much in expenditures did Somerville have related to Property, Plant and Equipment (use the field "Item Class" for this answer) in the General
Government category in each of the years 2013 - 2016? How much in expenditures in each of those years were related to repairs and maintenance?
5. Prepare a pivot table that shows a line chart of Somerville's expenditures in each of the three categories of government (Education, General Government,
and Public Works) for the years 2013 - 2016. Prepare a pivot chart using the line chart type of this information on the same worksheet. Analyze the pivot
chart and summarize the trends.
6. As a separate document, create a memo about what you found in the pivot tables and charts. Assume that the readers of the memo will be both city officials
who are knowledgeable about the city but not about data analytics or necessarily how to interpret data. You should make this a standalone document.
That is, the person should not need to go back and forth between your memo and your analysis. You are free to copy any
information
you
wish from your
analysis to make this possible.
Transcribed Image Text:A
В
C
E
F
G
H
|
J
K
L
M
1
Sum of Amount
Column Labels
2
Row Labels
v Education
General Government Public Works
Grand Total
2013
103,035,030 $ 41,224,910 $ 157,158,459
84,464,671 $ 43,654,715 $ 141,432,243
$
12,898,519 $
$
13,312,857 $
$
14,391,024 $
$
14,463,190 $
$
3
4
2014
120,518,951 $ 55,211,387 $ 190,121,361
128,668,856 $ 45,170,727 $ 188,302,774
436,687,509 $ 185,261,739 $ 677,014,837
5 2015
6 2016
7
Grand Total
55,065,589 $
$140,000,000
8.
9.
$120,000,000
10
$100,000,000
11
12
$80,000,000
Education
13
Gener al Government
14
$60,000,000
Public Works
15
$40,000,000
16
17
$20,000,000
18
19
$-
20
2013
2014
2015
2016
21
22
23
24
25
26
27
28
29
30
31
32
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman