I need to know how to figure this problem by doing in excel. Hypertensive Status by...

I need to know how to figure this problem by doing in excel.

Hypertensive Status by Clinical Trial Site--Observed:

Site

Hypertensive 1 2 3

Yes 17 23 35

No 83 77 65

Question: Data from 300 patients recruited for a clinical trial. The trial recruited patients from three different sites. Use this data to determine if there is a difference in the number of hypertensive patients across clinical sites. Interpret your results. Is the p-value calculated significant?

Expert Solution

orchestra answered 1 year ago

**NEED TO KNOW HOW PROBLEM IS SET UP IN EXCEL* During the period of time that...

****NEED TO KNOW HOW PROBLEM IS SET UP IN EXCEL*** During the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes. Clearly state what the random variable in this problem is? What is an appropriate distribution to be used for this problem and why? What is the expected number of calls in one hour? What is the probability of receiving three calls in five minutes? What is the...

**I need to know how to do it by had without a financial calculator or excel....

**I need to know how to do it by had without a financial calculator or excel. Unsure of what formula to use.** If a 4-year bond with a 7% coupon and a 10% yield to maturity is currently worth $904.90, how much will it be worth 1 year from now if interest rates are constant? A)$947.93 B) $925.39 C) $904.90 D)$1,000.00

I need to know how to do this IN EXCEL, please! Dennis wants to determine if...

I need to know how to do this IN EXCEL, please! Dennis wants to determine if the discount rate really makes any difference in the net present value of a project. He feels that if a project is acceptable at one rate of return, it will be acceptable at all rates of return. To explain why his thinking is incorrect, you are creating an example to illustrate your point. The cash flows you are using are as follows: time zero...

I need to know how to answer this question only in Excel. Please include instructions, screenshots,...

I need to know how to answer this question only in Excel. Please include instructions, screenshots, etc. in Excel which explain the process (formulas included). TropSun is a leading grower and distributer of fresh citrus products with three large citrus groves scattered around central Florida in the cities of Orlando, Eustis, and Winter Haven. TropSun currently has 275,000 bushels of citrus at the grove in Mt. Dora, 400,000 bushels at the groves in Eustis, and 300,000 bushels at the grove...

I need the calculation of this problem. This question has solution but I can't figure the...

I need the calculation of this problem. This question has solution but I can't figure the answer calculation Again I need calculation probably last line Question : On a certain standardized test The mean is 51 The standard deviation is 15 Exactly 66% of the people who took the test scored higher than Mr. Peterson. Find a, b, and c such that Mr. Peterson's score is approximately a + b ⋅ Φc(d) Do not make a continuity correction. What is...

Need Instructions on how to complete with EXCEL.... Handwritten answer not adequate, need to know how...

Need Instructions on how to complete with EXCEL.... Handwritten answer not adequate, need to know how EXCEL can be used to solve this problem.... A process is in control and centered at nominal. Output from the process is normally distributed and the process capability index, Cp, equals 1.02. Determine the expected number of nonconforming units that will result from a production run of 20,000 units. Assume that all previously stated conditions regarding the process remain as described during the production...

I would like to know how to solve this problem using POM or Excel Alan Resnik,...

I would like to know how to solve this problem using POM or Excel Alan Resnik, a friend of Ray Cahnman, bet Ray $5 that Ray’s car would not start 5 days from now (see Problem 14-8). What is the probability that it will not start 5 days from now if it started today? What is the probability that it will not start 5 days from now if it did not start today? What is the probability that it will...

I need to know about equations used and how to by hand! A. Quantitative Problem 1:...

I need to know about equations used and how to by hand! A. Quantitative Problem 1: Assume today is December 31, 2013. Barrington Industries expects that its 2014 after-tax operating income [EBIT(1 – T)] will be $400 million and its 2014 depreciation expense will be $60 million. Barrington's 2014 gross capital expenditures are expected to be $100 million and the change in its net operating working capital for 2014 will be $30 million. The firm's free cash flow is expected...

what do I need to know while doing a multi-step income statement?

I need an example of how to calculate correlation in excel

Question