C207 - Data-Driven Decision Making

C207 QUM3 Task 1 Example and Guide: Regression Analysis – Data-Driven Decision Making C207 PRFA

C207 QUM3 Task 1 Guide: Regression Analysis Example

Updated on: Aug 14, 2026

C207 QUM3 Task 1 Quick Facts

Course C207 — Data-Driven Decision Making
Assessment QUM3 — Task 1: Linear Regression Analysis
Format Performance Assessment — regression analysis + written report
Software Excel (Data Analysis ToolPak) strongly recommended for full functionality
Rubric aspects 11 scored components across sections A through F
Submission check Automatic similarity scan and Grammarly for Education review before evaluation

C207 QUM3 Task 1: Linear Regression Analysis

Data-Driven Decision Making — C207 PRFA — QUM3

Introduction

Managers are required to organize, interpret, and display data that is reliable and relevant to the real-world decisions they must make in their businesses. The use of analytical tools will improve your ability to use data to make these informed decisions.

In this task, you will address the business situation in the attached “Linear Regression Analysis Resources” scenario. You will access the scenario and dataset by entering your student ID number in the “Start” tab of the attachment, then continuing to the “Scenario” tab. Using this data set, you will perform a linear regression analysis and write a report in which you recommend a solution by summarizing the key details of your analysis.

For full functionality of the scenario and dataset attachment, you are strongly encouraged to use Microsoft Excel, which is available via the Microsoft Office 365 subscription service provided to all WGU students. It can be downloaded using the “Microsoft Office 365” link in the Web Links section.

Scenario

Refer to the scenario located in the attached “Linear Regression Analysis Resources.”

You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.

Complete your linear regression analysis and create a report by doing the following:

Note: The supporting document “Linear Regression Analysis Resources” contains a scenario, data set, and data analysis template. While you must use the scenario and data set provided in the supporting document, the template is optional. You are encouraged to use the template to complete your analysis. Please see supporting document, “QUM Task 1 Getting Started,” for help accessing the scenario and dataset.

C207 QUM3 Task 1

C207 QUM3 Task 1 Example

Senario

C207 Task 1 Scenario

Summary Output

C207 Task 1 Summary output

Interpretation of Findings

Section D

D1a. Goodness of Fit

The linear regression model shows a strong goodness-of-fit, with an R² value of approximately 0.67. In context, this means that close to 67% of the variation in nurse attrition is explained by the program participation rate, indicating that program participation implicitly accounts for the variation in nurse attrition.

D1b. Significance of the Independent Variable

The regression results show that the independent variable, program participation rate, is highly significant in predicting nurse attrition rates. The p‑value (1.13 × 10⁻⁹) is way below the significance level of 0.05, indicating a statistically meaningful relationship. Likewise, the negative coefficient (‑0.1138) shows that as participation increases, the attrition rates decrease. The model explains a substantial portion of variance, with an R² of 0.669, meaning close to 67% of the outcome is predicted by this single variable. Therefore, the results demonstrate that the independent variable is a powerful and reliable predictor of nurse attrition.

D1c. Linear Equation and Application

Predicted attrition rate is -0.1138x + 6.611 (participation rate). The slope which is –0.1138 means that for every 1‑percentage‑point increase in program participation, there is a 0.1138 decrease in percentage points. The intercept of 6.6110, which is a constant, depicts the estimated attrition rate when participation is zero.

D3. Recommended Course of Action

The results from the linear regression analysis indicate that the hospital should continue to have a program for employee wellness, and specifically increase the participation of nurses in the program. The findings show that participation rate is an important factor that determines nurse attrition, with a higher participation being significantly associated with the lower nurse attrition. For hospital leaders, the extent of the impact of participation is sufficient to feel assured that it plays a significant role in the model, which accounts for about 67% of the variance in attrition, and therefore they can focus on strategies to improve participation.

The hospital can achieve less nurse attrition, higher retention and subsequently lower costs for staffing through targeted interventions like enhanced outreach, incentives, flexible scheduling and additional program options.

C207 QUM3 Task 1 Example

Common Mistakes to Avoid

  • Writing a business question that’s interesting but not specifically answerable by linear regression
  • Reporting R² without any interpretation of what it actually means for the business
  • Treating a non-significant p-value as proof of “no relationship” rather than “not enough evidence in this data”
  • A D1c equation explanation that restates the numbers instead of applying them to a future scenario
  • Skipping the correlation-vs-causation limitation in favor of a vaguer, less defensible one
  • Submitting before reviewing the Grammarly for Education feedback

Perfect-Score Self-Check

  • Does my business question name both variables and fit the “does X predict Y” shape?
  • Is my null hypothesis specifically about the regression slope, not a generic statistical statement?
  • Have I included all four data-description elements in B1?
  • Does my C1 output include the full table, not just the final numbers?
  • Is my C2 chart actually a scatter plot with all three required elements?
  • Did I compare my p-value to my stated significance level explicitly in D1b?
  • Does my D3 recommendation reference my specific analysis results, not just general advice?
  • Have I cleared the Grammarly for Education check?

References & Further Reading

Related Resource

Frequently Asked Questions

  • Is the hospital/nurse wellness scenario used in this guide’s examples? No. Every C207 QUM3 Task 1 student receives the same scenario and one of three shared datasets, so this guide uses a fictitious retail scenario (Ferngate Retail Group) to demonstrate the method without answering the actual shared prompt.
  • Does this guide give me the answers to my specific dataset? No — and it can’t, since your dataset is one of three assigned by your student ID and not visible to us. What this guide gives you is the exact rubric-by-rubric method, demonstrated on fictitious numbers, so you can apply the same process to your real output.
  • What software should I use for the regression analysis? Excel with the Data Analysis ToolPak add-in is what WGU recommends and what this guide’s walkthrough assumes. If the ToolPak isn’t visible in your Data tab, it needs to be enabled through Excel’s Add-ins settings first.
  • Is getting help with this task against WGU’s academic integrity policy? Tutoring, coaching, and editing support are a normal, accepted part of studying — most university policies explicitly support students getting this kind of help. Our role is to help you understand and interpret your own output, which fits well within that.