6 7 assignment project applied statistics 1

Getting Started

The purpose of the Project assignment in each STAT-535 workshop is to provide you with an opportunity to demonstrate your ability to apply the statistical tools you have learned in this course.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now


  • Assigned Statistics for Managers: Using Microsoft Excel reading
  • MyStatLab assignments
  • File: Patients dataset (Excel)

Background Information

In each workshop, you will be asked to demonstrate some of the knowledge you have gained by applying a few of the statistical tools that you have learned.


  1. Using the Patients dataset (Excel), create a scatter plot (similar to Figure 13.5) with patient’s age on the x-axis and length of stay on the y-axis. Make sure that you fully label this chart (title for the chart, x-axis, and y-axis). (5 points)
  2. Follow the directions in EG13.2 (Excel Guide) and create a linear trendline along with the linear regression equation and R-squared value. Interpret both the linear regression equation and the R-squared value. (10 points)
  3. Now calculate the correlation coefficient and interpret it. What do you conclude about the relationship between a patient’s age and length of stay? (5 points)
  4. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor using the Assignment submission rubric by the end of the workshop. Showing your work is required, not just providing answers without showing how you arrived at them.

Thank you for your work on this.

1. +5
You produced a correct scatter plot.

2. +6
You produced a correct linear regression equation, but need to work on your interpretations.
Linear regression equation: y= -0.0172x + 5.6474.
Interpretation: for every additional year of patient age, the length of stay decreases 0.017 day.

R-squared interpretation: Approximately 0.62% of the variation in length of stay can be
explained by the variation in patient age.

3. +5

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.