PSY 6402 Week 3 – Assignment: Calculate and Interpret Data

PSY 6402 Week 3 – Assignment: Calculate and Interpret Data

PSY 6402 Week 3 – Assignment Calculate and Interpret Data

How to Add the Option for Data Analysis to Excel 2016

Complete the following steps to add the option for data analysis to Excel 2016.

  1. Open Excel 2016.
  2. Click “File.”
  3. Click “Options.”
  4. Select “Add-ins” from the list of Options that appear on the left side of your screen.
  5. In the “Manage” area, click “Go.”
  6. The following screen will appear. Then, make sure that Analysis ToolPak and Analysis ToolPak  – VBA are checked.
  7. Click OK.

The “Data Analysis” area will now appear in the “Data” tab. This is the last option in this row and to the right of “Outline”:

  1. Click on “Data Analysis” to view the options for inferential statistical tests, as well as options for descriptive statistics:
  2. Select the “Descriptive Statistics” option; then, complete the following field:

The “Input Range” consists of the cells you want included in the analysis. To obtain the means for each age group and drug condition, be sure to select each set of BDI scores separately (i.e., younger adults in the placebo group, older adults in the placebo group, younger adults in the Drug A group, older adults in the Drug A group).

  1. Click OK.

This assignment has two parts, which will be submitted in one document.

For this task, you will calculate the mean, median, and mode for a fictitious data set. These data represent the results of a fictitious study, which investigates whether a new drug (Drug A) is more effective than a placebo (i.e., an inactive substance) in the treatment of depression. The researcher is also interested in whether the effects of the drug varies by age so participants between the ages of 18-39 years were recruited (the younger adult group), and participants between the ages of 60-80 years were recruited (the older adult group). Participants were randomly assigned to either the placebo group or to the drug group (Drug A). All participants were first screened to ensure they met the criteria for depression. After 2 months of taking either the placebo or Drug A, participants returned to the lab and completed a measure of depressive symptomology called the Beck Depression Inventory-II (BDI-II).

Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: PSY 6402 Week 3 – Assignment: Calculate and Interpret Data

Part 1

For the first part of this assignment, create a table showing the mean, median, and mode for each participant group and each drug condition on the score for the BDI-II. The data for each participant are contained in the “Participant Data” worksheet in the Data1 File. You may use Excel or you can calculate these values by hand. Your table should look like the following:

 

Younger Adults
Placebo		 Younger Adults
Drug A		 Older Adults
Placebo		 Older Adults
Drug A
Mean
Median
Mode

You must have the “Data Analysis” add-in installed. Directions for this installation are provided in the “Data Analysis in Excel 2016”

PSY 6402 Week 3 - Assignment Calculate and Interpret Data
PSY 6402 Week 3 – Assignment Calculate and Interpret Data

file located under your weekly resources. These instructions will also work for Excel 2010. This document also describes how to calculate basic descriptive statistics using Excel.

Part 2

For this part of the assignment, create a bar chart in Excel. You will need the “Summary Data for Graph” worksheet from the Data 1 file. Remember, the bar chart shows the means for each condition rather than individual participant data, and the data in this worksheet have been organized accordingly.

 

For the steps regarding how to create the bar graph, review the steps in “Creating a Bar Graph in Excel 2016” or “Creating a Bar Graph in Excel 2010,” located under your weekly resources. These instructions should also work with other versions of Excel.

You should copy and paste the graph you create into a Word document, along with your table showing the mean, median, and mode.

 

Length:1-2 pages

Your graph and table should demonstrate thoughtful consideration of the ideas and concepts presented in the course by providing new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards.

As we begin this session, I would like to take this opportunity to clarify my expectations for this course:

Please note that GCU Online weeks run from Thursday (Day 1) through Wednesday (Day 7).

 

Course Room Etiquette:

  • It is my expectation that all learners will respect the thoughts and ideas presented in the discussions.
  • All postings should be presented in a respectful, professional manner. Remember – different points of view add richness and depth to the course!

 

Office Hours:

  • My office hours vary so feel free to shoot me an email at Kelly.[email protected] or my office phone is 602.639.6517 and I will get back to you within one business day or as soon as possible.
  • Phone appointments can be scheduled as well. Send me an email and the best time to call you, along with your phone number to make an appointment.
  • I welcome all inquiries and questions as we spend this term together. My preference is that everyone utilizes the Questions to Instructor forum. In the event your question is of a personal nature, please feel free to post in the Individual Questions for Instructor forum I will respond to all posts or emails within 24 or sooner.

 

Late Policy and Grading Policy

Discussion questions:

  • I do not mark off for late DQ’s.
  •  I would rather you take the time to read the materials and respond to the DQ’s in a scholarly way, demonstrating your understanding of the materials.
  • I will not accept any DQ submissions after day 7, 11:59 PM (AZ Time) of the week.
  • Individual written assignments – due by 11:59 PM AZ Time Zone on the due dates indicated for each class deliverable.

