NEED IT ON TIME; NO JOKERS ; PRICE IS INDICATED; IF YOU HAVE BAD REVIEWS DONT PING.....I WILL SEND THE STATISCTICAL BOOK AND TABLES INTO YOUR MAIL

Welcome Info

Welcome to unit 3!

This week will involve a mix of research and analysis. For the first portion of the IP you will be researching surveys already published, paying attention to the sample size and possible areas of bias. Be sure to mention how EACH survey could be used in the business environment. What is the potential application?

After analyzing surveys that have already been created you will have the opportunity to create your own. After the surveys have been created using an online survey tool such as SurveyMonkey.com or Zoomerag.com, you MUST use Excel to create graphs to visualize the results. You will earn ZERO points for the graphs if you simply copy and paste from the survey tool.

This week's skills will specifically focus on how to create these graphs.

In each GREEN Tab you will find information about the task you are to complete and try. In each RED tab you will find the solutions.

This will allow you to check your work and ensure you can complete the necessary process for each concept you are required to complete on the IP.

If your solution does not agree with the solution and you can't figure out why this is the situation, then please feel free to ask for some assistance.

You may reach me any time at

lemurray@faculty.aiuonline.edu

mailto:lemurray@faculty.aiuonline.edu

Creating a Survey

This week you will NOT be using the AIU data set that you used in wee 1 and week 2

Instead, you get to create your own survey.

First, think of a topic that interests you. It can be any topic of your choice as long as it is appropriate for the classroom. You do NOT want to choose a topic so limiting that you will have trouble finding responses, however. For example be careful about giving a survey that is specific to your neighborhood, region or experiences, as you may have trouble meeting the minimum response guidelines.

After you have chosen a topic, create three questions for the survey.

***While not a requirement, it would be helpful if your questions have a limited number of answer choices.***

Creating a survey that provides free responses may seem like a good idea…until you have to tally the responses and analyze the results. If you permit each person to write in responses, you may end up having 20 different responses.

Once you have written three questions and have written your corresponding answer choices, you are ready to create the survey!

You may choose from two different survey programs to create and administer your survey.

Here is a video tutorial for using Zoomerang:

How to use zoomerang

Here is a video tutorial for using SurveyMonkey:

How to use survey monkey

***PLEASE start this survey process early in the week as getting a minimum of respondents to participate is challenging in order to complete the tallying and the charts so that you are able to submit your paper before midnight on Sunday.***

Surveys may be shared via facebook, email, twitter or other forms of social media.

PLEASE START THIS PROCESS EARLY

If you are unable to gather 20 responses via social media, you may also contact participants face-to-face, over the phone, etc. and manually add those into your results.

http://youtu.be/dZHyh4O7cvw http://youtu.be/mtGSiZG7Vrs

Bar graph

Once you have collected your survey responses you are ready to make a graph!
Before you can create your graphs, you must enter the results of your survey for each question manually into Excel. These are then easily organized into the cells of Excel.
For example the responses to the Vet Survey can be entered as:
Question 1: What type of pets do you have?
Type	Frequency
Dog	18
Cat	10
Bird	7
Fish	10
Other	2
Question 2: Do you conisder your pets a part of your family?
Response	Frequency
Yes	18
No	3
Note that although there are only two questions as examples, you still must create three questions.
Once you have entered your data you are ready to make a graph.
Please view the following instructional video:
Analyzing your data
Now that you are ready, try making a bar graph based on the data in question one.
You may check your work on the next tab.

http://youtu.be/zNru7ougMWI

Bar graph solution

SOLUTION:

You must also write a short caption to describe the graph.

This does not have to be long but should be written in complete sentences.

For example:

This graph shows the majority of respondents owned dogs, followed with a tie for cats and fish.

Those who responded with "other", may own any animal not listed.

MOST COMMON ERRORS

Be sure to put a title on your graphs!

These titles should be meanignful to the graph.

For example, a good title tells what is in the graph.

A bad title such as frequency or number does not give any indication of what the graph contains.

Titles may be added under the layout tab om Excel.

***YOU MUST CREATE YOUR GRAPHS IN EXCEL! FAILURE TO DO SO WILL RESULT IN ZERO POINTS EARNED FOR THE GRAPH***

Type of animal

Frequency Dog Cat Bird Fish Other 18 10 7 10 2

