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

Effects on Number of Parking Tickets

Age	GPA	Number of Tickets
23	44	99
23	44	88
22	44	66
20	44	55
19	33	55
19	22	55
18	22	44
18	22	44
18	22	33

Copy Data

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.

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 ( )There is not enough evidence.

Submit AnswerTry SimilarSkipTutor

Answer 1

applying multiple regression from data analysis tool of excel: (Data-data analysis-regression :choose x and y varaibles):

	df	SS	MS	F	Significance F
Regression	2	3288.1270	1644.0635	26.7500	0.0010
Residual	6	368.7619	61.4603
Total	8	3656.8889
	Coefficients	Standard Error	t Stat	P-value
Intercept	-160.2857	41.0937	-3.9005	0.0080
Age	11.8730	2.7937	4.2500	0.0054
GPA	-0.5238	0.5387	-0.9723	0.3685

since p value for test statistic F is less than 0.05 level ; correct option is:

y^ =-160.286+11.873x1+(-0.524)*x2