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

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

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

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
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

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
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

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…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman