1. Your company is developing a new radio communication system. Weight, power output, and frequency have each been identified by your engineering and productions staffs as being potential significant contributors to the production cost of a radio communication system. The following relationships between cost and these parameters have been hypothesized:

Cost will increase with increased radio weight.
Cost will increase with increased power output.
Cost will increase with increased frequency.

2. Your company collected first unit cost, weight, power output, and frequency data for fifteen radio communication systems that your company has previously manufactured. Your department head had a young summer intern who is familiar with performing linear regression using Microsoft Excel perform the following univariate and multivariate regressions using a 95% confidence interval.

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

3. The regression statistics developed by the intern are summarized in the accompanying Microsoft Excel spreadsheet entitled â??Radio Communication System Regression Statisticsâ?. However, the intern is not confident that he understands how to correctly interpret the regression statistics he has generated. Your department head is aware of your recently acquired expertise regarding interpreting linear regression statistics and has tasked you to analyze the regression statistics generated by the intern and answer the following:

4. Identify each of the following as either being a dependent variable, an independent variable, or not a variable.

a) Weight
b) Power
c) Cost
d) Frequency
e) System

5. Which of the following regression models fails to satisfy the common sense test criteria regarding the hypothesized correlation between the dependent variable and independent variable? (select all that apply)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) All of the above
e) None of the above

6. Which of the following regression models fails to satisfy the common sense test criteria regarding the statistical significance of the model as a whole? (select all that apply)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

7.  Which of the following regression models fails to satisfy the common sense test criteria regarding the statistical significance of the strength of the relationship between the dependent variable and the independent variable(s)? (select all that apply)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

8. Which of the following models evidences the least probability of the observed R2 or Adjusted R2 values for the linear regression model being attributable to random chance as opposed to being attributable to an actual linear relationship existing between the dependent and independent variable(s)? (select one)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

9. Which of the following regression models explain less than 50% of the observed variation between the actual values of the dependent variable and the mean value of the dependent variable values for the sample data set? (select all that apply)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency
h) None of the above

11) Which of the following regression models would result in the largest degree of error on average when using the model to predict the first unit cost for a new communication system? (select one)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

12) Which of the following regression models satisfy the requirement for the F-significance value associated with the model being less than or equal to the specified 0.05 statistical significance criterion? (select all that apply)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency
h) All of the above

13) Which of the following regression models satisfy the requirement for the p-value associated with each independent variable associated with the model being less than or equal to the specified 0.05 statistical significance criterion? (select all that apply)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

14) Which of the following regression models evidences the strongest relationship between the dependent variable and the independent variable(s)? (select one)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

15) Which of the following regression models is the preferred regression model? (select one)

a) Cost vs. Weight
b) Cost vs. Power
c) Cost vs. Frequency
d) Cost vs. Weight and Power
e) Cost vs. Weight and Frequency
f) Cost vs. Power and Frequency
g) Cost vs. Weight, Power and Frequency

Attachment:- Radio Communication System Regression Statistics.xls