Instruction 13 ANOVA Note: Adj R Square = Adjusted R Square; Std

question 35

Short Answer

Instruction 13.23
The Head of the Accounting Department wanted to see if she could predict the average grade of students using the number of course units (credits) and total university entrance exam scores of each. She takes a sample of students and generates the following Microsoft Excel output:
OUTPUT
SUMMARY
$\begin{array} { l l } \text { Regression Statistics } & \\ \text { MultipleR } & 0.916 \\ \text { R Square } & 0.839 \\ \text { Adj. R Square } & 0.732 \\ \text { Std. Error } & 0.24685 \\ \text { Observations } & 6 \end{array}$

ANOVA
$\begin{array} { l l l l l l } & d f & \text { SS } & \text { MS } & F & \text { Signiff } \\ \text { Regression } & 2 & 0.95219 & 0.47610 & 7.813 & 0.0646 \\ \text { Residual } & 3 & 0.18281 & 0.06094 & & \\ \text { Total } & 5 & 1.13500 & & & \\ & & & & & \\ & \text { Coeff } & \text { StdError } & t \text { Stat } & p \text { value } & \\ \text { Intercept } & 4.593897 & 1.13374542 & 4.052 & 0.0271 & \\ \text { GDP } & - 0.247270 & 0.06268485 & - 3.945 & 0.0290 & \\ \text { Price } & 0.001443 & 0.00101241 & 1.425 & 0.2494 & \end{array}$ Note: Adj. R Square = Adjusted R Square; Std. Error = Standard Error
-Referring to Instruction 13.23,the Head of Department wants to use a t test to test for the significance of the coefficient of X₁.The value of the test statistic is _____.

---

Definitions:

Barrel Of Oil

A standard measure of crude oil and petroleum products equivalent to 42 U.S. gallons.

U.S. Electricity Generation

U.S. Electricity Generation denotes the process and methods used in the United States to produce electricity, including coal, natural gas, nuclear, and renewable energy sources.

Energy Information Administration

A U.S. Government agency responsible for collecting, analyzing, and disseminating energy information to promote sound policymaking, efficient markets, and public understanding of energy and its interaction with the economy and the environment.

Natural Gas

A fossil fuel formed from the remains of ancient marine organisms, used primarily for heating, cooking, and generating electricity.