Purchase Solution

Multiple Regression Analysis

Not what you're looking for?

Ask Custom Question

The total expenses of a hospital are related to many factors. Two of these factors are the number of beds in the hospital and the number of admissions. Data were collected on the 14 hospitals, as shown in the table:

HOSPITAL NUMBER OF BED's ADMISSSIONS (100s) TOTAL EXPENSES (MILLIONS)
1 215 77 57
2 336 160 127
3 520 230 157
4 135 43 24
5 35 9 14
6 210 155 93
7 140 53 45
8 90 6 6
9 410 159 99
10 50 18 12
11 65 16 11
12 42 29 15
13 110 28 21
14 305 98 63

-------------------------------------

ASSIGNMENT:

* State the linear equation,
* Explain the overall statistical significance of the model,
* Explain the statistical significance for each independent variable in the model
* Interpret the Adjusted R2,
* Is this a good predictive equation(s)? Which variables should be excluded (if any) and why? Explain.

Purchase this Solution
Solution Preview

We're going to look at the relationship between the number of beds in the hospital, the number of admissions, and the total expenses.
The independent variables are beds and admissions. The dependent variable is expenses.
I used Excel to do a linear regression.

State the linear equation,

The linear equation is expenses = 0.023*beds + 0.623*admissions - 0.654.

Explain ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Purpose and interpretation of multiple regression analysis

    472787 What purpose does a multiple regression analysis serve? What purpose does a multiple regression analysis serve? Give an example of how it might be used in marketing research.

  • Data Analysis: Multiple Regression

    Basically we want to see which variables are able to predict the dependent variable using the multiple regression. This solution is comprised of a detailed explanation of multiple regression analysis.

  • Multiple Regression Analysis and Least Squares Regression

    Do you have an example of how to set up excel program for a multiple regression analysis? When you do a multiple regression analysis, you make one equation relating one dependent variable (y) to several independent variables (x's).

  • Multiple regression analysis of Starbuks and DJIA data

    107237 Multiple regression on Starbuks and DJIA data Can you perform a multiple regression analysis with the data you have been collecting without changing that data or adding to it? Why or why not?

  • Important Information About Statistical Techniques

    Multiple linear regression, discriminate analysis, canonical correlation and multivariate analysis of variance is examined.

  • Multiple regression analysis with the attached data

    133196 Multiple regression analysis with the attached data 1. Can I perform a multiple regression analysis with the attached data that I've collected without changing that data or adding to it?

  • Is an F-statistic used to test the global hypothesis

    Yes or no: Is an F-statistic used to test the global hypothesis in multiple regression analysis? Yes, F statistic is used to test the global hypothesis in Multiple Regression analysis.

  • Multiple Regression

    371576 Multiple regression analysis: leadership change Give an example of how you may use multiple regression to answer a question related to the impact of leadership change on employee attitudes scores, teambuilding training and performance outcomes.

  • Design of Experiments

    Regression analysis shows how the typical value of the dependent variable changes when any of the independent variables changes. Multiple Regression analysis is used mainly in forecasting and estimation.

  • Multiple regression

    207261 Multiple regression equation. Given the computer output from a regression analysis, write the regression equation, describe the variables, and decide of some of the variables should be eliminated from the equation.

View More Related Solutions