solution:
Given no.of observations (n) = 15
a) A Stem and Leaf Plot: A stem and leaf plot is a table where data is split into two columns.First column called Stem (consists first digit or digits) and second column called leaf (usually consists last digit)
---> Stem and leaf plot for given data is:
Stem | Leaf |
11 | 8 9 9 |
12 | 0 1 2 2 4 6 7 |
13 | 2 4 5 |
14 | 1 |
15 | |
16 | 1 |
b) Frequency distribution for given data
Xi | fi | fi*Xi |
118 | 1 | 118 |
119 | 2 | 238 |
120 | 1 | 120 |
121 | 1 | 121 |
122 | 2 | 244 |
124 | 1 | 124 |
126 | 1 | 126 |
127 | 1 | 127 |
132 | 1 | 132 |
134 | 1 | 134 |
135 | 1 | 135 |
141 | 1 | 141 |
161 | 1 | 161 |
or N = 15 | =1921 |
i) Mean = / N = 1921 / 15 = 128.1
ii) N/2 th corresponding observation is our median(Ascending order)
N/2 =~ 8 th observation i.e., 124
Median = 124
iii) Mode : Most frequently occurred value.Here data is Bimodal
Modes are 119 , 122
iv) Maximum value = 161
v) Minimum value = 118
c)
i) Range = Maximum value - Minimum value = 161 - 118 = 43
ii) First quartile(Q1) = 25% percentile = N/4 th observation [ceil value]=~ 4th observation = 120
iii) Second quartile (Q2)= 50% percentile = Median = 124
iv) Third quartile (Q3)= 75% percentile = 3N/4 th observation [ceil value]=~ 12 th observation = 134
v) Inter quartile Range (IQR) = Q3-Q1 = 134 - 120 = 14
d) Box plot is a method of graphical ly depicting groups of numerical data through their quartiles.
--->First identify the First , second and third quartiles and draw verticle lines and connect them as a box
---> Identify if there are any outliers exist which are out of range of (Q1-1.5(IQR) , Q3+1.5(IQR) ) - ( 99 , 155)
If there any exist leave them as dot with out connecting to box plot.
Here 161 is a outlier
We were unable to transcribe this image
We were unable to transcribe this image
We were unable to transcribe this image
We were unable to transcribe this image
We were unable to transcribe this image
162.5- 160 157.5 150- 147.5- 145 142.5 140- 137.5 135- 132.5- 130- 127.5 125- 12.5-
PLEASE ANSWER ALL PARTS AND PROVIDE COMPLETE WORK FOR ALL PARTS. 1. An environmentalist studied 15...
Please answer the questions in yellow using an Excel Formula Answers must be written using an Excel Formula Thank You 4 111 A B D F G H 1 J K 107 Basic Functions 108 The AVERAGE function averages the cells that have numeric values. 109 Write a formula in the yellow cell immediately below that sets the value of cell equal to the average of the eight grey cells in the range F110:1111. 110 4 5 2 9 text...
please answer question 1 ASAP and thank you answer a,b,c,d,e,f,g and thank you DIU LIL HUITWork 1 Using the midpoints of the indicated ranges of X (ie. 1.90 gram for the first class), to Note: To get full credit for your homework, you need to show step by step calculation which includes the formula, how to apply the date of question to the formule, and answer with an appropriate unit. Showing only the final solution (e.g, a single number) will...
Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store....
HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data link fir this data it’s all in photos.... thank you i have already posted the question We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...
CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...