Question

please do it in Excel Classes F x 10-19 2 4 20-29 19 23 30-39 7...

please do it in Excel

Classes

F

x

10-19

2

4

20-29

19

23

30-39

7

68

40-49

2

4

50-59

1

1

60-69

0

0

1. Mean

2. Median

3. Mode

4. Standard divition

5. quartiles, percentiles and the correlation coefficient

Homework Answers

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
Class Limits (Age in years) , Frequency 0-9 ,1 10-19, 7 20-29, 12 30-39 ,12 40-49,...
Class Limits (Age in years) , Frequency 0-9 ,1 10-19, 7 20-29, 12 30-39 ,12 40-49, 23 50-59, 23 60-69 ,32 70-79 ,9 80-89 ,4 90-99, 1 Find the mean, calculate sample variance and sample standard deviation,
Classes Frequency 20-29 7 30-39 7 40-49 12 50-59 3 60-69 3 70-79 6 80-89 2...
Classes Frequency 20-29 7 30-39 7 40-49 12 50-59 3 60-69 3 70-79 6 80-89 2 The ages of a sample of individuals in an GSS study are as shown in the table above. a. Obtain the mean score for the data b. Obtain the median for the data c. Obtain the first quartile for the data d. Obtain the third quartile for the data e. Find the IQR a.= b.= c.= d.= e.=
Find the measures of center for the following: Data Frequency 30-34 2 35-39 4 40-44 6...
Find the measures of center for the following: Data Frequency 30-34 2 35-39 4 40-44 6 45-49 11 50-54 18 55-59 15 60-64 11 65-69 1 70-74 5 mode= median= mean (round to 4 decimal places)=
Age Frequency Midpoint f*M f*(M-xbar)2 30-39 2 40-49 3 50-59 7 60-69 5 70-79 1 Compute...
Age Frequency Midpoint f*M f*(M-xbar)2 30-39 2 40-49 3 50-59 7 60-69 5 70-79 1 Compute the Coefficient of Variation to 2 decimal places. Do NOT format answer: No $, Commas, %.
Dataset: Husband   Wife 53   50 38   34 46   44 30   36 31   23 26   31 29  ...
Dataset: Husband   Wife 53   50 38   34 46   44 30   36 31   23 26   31 29   25 48   51 65   46 29   26 28   23 29   32 25   22 22   21 21   24 43   50 24   27 38   33 33   26 35   29 40   29 27   25 27   24 49   38 48   39 27   27 26   24 40   34 35   37 21   26 32   39 30   28 60   52 36   40 25   23 66   55 52   34 41   40 43  ...
Using the class sample data, analyze the student heights by completing the following. Please note the...
Using the class sample data, analyze the student heights by completing the following. Please note the following directions. The data below was collected from a group of 45 female students last semester. You will use this data throughout the semester on your lab assignments. Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F 60 5.5 27 R 3 F 64 7 31 R 4 F 67 7.5 19 R 5 F 65 8 20...
Age range (yr) 20-29 30-39 40-49 50-59 60-69 70-79 80+ Midpoint x 24.5 34.5 44.5 54.5...
Age range (yr) 20-29 30-39 40-49 50-59 60-69 70-79 80+ Midpoint x 24.5 34.5 44.5 54.5 64.5 74.5 84.5 Percent of nurses 5.6% 9.1% 19.3% 29.7% 24.5% 10.1% 1.7% What was the age distribution of nurses in Great Britain at the time of Florence Nightingale? Suppose we have the following information.  Note: In 1851 there were 25,466 nurses in Great Britain. Compute the standard deviation σ for ages of nurses shown in the distribution. (Round your answer to two decimal places.)
MALE :Student # Gender Height Shoe Age Hand 1 M 67 10 19 R 2 M...
MALE :Student # Gender Height Shoe Age Hand 1 M 67 10 19 R 2 M 74 12 17 R 3 M 72 11.5 19 R 4 M 69 10 35 R 5 M 66 9 18 R 6 M 71 10.5 17 R 7 M 72 10.5 17 R 8 M 66 10 20 R 9 M 67 10 18 R 10 M 71 10.5 24 R 11 M 66 10 21 R 12 M 71 10.5 18 R...
1. 30 53 12 42 29 51 25 26 45 18 32 10 31 6 a....
1. 30 53 12 42 29 51 25 26 45 18 32 10 31 6 a. Construct a frequency distribution. use the following class intervals: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59. b. construct a steam-and leaf plot. C. construct a histogram. use class boundaries along the x-axis.
Age range (yr) 20-29 30-39 40-49 50-59 60-69 70-79 80+ Midpoint x 24.5 34.5 44.5 54.5...
Age range (yr) 20-29 30-39 40-49 50-59 60-69 70-79 80+ Midpoint x 24.5 34.5 44.5 54.5 64.5 74.5 84.5 Percent of nurses 5.9% 9.6% 19.4% 29.5% 24.9% 8.7% 2.0% (c) Find the probability that a British nurse selected at random in 1851 would be 60 years of age or older. (Round your answer to three decimal places.) (d) Compute the expected age μ of a British nurse contemporary to Florence Nightingale. (Round your answer to two decimal places.) yr (e)...