Question

The table below shows math and verbal SAT scores for six freshman.

SAT Scores

Verbal	428	386	653	316	438	323
Math	373	571	686	319	607	440

Verify there is a significant correlation at 10% significance using Math score and the dependent variable and Verbal score as the independent variable. Be sure to include your test, sample correlation coefficient, p- value, decision rule and conclusion.

Write your prediction equation.

Predict the following math scores (if any are not valid, explain why)
Verbal of 428
Verbal of 150
Verbal of 1500

Interpret your r-squared. What are at least 3 potential lurkers?

please show all work and round to the fourth on all answers! I'm super lost on this one

Answer 1

Solution

sample correlation =0.749653

Write your prediction equation.

we will solve it by using excel and the steps are

Enter the Data into excel

Click on Data tab

Click on Data Analysis

Select Regression

Select input Y Range as Range of dependent variable.

Select Input X Range as Range of independent variable

click on labels if your selecting data with labels

click on ok.

So this is the output of Regression in Excel.

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.7497
R Square	0.5620
Adjusted R Square	0.4525
Standard Error	106.4979
Observations	6.0000
ANOVA
	df	SS	MS	F	Significance F
Regression	1.0000	58206.1035	58206.1035	5.1320	0.0862
Residual	4.0000	45367.2298	11341.8075
Total	5.0000	103573.3333
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	128.1812	169.5065	0.7562	0.4916	-342.4444	598.8069
Verbal	0.8754	0.3864	2.2654	0.0862	-0.1975	1.9482

prediction equation

Math score = 128.1812+0.8754*Verbal

Predict the following math scores (if any are not valid, explain why)
Verbal of 428

Math score = 128.1812+0.8754*Verbal

Math score = 128.1812+0.8754*428

Math score = 502.8524

Verbal of 150

Math score = 128.1812+0.8754*Verbal

Math score = 128.1812+0.8754*150

Math score = 259.4912

Verbal of 1500

Math score = 128.1812+0.8754*Verbal

Math score = 128.1812+0.8754*1500

Math score = 1441.2812

This point may be outlier

Interpret your r-squared.

56.20% variation explained by Verbal variable in model.