Assignments:

  • Assignments turned in after their specified due dates are subject to a late penalty of -10%, each day late, of the available credit. Please refer to the student academic handbook and GCU policy.
  • Any activity or assignment submitted after the due date will be subject to GCU’s late policy
  • Extenuating circumstances may justify exceptions, which are at my sole discretion. If an extenuating circumstance should arise, please contact me privately as soon as possible.
  • No assignments can be accepted for grading after midnight on the final day of class.
  • All assignments will be graded in accordance with the Assignment Grading Rubrics

Participation

  • Participation in each week’s Discussion Board forum accounts for a large percentage of your final grade in this course.
  • Please review the Course Syllabus for a comprehensive overview of course deliverables and the value associated with each.
  • It is my expectation that each of you will substantially contribute to the course discussion forums and respond to the posts of at least three other learners.
  • A substantive post should be at least 200 words. Responses such as “great posts” or “I agree” do not meet the active engagement expectation.
  • Please feel free to draw on personal examples as you develop your responses to the Discussion Questions but you do need to demonstrate your understanding of the materials.
  • I do expect outside sources as well as class materials to formulate your post.
  • APA format is not necessary for DQ responses, but I do expect a proper citation for references.
  • Please use peer-related journals found through the GCU library and/or class materials to formulate your answers. Do not try to “Google” DQ’s as I am looking for class materials and examples from the weekly materials.
  • I will not accept responses that are from Wikipedia, Business dictionary.com, or other popular business websites. You will not receive credit for generic web searches – this does not demonstrate graduate-level research.
  • Stay away from the use of personal pronouns when writing. As a graduate student, you are expected to write based on research and gathering of facts. Demonstrating your understanding of the materials is what you will be graded on. You will be marked down for lack of evidence to support your ideas.

Plagiarism

  • Plagiarism is the act of claiming credit for another’s work, accomplishments, or ideas without appropriate acknowledgment of the source of the information by including in-text citations and references.
  • This course requires the utilization of APA format for all course deliverables as noted in the course syllabus.
  • Whether this happens deliberately or inadvertently, whenever plagiarism has occurred, you have committed a Code of Conduct violation.
  • Please review your LopesWrite report prior to final submission.
  • Every act of plagiarism, no matter the severity, must be reported to the GCU administration (this includes your DQ’s, posts to your peers, and your papers).

Plagiarism includes:

  • Representing the ideas, expressions, or materials of another without due credit.
  • Paraphrasing or condensing ideas from another person’s work without proper citation and referencing.
  • Failing to document direct quotations without proper citation and referencing.
  • Depending upon the amount, severity, and frequency of the plagiarism that is committed, students may receive in-class penalties that range from coaching (for a minor omission), -20% grade penalties for resubmission, or zero credit for a specific assignment. University-level penalties may also occur, including suspension or even expulsion from the University.
  • If you are at all uncertain about what constitutes plagiarism, you should review the resources available in the Student Success Center. Also, please review the University’s policies about plagiarism which are covered in more detail in the GCU Catalog and the Student Handbook.
  • We will be utilizing the GCU APA Style Guide 7th edition located in the Student Success Center > The Writing Center for all course deliverables.

LopesWrite

  • All course assignments must be uploaded to the specific Module Assignment Drop Box, and also submitted to LopesWrite every week.
  • Please ensure that your assignment is uploaded to both locations under the Assignments DropBox. Detailed instructions for using LopesWrite are located in the Student Success Center.

Assignment Submissions

  • Please note that Microsoft Office is the software requirement at GCU.
  • I can open Word files or any file that is saved with a .rtf (Rich Text Format) extension. I am unable to open .wps files.
  • If you are using a “.wps” word processor, please save your files using the .rtf extension that is available from the drop-down box before uploading your files to the Assignment Drop Box.

Grade of Incomplete

  • The final grade of Incomplete is granted at the discretion of the instructor; however, students must meet certain specific criteria before this grade accommodation is even possible to consider.
  • The grade of Incomplete is reserved for times when students experience a serious extenuating circumstance or a crisis during the last week of class which prevents the completion of course requirements before the close of the grading period. Students also must pass the course at the time the request is made.
  • Please contact me personally if you are having difficulties in meeting course requirements or class deadlines during our time together. In addition, if you are experiencing personal challenges or difficulties, it is best to contact the Academic Counselor so that you can discuss the options that might be available to you, as well as each option’s academic and financial repercussions.

Grade Disputes

  • If you have any questions about a grade you have earned on an individual assignment or activity, please get in touch with me personally for further clarification.
  • While I have made every attempt to grade you fairly, on occasion a misunderstanding may occur, so please allow me the opportunity to learn your perspective if you believe this has occurred. Together, we should be able to resolve grading issues on individual assignments.
  • However, after we have discussed individual assignments’ point scores, if you still believe that the final grade you have earned at the end of the course is not commensurate with the quality of work you produced for this class, there is a formal Grade Grievance procedure which is outlined in the GCU Catalog and Student Handbook.