Excel Homework #1
1. A researcher is interested in describing the distribution of
blood types. She selects a random sample of forty patient files in
an immediate care clinic and records the blood type on each. The
data is shown:
A; B; O; A; AB; O; O; A; O; B; A; A; A; O; O; O; B; O; AB; B
O; B; O; AB; B; O; O; A; O; B; A; O; A; O; A; A; B; O; A; AB
a) Make a frequency table for this
data.
b) Make a pie chart for the data.
c) Make a Pareto chart for the data.
2. The following are the daily high temperatures in Chicago for a
single month:
56, 58, 62, 64, 66, 67, 67, 67, 69, 69, 70, 70, 71, 71, 72,
72, 74, 74, 74, 75, 75, 76, 76, 77, 78, 78, 79, 82, 84, 90
a) Create a histogram for this data using class width 10.
b) Create a stem/leaf display for this data.
1)Make a frequency table for this data.
b) Pie chart:
c) Paretto chart:
formula Reference:
2) Histogram:
Formula Ref:
b) Stem/leaf:
Excel Homework #1 1. A researcher is interested in describing the distribution of blood types. She...
Thank you! Listed below are the heights from a sample of male students (in inches 72 70 69 75 69 71 75 72 74 73 70 75 74 71 78 65 75 70 a. [3 pts] Create an ordered stem and leaf display for these data. b. [1 pt] How many students are measured? c. [1 pt] What percentage of students are at least 70"? (Round to 1 decimal place.)
Provided set of data are concentrations of suspended solids in river water that are collected for environmental characteristics. Total of 36 samples have concentrations of: 84 49 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53 67 75 61 70 81 76 79 75 76 58 31 a) Construct a stem‐and‐leaf display of the data. b) Calculate first and third quartiles and median from stem‐and‐leaf display...
The following scores represent the final examination grades for an elementary statistics course: 23 60 79 32 57 74 52 70 82 36 80 77 81 95 41 65 92 85 55 76 52 10 64 75 78 25 80 98 81 67 41 71 83 54 64 72 88 62 74 43 60 78 89 76 84 48 84 90 15 79 34 67 17 82 69 74 63 80 85 61 Calculate: Stem and leaf Relative frequency histogram Cumulative frequency Sample Mean Sample Median Mode Variance Standard deviation
02 The following scores represent the final examination grades for an elementary statistics course: 23 60 79 32 57 74 52 70 82 36 80 77 81 95 41 65 92 85 55 76 52 10 64 75 78 25 80 98 81 67 41 71 83 54 64 72 88 62 74 43 60 78 89 76 84 48 84 90 15 79 34 67 17 82 69 74 63 80 85 61 Calculate: . Stem and leaf ....
Show your work AND explain your reasoning using complete English sentences. Explanations must directly follow the solution for each part of the problem. Listed below are the heights from a sample of male students (in inches). 75 72 72 73 74 65 69 74 70 70 71 75 71 75 69 75 78 70 a. Create an ordered stem and leaf display for these data. b. How many students are measured? c. What percentage of students are at least 70”?...
The following data represent glucose blood levels (mg/100 ml) after a 12-hour fast for a random sample of 70 women (Reference American Journal of Clinical Nutrition, Vol. 19, pp. 345-351) 45 668) 71 75 64 59 59 75 82 B0 81 85 77 82 90 87 72 70 69 83 71 87 69 81 76 96 83 67 94 101 94 89 94 73 99 93 85 83 90 78 80 85 83 84 74 81 70 65 89 70...
Please answer all questions! thanks :) VI/ Test scores from a math midterm are as follows: 79, 90, 85, 89, 70, 59, 75, 64, 83, 78, 75, 77, 78, 77, 67, 85, 74, 52, 87, 72, 69, 76, 61, 77, 93, 86, 79, 90, 74, 67, 51, 75, 77, 82, 78, 60, 86, 72, 91, 95, 82 Complete the frequency distribution table to include all data a. Class Tallies Class Midpoint Relative Cumulative Frequency relative freq boundaries Frequency 51 57...
A. Make a stem-and-leaf display for the following data. Comment about the shape of the distribution. 58 52 68 86 72 66 97 89 84 91 91 92 66 68 87 86 73 61 70 75 72 73 85 84 90 57 77 76 84 93 58 47 B. Construct a frequency distribution using 6 classes with the first lower class limit of 58, draw a Histogram, and what is the shape of distribution? 58, 60, 62, 63, 70, 71, 71, 76,...
12 a and b 12. A distribution has a skewness of-0.14 and a kurtosis of +0.09 a. Draw approximately what this distribution should look like. b. What terms would you use to describe this distribution? 13. Build a stem-and-leaf plot for the sibling age data in Table 3.1 14. Create a pie chart showing the percentage of subjects in Table 3.1 who gave each r the language development data in the Waite et al. (2015) study 15. The following data...
2.) Below is a data set for a set of scores on a final exam: 63, 88, 79, 92, 86, 87, 83, 78, 41, 67, 68, 76, 46, 81, 92,77, 84, 76, 70, 66. 77, 75, 98, 81, 82,81, 87, 78, 80, 60, 94, 79, 52, 82, 77, 61, 77, 70, 74, 61 Complete the following questions: (4 points total) (1 point each) a.) Create a frequency distribution by hand b.) Create a histogram by hand c.) Create a stem-and-leaf...