Compute confidence intervals for two means

Assignment Help Basic Statistics

Reference no: EM133983556

Assignment: Healthcare Research Statistics

You will perform the calculations for four problems using data in the attached spreadsheet containing Data Set 3. Please perform the calculations in the spreadsheet.

Use tab 7. (Hospital charges) in DS3.xls and do the following:

A. Calculate the mean and median of age, LOS and charges using the =AVERAGE() and =MEDIAN() functions.
B. Based on the results from ‘A.' above, in which direction, if any, are each of these three distributions (age, LOS, charges) skewed?
C. Calculate the variance and standard deviation of age, LOS and charges using the =VAR.S() and =STDEV.S() functions.
D. Write out the formula for calculating the 95% confidence interval for a sample mean.

In this problem, you will compute confidence intervals for the mean under a variety of conditions and compare the results. You will also discuss what accounts for differences in these confidence intervals, if any. Use Tab 9. In DS3.xlsx to show your work and report your results with two digits to the right of the decimal point.

A. Using =T.INV.2T() and the formula for calculating the confidence interval, calculate the exact 95% confidence interval (upper and lower limits) for the following:

• n = 40, mean = 32, S.D. = 6
• n = 40, mean = 32, S.D. = 12
• n = 140, mean = 32, S.D. = 6
• n = 140, mean = 32, S.D. = 12

Using t = 2 and the formula for calculating the confidence interval, calculate the approximate 95% confidence interval (upper and lower limits) for the following:

• n = 40, mean = 32, S.D. = 6
• n = 40, mean = 32, S.D. = 12

B. Compare the confidence intervals computed in a.i and a.ii, above. What accounts for any differences observed.

C. Compare the confidence intervals computed in a.i and a.iii, above. What accounts for any differences observed.

D. Compare the confidence intervals computed in b.i and b.ii, above. What accounts for any differences observed.

E. Compare the confidence intervals computed in a.i and b.i, above. What accounts for any differences observed.

In the next problem, you will compute confidence intervals for two means and use these to test hypotheses concerning these means. You will also compute the confidence interval for a proportion. Using the data in Tab 10. (Charges) in DS3.xlsx. Report your results with two digits to the right of the decimal point. Assume that the data represent a random sample from a larger population and do the following:

A. Calculate the exact 95% confidence interval (lower and upper limits) for the sample mean of LOS.

B. Use the confidence interval calculated in "a" above to test the hypothesis that the mean LOS is 5.5 days.

C. Calculate the exact 99% confidence interval (lower and upper limits) for the sample mean of charges. Get the instant assignment help.

D. Using the confidence interval calculated in "c" above, test the hypothesis (at the alpha = 1% level) that the mean of charges is $4,700.

E. Compute the 95% confidence interval for the proportion female. (Hint: You will need to calculate the proportion of records that are for females and the S.E. for this proportion).

Reference no: EM133983556

Questions Cloud

What is project communication management : What is Project Communication Management? Why is Project Communication important? Explain the Project Sponsor and their role.

Discuss the evolution of education policy in texas : Discuss the evolution of education policy in Texas. Be sure to include important court cases, school funding and the ongoing effort to bring accountability

Planning for building emergency management profession : Planning for building the emergency management profession to prepare effectively for, mitigate against, respond to, and recover from any hazard.

Why do you identify as belonging with the inner circle group : Why do you identify as belonging with the inner circle group more than the outer circle group? Do you think this could change someday? Why or why not?

Compute confidence intervals for two means : In the next problem, you will compute confidence intervals for two means and use these to test hypotheses concerning these means.

Identify the cranial nerve responsible for transmitting : Identify the cranial nerve responsible for transmitting visual information and describe the anatomical structures it connects between the eye and the brain.

Paper on legal liability for injuries in youth sports : Legal liability for injuries in youth sports, with a specific focus on negligent supervision and duty of care related to overuse injuries in organized youth

How can multinational firms alleviate cultural shock : How can multinational firms alleviate cultural shock? Identify and describe the approaches to intercultural training offered by multinational firms.

Write a short position on student-athletes : Write a short position on whether student-athletes should or should not be compensated for the use of their names and likenesses. You must address the legal

User Account

All Pages