Assignment ContentPurpose 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 asses

1.Use your graphing calculator to evaluate . (2 points)e50π12.Use your calculator to select the best answer below: (2 points)1−10does not exist3. (2 points)2a4.Find . (2 points)does not exist305.If and , then find . (2 points)40-416286.Evaluate . (2 points)0does not exist1-17.Evaluate . (2 points)8.Evaluate . (2 points)1does not exist9.If f is a continuous function with odd symmetry and , which of the following statements must be true? (2 points)I.II.There are no vertical asymptotes.III.The lines y = 5 and y = -5 are horizontal asymptotes.I onlyII onlyIII onlyAll statements are true.10.What are the horizontal asymptotes of the function ? (2 points)y = -2 and y = 2y = 2 onlyy = -2 onlyy = 011.Which one or ones of the following statements is/are true? (2 points)I.If the line y = 2 is a horizontal asymptote of y = f(x), then f is not defined at y = 2.II.If f(5) > 0 and f(6) < 0, then there exists a number c between 5 and 6 such that f(c) = 0.III.If f is continuous at 2 and f(2)=8 and f(4)=3, then .All statements are true.I onlyII onlyIII only12.Find (2 points)0-∞∞13.Evaluate . (2 points)0does not exist14.Which of the following are the equations of all horizontal and vertical asymptotes for the graph of ? (2 points)y = 0, x = -4, x = 4y = 1, x = -4, x = 4y = 0, x = -4, x = 0, x = 4y = 1, x = -4, x = 0, x = 415.Evaluate . (2 points)3-51does not exist16.Where is discontinuous? (2 points)x = -2x = 4x = -2 and x = 4f(x) is continuous everywhere17.Which of the following are continuous for all real values of x?(2 points)I.II.III.I onlyII onlyI and II onlyI and III only18.Which of the following must be true for the graph of the function ?(2 points)There is:I.a vertical asymptote at x = 3II.a removable discontinuity at x = 3III.an infinite discontinuity at x = 3I onlyII onlyIII onlyI, II, and III19.What is the average rate of change of y with respect to x over the interval [1, 5] for the function y = 4x + 2? (2 points)82420.What is the instantaneous slope of y = at x = 3? (2 points)21.The height, s, of a ball thrown straight down with initial speed 64 ft/sec from a cliff 80 feet high is s(t) = -16t2 - 64t + 80, where t is the time elapsed that the ball is in the air. What is the instantaneous velocity of the ball when it hits the ground? (2 points)256 ft/sec-96 ft/sec0 ft/sec112 ft/sec22.The surface area of a right circular cylinder of height 5 feet and radius r feet is given by S(r)=2πrh+2πr2. Find the instantaneous rate of change of the surface area with respect to the radius, r, when r = 6. (2 points)24π34π64π20π

This week we talk about the uses of a crosstabulation (crosstabs) and the benefits of creating this "snapshot" of your data.For this forum, provide a brief introduction to your study to remind your classmates what we are reading about here. Include: 1. Your overall research question 2. The research hypothesis and null hypothesisNext, create a crosstab for your data and include it in the post. Be sure to explain your findings, including a description of the data, a calculation of the epsilons, and a discussion of the 10% rule. The epsilons in short are the differences between the highest and lowest column % in any given row. As long as one epsilon makes the 10% threshold, we'll deem two variables have "enough" going on to with each other to warrant further statistical analysis.Special note:When a variable is continuous (interval/ratio level of measurement), for example, age of respondent, we do not run crosstabs directly b/c it will result in a really spread-out table with lot of 0s and low frequency cells. Such a crosstab does not help us understand the data.The correct way is to reduce the level of measurement to either ordinal level or nominal level (group the numbers into categories) and then run the cross table. You do this by recoding (as you demonstrated in Assignment 1). In this way, your crosstabs will help us better understand data. Here is another example of recoding in a video.******I will include attachments that show my research question and previous work (Donald_soci332_A1), variables of choice (satjob1 and happy), a zip file labeled (job and happiness) from gss. I have also attached how to documents that are strictly examples.