i need these questions done on excel

Tbbbare10
timer Asked: Mar 8th, 2018

Question Description

i need these questions done on excel please









Unformatted Attachment Preview

1) (9 points) Below are the heights of children and their parents. Gender M M M M M M M M M M M M M M M M M F F F F F F F F F F F F F F F F F F Mother's Height 66 58 68 64 62 66 63 65 64 64 62 62 67 63 66 65 71 63 64 60 65 67 59 60 58 72 63 67 62 63 64 63 64 60 65 Father's Height 70 69 71 68 66 74 73 69 67 68 72 72 68 71 67 71 75 64 67 72 72 72 67 71 66 75 69 70 69 66 76 69 68 66 68 Offspring's Height 62,5 64,6 73,9 67,1 64,4 71,1 71 69,3 64,9 68,1 66,5 66,5 70,3 67,5 68,5 71,9 67,8 58,6 65,3 61 65,4 67,4 60,9 63,1 60 71,1 62,2 67,2 63,4 62,2 64,7 59,6 61 64 65,4 a) Calculate the mean and median of the mother's height. b) Calculate the mean and median of the father's height. c) Calculate the mean and median of the offspring's height. 2) (9 points) Below are the heights of children and their parents. Gender M M M F F Mother's Height 66 64 69 67 69 Father's Height 64 62 66 65 62 Offspring's Height 69,1 67,4 67,5 64,7 68,4 a) Calculate the mean and median of the mother's height. b) Calculate the mean and median of the father's height. c) Calculate the mean and median of the offspring's height. 3) (4 points) Based on your calculations what kind of observations did you make? 4) (10 points) Median Household Income By State State Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Puerto Rico Rhode Island South Carolina South Dakota Tennessee Income 43.623 72.515 50.255 41.371 61.818 60.629 70.331 60.509 70.848 47.507 49.620 69.515 47.583 57.574 49.255 53.183 52.205 43.740 45.047 49.331 74.551 68.563 49.576 61.492 39.665 48.173 47.169 52.997 51.847 66.779 72.093 44.963 59.269 46.868 57.181 49.429 46.879 51.243 53.599 19.350 56.852 45.483 50.957 45.219 a) Construct a grouped frequency distribution using eight classes. b) Construct a histogram. Does the data resemble a normal distribution? Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming 53.207 60.727 55.176 65.015 61.062 41.751 53.357 58.840 5) (15 points) Below are the high temperatures of January 2017. 56 25 49 52 47 46 29 46 50 39 46 41 53 49 56 57 57 60 61 37 72 53 61 35 65 49 45 27 43 50 49 48 42 50 63 57 48 41 41 a) Find the median of the data set b) Find the first and third quartiles of the data set. c) Find the Interquartile Range (IQR) d) Find the upper and lower outlier boundaries e) List all the values, if any, that are classified as outliers. 6) (15 points) Below are the high temperatures of January 2018. 26 26 35 27 21 21 23 39 51 43 62 64 62 28 32 43 37 47 51 63 61 65 68 a) Find the median of the data set b) Find the first and third quartiles of the data set. c) Find the Interquartile Range (IQR) d) Find the upper and lower outlier boundaries e) List all the values, if any, that are classified as outliers. 7) (4 points) Draw a boxplot of each data set. Describe the distribution of each set. 8) (15 points) Below are the high temperatures of February 2017. 51 50 40 41 54 61 73 74 53 39 53 55 47 46 55 42 51 68 71 68 58 63 75 82 71 52 59 67 a) Find the median of the data set b) Find the first and third quartiles of the data set. c) Find the Interquartile Range (IQR) d) Find the upper and lower outlier boundaries e) List all the values, if any, that are classified as outliers. 9) (15 points) Below are the high temperatures of February 2018. 54 43 36 37 39 43 43 38 46 50 68 65 43 53 74 67 44 51 50 78 82 67 51 61 71 a) Find the median of the data set b) Find the first and third quartiles of the data set. c) Find the Interquartile Range (IQR) d) Find the upper and lower outlier boundaries e) List all the values, if any, that are classified as outliers. 59 62 62 10) (4 points) Draw a boxplot of each data set. Describe the distribution of each set.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors