Question

The following data was collected to explore how a student's age and GPA affect the number of parking tickets they receive in a given year. The dependent variable is the number of parking tickets, the first independent variable (x1) is the student's age, and the second independent variable (x2) is the student's GPA.

Effects on Number of Parking Tickets

Age	GPA	Number of Tickets
23	3	7
22	3	6
21	2	5
21	2	4
20	2	2
19	2	2
18	2	2
18	2	2
18	2	0

Step 1 of 2 :  

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

Step 2 of 2 :  

Determine if a statistically significant linear relationship exists between the independent and dependent variables at the 0.050.05 level of significance. If the relationship is statistically significant, identify the multiple regression equation that best fits the data, rounding the answers to three decimal places. Otherwise, indicate that there is not enough evidence to show that the relationship is statistically significant

How to enter your answer

Selecting a checkbox will replace the entered answer value(s) with the checkbox value. If the checkbox is not selected, the entered answer is used.

y^=  +____  x1 +___ x2 or There is not enough evidence.

Submit Answer

Answer 1

using excel data analysis tol for regression

excel>menu>data>data analyisis>regression>enter required labels>ok

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.940487
R Square	0.884517
Adjusted R Square	0.846022
Standard Error	0.899101
Observations	9
ANOVA
	df	SS	MS	F	Significance F
Regression	2	37.1497	18.57485	22.97778	0.00154
Residual	6	4.850299	0.808383
Total	8	42
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-18.2635	3.722726	-4.90594	0.002695	-27.3727	-9.15429	-27.3727	-9.15429
Age	0.976048	0.260324	3.749356	0.009517	0.339058	1.613038	0.339058	1.613038
GPA	0.934132	1.104462	0.84578	0.430108	-1.76839	3.636652	-1.76839	3.636652

1)

p-value = 0.0015

2)

since, p-value = 0.0015 <α=0.05, so

there is enough evidence to show that the relationship is statistically significant

Y^ = -18.2635 + 0.9760*X1 + 0.9341*X2