Question

In: Statistics and Probability

3. You have been provided the following values: 23 23 15 19 14 21 48 32...

3. You have been provided the following values:
23 23 15 19 14
21 48 32 32 32
59 22 62 29 9
a. Construct a stem-and-leaf plot.
b. How many "stems" are in your plot?
c. Is the data skewed to the left or to the right?
d. What is the mean?
e. What is the median?
f. What is the mode?
g. What is the standard deviation?
h. Calculate 1.s.d. below the mean.
i. Calculate 1 s.d. above the mean.
j. Calculate 2 s.d. below the mean.
k. Calculate 2 s.d. above the mean.
l. Calculate 3 s.d. below the mean.
m. Calculate 3 s.d. above the mean.
n. Are there any outliers in the data?
o. If you answered yes to the question above, which one (s)?

Solutions

Expert Solution

Since the data is not printed properly, assuming the data is as follows:
( if there's any mistake from my side in the data, please do let me know in the comment section so that I can rectify the mistake )

S = { 23, 21, 59, 23, 48, 22, 15, 32, 62, 19, 32, 29, 14, 32, 9 }

a) The stem and leaf plot obtained in R language is as follows :

b) There are 4 stems in the stem and leaf plot as shown in the above image.

All the further required results will be obtained using the Descriptive Statistics function available in the data analysis package of the Excel. This can be obtained as follows :

Step 1 : Enter the data in the excel.

Step 2 : Select the Descriptive Statistics function available in the data analysis package under the Data tab of the Excel.

Step 3 : Enter the data range in the first cell and check box denoting summary statistics.

Step 4 : Click on ok and following results would be obtained :

Data
Mean 29.33333333
Standard Error 4.071581729
Median 23
Mode 32
Standard Deviation 15.76916823
Sample Variance 248.6666667
Kurtosis 0.36377758
Skewness 1.050676276
Range 53
Minimum 9
Maximum 62
Sum 440
Count 15

c) Since Skewness = 1.05068, the data can be terned as positively skewed.

d) Mean = 29.33333

e) Median = 23

f) Mode = 32

g) Standard deviation = sd = 15.7692

h) 1 sd below mean = Mean - 1*sd = 13.5642

i) 1 sd above mean = Mean + 1*sd = 45.1025

j) 2 s.d. below the mean = Mean - 2*sd = -2.2050

k) 2 s.d. above the mean = Mean + 2*sd = 60.8717

l) 3 sd below mean = Mean - 3*sd = -17.9742

m) 3 sd above mean = Mean + 3*sd = 76.6408

n) Outliers in a data can be easily determined using the range ( Q1 - 1.5*IQR , Q3 + 1.5*IQR ) i.e. any value that lies outside of this range would be considered as an outlier, where Q1 is the first quartile, Q3 is the third quartile and IQR is the inter quartile range.
Q1 = QUARTILE.EXC(A1:A15,1) = 19
Q3 = QUARTILE.EXC(A1:A15,1) = 32
IQR = Q3 - Q1 = 13
Thus, ( Q1 - 1.5*IQR , Q3 + 1.5*IQR ) = ( -0.5 , 51.5 )
Since, 62 value lies outside the above mentioned range, thus there is a outlier in the given data.

o) 62 is the only outlier.


Related Solutions

