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

Biology
1.2K views

What is the role of the conductor A to clean all the instruments B C...

Biology
1.2K views

List and explain 3 Homeostasis problems in Down syndrome

Geometry
1.2K views

COS cos arc tan 5 12 ifadesinin de eri

Algebra
1.2K views

r graph shows the average annual spending per person on selected items in 2010 mbined...

Accounting
1.2K views

Bazley, Inc.'s semimonthly gross payroll is $100,000. Federal income tax withholdings are $23,000. Also withheld...

Accounting
1.2K views

Evaluate each of the following transactions in terms of their effect on assets, liabilities, and...

Accounting
1.2K views

The IRS has been challenging owners of S-Corps over the issue of salaries that are...

Accounting
1.2K views

The Regal Cycle Company manufactures three types of bicycles-a dirt bike, a mountain bike, and...

Accounting
1.2K views

Plant and Machinery A/C 2022 Jan 1 Balance B/D 240,000 2022 March 31 Disposal 60,000...

Accounting
1.2K views

need help with the second half Prepare the perpetual imentory...

Accounting
1.2K views

given information: calulate ending inventory, cost of goods sold, gross profit for LIFO,...

Accounting
1.2K views

sadowski video center accumulates the following cost and market data at December 31. Compute the...