New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

Methods of Public Policy Analysis and Presentation

by: Juwan Shields

Methods of Public Policy Analysis and Presentation PAF 315

Marketplace > Syracuse University > Urban Affairs&Public Policy > PAF 315 > Methods of Public Policy Analysis and Presentation
Juwan Shields
GPA 3.9


Almost Ready


These notes were just uploaded, and will be ready to view shortly.

Purchase these notes here, or revisit this page.

Either way, we'll remind you when they're ready :)

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

Class Notes
25 ?




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.

Similar to PAF 315 at Syracuse

Popular in Urban Affairs&Public Policy


Reviews for Methods of Public Policy Analysis and Presentation


Report this Material


What is Karma?


Karma is the currency of StudySoup.

You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

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


Buy Material

Are you sure you want to buy this material for

25 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

Why people love StudySoup

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Amaris Trozzo George Washington University

"I made $350 in just two days after posting my first study guide."

Bentley McCaw University of Florida

"I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"

Parker Thompson 500 Startups

"It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.