Question

The following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1) is the number of hours spent studying, and the second independent variable (x2) is the student's GPA.

Study hours	GPA	ACT score
0	2	17
1	2	19
5	2	28
5	3	29
6	4	31

Find the p-value for the regression equation that fits the given data.

How do i find p value on a ti-84 calc? i dont have excel.

Answer 1

Regression Statistics
Multiple R	0.9991
R Square	0.9982
Adjusted R Square	0.9963
Standard Error	0.3851
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	2	160.50	80.25	541.13	0.0018
Residual	2	0.30	0.15
Total	4	160.80
	Coefficients	Standard Error	t Stat	P-value
Intercept	16.08	0.62	25.81	0.0015
Study hours	2.25	0.10	22.40	0.0020
GPA	0.42	0.30	1.37	0.3040

The p-value for the regression equation is 0.0018

In excel, I have used the Regression function in the Data Analysis option of the Data tab.