Excel Question

1. The production of car tires in any given year is related to the number of cars produced
that year and in prior years. Suppose our econometric model resulted in the following
data.
Regression Coefficient t-stat
X1=Cars produced this year 5.00 10.4
X2=Cars produced last year 0.25 0.6
X3=Cars produced 2 years ago 0.67 1.4
X4=Cars produced 3 years ago 2.12 2.7
X5=Cars produced 4 years ago 3.44 6.5
Constant -50,000
Multiple R 0.83
a. Write out the regression equation.
b. Which independent variable has the most significant effect on the production of car
tires?
c. What proportion of the total variation in the production of car tires is accounted for
by the set of independent variables?
2. A multiple regression analysis showed the following ANOVA table result.
Based on the information in the ANOVA,
a. How many independent variables were included in the multiple regression analysis?
b. What is the multiple coefficient of determination expressed as a percent?
c. What is the decision regarding the global null hypothesis, at 0.05 significance level?
3. A sociologist claims that the success of students in college (measured by their GPA) is
related to their family’s income. For a sample of 25 students, the correlation coefficient
is 0.6. Using the 0.01 significance level, can we conclude that there is a positive
correlation between the variables?
4. In a study of several companies going public for the first time, a researcher is
particularly interested in the relationship between the size of the offering and the price
per share. A sample of 15 companies that recently went public revealed the following
information.
IS 601
Company Size ($ millions)
x
Price per Share
y
1 9.0 10.8
2 94.4 11.3
3 27.3 11.2
4 179.2 11.1
5 71.9 11.1
6 97.9 11.2
7 93.5 11.0
8 70.0 10.7
9 160.7 11.3
10 96.5 10.6
11 83.0 10.5
12 23.5 10.3
13 58.7 10.7
14 93.8 11.0
15 34.4 10.8
Use a software to:
a. Determine the regression equation.
b. Conduct a test to determine whether size is a significant variable in describing
the price per share. (use alpha 0.05)
c. Determine the coefficient of determination. Do you think the researcher should
be satisfied with using the size of the offering as the independent variable?
Include a copy of your software analysis.