# Sample apa results

Hints: Depending on context, you could argue which is the dependent variable and which is the independent variable.  I chose to investigate whether obesity rates could predict total hospital expenditures.  I did not “check” the ‘constant is zero” box.

Instructions Part One: A linear regression analysis was performed in SPSS to evaluate the ability of independent variables full and part-time FTEs, number of Medicare certified beds and urban vs. rural setting to predict dependent variable, occupancy rate. In paragraph, APA-formatted form, interpret the results. Include basic assumptions for regression analysis.

 Variables Entered/Removeda Model Variables Entered Variables Removed Method 1 Urban=1 Rural=0, F59 FTEs Part Time, F59 FTEs Full Time, Medicare Certified Beds, F33 FTEs Part Time, F33 FTEs Full Timeb . Enter a. Dependent Variable: OccRate b. All requested variables entered.

For the chart above, the Independent Variables are:

F59 FTEs Full Time [ACTTHRFT]

F59 FTEs Part Time [ACTTHRPT]

Medicare Certified Beds [MCAREBED]

Urban = 1 Rural = 0 [URBAN]

The Dependent Variable is:

Occupancy Rate [OccRate]

 Model Summaryb Model R R Square Adjusted R Square Std. Error of the Estimate 1 .334a .111 .098 16.15966 a. Predictors: (Constant), Urban=1 Rural=0, F59 FTEs Part Time, F59 FTEs Full Time, Medicare Certified Beds, F33 FTEs Part Time, F33 FTEs Full Time b. Dependent Variable: OccRate

 ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 12874.868 6 2145.811 8.217 .000b Residual 102625.909 393 261.135 Total 115500.777 399 a. Dependent Variable: OccRate b. Predictors: (Constant), Urban=1 Rural=0, F59 FTEs Part Time, F59 FTEs Full Time, Medicare Certified Beds, F33 FTEs Part Time, F33 FTEs Full Time

 Coefficientsa Model Unstandardized Coefficients Standardized Coefficients t Sig. B Std. Error Beta 1 (Constant) 76.194 1.794 42.468 .000 F59 FTEs Full Time 2.799 1.064 .129 2.632 .009 F59 FTEs Part Time -2.085 3.904 -.026 -.534 .594 F33 FTEs Full Time .508 .182 .153 2.788 .006 F33 FTEs Part Time 1.561 .831 .101 1.878 .061 Medicare Certified Beds -.265 .051 -.251 -5.155 .000 Urban=1 Rural=0 .608 1.763 .017 .345 .730 a. Dependent Variable: OccRate

 Residuals Statisticsa Minimum Maximum Mean Std. Deviation N Predicted Value 54.8814 110.5536 81.8834 5.68048 400 Residual -76.74610 36.51113 .00000 16.03770 400 Std. Predicted Value -4.753 5.047 .000 1.000 400 Std. Residual -4.749 2.259 .000 .992 400 a. Dependent Variable: OccRate

Instructions Part Two: Use the same Excel file you used for the correlation assignment to calculate regression on obesity rates and total hospital expenditures (Data > Analyze Data (may be an add in) > Regression). Paste results and interpretation below.

## Sheet1

 Category Type of Service/Source of Funds Date Expenditures Obesity Prevalence Total Hospital Expenditures Department of Defense 12/31/80 \$2,819,000,000 0.095 Total Hospital Expenditures Department of Veterans Affairs 12/31/80 \$4,997,000,000 0.107 Total Hospital Expenditures Medicaid (Title XIX) 12/31/80 \$9,214,000,000 0.151 Total Hospital Expenditures Medicare 12/31/80 \$26,278,000,000 0.104 Total Hospital Expenditures Other Third Party Payers and Programs 12/31/80 \$15,041,000,000 0.093 Total Hospital Expenditures Out of pocket 12/31/80 \$5,381,000,000 0.144 Total Hospital Expenditures Private Health Insurance 12/31/80 \$36,786,000,000 0.095 Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/80 \$35,493,000,000 0.088 Total Hospital Expenditures Department of Defense 12/31/81 \$3,275,000,000 0.143 Total Hospital Expenditures Department of Veterans Affairs 12/31/81 \$5,436,000,000 0.112 Total Hospital Expenditures Medicaid (Title XIX) 12/31/81 \$11,062,000,000 0.105 Total Hospital Expenditures Medicare 12/31/81 \$31,521,000,000 0.127 Total Hospital Expenditures Other Third Party Payers and Programs 12/31/81 \$17,300,000,000 0.11 Total Hospital Expenditures Out of pocket 12/31/81 \$6,271,000,000 0.109 Total Hospital Expenditures Private Health Insurance 12/31/81 \$42,615,000,000 0.096 Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/81 \$42,583,000,000 0.072 Total Hospital Expenditures Department of Defense 12/31/82 \$3,694,000,000 0.1 Total Hospital Expenditures Department of Veterans Affairs 12/31/82 \$5,951,000,000 0.135 Total Hospital Expenditures Medicaid (Title XIX) 12/31/82 \$11,782,000,000 0.158 Total Hospital Expenditures Medicare 12/31/82 \$36,662,000,000 0.175 Total Hospital Expenditures Other Third Party Payers and Programs 12/31/82 \$19,052,000,000 0.199 Total Hospital Expenditures Out of pocket 12/31/82 \$7,210,000,000 0.162 Total Hospital Expenditures Private Health Insurance 12/31/82 \$49,297,000,000 0.212 Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/82 \$48,444,000,000 0.201 Total Hospital Expenditures Department of Defense 12/31/83 \$3,887,000,000 0.164 Total Hospital Expenditures Department of Veterans Affairs 12/31/83 \$6,290,000,000 0.188 Total Hospital Expenditures Medicaid (Title XIX) 12/31/83 \$12,947,000,000 0.204 Total Hospital Expenditures Medicare 12/31/83 \$40,989,000,000 0.143 Total Hospital Expenditures Other Third Party Payers and Programs 12/31/83 \$19,725,000,000 0.148 Total Hospital Expenditures Out of pocket 12/31/83 \$7,624,000,000 0.176 Total Hospital Expenditures Private Health Insurance 12/31/83 \$53,282,000,000 0.141 Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/83 \$53,936,000,000 0.18 Total Hospital Expenditures Department of Defense 12/31/84 \$4,200,000,000 0.157 Total Hospital Expenditures Department of Veterans Affairs 12/31/84 \$6,886,000,000 0.191 Total Hospital Expenditures Medicaid (Title XIX) 12/31/84 \$13,961,000,000 0.159 Total Hospital Expenditures Medicare 12/31/84 \$45,415,000,000 0.163 Total Hospital Expenditures Other Third Party Payers and Programs 12/31/84 \$20,035,000,000 0.148 Total Hospital Expenditures Out of pocket 12/31/84 \$8,093,000,000 0.176 Total Hospital Expenditures Private Health Insurance 12/31/84 \$55,775,000,000 0.182 Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/84 \$59,377,000,000 0.182 Total Hospital Expenditures Department of Defense 12/31/85 \$4,917,000,000 0.193 Total Hospital Expenditures Department of Veterans Affairs 12/31/85 \$7,100,000,000 0.196 Total Hospital Expenditures Medicaid (Title XIX) 12/31/85 \$14,624,000,000 0.203 Total Hospital Expenditures Medicare 12/31/85 \$48,644,000,000 0.198