Data Analysis 8

Excel file: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing

To monitor and improve its productivity, a company made an investigation and found out that the factor that affects the productivity the most is the absenteeism. The company data analytics department have collected data about the two variables (Productivity and Absenteeism) for the 12 past years as shown in the table below. Now the purpose of the company is to determine, through regression analysis, whether the productivity is statistically affected by the absenteeism level or not. Year Absenteeism Productivity (in number of absent worker) (in Million AED) 1 204 342 2 352 336 3 154 406 4 206 410 5 422 278 6 530 214 7 750 138 8 482 268 9 374 262 10 120 356 11 188 396 12 634 152 Questions: Construct a scatter diagram for the data about productivity and absenteeism then interpret the possible relationship that can be found. Construct a simple regression model to predict the…

Find the degrees of freedom in a regression model with an intercept term that has 88 observations and 7 explanatory variables.

when a regression is used as a method of predicting dependent variables from one or more independent variables. How are the independent variables different from each other yet related to the dependent variable?

A consumer advocacy group recorded several variables on 140 models of cars. The resulting information was used to produce the following regression output that relates the city gas mileage (in mpg) and the engine displacement (in cubic inches). The regression equation is mpg_city= 35.5 - 0.0696 * displacement We have a car that has an engine with 141 cubic inches. Based on this output, what city gas mileage would you predict for this car?____ (Round answer to the nearest hundredth (2 decimal places.)

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? FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 5940 4 2 2 2094 5720 4 2 34 1968 3660 3 2 38 1567 5000 4 2 31 1878 2990 2 1 19 949 2610 2 1 48 910 5650 4 2 42 1774 3570 2 1 4 1187 2930 3 2 15 1113 1280 2 1 31 671 4880 3 2 42 1678 1620 1 2 35 710 1820 2 1 17 678 4530 2 2 5 1585 2570 2 1 13 842 4690 2 2 45 1539 1280 1 1 45 433 4100 3 1 27 1268 3530 2 2 41 1251 3660 2 2 33 1094 1110 1 2 50 638 2670 2 2 39 999 1100 1 1 20 653 5810 4 3 17 1914 2560 2 2 24 772 2340 3 1 5 890 3690 2 2 15 1282 3580 3 2 27 1264 3610 2 1 8 1162 3960 3 2 17 1447

Dex Research Limited conducted a research to investigate consumer characteristics that can be used topredict the amount charged by credit card users. The following multiple regression output is based on adata collected by this research company on annual income, household size and annual credit cardcharges for a sample if 50 consumers.  aComplete the missing entries from A to H in this output b. Estimate the annual credit card charges for a three-person household with an annual incomeof $40,000. c. Did the estimated regression equation provide a good fit to the data? Explain

Define the different ways to use linear regression?