Question

**The table is bottom of these questions a) What are the quartiles? b) What are the...

**The table is bottom of these questions

a) What are the quartiles?

b) What are the deciles?

c) Where would 150 minutes rank as a percentile?

d) Where would 160 minutes rank as percentile?

Times
175.21
175.18
176.6
141.83
174.09
158.53
140.57
172.2
152.03
177.64
171.46
141.97
158.39
143.76
165.63
173.9
185.41
141.18
175.58
173.18
183.97
152.07
146.59
142.33
164.87
165.06
143.44
191.42
147.78
143.96
171.33
169.49
145.11
176.29
164.17
146.67
192.84
144.69
140.95
158.75
145.91
170.43
219.96
141.06
173.24
176.98
144.41
153.34
156.9
140.1
150.51
165.08
201.79
178.38
160.88
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The whole question can be solved easily using excel

First step is to sort the numbers in ascending order

1. use "quartile.exec(array,1or2or3) in order to determine first, second or third quartile

first quartile second quartile (median) third quartile
145.11 164.17 175.18

2. use "PERCENTILE.EXC(array, 0.1)" to find the first decile and so on until the 9th decile

141.57 1st decile
144.05 2nd decile
146.654 3rd decile
154.764 4th decile
164.17 5th decile
170.054 6th decile
173.372 7th decile
176.148 8th decile
184.546 9th decile

3. use "=PERCENTRANK.EXC(array,150)" to find the percentile of 150 = 0.335 = 33.5th percentile

4. use "=PERCENTRANK.EXC(array,160)" to find the percentile of 160 = 0.474 = 47.4th percentile

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Section 1. IQ tests supposedly measure our intelligence. They typically are ‘normed’ so that they have...
Section 1. IQ tests supposedly measure our intelligence. They typically are ‘normed’ so that they have a mean of 100 and a standard deviation of 15. (Higher scores show higher intelligence.) Use the graph and use the z-score and percents from columns b and c in Table A, when relevant. Questions If you scored 140, what is your z-score? (Interpret.) Use table A and use the graph Group of answer choices A 2.80 z. I'm at the 99.74 percentile rank...
Use the table below to answer the following questions. Price Quantity Demanded Quantity Supplied $10 100...
Use the table below to answer the following questions. Price Quantity Demanded Quantity Supplied $10 100 160 8 120 145 6 130 130 4 140 115 2 150 100 Graph the supply and demand curves. What are equilibrium price and equilibrium quantity?
1. A criminologist developed a test to measure recidivism, where low scores indicated a lower probability...
1. A criminologist developed a test to measure recidivism, where low scores indicated a lower probability of repeating an undesirable behavior. The test is normed so that it has a mean of 140 and a standard deviation of 40. a. What is the percentile rank of a score of 172? b. What is the Z score for a test score of 200? c. What percentage of scores fall between 100 and 160? d. What proportion of respondents should score above...
3. (28 pts) The number of vacation days used by a sample of twenty employees in...
3. (28 pts) The number of vacation days used by a sample of twenty employees in a recent year is shown. 3   9   2   1   7   5   3   2   2   6   4   0   10   0   3   5   7   8   6   5 a. Find the percentile rank of 4 in the data set. b. What value corresponds to the 88th percentile? c. Determine the quartiles. d. Graph the box-and- whisker plot. e. Find the lower and upper fences. f. Are there any outliers? Explain.
Complete the ANOVA summary table below. In addition, answer the following questions for the ANOVA summary...
Complete the ANOVA summary table below. In addition, answer the following questions for the ANOVA summary table. a. What is the factorial notation? b. How many conditions were in the study? c. How many subjects were in the study? d. Identify significant main effects and interaction effects. Source   df SS MS F A 2 40 B 3 60 A x B 6 150 Error 72 Total 83 400
In the following table, individuals are cross-classified by their age group and income level. Income Age...
In the following table, individuals are cross-classified by their age group and income level. Income Age Low Medium High 21–35 120 100 75 36–50 150 160 100 51–65 160 180 160 For the chi-square test of independence, the value of the test statistic is ________. A) 8.779 B) 10.840 C) 13.243 D) 16.159
the average employee in ontario spends mu=24.0 minutes commuting to work each day. Assume that the...
the average employee in ontario spends mu=24.0 minutes commuting to work each day. Assume that the distribution of commute times is normal with a standard deviation of sigma=8.0 minutes. a)what proportion of ontario employees spend less than 25 minutes a day commuting? b)what is the probability of randomly selecting an employee who spends more than 20 minutes commuting each day? c) what proportion of employees spend between 11 and 15 minutes commuting? d)what is the 50th percentile in this distribution...
What is usually shown at the bottom of a bar chart? a. advance/decline line b. closing...
What is usually shown at the bottom of a bar chart? a. advance/decline line b. closing price c. a point and figure chart d. volume
Home work#4 cont. Sum#5 The following data give the speeds of 13 cars (in mph) measured...
Home work#4 cont. Sum#5 The following data give the speeds of 13 cars (in mph) measured by radar, traveling on i-84 73, 75,69,68,78,70,74 76,72,79,68,77,72 Calculate the value of the 35th percentile. Enter the exact answer in mph. Sum#6 The following data give the annual salaries (in thousand dollars) of 20 randomly selected health care workers. 50,71,57,39,45,64,38,51,33,62 75,40,69,44,77,61,58,54,64,59 A. Calculate the values of the three quartiles and the interquartile range Q1 Q2 Q3 IQR B. Find the approximate value of the...
Use the following table to answer questions 12 and 13. Data for LIM Aviation Number of...
Use the following table to answer questions 12 and 13. Data for LIM Aviation Number of flights per day Daily Total Costs 0 $1000 1 $1100 2 $1150 3 $1250 4 $1400 5 $1600 6 $1850 7 $2150 8 $2500 9 $2900 12. A)What are LIM Aviation’s fixed costs? A. $1100 per day B. $100 per day C. $1000 per day D. $1150 per day 13. B)What is the marginal cost of the 5th daily flight? A. $200 B. 520...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT