Question

Cholesterol levels were collected from patients two days after they had a heart attack (Ryan, Joiner...

Cholesterol levels were collected from patients two days after they had a heart attack (Ryan, Joiner & Ryan, Jr , 1985). Use Excel to find the 38th percentile. Round to two decimal places.

270

220

294

310

236

226

282

280

210

242

234

278

142

186

224

288

280

266

276

288

272

206

282

244

160

318

360

236

0 0
Add a comment Improve this question Transcribed image text
Answer #1

38th Percentile: 236.12

Excel Formula: "=Percentile.EXC(Array, K)"

D3 X fix =PERCENTILE.EXC(A2:A29,0.38) D E F ل N لا 236.12 4 01 co Business Business Unrestricted А. B с 1 Data 2 270 220 38th

Add a comment
Know the answer?
Add Answer to:
Cholesterol levels were collected from patients two days after they had a heart attack (Ryan, Joiner...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 5. Cholesterol levels were collected from patients two days after they had a heart attack and...

    5. Cholesterol levels were collected from patients two days after they had a heart attack and are shown in the table below. (Show all work. Just the answer, without supporting work, will receive no credit.) 270236 210 142 280 272 160 220 226 242 186 266 206 318 294 282 234 224 276 282 360 310 280 278 288 288 244 236 a.) What is the sample mean? b.) What is the sample standard deviation? (Round your answer to two...

  • A study was conducted at an American medical center and heart-attack incidents. A random sample of 30 heart-attack patients had their cholesterol levels measured two days after the attack. In add...

    A study was conducted at an American medical center and heart-attack incidents. A random sample of 30 heart-attack patients had their cholesterol levels measured two days after the attack. In addition, cholesterol levels were measured for a control group of 30 people who had not had a heart attack. The unitsf cholesterol measurement are mg/dL of blood. The two data sets are below regarding blood cholesterol levels DATA SET 1: HEART ATTACK GROUP (Assume that σ=46.63). 270 236 210 142...

  • Here is the data file: day2 day4 270 218 236 234 210 214 142 116 280...

    Here is the data file: day2 day4 270 218 236 234 210 214 142 116 280 200 272 276 160 146 220 182 226 238 242 288 186 190 266 236 206 244 318 258 294 240 282 294 234 220 224 200 276 220 282 186 360 352 310 202 280 218 278 248 288 278 288 248 244 270 236 2427.3.11 The Cholesterol Level data sets give cholesterol levels of heart attack patients. Cholesterol measures are taken 2,...

  • 33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim...

    33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...

  • In C++ Programming: Using a single for loop, output the even numbers between 2 and 1004...

    In C++ Programming: Using a single for loop, output the even numbers between 2 and 1004 (inclusive) that iterates (loops) exactly 502 times. The outputted numbers be aligned in a table with 10 numbers per row. Each column in the table should be 5 characters wide. Do not nest a loop inside of another loop. Hint: First create and test the code that output the numbers all on one line (the command line will automatically wrap the output to new...

  • A partial payment is made on the date indicated. Use the United States rule to determine...

    A partial payment is made on the date indicated. Use the United States rule to determine the balance due on the note at the date of maturity. (The Effective Date is the date the note was written.) Assume the year is not a leap year. Effective Partial Payment Maturity Principal Rate Date Amount Date Date $4000 4% April 1 $1000 May 1 June 1 Click the icon to view a table of the number of the day of the year...

  • Partial payments are made on the dates indicated. Use the United States rule to determine the...

    Partial payments are made on the dates indicated. Use the United States rule to determine the balance due on the note at the date of maturity. (The Effective Date is the date the note was written.) Assume the year is not a leap year. Effective Partial Payment Maturity Principal Date Amount Date Date $1900 19% Sept. 1 $500 Oct. 1 Dec. 1 $500 Nov. 1 Click the icon to view a table of the number of the day of the...

  • Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with ...

    Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with alphabetically both rows and columns I was successful with these steps but I am stuck with next step below is my code and screenshot import numpy as np import pandas as pd data=pd.read_csv("/Users/superman/Downloads/words_file2.txt",header=None) df_input=pd.DataFrame(data) df_output=pd.DataFrame(np.arange(676).reshape((26,26)), index = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'], columns = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z']) df_output.index.name="Start" df_output.columns.name="End" df_output This below screen shot is what I have to find I have to find each word...

  • Design Column B2: KL 30, Use an HSS section, Fy 46 ksi. pe 0.9 Use table 10.5 from handout Calcul...

    Answer the following blanks for design column B2 Design Column B2: KL 30, Use an HSS section, Fy 46 ksi. pe 0.9 Use table 10.5 from handout Calculate the following: Column tributary area: Artb (At2) Total column load: Pu (kips)- Column nominal Load: Pr (Kkips)- Lightest Column Section: Column Selection Table Pu (kips)- BLE 10.5 Safe Factored Loads for Selected 46-ksi Yield Stress Tube Steel Columns Effective Length (KL) in feet Area (in.2) 06 8 10 12 14 16 18...

  • Ken Wilson had done it all at Wilson Manufacturing, a company founded by his grandfather 63...

    Ken Wilson had done it all at Wilson Manufacturing, a company founded by his grandfather 63 years ago. Among his many duties, Ken oversaw all the plant’s operations, a task that had grown in responsibility given the company’s rapid growth over the past three decades. When Ken’s grandfather founded the company, there were only two manufacturing sites. Expansion and acquisition of competitors over the years had caused that number to grow to over 50 manufacturing plants in 18 states. Wilson...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT