Question
The following are ages of of the signers of the Declaration of Independence. 35, 62, 52,...
The following are ages of of the signers of the Declaration of Independence. 35, 62, 52, 34, 35, 63, 48, 30, 35, 32, 36, 44, 50, 40, 39, 42, 46, 50, 45 Send data to Excel Find th and th percentiles for these ages. (If necessary, consult a list of formulas.) (a) The th percentile: (b) The th percentile:
QUESTION 2 Problem Page Here are the shopping times (in minutes) for a sample of shoppers at a particular shoe store: 37, 39, 43, 39, 32 Find the standard deviation of this sample of shopping times. Round your answer to two decimal places. (If necessary, consult a list of formulas.)
Homework Answers
Answer #1
The formula to find percentile in excel is
=PERCENTILE(array,k)
a) =PERCENTILE (array,0.25)
b) =PERCENTILE (array,0.75)
The formula for finding standard deviation is
STDEV(array)
The answers are given in the following image .
Not the answer you're looking for?
Similar Questions
The following are the annual salaries of 17 chief executive officers of major companies. (The salaries...
The following are the annual salaries of
17
chief executive officers of major companies. (The salaries are
written in thousands of dollars.)
428, 452, 653, 814, 743, 381, 271, 1108, 723, 75, 586, 405, 338,
204, 519, 362, 542
Find
25
th and
90
th percentiles for these salaries.
(If necessary, consult a list of formulas.)
(a) The
25
th percentile:
thousanddollars
(b) The
90
th percentile:
thousanddollars
Driving under the influence of alcohol (DUI) is a serious offense. The following data give the...
Driving under the influence of alcohol (DUI) is a serious
offense. The following data give the ages of random sample of 50
Drivers arrested while driving under the influence of alcohol.
Using the listed ages; find 16 18 20 21 21 22 22 22 23 24 24 25 26
26 26 27 27 27 29 30 30 31 31 32 33 34 34 35 35 36 37 38 39 40 40
41 43 45 46 47 47 49 49 51...
The accompanying table lists the ages of acting award winners matched by the years in which...
The accompanying table lists the ages of acting award winners
matched by the years in which the awards were won. Construct a
scatterplot, find the value of the linear correlation coefficient
r, and find the P-value of r. Determine whether there is
sufficient evidence to support a claim of linear correlation
between the two variables. Should we expect that there would be a
correlation? Use a significance level of
alphaαequals=0.050.05.
LOADING...
Click the icon to view the ages of the...
The following data were randomly drawn from an approximately normal population. 31, 32, 35, 37, 42,...
The following data were randomly drawn from an approximately
normal population.
31, 32, 35, 37, 42, 44, 48
Based on these data, find a
90%
confidence interval for the population standard deviation. Then
complete the table below.
Carry your intermediate computations to at least three decimal
places. Round your answers to at least two decimal places. (If
necessary, consult a list of formulas.)
What is
the lower limit of the
90%
confidence interval?
What is
the upper limit of the...
How Democratic is Georgia? County-by-county results are shown for a recent election. For your convenience, the...
How Democratic is Georgia? County-by-county results are shown
for a recent election. For your convenience, the data have been
sorted in increasing order (Source: County and City Data
Book, 12th edition, U.S. Census Bureau).
Percentage of Democratic Vote by Counties in Georgia
31
33
34
34
35
35
35
36
38
38
38
39
40
40
40
40
41
41
41
41
41
41
41
42
42
43
44
44
44
45
45
46
46
46
46
47
48
49...
Pinky and The Brain are great friends. They like to play games with numbers. This time,...
Pinky and The Brain are great friends. They like to play games
with numbers. This time, Pinky has given The Brain a list of
numbers and given him the task of determining if it is possible to
choose a subset of them such that they sum is equal to another
given number.
Build an algorithm using dynamic programming to help The Brain
with his problem.
INPUT
The first line corresponds to N, the amount of numbers given by
Pinky
The...
Data was collected for 364 randomly selected 10 minute intervals. For each ten-minute interval, the number...
Data was collected for 364 randomly selected 10 minute
intervals. For each ten-minute interval, the number of people
entering the atrium of a large mall were recorded. The data is
summarized in the table below.
Number
of Guests
Frequency
220 – 239
83
240 – 259
95
260 – 279
47
280 – 299
43
300 – 319
96
What is the class width for this GFDT?
Class width =
The number of students in the tutoring center was recorded...
1. Driving under the influence of alcohol (DUI) is a serious offense. The following data give...
1. Driving under the influence of alcohol (DUI) is a serious
offense. The following data give the ages, in order,
of a random sample of 50 drivers arrested while driving under the
influence of alcohol. This distribution is based on the age
distribution of DUI arrests given in the Statistical Abstract of
the United States (112th Edition).
16 18 20 21 21 22 22 22 23 24 24 25 26 26 26 27 27 27 29 30 30
31 31...
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88...
Student Grades
Student
Test
Grade
1
76
62
2
84
90
3
79
68
4
88
84
5
76
58
6
66
79
7
75
73
8
94
93
9
66
65
10
92
86
11
80
53
12
87
83
13
86
49
14
63
72
15
92
87
16
75
89
17
69
81
18
92
94
19
79
78
20
60
71
21
68
84
22
71
74
23
61
74
24
68
54
25
76
97...
This dataset contains consumer responses indicating the number of times they had to send their product...
This dataset contains consumer responses indicating the number
of times they had to send their product for repair and their
satisfaction with the repair process. Create a graph which can be
used to visually demonstrate the relationship between the two
columns of data. Ensure that the chart is professional with
appropriate titles, axis labels, etc. Note any observations you see
in your visualization (type these as sentences directly into an
Excel cell(s)).
Sample
Satisfaction Rating
Repair Requests
1
63%
13...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 11 minutes ago
asked 17 minutes ago
asked 18 minutes ago
asked 31 minutes ago
asked 34 minutes ago
asked 44 minutes ago
asked 57 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago