## Regression Modeling Application

Regression Modeling Application
Assignment Content

1. Purpose
This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.
Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_File
Instructions:
The Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:

• FloorArea: square feet of floor space
• Offices: number of offices in the building
• Entrances: number of customer entrances
• Age: age of the building (years)
• AssessedValue: tax assessment value (thousands of dollars)
• Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.Regression Modeling Application

ORDER A PLAGIARISM- FREE PAPER NOW

• Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
• Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?
• Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
• Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?
• Construct a multiple regression model.
• Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorAreaOfficesEntrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?
• Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?
• What is the final model if we only use FloorArea and Offices as predictors?
• Suppose our final model is:
• AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices
• What wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?Regression Modeling Application

## compare the health trends that are exhibited in Healthy People 2010 and 2020 frameworks.

For this assignment, you will compare the health trends that are exhibited in Healthy People 2010 and 2020 frameworks. You will create your comparison by addressing the following issues that are listed below.

1) Describe some of the major historical events that have helped to shape the disparities evident in the 2010 and 2020 Healthy People frameworks.

2) How are these frameworks similar; how are they different?

3) What changes have been made to improve the health of people?

4) Give your prediction for a future framework based on today’s trends.

Your report should be at least two pages in length, not counting the title page and reference page. Adhere to APA Style when constructing this assignment, including in-text citations and references for all sources that are used. In addition to citing and referencing both Healthy People frameworks, include a minimum of one additional reference from an Online Library. Please note that no abstract is needed.

## Introduction To Workplace Safety

As a leader of an occupational safety and health program, you will be responsible for setting goals that will drive continuous improvement. Do you think having a goal of zero injuries is effective at driving continuous improvement? Include how this goal will support or detract from employee involvement. Respond to another student’s post with a comment that supports his or her position or provides an alternative point of view.

ALSO PLEASE REPLY TO ANOTHER STUDENTS COMMENT BELOW WITH A POSITIVE COMMENT RESPONSE

Alex:

Hello, my names Alex. I live in a small town called Loch Broom, which is in Nova Scotia (Canada). I currently work as a locomotive engineer (train driver) and am working on completing my BS in Environmental Managment with hopes of working with the department of fisheries or similair here in Nova Scotia doing ocean related conservation.

As a leader of an OSH program, I would think having a goal of zero injuries could be a driving factor for improvment, depending how it was handled. One railroad I previously worked for would take any incident and find a way to blame the employee, for instance, person walking next to the rail track on a hot day tripped over an old peice of rail that was in the rocks, fell and cut there hand open. The company punished this person for not wearing gloves, even though it was not in our rules, they added the rule the next day. I don’t believe the zero injuries is effective in this way, I think that accidents, although majorily preventable, is not 100% preventable. The goal, of course should be to be ahead of them and preventing them, and in that way effective if the team is under the same mind set, but understanding that, and this is true in every job I have ever had, somethings just aren’t foreseeable.

## Competency

Evaluate sets of health data from diverse populations using population health management principles.

## Scenario

Effective population health management (PHM) requires strategies to reach the individual consumer or patient at all stages of life in the manner most appropriate for each individual. PHM must use a set of patterns of population health strategies that describe people and their preferences. These pattern classifications help healthcare organizations begin to understand how they should develop a robust PHM that serves the population needs.

Each market and population is unique. Market position, service offerings, health status, predominant diseases, and geographic and community features are all unique factors that need to be addressed. As your healthcare system gains a greater understanding of their local population needs, the PHM program you are implementing needs to develop criteria that will be assigned to specific population cohorts to define the various proactive health interventions and care delivery.

## Instructions

Write an executive summary that analyzes the various patterns of population health management that your health system is developing for your diverse population.

Use five quality references to support your assessment and findings in this assessment.

## Resources

This link has information for creating an executive summary.

Puro, J., & Falca-Dodson, M. (2016). Population Health: How Two Community-Based Collaborations Are Changing the Face of Healthcare in New Jersey and Beyond. MD Advisor: A Journal For New Jersey Medical Community, 9(1), 4-7.

Devereaux, D. S., & Zilz, D. A. (2018). Population health management: A community imperative. American Journal Of Health-System Pharmacy, 75(2), 46-48.

Block, D. J. (2014). Is Your System Ready for Population Health Management?. Physician Executive, 40(2), 20-24.

QUINTERO, A. (2014). Population Health Management, Data, and Clinical Documentation. Journal Of Health Care Compliance, 16(4), 45-63.

Quinn Ahonen, E., Kaori, F., Cunningham, T., & Flynn, M. (2018). Work as an Inclusive Part of Population Health Inequities Research and Prevention. American Journal Of Public Health, 108(3), 306.

May, T., Byonanebye, J., & Meurer, J. (2017). The Ethics of Population Health Management: Collapsing the Traditional Boundary Between Patient Care and Public Health. Population Health Management, 20(3), 167-169.

Designing a Community-Based Population Health Model

Four Population Health Management Steps for Safety Net Patients

4 Components of Effective Population Health Management