Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. please answer the question using excel with formul

please answer the question using Excel with formula please explain how the answer came 1. Many drugs used to treat...

80.2K

Verified Solution

Question

Basic Math

please answer thequestion using Excel with formula please explain how the answercame


1.Many drugs used totreat cancer are expensive. BusinessWeek reported on the cost pertreatment of Herceptin, a drug used to treat breast cancer. Typicaltreatment costs (in dollars) for Herceptin are provided by a simplerandom sample of 10 patients.

5798?7446?5119?5376?5495?5237?4814?6578?3717?5920

a.Develop a pointestimate of the mean cost per treatment withHerceptin.
b.Develop a pointestimate of the standard deviation of the cost per treatment withHerceptin.

Answer & Explanation Solved by verified expert
3.7 Ratings (491 Votes)
Using exceli First enter all observations in one columnin column Aii Then using command AVERAGEA1A10 find average of allobservations in cell A11iii Then using    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A farmer estimates that a 50 acre peach orchard will require an initial investment of $25,000...

Finance
Q

1: A) Describe isotonicity, hypertonicity, and hypotonicity. How does each affect the cell volume? B) What is osmotic...

Medical Sciences
Q

Q 1. (A) Explain the difference between PULL and PUSH production systems. Q 1. (B) Which one...

General Management
Q

A playground merry go round of radius 1 5 m has a mass 20 kg...

Physics
Q

5 Mylyssa can deposit 2 400 into a money market account earning 6 4 simple...

Basic Math
Q

12 Determine the convergence or divergence of the series and explain 52 2 Inn n...

Calculus
Q

Do It! Review 9-5 For 2017, Sale Company reported beginning total assets of...

Accounting
Q

Steven Garcia had been allocating MOH costs to his products using a single plant-wide rate...

Accounting
Q

When annual net cash inflows are equal, the cash payback period is computed as: a.Annual...

Accounting
Q

Presented below is financial information of the Sandhill Corporation for 2020. Gain on the sale...

Accounting
Q

Nocioni Company issued $1,000,000 of bonds on January 1, 2010. Instructions (a) Prepare the journal...

Accounting
Q

1 Question M (point George and Anne were married for nine years and had three...

Finance