Question

Who would be interest in this type of data and why? What relationship would you expect to see? Graph the data and describe the relationship. Is it surprising? Are the conditions for regression met and describe. Write the regression equation.

Comment on the following:

a. Statistical significance of the model.

b. Goodness of fit

Excel File Edit View Insert Format Tools Data Window Help 酉 10% D- Sun 5:41 PM Sample Data -Saved to my Mac Q Search Sheet InsertPage Layout Formulas Data Review View 1→ Share ^ Σ AutoSum , A Calibri (Body) AA B 1 Y ,||ー, sh, A, -Wrap Text Copy Fill 恒恒!!] Merge & Center, $, % , 40 conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & Clear 032 1 Year xpensesEmplayee Rainfall Units Sold In this set, we are predicting units sold (in thousandsof dollars) for a firm over thenext two years To do so, we have the number of employee, annual rainfall (in inches, andannl expenses in S SUMMARY CUTPUT 2001 Units Sold 6500 229 5745 990 6312 20046450 236 238 MultipleR R Squarc Adjusted R Square 0.920041 0.84647S 0.7953 215 216 2007 38 5975 12 214 36 6279 14 890 8900 9150 16 Residual 216 218 217 6479 6332 12 1175677 9797.306 Raintal On in. 18 2016 36 P-HOJue Lower 95 N Upper 95% ower 95.0' 0.001309 95.0% Intercept 63395.9 204014 21 68,04674 16.02491 4,246309 0001135 33,13145 102.962 33,13145 102.962 Expenses .055587 0.355981 .067743 0.17448 0 17.60762 4.013142 4.387489 0.000885 8.363733 26.35151 8.863733 26.35151 2,1807 19.54269 -22,1807 19.54269 1.31899 9.5747940,13776 0892 25 26 ear Expenses MEmployces Rainfal Units Soid 28 Expenses 0.926893 0.70541 0.274547 0.178249 0.05448 0.60765 39 Weight loss 目凹ー 100%

Answer 1