Methods of Public Policy Analysis and Presentation
Methods of Public Policy Analysis and Presentation PAF 315
Popular in Course
Popular in Urban Affairs&Public Policy
This 2 page Class Notes was uploaded by Juwan Shields on Wednesday October 21, 2015. The Class Notes belongs to PAF 315 at Syracuse University taught by Staff in Fall. Since its upload, it has received 56 views. For similar materials see /class/225661/paf-315-syracuse-university in Urban Affairs&Public Policy at Syracuse University.
Reviews for Methods of Public Policy Analysis and Presentation
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/21/15
Excel Training Cross Tabs In most of the ndings in your Community Link Reports you are looking at a single variable For example you may look at the percent of people who were very dissatis ed dissatis ed satis ed or very satis ed with a service provided However sometimes it may be useful and interesting to compare two variables This is where cross tabulations are useful Cross tabs allow you to see the relationship between two variables For instance you may want to see how females feel about the program compared to males or how different aged respondents feel about the program Example 9 Open EnableiDataiS et 9 Select the DataiSet worksheet if it is not already selected 9 Place the cursor in cell Al 9 Under data on the tool bar choose Pivot Table and Pivot Chart Report and the Pivot table wizard will open 9 Choose the default settings of Microsoft Of ce Excel List or database and PivotTable Click Next 9 Since the cursor was placed in cell Al the wizard automatically selects the entire data set Click Next 9 Select the default of opening the Pivot Table Report in a new worksheet Click Finish Create a cross tab of Sex and Support 9 Drag sex to the rows eld 9 Drag support to the column eld 9 Drag sex to the data items eld 9 To change the numbers to percentages double click the cell labeled Count of Sex in the comer of the table 9 Click the Optionsgtgt button 9 Under the heading show data as choose to display the results as percent of row This creates a cross tabulation of the two variables sex and support Now your nding statement could be more detailed For example 60 of females agreed or strongly agreed that they felt comfortable asking for support during a home visit Practice Create a cross tab using the age variable and the explain variable KPAFPAF 315 TAClass 07More Excel TrainingExcel Training Outlinedoc Weighted Averages Reminder Weighted average is calculated by nding the sum of multiplying each price by the units sold at that price and dividing it by the total units sold The formula looks like this 20 X 500 25 X 750 35 X 200500 750 200 2466 Sum total price sum units sold Weighted Average Computing Weighted Averages in Excel SUMPRODUCTA2A4B2B4SUMB2B4 Divides the total cost of all three orders by the total number of units sold 2466 Practice Under Practice Weighted Averages nd the weighted average for each of the three charts NOTE If the weight is already eXpressed in percentages then the weighted average can be determined by simply using the sum product function Final Grade SUMPRODUCTA2A4B2B4 Final Grade 8825 KPAFPAF 315 TAClass 07More EXcel TrainingEXcel Training Outlinedoc