Question

Fig. 4.5 Worksheet Data for Chapter 4: Practice Problem #1 ACCOUNTS RECEIVABLE PAST-DUE ACCOUNTS No. of days past due 124 (a) Write the null hypothesis and the research hypothesis on your spreadsheet (b) Use Excel to find the sample size, mean, standard deviation, and standard error of the mean to the right of the data set. Use number format (2 decimal (c) Enter the critical t from the t-table in Appendix E onto your spreadsheet, and (d) Use Excel to compute the t-value for these data (use 2 decimal places) and (e) Type the result on your spreadsheet, and then type the conclusion in plain places) for the mean, standard deviation, and standard error of the mean. label it. label it on your spreadsheet English on your spreadsheet (t) Save the file as: ACCOUNTS3 2. The Department of Managed Health Care in the State of California (USA) has adopted a number of regulations to ensure that managed care enrollees have access to healthcare services in a timely manner. One of these regulations requires that health care plans show that their provider networks are sufficiently large to ensure that enrollees be offered an appointment with a primary care provider within 10 business days of such a request. Suppose that you are an intern for a health insurer and that you have been asked to determine whether or not your company is in compliance with this regulation. Hypothetical data on a random sample of patients insured with your company are presented in Fig. 4.6:

Answer 1

a) H^0: the average time required is 32 minutes ie u = 32 minutes where u: mean time required to conduct a specify research in laboratory H1: the average time required is not 32 minutes u not equal 32 minutes b) the sample size n = 21, (cam be calculated using) count function of excel, mean (x) = (sigma ^n x I/n) = 614/21 = 29.238 standard derivation is given as: Sigma^n_i = 1 (x _i - x^-)^2/x - 1 = 6.37 mean in two decimal places can be written as 29.24 c) the critical value of t statistic at alpha = 0.05 is 1.725 at 20 degrees of freedom for one tailed test and is 2.086 for a two failed test d) the t value for the case is given as: t = x - 4/s/squareroot n 29.23 -32/6.37/squareroot = -1.98 (approx) \r\n \ e) since the critical value for a double/two failed test at alpha = 0.05 is + 2.086, and t = -1.98 < - 2. 086, this means that the L-statistic falls in the acceptance region and we do not have strong evidence to reject h0 this means that time taken is not significantly different from 32 minutes