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.=
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, %.
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...
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...
4) Given the data set below 25 52 67 23 78 89 57  90 32 77 45...
4) Given the data set below 25 52 67 23 78 89 57  90 32 77 45 48  62 54 94 69 46 79 40 33 21 57  84 54 23 34 68  63 61 76 87 78  39 50 70 60 32 65 73 45 28 82  66 79 71 80 46 66 24 90 For the dada of Problem 1, find the approximate mean using the Frequency Distribution from problem 1 5) Find the Median of the data set from problem 1 using an...
You are a teacher of a group of 30 students and then take the test. 56       ...
You are a teacher of a group of 30 students and then take the test. 56        50        45        42        33        34        42        55        58        51        50        48 34        42        48        49        30        25        22        44        56        52        48        49 48    40        45        51        47        39. 1. Organize the scores into a simple frequency distribution. 2. Calculate the fashion 3. Calculate the median 4. Calculate the average 5. Calculate the Mean Deviation 6. Calculate the Standard Deviation of the scores...
Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F 60...
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 R 6 F 66 9 29 R 7 F 62 9.5 30 L 8 F 63 8.5 18 R 9 F 60 5 19 L 10 F 63 7.5 42 R 11 F 61 7 20 R 12 F 64 7.5 17 R 13...
clemson This Excel file Undergrad Survey shows the data resulting from a survey of 50 undergraduate...
clemson This Excel file Undergrad Survey shows the data resulting from a survey of 50 undergraduate students at Clemson University. Majors of students in the survey are accounting (A), economics and finance (EF), management (M), marketing (MR), computer information systems (IS), other (O), and undecided (UN). "Number of affiliations" is the number of social networking sites at which the student is registered; "Spending" is the amount spent on textbooks for the current semester. The other variables are self-explanatory. We will...
20 women and 30 men between 18 to 60 years old and the number of hours...
20 women and 30 men between 18 to 60 years old and the number of hours that they work. These information would be your populations. For each group find the followings: 20 Women Ages = 19, 23, 40, 18, 60, 50, 21, 30, 33, 28, 33, 35, 28, 24, 28, 18, 19, 22, 25, 50 20 women work hours weekly = 40, 24, 30, 31, 19, 10, 21, 5, 40, 9, 8, 40, 37, 12, 20, 40, 20, 10, 40,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT