1
Regression Analysis
Name
University, Department
Course
Instructor
Date
2
Data Description
Relevant data characteristics
1. Independent variable:
Monthly Nurse Participation Rate: This represents the percentage of nurses participating
in the well-being program each month over a span of 36 months.
2. Dependent Variable
Nurse Attrition Rate: This represents the percentage of nurses leaving the hospital each
month over the same 36-month period.
Types of Data
The data for both variables are quantitative and continuous.
Quantity of Data:
The dataset consists of 36 pairs of observations, representing 36 months of data for both
nurse participation rates and nurse attrition rates.
Graphical Display of Data
A scatter plot is created to visualize the relationship between the monthly nurse
participation rate and the nurse attrition rates using Excel, as shown in the chart below.
3
Chart Title: Relationship between Nurse Participation Rate and Attrition Rate
N.B. Legend is not necessary for a scatter plot with a single data series.
Axis Title’s
- X-axis: Monthly Nurse Participation Rate (%)
- Y-axis: Monthly Nurse Attrition Rate (%)
Data Intervals: 36 data points represent monthly observations.
Data Analysis Using Linear Regression.
Output and calculations.
Using Excel's Data Analysis, a linear regression analysis was performed. Below is a summary
of the regression output.
4
Regression Equation: y=β0+β1x
Regression Statistics
Multiple R=0.72
R-Square=0.52
Adjusted R-Square=0.50
Standard Error=0.05
Observations=36
Coefficients
Intercept (β0): 0.15 (p-value = 0.001).
Participation Rate (β1): -0.35 (p-value = 0.0002)
The regression equation will be
Attrition Rate=0.15−0.35×Participation Rate
5
Justification for Linear Regression
Linear regression is appropriate for this analysis, as we are interested in predicting the
dependent variable (nurse attrition rate) based on the independent variable (nurse participation
rate). The linear relationship is hypothesized using the supporting data, this helps identify the
strength and direction of the association.
Implications of Data Analysis
Null Hypothesis: There is no significant relationship between the monthly nurse participation
rate in the well-being program and the nurse attrition rate.
Results Interpretation
Goodness of Fit
The R-Square value of 0.52 shows that approximately 52% of the variation in the nurse
attrition rate is attributed to the nurse participation rate, suggesting a moderate level of
explanatory power.
Significance of an Independent Variable
The participation rate has a significant negative relationship with the attrition rate (p-
value = 0.0002), indicating that higher participation in the well-being program is
associated with lower attrition rates.
Linear Equation
The equation Attrition Rate=0.15−0.35×Participation Rate means that for every 1%
increase in the participation rate, the attrition rate decreases by 0.35%; this helps in
understanding the quantitative impact of participation on attrition.
Limitation of Research
6
One limitation is that the analysis does not account for other potential factors influencing
nurse attrition, such as workload, job satisfaction, or external economic conditions.
Recommendation
Based on the analysis, the continuation and expansion of the well-being program is
recommended since there is a correlation between higher participation and lower nurse
attrition.
