This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_FileInstructions: 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 spaceOffices: number of offices in the buildingEntrances: number of customer entrancesAge: 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 OfficesWhat 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?

Assignment Four: Writing a Business ReportPROBLEMThe manufacturing facility where you work employs three data-entry operators who work full-time keyboarding production, personnel, and inventory data into a computer. This data is then sent via secure Internet connection to the headquarters minicomputer, where it becomes part of the corporate database for financial, production, and personnel management.Last year, one of the operators was absent from work for two weeks for a condition diagnosed as carpal tunnel syndrome, a neuromuscular disorder of the tendons and tissue in the wrists caused by repeated hand motions. Her symptoms included a dull ache in the wrist and excruciating pain in the shoulder and neck. Her doctor treated her with anti-inflammatory medicine and a cortisone injection, and she has had no further problems. However, just last week a second data-entry operator experienced similar symptoms; her doctor diagnosed her ailment as “repeated-motion illness,” or repetitive stress injury (RSI).Because the company anticipates further automation in the future, with more data-entry operators to be hired, your boss has asked you to gather additional information on this condition. Once the extent of the problem is known, she wants you to make any appropriate recommendations regarding the work environment—posture, furniture, work habits, rest breaks, and the like —that will alleviate this problem.PROCESSCompose a few paragraphs describing how you solved this problem. In narrative form, provide information such as the following:1. The problem statement and subproblems for your report2. How you gathered the needed secondary data3. How you evaluated the quality and relevance of any data you collected from online searching4. How you decided whether to use a direct or an indirect organizational plan5. The degree of formality you decided to use6. Factors you used to determine whether to include any visual aidsPRODUCTCompose your two to four page report, following the five steps in the writing process (planning, drafting, revising, formatting, and proofreading). Include a bibliography or reference list. Format the final version in appropriate style (refer to the Appendix for formatting guidelines).