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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Suppose that in an assortment of 30 calculators there are 5 with defective switches. Draw with...

Basic Math
Q

research on Lee Silverman's Voice Therapy or BIG Program what is the purpose of the program?...

Medical Sciences
Q

Describe five tests of hardened concrete. Please i want the answer written here not on paper

Civil Engineering
Q

Why FOMC is important? What does FOMC do? Can the Fed control over the federal funds rate...

Economics
Q

Deep Drilling & Boring Inc., which follows IFRS, offers ten-year, 6% convertible bonds (par $1,000). Interest...

Accounting
Q

Match the following terms to their definition Sexual Dimorphism Founder Effect Bottleneck Effect Speciation Migration

Biology
Q

Active transport involves the use of channels while passive transport does not.TrueFalse

Biology
Q

B Use the diagram below to start of replication The DNA Replication diagram is incomplete...

Biology
Q

Evaluate the integral 16t i 15t2j 10t4k dt

Calculus
Q

Write the solution to the inequality below using interval notation y 10y 24

Algebra
Q

The condenesd financial statements of Sheridan Company for the years 2026 and 2027 are as...

Accounting
Q

Current Attempt in Progress Prepare a worksheet to show the adjusted net income heure for...

Accounting