Students from two classes tried out the popularity test. The higher the score, the more popular the person is. Here is the summary of the data: Class A Frequency Class Be Popularity Score Frequency? 18 19 10 20 21 30 20 22 30 23 24 6 40 6 20 25 26 30 27 1e 28 30 33 0 34 36 10 Meane 24.40 23.85. Standard Deviatione 3.59 2.08 Based on the above results, with the help of Excel, answer the following questions: a. James in Class A got 22 in the test. What is his z score in this test? b. Assuming the test scores are nomally distributed, detemine the percentile rank of James. c. Using nomal approximation, it was found that the percentile rank of Edward in Class B is 19. What is his raw score in this test?
Students from two classes tried out the popularity test. The higher the score, the more popular the person is. Here is the summary of the data: Class A Frequency Class Be Popularity Score Frequency? 18 19 10 20 21 30 20 22 30 23 24 6 40 6 20 25 26 30 27 1e 28 30 33 0 34 36 10 Meane 24.40 23.85. Standard Deviatione 3.59 2.08 Based on the above results, with the help of Excel, answer the following questions: a. James in Class A got 22 in the test. What is his z score in this test? b. Assuming the test scores are nomally distributed, detemine the percentile rank of James. c. Using nomal approximation, it was found that the percentile rank of Edward in Class B is 19. What is his raw score in this test?
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
please provide answer of abc
![Question 2
Students from two classes tried out the popularity test. The higher the score, the more popular
the person is. Here is the summary of the data:
Class A
Class Be
Popularity Score
Frequencye
Frequency
18
0
19.
20
30
210
20
22
3e
23e
24
25.
26
27
28
0
30
33
34
36
Meane
24.40
23.85e
Standard Deviatione
3.59
2.08
Based on the above results, with the help of Excel, answer the following questions: «
a. James in Class A got 22 in the test. What is his z score in this test?
b. Assuming the test scores are nomally distributed, detemine the percentile rank of James.
c. Using nomal approximation, it was found that the percentile rank of Edward in Class B
is 19. What is his raw score in this test?
d. Using the original distribution of the data, determine the percentile rank of James and
Edward. (Hint: If a lot of observations fall into the same category, when calculating the
percentile rank, we will assume half of the observations within the category is lower than
our target person while the other half is higher.)
e. Based on the answer in (d), comment on the popularity of James and Edward in their
classes.
f. Compare the percentile rank of James found in (b) and (d), are they the same? Why or
why not?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbadc16d5-7d56-4e68-aecd-f218fefc9dcc%2F6d5dca34-a3fe-42b6-83db-d36b1565db6c%2Fmrtz2ac_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Question 2
Students from two classes tried out the popularity test. The higher the score, the more popular
the person is. Here is the summary of the data:
Class A
Class Be
Popularity Score
Frequencye
Frequency
18
0
19.
20
30
210
20
22
3e
23e
24
25.
26
27
28
0
30
33
34
36
Meane
24.40
23.85e
Standard Deviatione
3.59
2.08
Based on the above results, with the help of Excel, answer the following questions: «
a. James in Class A got 22 in the test. What is his z score in this test?
b. Assuming the test scores are nomally distributed, detemine the percentile rank of James.
c. Using nomal approximation, it was found that the percentile rank of Edward in Class B
is 19. What is his raw score in this test?
d. Using the original distribution of the data, determine the percentile rank of James and
Edward. (Hint: If a lot of observations fall into the same category, when calculating the
percentile rank, we will assume half of the observations within the category is lower than
our target person while the other half is higher.)
e. Based on the answer in (d), comment on the popularity of James and Edward in their
classes.
f. Compare the percentile rank of James found in (b) and (d), are they the same? Why or
why not?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Score 30-under 40, frequency 1. Approximately what percent of students got more than 70?
Solution
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman