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

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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...
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...
Use the following table to answer the next questions (11-14). (T1 to T5 is the type...
Use the following table to answer the next questions (11-14). (T1 to T5 is the type of the consumer and from each type there is one consumer, to be clear there is a total of 5 consumers in the market ) Customer Product A Reservation Price Product B Reservation Price T1 180 170 T2 120 140 T3 100 80 T4 90 120 T5 90 80 Marginal Cost 80 70 11.  If the firm does not bundle the products, what single price...
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
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...
Use the following information about the MD-MAC model for questions 1 to 6. There is a...
Use the following information about the MD-MAC model for questions 1 to 6. There is a polluter on a lake that is damaging a fishery by its pollution. MAC = 800 – 3e where e is the level of emissions measured in tonnes MD = 2e 1) The socially efficient level of emissions is: a. 320 b. 160 c. 640 d. 80 2) A Coase Theorem negotiation where the property rights belong to the fishery results in an offer of:...
The following table reflects results of a Dutch auction: Bidder Quantity Price A 100 20 B...
The following table reflects results of a Dutch auction: Bidder Quantity Price A 100 20 B 150 18 C 150 16 D 200 14 E 250 12 F 250 10 When the company decides to issue 300 the amount that they could raise would be: 4.800 5.100 5.500
The following table reflects results of a Dutch auction: Bidder Quantity Price A 100 20 B...
The following table reflects results of a Dutch auction: Bidder Quantity Price A 100 20 B 150 18 C 150 16 D 200 14 E 250 12 F 250 10 When the company decides to issue 300 the amount that they could raise would be: 4.800 5.100 5.500
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT