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.  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 FloorArea, Offices, Entrances, 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?

For this assignment, we will focus on the case “Improving Performance at the Hotel Paris” (p. 380) in the textbook.A case study is a short description of a real business situation. Analyzing case studies gives you the opportunity to apply those concepts to real business problems. Cases are generally written for several types of analysis. Usually, there is not a “ right or wrong"” answer. Rather, cases provide a vehicle for you to demonstrate your understanding and ability to apply course concepts. You must use appropriate sources (properly cited) to support your position. Check your analysis by assessing how well it demonstrates your HR knowledge. If your answer relies on your impressions of HR prior to taking this course, it is likely that the analysis is not your best effort.Simply answering the questions which are part of the case is not enough; consider the questions to be clues to the important concepts and facts. You are strongly encouraged to use the following outline so that your analysis is organized appropriately:Identify both the key issues and the underlying issues. In identifying the issues, you should be able to connect them to the HR principles which apply to this situation.Discuss the facts which affect these issues. The case may have too much information. In your discussion, you should filter the information and discuss those facts which are pertinent to the issues identified above.Discuss your tentative solution to the problem and how you would implement your solution. What actions would you propose to correct the situation, based on the knowledge you have gained in this course? Be sure to support your recommendation by citing references in the text and in the supplementary readings. You should also draw on other references such as business periodicals and HR journals. Remember that an ANALYSIS is more than simply a SUMMARY of the Case Study.Discuss follow-up and contingency plans. How will the organization know that your proposed solution is working? What should they do if it does not work?It may be helpful for you to “role-play” this assignment. Consider yourself to be the HR Manager, charged with developing a presentation for the CEO. Your presentation should cover the points listed above. By "role-playing" the situation, using the questions at the end of the case as hints, and by using this guide, you should be able to develop an action-oriented analysis with a recommended course of action. Your analysis of the case study should be a minimum of 4 pages written in APA style and is due at the end of this module.Compose your work in a .doc or .docx file type using a word processor (such as Microsoft Word, etc.) and save it frequently to your computer. For those assignments that are not written essays and require uploading images or PowerPoint slides, please follow uploading guidelines provided by your instructor.Check your work and correct any spelling or grammatical errors. When you are ready to submit your work, click “Upload Submission.” Enter the submission title and then click on “Select a file to upload.” Browse your computer, and select your file. Click “Open” and verify the correct file name has appeared next to Submission File. Click on “Continue.” Confirm submission is correct and then click on “Accept Submission & Save.”Turnitin®This course has Turnitin® fully integrated into the course dropbox. This means that you should only submit your assignments to the dropbox below. Please do not submit your assignment directly to Turnitin.com. Once submitted, your assignment will be evaluated by Turnitin® automatically. You will be able to view an Originality Report within minutes of your first submission that will show how much of your work has been identified as similar to other sources such as websites, textbooks, or other student papers. Use your Originality Report as a learning tool to identify areas of your assignment that you may not have cited appropriately. You may resubmit your assignment through this dropbox as many times as you need to check to see if you have made improvements, until the due date of the assignment. However, once you have made your first submission, you will need to wait 24 hours after each subsequent submission to receive a new Originality Report. Plan accordingly as you draft your assignment. Once the due date has passed, your assignment submission will be considered final.EvaluationThis assignment will be graded using the SBT Case Analysis Rubric. Please review this rubric prior to beginning your work. You can also access the rubric on the Course Rubrics page within the Start Here module. This assignment is worth 20% of your final course grade.