Pie chart

The next graph you may want to try is a pie chart.

Remember that pie charts show pieces of a “whole”. You CANNOT make a pie chart if the pieces are not part of a whole.

For example we do not put the :

Mean

Median

Mode

On a pie chart, they do not represent pieces of a whole. They are separate and independent calculations.

In general, a good pie chart has at MOST 6 slices. If your graph has more than 6 slices, this may be a good indication that you should consider a different type of graph.

Next try making a pie chart from question 2 from the Vet Survey.

The same video from the last tab will assist you, or you can refer to the unit 1 pie chart graph.

Then check your solutions on the next tab.

Pie chart solution

SOLUTION:

Caption:

This graph shows that the majority of respondents (86%) consider their pets a part of the family, while the minority of respondents (14%) do not consider them a part of the family.

If you would like to check out common chart layouts to set up your graphs, simply click on the Layout Tab in Excel.

Do you consider your pet a part of the family?

Yes No 18 3

Your IP checklist

HIGH FIVE!!
You have completed all sample exercises and are now ready to start your IP.
To help you get started, here is a checklist of items that need to be completed.
Completed?		Area
		Download template for IP
		Your completed project should all be on this template. You do NOT have to submit your Excel file but instead copy/paste all information from Ecel onto the template.
		Failure to use this template will result in an automatic 10 point penalty. DO NOT remove the bolded headings.
		Find an entertainment survey
		Summarize the study
		Analyze the sample size. Does it accurately represent the population?
		Discuss how the survey could be used by the sponsoring company or media group.
		This survey article must come from the Proquest database in the AIU library.
		Find a political survey
		Summarize the study
		Analyze the sample size. Does it accurately represent the population?
		Discuss how the survey could be used by the sponsoring company or media group.
		This must come from the Pew or Gallup online sites, for which links are provided in the assignment list.
		Find a General Opinion Survey
		Summarize the study
		Analyze the sample size. Does it accurately represent the population?
		Discuss how the survey could be used by the sponsoring company or media group.
		This must come from thePpew or Gallup online sites.
		Provide an overview
		Compare and contrast the sample size for each survey.
		Which do you think is most accurate and why?
		Be sure to cite and reference your textbook here!
		Create a survey!
		Use Zomerang.com or Surveymonkey.com to create a survey of three questions.
		Share this survey via facebook or email.
		Check out proflmurray.webs.com for more information about using each web site.
		Provide a copy of your survey
		This should be a blank copy of the survey and include all answer choices.
		Do NOT include a link to your survey as these will expire. Copy/paste the questions and answer choices into the paper.
		Create one graph for the total responses to every question.
		Consider making a pie or bar chart for each question
		Explain the graphs in words.
		-This should be an appropriate graph that gives a good picture of the data
		Explain your survey results
		Identify a group or company that may be interested in your results.
		Why would this be important to the sponsoring company? How could they use this information?
		Be sure to be specific! Don’t say the results could help business. Elaborate HOW could they be used.
		Sources cited
		Be sure these are cited both In-text and on the last page (references) in APA format.
Are you sensing a theme?? Be sure to check out the live chat, the videos at proflmurray.webs.com and the unit 3 newsletter. You’ll find lots of helpful information there.

DO NOT MAKE THESE ERRORS

Unit 3 Common Errors

Discussion Board

Sample Size Research

Sample size research for paragraph one must come from a .gov or .edu website. Do not include information from other websites that end in .com.

Sample Size Calculators

Be sure that these calculate the sample size recommended for a study.

Mention which values you filled in.

What was the recommended sample size?

Individual project

Required Research

Be sure to meet the research requirements for each study (either a Pew, Gallup or Proquest newspapers). Specific requirements for each study are listed in the assignment description.

Required Discussion For Each Study

Be sure each study description mentions if the sample size is adequate and how the results could be used by the company or sponsoring organization.

If the study does not mention how many people were surveyed, discuss if you believe the results are valid. If so, why. If not, why not?

Overview

Compare and contrast the sample sizes.

You MUST cite the textbook here.

Application

Include a copy of your survey, NOT a link to the survey, since the links will expire.

Create one graph per question in Excel. Do not use the survey program to make a graph.

Provide a written description of each graph.

Citations

Be sure these are in APA format and are both in-text and at the end of the report in the references.