solution to psyc 354 Homework 7EXCEL HOMEWORK 7 (70 PTS POSSIBLE) Research Question:A clinical psychologist is treating 25 patients with clinical depression….
solution to psyc 354 Homework 7EXCEL HOMEWORK 7 (70 PTS POSSIBLE) Research Question:A clinical psychologist is treating 25 patients with clinical depression. She wants to find out whether these patients score differently than the general population on an emotional response scale with a population mean Î¼ = 9.5. She is only interested in whether there is a difference, but not in the direction of the difference at this point. Open the â€œData Set 7â€ attachment under the â€œExcel Homework 7â€ header located in the Assignment Instructions folder and perform a single-sample t-test to evaluate this hypothesis. 1. State the null and alternative (research) hypothesis in symbolic form. Remember that your hypothesis should include evaluators such as =, [removed] or a combination of these.(7 pts) 2. Remember that we are only doing 2-tailed t-tests at this point. 3. Fill in the cells for the degrees of freedom andÎ¼, which are already known. These will be used in formulas as shown in this weekâ€™s presentation. (7 pts) 4. In the appropriate cell in the table, compute the standard deviation of the sample (s) using the steps shown in this module/weekâ€™s presentation. (7 pts) 5. Fill in the sample mean (M), using the AVERAGE function for the raw scores on the left. (7 pts) 6. We are going to test our hypothesis at the .01 level of significance. Enter the alpha value in the appropriate cell. (7 pts) 7. Find the critical t value for our test, based on the alpha level, using the TINV function as shown in this module/weekâ€™s presentation. Remember that we are running a two-tailed test, so no change to the alpha level is needed. (7 pts) 8. Compute the sample t score using the steps gone over in this weekâ€™s presentation. (7 pts) 9. Fill in the critical p-value based on your alpha level. (7 pts) 10. Compute your sampleâ€™s p-value (based on your sampleâ€™s t score) by using the TDIST function as shown in this module/weekâ€™s presentation. (7 pts) 11. Answer the 2 questions underneath the second table directly in Data Set 7, after each question as indicated. (Questions = 3.5 points each for total of 7 pts.)
Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Our Homework Writing Disciplines
With a highly diverse team in almost all academic fields including: