View the step-by-step solution to:

Problems 1 and 2 below refer to the following data for the variable "cognitive ability": 100 90 80 100 90 110 130 100 120 80 110 80 130...

I need to solve the 5 problems using excel and a histogram.
Problems 1 and 2 below refer to the following data for the variable "cognitive ability": 100 90 80 100 90 110 130 100 120 80 110 80 130 120 130 130 100 110 110 100 100 100 120 130 80 Problem 1: Construct a frequency distribution (non-grouped) that summarizes the data for "cognitive ability": Cognitive Ability Frequency Total Problem 2: Construct a relative frequency distribution (non-grouped) for the "cognitive ability" data: Cognitive Ability Relative Frequency Total Problems 3, 4, and 5 below refer to the following data for the variable "cognitive ability": 102 107 104 125 125 105 98 101 118 100 100 115 102 119 108 98 110 114 128 100 110 109 121 128 102 103 97 111 100 117 103 105 106 106 107 108 107 107 106 119 110 111 109 108 111 111 109 110 108 110 Problem 3: Construct a grouped frequency distribution that summarizes the data for "cognitive ability": You can use the following formula to determine the number of classes: k = 1 + 3.3 log10 N (Sturges, 1926), where "k" = number of classes, "log10" = logarithm of base 10 of a number, and "N" = number of scores. For example, if our number of scores were 80, we would write the following formula in Excel: =1+3.32*(LOG10(80)), which would return a value of 7.318259, which rounded to a whole value (integer) would be 7. So, in this case we would use 7 classes. To figure the class size or "width", you can use the following formula: W = (largest value-smallest value)/k, where k = number of classes. would be 11. So, the intervals in this example would be as follows: 69-80; 81-92; 93-104; 105-116; 117-128; 129-140; and 141-152. Problem 4: Construct a grouped relative frequency distribution for the "cognitive ability" data: Problem 5: Using the grouped frequency distribution you made in problem 3, construct (a) a histogram, and (b) describe the shape of the distribution (i.e., symmetrical, approximately symmetrical, unimodal, multimodal, positively skewed, negatively skewed?) Reference: Week 2 Problems - Due Week 2, Day 7 (Monday) Post this assignment in the Assignment section as a Microsoft® Word or Microsoft® Excel attachment: Suppose that in our example above, our highest value were 150 and our lowest value were 70. So, W = 150-70/7 = 80/7 = 11.42 ≈ 11. In this case the class size Sturges, H. A. (1926). The choice of a class interval. Journal of the American Statistical Association, 21, 65-66.
Background image of page 01
Important: The use of web sites and/or "online tutoring services" were you can post an assignment problem or question and receive an answer is strictly You are advised to consult with your teammates and/or your instructor. Problem 1: “For the fol owing scores, find the (a) mean, (b) median, (c) sum of squared deviations, (d) variance, and (e) standard deviation: 2, 2, 0, 5, 1, 4, 1, 3, 0, 0, 1, 4, 4, 0, 1, 4, 3, 4, 2, 1, 0” (Aron, Aron, & Coups, 2009) Problem #2: “For the fol owing scores, find the (a) mean, (b) median, (c) sum of squared deviations, (d) variance, and (e) standard deviation: 1,112; 1,245; 1,361; 1,372; 1,472” (Aron, Aron, & Coups, 2009) Problem #3: “For the fol owing scores, find the (a) mean, (b) median, (c) sum of squared deviations, (d) variance, and (e) standard deviation: 3.0, 3.4, 2.6, 3.3, 3.5, 3.2” (Aron, Aron, & Coups, 2009) Problem #4: “Describe and explain the location of the mean, mode, and median of a distribution of scores that is strongly skewed to the left.” (Aron, Aron, & Coups, 2009) Problem #5: “You figure the variance of a distribution of scores to be -4.26. Explain why your answer cannot be correct.” (Aron, Aron, & Coups, 2009) Problem #6: “On a standard measure of hearing ability, the mean is 300 and the standard deviation is 20. Give the Z scores for persons who score (a) 340, (b) 310, and Problem #7: “A person scores 81 on a test of verbal ability and 6.4 on a test of quantitative ability. For the verbal ability test, the mean for people in general is 50 and the standard deviation is 20. For the quantitative ability test, the mean for people in general is 0 and the standard deviation is 5. Which is this person’s stronger ability: verbal or quantitative? Explain your answer to a person who has never had a course in statistics.” (Aron, Aron, & Coups, 2009) Problem #8: “You are conducting a survey at a col ege with 800 students, 50 faculty members, and 150 administrative staf members. Each of these 1,000 individuals has a single listing in the campus phone directory. Suppose you were to cut up the directory and pul out one listing at random to contact. What is the probability it would be (a) a student, (b) a faculty member, (c) an administrative staf member, (d) a faculty or administrative staf member, and (e) anyone except an administrative staf member? (f) Explain your answers to someone who has never had a course in statistics.” (Aron, Aron, & Coups, 2009) Problem #9: Indicate which of the numbers below would qualify as measures of probability. (a) 1 (d) 0.8 (g) 150% (j) 1/4 (m) -0.5 (b) 3/5 (e) 5% (h) 0.25 (k) 1.1 (n) 0.99 (c) 75% (f) 108% (i) 2 (l) -7/8 (o) 0 Problems 10, 11, 12, and 13 below refer to the "cognitive ability" scores for a sample of students: Cognitive Ability Relative Frequency 90 0.07 95 0.15 100 0.3 105 0.25 110 0.1 115 0.09 120 0.03 125 0.01 Total 1 Note: The relative frequency is an estimate of probability. Also, don’t forget to read the subtopic entitled “Addition Rule” on pages 96-97 of our textbook (Aron, Aron, & Coups, 2009, pp. 96-97). Problem #10: What is the estimated probability that a randomly selected student from the sample has a score that is more than 115? Problem #11: What is the estimated probability that a randomly selected student from the sample has a score that is 110 or more? Problem #12: What is the estimated probability that a randomly selected student from the sample has a score that is 105 or less? Problem #13: What is the estimated probability that a randomly selected student from the sample has a score that is less than 115? Reference: Week 3 Problems - Due Week 3, Day 7 (Monday) Post this assignment in the Assignment section as a Microsoft® Word or Microsoft® Excel at achment: prohibited. This wil be considered cheating, which is a very serious academic offense . The problems need to be worked out by you. (c) 260. Give the raw scores for persons whose Z scores on this test are (d) 2.4, (e) 1.5, (f) 0, and (g) -4.5.” (Aron, Aron, & Coups, 2009) Aron, A., Aron, E., & Coups, E. J. (2009). Statistics for psychology (5th ed.). Upper Saddle River, NJ: Pearson Education.
Background image of page 02
Show entire document

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question