# HT WT CHOL 1 16 57 94.3 2 Percentiles (Source: Dr. Diane Kiernan, APM 510...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
# HT WT CHOL 1 16 57 94.3 2 Percentiles (Source: Dr. Diane Kiernan, APM 510 Reader Final Edition Fall Place functions to answer the questions in the yellow cells. AGE a. Find the percentile for Cholesterol (CHOL) for 123. 2 19 63.1 100.7 8 3 19 64.8 105.4 44 4 29 63.6 106.7 62 b. Find the Cholesterol value for the 58th percentile. 5 23 64.7 107.8 62 6 12 63.3 108.8 89 c. Find Q1, Q2 and Q3 for the Weight Column (WT). 7 40 58.6 110.2 94 8 27 59.6 111.7 98 9 27 65.1 112.9 98 10 23 66.7 114.8 112 11 31 63.4 119 123 12 41 64.3 123.1 125 13 25 59.8 124.2 126 14 32 61.4 124.3 130 15 36 63.2 127.1 146 16 34 60.5 130 149 17 37 65 130.4 149 18 37 60.6 135 173 19 31 66.7 135.5 175 20 32 66.4 136.1 181 Q1 Q2 Q3 d. Are there any outliers for the Weight data? Calculate the lower and upper limits of the outliers. Calc for outlier lower limit upper limit e. Calculate the mean, median and standard deviation for Weight and Cholesterol. mean median st dev weight cholesterol f. Calculate the z-scores for Sample number 32 with a weight of 179.9 and cholesterol reading of 318. weight cholesterol 21 48 67 141.4 207 z-score 22 23 61.3 147.8 223 23 24 62.6 149.3 237 24 52 67.6 149.9 254 25 17 64.3 156.3 264 26 25 62.3 159.7 267 27 29 68 160.1 271 28 45 60.2 161.9 280 29 47 58.2 162.8 293 30 23 62.7 163.1 301 31 59 63.5 174.1 309 32 56 63.4 179.9 318 33 22 60.7 181.2 325 34 55 62.3 182.4 384 35 45 61.9 188.3 447 36 40 66.8 195.6 462 37 41 67.9 218.8 531 38 32 64.1 238.4 596 39 57 63.4 255.9 600 # HT WT CHOL 1 16 57 94.3 2 Percentiles (Source: Dr. Diane Kiernan, APM 510 Reader Final Edition Fall Place functions to answer the questions in the yellow cells. AGE a. Find the percentile for Cholesterol (CHOL) for 123. 2 19 63.1 100.7 8 3 19 64.8 105.4 44 4 29 63.6 106.7 62 b. Find the Cholesterol value for the 58th percentile. 5 23 64.7 107.8 62 6 12 63.3 108.8 89 c. Find Q1, Q2 and Q3 for the Weight Column (WT). 7 40 58.6 110.2 94 8 27 59.6 111.7 98 9 27 65.1 112.9 98 10 23 66.7 114.8 112 11 31 63.4 119 123 12 41 64.3 123.1 125 13 25 59.8 124.2 126 14 32 61.4 124.3 130 15 36 63.2 127.1 146 16 34 60.5 130 149 17 37 65 130.4 149 18 37 60.6 135 173 19 31 66.7 135.5 175 20 32 66.4 136.1 181 Q1 Q2 Q3 d. Are there any outliers for the Weight data? Calculate the lower and upper limits of the outliers. Calc for outlier lower limit upper limit e. Calculate the mean, median and standard deviation for Weight and Cholesterol. mean median st dev weight cholesterol f. Calculate the z-scores for Sample number 32 with a weight of 179.9 and cholesterol reading of 318. weight cholesterol 21 48 67 141.4 207 z-score 22 23 61.3 147.8 223 23 24 62.6 149.3 237 24 52 67.6 149.9 254 25 17 64.3 156.3 264 26 25 62.3 159.7 267 27 29 68 160.1 271 28 45 60.2 161.9 280 29 47 58.2 162.8 293 30 23 62.7 163.1 301 31 59 63.5 174.1 309 32 56 63.4 179.9 318 33 22 60.7 181.2 325 34 55 62.3 182.4 384 35 45 61.9 188.3 447 36 40 66.8 195.6 462 37 41 67.9 218.8 531 38 32 64.1 238.4 596 39 57 63.4 255.9 600
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
Starting with acetylene as your only source of carbon atoms, identify how you would prepare each member of the following homologous series of aldehydes: a. Ethanal b. Propanal c. Butanal d. Pentanal
-
In absorption refrigeration systems, a two-phase equilibrium mixture of liquid ammonia (NH3) and water (H2O) is frequently used. Consider a liquid-vapor mixture of ammonia and water in equilibrium at...
-
Zehra Inc. had gift card sales in 2023 for $100,000. On December 31, 2023, its year end, $30,000 of these gift cards were not redeemed. Zehra does not expire gift cards. (a) Explain whether or not...
-
What are the advantages and disadvantages of e-learning?
-
The Education Agency of one of the nations most populous states evaluates public elementary schools on the basis of the following inputs and outcomes: Outcomes Total campus attendance Average...
-
Image transcription text Engineering Feats and Disasters Presentation . 5 Minute Presentation (with Powerpoint and/or other visuals) . Capture the key information . What happened? . Why did happen? ....
-
Proud Company Limited Trial Balance as at 31st December 2021 Debit Credit 500,000 10,000 50,000 Authorized Capital (500,000 @ $1) Short term loan Profit and Loss Appropriation Account Investment in...
-
Why do some people use cheque-cashing centres?
-
In government accounting, which of the four main bases of accounting records expenditures and revenues when they become due (i.e. in many cases before the associated cash flows take place)?
-
Company 1 wholly owns company 2 and company 3. Company 2 and 3 are both operating businesses, but, in order to mitigate taxable income, intercompany transactions that are not always done on...
-
A budget consists of accounting of what has been spent and how much is left a plan for spending for the coming year income, expenses, and assests such as buildings and equipment a list of income and...
-
Princeton Enterprises is a diversified cBlasco Distributors has become a large conglomerate. Its board of directors recently concluded that the firm has become so large that it has lost its...
-
On January 3, 2010, Mercury Company began self-constructing an asset that qualified for interest capitalization. On January 5, Mercury borrowed $300,000 on an 8% construction loan. In addition,...
-
Suppose that you could invest in the following projects but have only $30,000 to invest. How would you make your decision and which projects would you invest in? Project Cost $ 8,000 11,000 9,000...
-
Apple stock is selling for \($120\) per share. Call options with a \($117\) exercise price are priced at \($12.\) What is the intrinsic value of the option, and what is the time value?
-
Refer to Problem 14.9. What would the loss of the seller of the put option be if, at expiration, XLB is trading at \($20?\) What would the profit of the seller be if, at expiration, XLB is trading at...
-
Ibrahim bought 200 shares of a stock trading in the Abu Dhabi Securities Exchange at AED 12 (United Arab Emirates dirham) per share. Over time, the price of the stock increased to AED 18 per share....
Study smarter with the SolutionInn App