Statistical exercise

Linear Regression Model

Exercise 4 offers two versions: EXCEL (base) and RStudio (BONUS). Submit final results in MS Word.

Don't use plagiarized sources. Get Your Custom Essay on
Statistical exercise
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay

Track 1 RStudio: If you have chosen to work with RStudio (1 % BONUS), please run the following models and complete the following tables. See Track 2 below for EXCEL

RStudio Track

Model 1. Run a linear model to predict the impact of difference in hospital beds (use the total_hospital_beds) and hospital’s ownership on hospital net benefit. Complete table below.

 

 

Model 1a

 

 

 

Hospital Characteristics

 

Coef.

 

St. Err

 

 

 

Hospital beds

 

 

 

 

 

 

 

Ownership

 

 

 

 

 

 

 

For-Profit

 

 

 

 

 

 

 

Not-for-profit

 

 

 

 

 

 

 

Other

 

 

 

 

 

 

 

N

 

 

 

 

 

 

 

R-Squared

 

 

 

 

 

 

1. Discuss your finding(s). Do you think having higher number of hospital beds has a positive impact on the hospital net benefit? What about the ownership?

Model 2. Now, estimate the impact of system membership on hospital net benefit. Complete table below.

 

 

Model 2

 

 

 

Hospital Characteristics

 

Coef.

 

St. Err

 

 

 

Hospital beds

 

 

 

 

 

 

 

Ownership

 

 

 

 

 

 

 

For-Profit

 

 

 

 

 

 

 

Not-for-profit

 

 

 

 

 

 

 

Other

 

 

 

 

 

 

 

Membership

 

 

 

 

 

 

 

System Membership

 

 

 

 

 

 

 

N

 

 

 

 

 

 

 

R-Squared

 

 

 

 

 

 

2. Discuss your finding(s) (no more than 2 lines). Is the result significant? Explain.

Model 3. Now, include the Medicare-discharge-ratio and Medicaid-discharge-ratio in your model. Complete table below

 

 

Model 3

 

 

 

Hospital Characteristics

 

Coef.

 

St. Err

 

 

 

Hospital beds

 

 

 

 

 

 

 

Ownership

 

 

 

 

 

 

 

For-Profit

 

 

 

 

 

 

 

Not-for-profit

 

 

 

 

 

 

 

Other

 

 

 

 

 

 

 

Membership

 

 

 

 

 

 

 

System Membership

 

 

 

 

 

 

 

Socio-Economic Characteristics

 

 

 

 

 

 

 

Medicare-discharge-ratio

 

 

 

 

 

 

 

Medicaid-discharge-ratio

 

 

 

 

 

 

 

N

 

 

 

 

 

 

 

R-Squared

 

 

 

 

 

 

3. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net benefit?

4. Based on your finding(s), please recommend 3 policies to improve hospital performance. Please make sure to use the final model for your recommendation(s).

Excel Track

Model 1. Run a linear model to predict the impact of difference in hospital beds (use the total_hospital_beds) on hospital net benefit in teaching hospitals. Complete table below.

 

 

Coefficient

 

Standard Error

 

t Stat

 

P-values

 

Lower 95%

 

Upper 95%

 

Intercept

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Hospital Beds

 

 

 

 

 

 

 

 

 

 

 

 

 

R Square

 

 

 

 

 

 

 

 

 

 

 

 

Model 2. Run a linear model to predict the impact of difference in hospital beds (use the total_hospital_beds) on hospital net benefit in non-teaching hospitals. Complete table below.

 

 

Coefficient

 

Standard Error

 

t Stat

 

P-values

 

Lower 95%

 

Upper 95%

 

Intercept

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Hospital Beds

 

 

 

 

 

 

 

 

 

 

 

 

 

R Square

 

 

 

 

 

 

 

 

 

 

 

 

1. Use the results from model 1 and model 2 and compare the results between teaching and non-teaching hospitals.

Model 3. Now, include the Medicare-discharge-ratio and Medicaid-discharge-ratio in the first model: Teaching Hospitals. Complete table below.

 

 

Coefficient

 

Standard Error

 

t Stat

 

P-values

 

Lower 95%

 

Upper 95%

 

Intercept

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Hospital Beds

 

 

 

 

 

 

 

 

 

 

 

 

 

Medicare-Discharge-Ratio

 

 

 

 

 

 

 

 

 

 

 

 

 

Medicaid-Discharge-Ratio

 

R Square

 

Model 4. Now, include the Medicare-discharge-ratio and Medicaid-discharge-ratio in the second model: Non-Teaching Hospitals. Complete table below.

 

 

Coefficient

 

Standard Error

 

t Stat

 

P-values

 

Lower 95%

 

Upper 95%

 

Intercept

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Hospital Beds

 

 

 

 

 

 

 

 

 

 

 

 

 

Medicare-Discharge-Ratio

 

 

 

 

 

 

 

 

 

 

 

 

 

Medicaid-Discharge-Ratio

 

R Square

 

2. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net benefit in teaching hospitals?

3. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net benefit in non-teaching hospitals?

4. Based on your finding(s), please recommend 3 policies to improve hospital performance. Please make sure to use the final model for your recommendation(s).

The data is the same of Exercise 1, 2 and 3.

Download codes from here:

E4-codes-dplyr

E4-codes-no-dplyr

The Homework Market
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure all papers are plagiarism-free and do not share them with third parties.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.