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 (x1x1) is the number of hours spent studying, and the second independent variable (x2x2) is the student's GPA.

Effects on ACT Scores

Study Hours	GPA	ACT Score
22	22	1717
33	22	1818
33	22	1818
55	22	2121
55	44	2727

Copy Data

Step 1 of 2 :  

Find the p-value for the regression equation that fits the given data. Round your answer to four decimal places.

What variables did you put in the x an y input cells?

Answer 1

We have to find the p-value for the regression equation that fits the given data.

We calculate the above p-value for the regression equation using Excel function "Data Analysis"

We put variables in the x an y input cells is as below

x1 = Study Hours

x2 = GPA

y = ACT Score

We write the above 3 variables y, x1 and x2 in Excel Spreadsheet is as below

y	x1	x2
1717	22	22
1818	33	22
1818	33	22
2121	55	22
2727	55	44

Then using Regression command in Data Analysis and then select input y Range and input x Range as (x1,x2) variable at a time. then output of ANOVA becomes is as below.

ANOVA

				F	Significance F
Regression	Regression	Regression	Regression	633.6	0.001575796
Residual	Residual	Residual	Residual
Total	4	681426.8

Here,the p-value for the regression equation that fits the given data is in last column that is Significance F

p-value = 0.001575796 0.0016 (Round answer up to four decimal places)

p-value = 0.0016

The p-value for the regression equation that fits the given data is 0.0016

Summary :-

The p-value for the regression equation that fits the given data is 0.0016

We put variables in the x an y input cells is

x1 = Study Hours

x2 = GPA

y = ACT Score