Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are the office manager of a busy radiology clinic. Your office has a CAT scan machine that physicians use to identify tumors. A new

You are the office manager of a busy radiology clinic. Your office has a CAT scan machine that physicians use to identify tumors. A new CAT scan machine has been developed and your office has received one of the new machines to test out for a week. The physicians in your office want to know if the new machine is actually better, or worse at detecting tumors. For the next 500 patients that come into the clinic you run them through the old CAT scan machine and record the number of tumors found, you then run them through the new machine and record the number of tumors found.

I don't want answers just need formulas for excell so I know how to do it

State the null and alternative hypotheses:H0:H1:Run the appropriate statistical test(s) needed to answer this question. Place output below:What is your alpha value?What is your critical t?What is your t-statistic?What is the probability of your t-statistic?State your findings as you would present them to the physicians in your clinic. Don't forget to reference values in your explanation!Patient IDTumor Count OLDTumor Count NEW1202303024155336127258009111010111212011300140015021601171318221910200321452202232124212541262127342802290130403105323233223410350036103723382039004032413042014300442245024600471248014920502051015211532254005511560157005810591060006140620363106420651166116711682169207010713472017301740075127603770078427922801081238211830284208510862087218833890090029100924293049411950096009712981099011000410131102021030110402105201062210702108001090011032111411121011304114011150011603117001181411910120001211012210123041240012502126231270212803129121300113120132301330113430135011361213711138031390114021141021420314300144301452214610147101481414902150101514315220153111541115521156021572115810159111600216110162301633216402165011660016710168121691217020171001722017301174421750117610177101781017931180011811118202183241843118504186011870018803189131900019120192211930019402195401960019715198011992120041201402024120310204202050320600207122081120901210422110121210213012141021510216102171021811219012201022102222212233122400225222260022701228002291223050231002320123301234112350023622237102382123900240012410124201243112440124501246212470224801249112502025130252122531025400255032564225713258102595026011261022620226342264112650126610267102681226911270142712327205273122741127512276022772027814279202801128142282142831128401285122861228700288112890029000291002921129304294012954529600297202982129902300023010130200303343041130511306003072030820309003101031101312133130531410315203160231701318113191032000321213220232302324123250032612327103280132911330253311133202333203340233504336213371033812339113402234110342123431034411345103460134722348203491135000351313522135300354013550135620357203580135900360313611036200363213641236521366003670036802369213700437101372323731037401375123761237705378203790038020381003821138321384003853038641387123880138912390103910439210393023944039502396303972039803399424002240102402254032140420405014062140711408244092141002411104120541312414104150141602417104181041902420224210242200423054241242502426314272042800429024301143101432104332043423435004361143702438214390044001441224420344321444514450044605447424480044901450034510045201453204542045501456204570045801459024601446103462034631046410465054660046710468114690247031471144722147310474224751247600477114781047901480004814248211483124840148510486114872048831489034901449124492034932149410495414960149712498224990050001

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Structure Of Groups With A Quasiconvex Hierarchy (AMS-209)

Authors: Daniel T Wise

1st Edition

069121350X, 9780691213507

More Books

Students also viewed these Mathematics questions

Question

What is your least favorite U.S. dialect? Why?

Answered: 1 week ago