ennifer Nguyen, a Humber College Healthcare Management program graduate who always had only perfect marks in statistics, was hired by the famousHealthy Lifemedical insurance company. Jennifer is assigned to conduct statistical

analysis of medical and financial data. As Jennifer is on probation, please help her to complete the following six tasks. In problems 2-6, state hypothesesH0andH1and provide detailed conclusions (based onP-values or critical values/test statistics) together with the Excel output. For your convenience, the data are given in the Major Assignment Data file. You can also find useful information on the Blackboard in Excel Instructions folder.

) Jennifer's managerDr. Jonathan Steinberg

wonders whetherHealthy Lifemembers needed

more chiropractic help in 2019 than in 2018, on

average. Jennifer selected a random sample of

those who were treated by chiropractic doctors in

both years. Data provided. Please help Jennifer

Nguyen to check whether annual expenses and

number of visits increased, on average. For both

tests use Data Analysist-Test: Paired Two

Sample for Means and 2% significance level. Jennifer Nguyen and her manager know that in both cases differences are normally distributed, so here again there is no need to build histograms.

STAT 1112 Major Assignment Data Winter 2021 Q v Search Sheet o+ Share Home Insert Draw Page Layout Formulas Data Review View AutoSum X Cut Calibri (Body) 11 A Wrap Text General Fill Copy U E CE Merge & Center $ % ) .00 Conditional Format Cell Insert Delete Format Sort & Find & Paste B I Clear Formatting as Table Styles Filter Select Format J24 X V fx M O P Q R S U V W X A B D E G H L N Patient's # Doctor's Fee i) Ho : H W N $450.00 H : H $435.00 $375.00 ii) Test Statistics = Critical Value = $450.00 P-value = $450.00 15 6 0 V Q UI A W N $420.00 iii) Decision $580.00 $450.00 $500.00 iv) Interpretation $550.00 $500.00 $450.00 $550.00 $540.00 $550.00 $525.00 $525.00 $525.00 $550.00 $560.00 $495.00 $520.00 $500.00 $510.00 $525.00 $575.00 $475.00 $550.00 $500.00 $450.00 $550.00 $500.00 $550.00 $525.00 $525.00 $550.00 $495.00 $570.00 $485.00 40 $525.00 Problem 1. Problem 2. Problem 3. Problem 4. Problem 5. Problem 6. + 100%