Buffalo Boston 26 23 27 14 39 11 23 19 17 19 16 4 21 9...
Buffalo Boston 26 23 27 14 39 11 23 19 17 19 16 4 21 9 31 12 1 12 23 7 32 32 32 26 24 21 42 16 38 16 29 18 16 16 12 20 29 20 16 11 18 10 27 18 2 11 21 17 35 20 21 20 29 25 24 16 17 17 21 8 38 21 9 24 31 26 16 27 24 18 24 17 13 15 21 21 21 32...
Consider the following sample data: x 22 24 27 21 23 14 14 15 y 101...
Consider the following sample data: x 22 24 27 21 23 14 14 15 y 101 139 250 88 87 14 16 20 Data is in the spreadsheet. Use Excel's Regression tool in Data Analysis to find the sample regression equation for the model: y = β0 + β1x + ε. What is the coefficient for β0 ? (Enter your answer rounded to 2 decimal places. If you got 876.36905323 for your answer, you would type 876.37)
Consider a sample with six observations of 23, 17, 15, 14, 21, and 6. Compute the...
Consider a sample with six observations of 23, 17, 15, 14, 21, and 6. Compute the z-scores for each sample observation. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places. Negative values should be indicated by a minus sign.)
For the stress data given below with the nearest error of 1: 27-17-11-24-36-13-29-22-18 23-30-12-46-17-32-48-11-18 18-32-26-24-38-24-15-13-13 18-21-27-20-16-15-37-19-19...
For the stress data given below with the nearest error of 1: 27-17-11-24-36-13-29-22-18 23-30-12-46-17-32-48-11-18 18-32-26-24-38-24-15-13-13 18-21-27-20-16-15-37-19-19 a) Construct a frequency distribution table. b) Construct the three types of statistical graphs. c) Determine the (1) Mean, (2) Median, (3) Mode, (4) Range, Variance, and (6) Standard Deviation.
A population consists of the following five values: 6, 6, 14, 18, and 23. a. Not...
A population consists of the following five values: 6, 6, 14, 18, and 23. a. Not available in Connect. b. By listing all samples of size 3, compute the mean of the distribution of the sample mean and the population mean. Compare the two values. (Round the final answers to 2 decimal places.) Sample means Population mean Both means are c. Compare the dispersion in the population with that of the sample means. Hint: Use the range as measure of...
22 17 19 10 30 10.5 31 11 32 15 45 6 48 11 49 5.2...
22 17 19 10 30 10.5 31 11 32 15 45 6 48 11 49 5.2 68 3 65 4.2 a) Create a scatterplot of this data and comment on the relationship between the variables b) Calculate the correlation coefficient between these two variables c) Does a linear relationship exist? d) Calculate the least squares regression equation e) Using your equation, predict how long we would expect a 43 year old new hire to remain with the company
The genome of an organism was analyzed and provided the following: 17%A, 23%G, 32%C, 0%T, and...
The genome of an organism was analyzed and provided the following: 17%A, 23%G, 32%C, 0%T, and 28%U. This organism is likely: A virus A virus or a bacterium A bacterium A bacterium or a eukaryote A eukaryote It cannot be calculated based on that number alone
Data Set: 5, 9, 11, 14, 15, 17, 19, 23 -Construct a frequency table using 5...
Data Set: 5, 9, 11, 14, 15, 17, 19, 23 -Construct a frequency table using 5 as a starting point and a class of width 7 -Construct a relative frequency histogram. Include the midpoints and boundary points - Find the mean, Variance, and standard deviation without a graphing calculator of the sample data Data Set: 5, 9, 11, 14, 15, 17, 19, 23 Data Set: 5, 9, 11, 14, 15, 17, 19, Data Set: 5, 9, 11, 14, 15, 17,...
13 25 40 20 28 48 19 14 Complete the following: a) Use the bubble sort...
13 25 40 20 28 48 19 14 Complete the following: a) Use the bubble sort (page 214) to sort the values showing the order of the values in the list after every pass of the sorting algorithm. b) What is the time complexity of the sort (use the number of comparisons required as a measure of time.) c) Modify the algorithm so it stops if there are no swaps in a complete pass. How many comparisons would be needed...
23-19 (Objective 23-3) You are auditing general cash for the Pittsburgh Supply Company for the fiscal...
23-19 (Objective 23-3) You are auditing general cash for the Pittsburgh Supply Company for the fiscal year ended July 31, 2016. The client has not prepared the July 31 bank reconciliation. After a brief discussion with the owner, you agree to prepare the reconciliation, with assistance from one of Pittsburgh Supply’s clerks. You obtain the following information: General ledger Bank Statement Beginning balance 7/1/16 $ 6,400 $ 8,378 Deposits 25,474 Cash receipts journal 26,874 Checks cleared (25,307) Cash disbursements journal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT