Data Analytics i ng Form iCarol - Call reports M myMU | Marshall U.. Community Specific... V MHFA Connect Tu Saved Help Save This question will be sent to your instructor for grading. Required information [The following information applies to the questions displayed below.] In any data analytics exercise, it is important to understand the underlying data as an aid in interpreting the results of any analysis undertaken. In this comprehensive problem that covers multiple chapters of the textbook, five cities in the state of New York are the basis for the analysis. The five cities are: . City of Elmira City of Poughkeepsie . City of Rome . City of Saratoga Springs . City of Watertown These five cities were selected because they are all in one state, thus governed by the same state reporting and audit requirements. The fact that the cities are governed by one set of reporting requirements means that the data reported follows the same chart of accounts and rules for what should be reported in each account. As you will see, state requirements may not always follow GAAP requirements or the recommendations of the text. Cities selected are fairly comparable in population size, but they are geographically dispersed within the state, which has an impact on their economy. A data set including information for the five cities has been provided. The data set includes: - Five years of data from 2014-2018 Modified accrual information for the General Fund, Capital Projects Funds, and Debt Service Funds . Budget information for the General Fund Click here to download the data set Click here for a brief tutorial on Pivot Tables in Excel. Click here for a brief tutorial on Pivot Table Filters and Charts in Excel. Next > Prev 1 2 of 2 Q Search