PSY 325 Week 3 DQ1

  This archive file contains PSY 325 Week 2 Discussion Question 1 Exel
Psychology - General Psychology

 Week 1 DQ1

 Types of Data

 Give an example of a research question that includes an independent and a dependent variable.  These are usually presented as, "How does A affect B?", where A is your independent variable and B is your dependent variable.  Describe the independent and dependent variables in terms of whether they are nominal (also called categorical), ordinal, interval, or ratio variables (interval or ratio variables are also called continuous variables).  How would you study this research question?

Guided Response:  Review several of your classmates’ posts.  Provide a substantive response to at least two of your peers that demonstrates thoughtful reflection and analysis of the discussion in relation to their variables and research questions.  Were their independent and dependent variables identified correctly?  Was the variable type specified well?  What would you ask them for further clarification?

 Week 1 DQ2

 Measures of Variability and Central Tendency

 For this discussion, come up with 20 different data points (set of data) and enter them into the first column in an Excel spreadsheet.  The data points can be any numbers you want as long as there are 20 of them.  Your set of data should reflect one of the following criteria:


 Create a set of data for which the mean is greater than the median.
 or
 Create a set of data for which the mean and median are equal but are different from the mode.


 You will then use the descriptive statistics option in Excel, which is explained in Chapter 1 of your course text.  You should get an output similar to Figure 1.2.  This output must contain the following values: mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count.  Begin your discussion by reporting your results for each of these values.  Based on this output, which single value best describes this set of data and why?  If you could pick three of these values instead of only one, which three would you choose and why?  It is important to note that the answers to these questions may be different for each of you since you are each using unique sets of data.

Guided Response: Review several of your classmates’ posts. Provide a substantive response to at least two of your peers.  Do you agree with their selections of the best value based upon their data?

 This exercise requires the use of the "Analysis ToolPak" within Excel.  This feature is already part of the 2007 and 2010 Excel program; however, it must be activated.  The following directions were provided by the "Help" function within Excel.  If you experience issues while following these steps, utilize the "Help" function within Excel or contact Microsoft's technical support for Excel.

 The Analysis ToolPak includes the tools described below. To access these tools, click Data Analysis in the Analysis group on the Data tab. If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program.

 Load the Analysis ToolPak

   1.  Click the File tab, click Options, and then click the Add-Ins category.

   2.  In the Manage box, select Excel Add-ins and then click Go.

   3.  In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.


Tip:  If Analysis ToolPak is n

Click this link Now for Complete Course - https://bitly.com/1xpvn5R

Going to college is a real commitment. If you are thinking about getting an education, you need to make sure you will have enough time to attend classes and do your homework. You might have to make some changes to your schedule, talk to your family and to your employer before you enroll for school.