December 15, 2017
###### What force must be applied to a steel bar 1 in. square and 2 ft. long to produce an elongation of 0.016 in? (The modulus of elasticity for steel is 29,000,000 psi)
December 15, 2017

Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following.

Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the “best fit” line. Interpret.
Determine the equation of the “best fit” line, which describes the relationship between the dependent variable and the selected independent variable.
Determine the coefficient of correlation. Interpret.
Determine the coefficient of determination. Interpret.
Test the utility of this regression model. Interpret results, including the p-value.
Based on the findings in Steps 1-5, analyze the ability of the independent variable to predict the designated dependent variable.
Compute the confidence interval for ?1 (the population slope) using a 95% confidence level. Interpret this interval.
Using an interval, estimate the average for the dependent variable for a selected value of the independent variable. Interpret this interval.
Using an interval, predict the particular value of the dependent variable for a selected value of the independent variable. Interpret this interval.
What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.
In an attempt to improve the model, use a multiple regression model to predict the dependent variable, Y, based on all of the independent variables, X1, X2, and X3.

Using Excel, run the multiple regression analysis using the designated dependent and three independent variables. State the equation for this multiple regression model.
Perform the Global Test for Utility (F-Test). Explain the conclusion.
Perform the t-test on each independent variable. Explain the conclusions and clearly state how the analysis should proceed. In particular, which independent variables should be kept and which should be discarded. If any independent variables are to be discarded, re-run the multiple regression, including only the significant independent variables, and summarize results with discussion of analysis.
Is this multiple regression model better than the linear model generated in parts 1-10? Explain.
All DeVry University policies are in effect, including the plagiarism policy.
Part C report is due by the end of Week 7.
Part C is worth 100 total points. See grading rubric below.
Summarize your results from Steps 1?14 in a three-page report. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.

Submission: The summary report and all of the work done in 1?14 (Excel output and interpretations) as an appendix

Format for report:

Summary Report
Points 1?14 should be addressed with appropriate output, graphs, and interpretations. Be sure to number each point 1?14.

Employee Number SALES CALLS TIME YEARS TYPE Legend:
1 46 171 12.7 5 ONLINE Employee Number is just as it sounds.
2 34 134 17.0 4 NONE SALES represents the number sales made this week.
3 44 165 15.7 3 ONLINE CALLS represents the number of sales calls made this week.
4 45 186 13.0 3 ONLINE TIME represents the average time per call this week.
5 42 180 14.8 2 ONLINE YEARS represents years of experience in the call center.
6 47 184 12.4 2 ONLINE TYPE represents the type of training the employee received.
7 33 126 20.2 3 NONE
8 44 172 14.4 3 GROUP
9 42 161 13.9 1 GROUP
10 37 149 15.4 3 NONE
11 46 181 12.2 4 ONLINE
12 40 145 16.0 0 NONE
13 43 140 17.0 2 GROUP
14 52 198 13.5 2 ONLINE
15 41 149 17.3 0 ONLINE
16 42 168 12.9 3 ONLINE
17 32 124 17.5 2 NONE
18 42 149 16.5 1 GROUP
19 38 135 18.2 1 GROUP
20 49 185 18.6 2 ONLINE
21 39 154 18.3 1 NONE
22 43 149 15.6 1 ONLINE
23 50 193 13.2 1 ONLINE
24 37 153 18.7 0 NONE
25 39 152 15.0 3 GROUP
26 43 170 14.7 4 GROUP
27 44 192 14.6 1 GROUP
28 45 165 16.4 3 ONLINE
29 40 150 15.3 3 GROUP
30 43 174 15.6 2 ONLINE
31 42 168 15.0 0 ONLINE
32 48 178 15.1 3 ONLINE
33 44 164 16.5 3 GROUP
34 51 191 11.8 2 ONLINE
35 37 139 14.4 0 NONE
36 37 138 17.7 1 NONE
37 46 171 15.9 5 ONLINE
38 44 170 11.2 0 ONLINE
39 41 153 18.0 3 GROUP
40 42 154 15.1 2 GROUP
41 40 144 14.0 3 NONE
42 37 134 16.9 2 NONE
43 47 177 17.2 0 ONLINE
44 39 157 14.5 4 NONE
45 40 134 20.2 3 GROUP
46 37 131 18.3 1 GROUP
47 35 129 18.4 4 NONE
48 44 183 15.1 4 ONLINE
49 43 169 14.0 5 GROUP
50 42 155 16.0 2 ONLINE
51 48 182 12.8 2 ONLINE
52 37 143 12.0 1 NONE
53 41 157 13.5 1 ONLINE
54 43 167 14.8 3 ONLINE
55 40 142 15.8 2 NONE
56 42 168 12.1 2 GROUP
57 43 175 14.8 2 GROUP
58 39 150 18.0 2 GROUP
59 41 155 17.9 1 GROUP
60 46 163 16.6 2 ONLINE
61 40 162 13.6 4 GROUP
62 44 189 14.1 3 ONLINE
63 44 153 20.9 2 ONLINE
64 41 158 13.4 3 ONLINE
65 43 160 11.2 4 ONLINE
66 46 173 12.1 1 ONLINE
67 43 178 18.3 2 GROUP
68 47 189 13.1 1 ONLINE
69 49 184 11.4 4 ONLINE
70 45 174 14.0 2 ONLINE
71 48 188 14.6 0 ONLINE
72 37 149 15.8 1 GROUP
73 40 159 14.6 2 GROUP
74 44 160 14.8 2 ONLINE
75 41 166 17.4 1 GROUP
76 52 178 14.9 1 ONLINE
77 49 178 12.0 2 ONLINE
78 48 176 13.3 1 ONLINE
79 39 143 15.5 2 NONE
80 41 159 18.8 2 ONLINE
81 38 149 14.7 2 NONE
82 40 151 16.6 2 GROUP
83 48 186 13.1 1 ONLINE
84 47 194 13.1 2 ONLINE
85 38 152 14.2 4 GROUP
86 38 146 19.7 2 NONE
87 45 188 10.0 2 ONLINE
88 39 139 19.3 3 GROUP
89 49 201 12.5 1 ONLINE
90 41 156 11.8 3 GROUP
91 36 132 19.5 2 NONE
92 42 161 16.3 3 ONLINE
93 41 152 14.6 1 ONLINE
94 45 178 16.4 2 ONLINE
95 38 157 16.4 3 GROUP
96 41 154 14.3 1 GROUP
97 44 156 21.6 0 ONLINE
98 44 170 12.5 1 ONLINE
99 44 170 15.8 0 ONLINE
100 37 146 17.7 3 NONE