MPA 620 Research for Public Administration Unit 6 Discussion

User Generated

pelfgnyjm8q

Business Finance

MPA 620

MPA

Question Description

I'm working on a business multi-part question and need an explanation to help me learn.

  • Prompt: Many students begin Research for Public Administration, lacking the ability to effectively use spreadsheets to manipulate and analyze data.  The first M&Ms exercise is designed to introduce students to spreadsheets while the second Belhaven Church exercise is designed to take students through the necessary steps required to analyze data.  Please take a moment to critique these two exercises.  Did any elements of the two exercises enhance your learning?  Should any elements of the two exercises be revised to improve the learning process?

Unformatted Attachment Preview

APPENDIX E BELHAVEN CHURCH TITHING PROJECT 1 APPENDIX E BELHAVEN CHURCH TITHING PROJECT TABLE OF CONTENTS Descriptive statistics for the data............................................................................................ 2 Age and average tithing analysis ............................................................................................ 3 Income and average tithing analysis ...................................................................................... 4 Church attendance and mileage analysis............................................................................... 5 Church satisfaction and tithing analysis ................................................................................ 6 Age and satisfaction analysis................................................................................................... 7 Response Rate........................................................................................................................................ 8 2 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Descriptive statistics for the data 1. What are the descriptive statistics for the data? The project will entail use of tables with counts and percentages for determining the tithing percentage, level of satisfaction, average attendance and the relationships of phenomenon under study. These are aimed at logically organizing raw data into meaningful information that will assist the leaders in decision making. This will point out development areas and enhance service delivery. 3 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Age and average tithing analysis 1. Do the average tithing percentages vary among the three age groups in the study? Table: Count Young Adult Average 7 18.6 Adult 11 28.2 Senior Adult 12 31.1 Total 30 26.8 Chart: Average Tithe Percentage 40.0 28.2 31.1 Adult Senior Adult 26.8 18.6 20.0 0.0 Young Adult Total Series2 Findings: The results of the survey suggest senior adults (n=12, 31.1%) members tithe at a 12.5% higher rate than Young adults (n=7, 18.6%) members of the church 4 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Income and average tithing analysis 2. Do the average tithing percentages vary among the four income groups in the study? Table: Count Average Lower 5 19.3 Lower middle 7 23.8 Upper middle 11 28.2 Upper income 7 32.9 30 26.8 Total Chart: Average Tithe Percentage 40.0 30.0 20.0 19.3 23.8 28.2 32.9 26.8 10.0 0.0 Lower Lower middle Upper middle Upper income Total Findings: The results of the survey suggest those in upper income (n=7, 32.9%) members tithe at a 13.6% higher rate than those in lower quadrant (n=5, 19.3%) members of the church 5 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Church attendance and mileage analysis 3. Do the average attendance rates vary among the three mileage groups in the study? Table: Count Average Less than 6 miles 13 28.7 6-10 miles 10 24.3 7 23.3 30 25.2 Over 10 miles Total Chart: Attendance Rate and Mileage 40.0 30.0 28.7 24.3 23.3 25.2 Over 10 miles Total 20.0 10.0 0.0 Less than 6 6-10 miles miles Findings: The results of the survey suggest those who are walk less 6 miles (n=13, 28.7%) members attend church at a 5.4% higher rate than those who walk over 10 miles (n=7, 23.3%) members of the church. 6 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Church satisfaction and tithing analysis 4. Does there seem to be a relationship between church satisfaction and tithing percentage? Table: Count Average least 0 0.0 Less 0 0.0 Moderate 10 27.0 More 11 27.0 Most 9 26.3 Total 30 26.8 Chart: Church satisfaction and Tithing 30.0 25.0 20.0 15.0 10.0 5.0 0.0 27.0 0.0 27.0 26.3 26.8 0.0 Findings: The results of the survey suggest those who are moderate and more satisfied (n=10, 27%) (n=11, 27%) respectively members tithe at 0.7 % higher rate than those who are most satisfied (n=9, 26.3%) members of the church. 7 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Age and satisfaction analysis 5. Are there any other interesting observations you can report to the leadership team, such as what is the response rate for the study? There is relationship of age and satisfaction as illustrated in the table below. Table: Count Average Young Adult 7 12.9 Adult 11 12.4 Senior Adult 12 13.6 Total 30 13.2 Chart: Age and Satisfaction 14.0 13.6 13.5 13.2 12.9 13.0 12.4 12.5 12.0 11.5 Young Adult Adult Senior Adult Total Findings The results of the survey suggest that the seniors Adults are more satisfied (n=12, 13.6%) at a higher rate of 1.2 % higher rate than the adults (n=11, 12.4%) members of the church. 8 APPENDIX E BELHAVEN CHURCH TITHING PROJECT Response Rate The table below illustrates the response rate from the target population of 120 members of the church. Moreover, 30 members accounting for 25.0% were responsive in the survey that was conducted by the church leaders. Table: Target population 120 Number of responses 30 Response rate 25.0% Chart: 140 120 Response Rate 120 100 80 60 30 40 20 0 Target population Number of responses Findings: The results of the survey suggest that the response rate was (n=30, 25.0%) that is lower by 75% than the target population (n=120, 100%) of the members of the church.
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

1

Research for Public Administration
Student’s Name
Institution Affiliation
Professor’s Name
Course Name
Date

RESEARCH FOR PUBLIC ADMINISTRATION

2

Research for Public Administration
Discussion
Spreadsheets offer essential tools to perform mathematical computation on data. They
give one the means to transform and analyze data for e...

Xvfuarjg2017 (50497)
New York University

Similar Content

Related Tags