Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started