Question
(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0"...
(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required.) Picture Click here for the Excel Data File College Student Weekly Earnings in Dollars (n = 5) Hours Worked (X) Weekly Pay (Y) (xi−x¯)2 (yi−y¯)2 (xi−x¯)(yi−y¯) 10 93 100 7056 840 15 171 25 36 30 20 204 0 729 0 20 156 0 441 0 35 261 225 7056 1260 20 177 350 15318 2130 x¯ y¯ SSXX SSyy SSxy (b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (Round your answer to 4 decimal places.) r (c) Find t.025 for a two-tailed test for zero correlation at α=.05. (Round your answer to 3 decimal places.) t.025 ± (d-1) Calculate the t test statistic.(Round your answer to 3 decimal places.) tcalc (d-2) Should we reject the null hypothesis of zero correlation? Yes No (e) Use Excel's function =T.DIST.2T(t,deg_freedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.) p-value
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
The following information was calculated for a least squares regression analysis: n = 20, SSxy =...
The following information was calculated for a least squares
regression analysis: n = 20, SSxy = 204, SSxx = 100, SSyy = 516,
β1-hat = 2.04, β0-hat = 3.12, and SSE = 99.84. Preform a hypothesis
test to see if X contributes information to Y using alpha =
0.05.
a) What is the value of your test statistic? (Round your final
answer to three decimal places)
Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter...
Solve the following problem with Excel Solver: (Leave no
cells blank - be certain to enter "0" wherever required. Do not
round intermediate calculations. Round your answers to 2 decimal
places.)
Maximize
Z
=
2X + 4Y.
6X +
17Y
?
76
Resource A
2X +
3Y
?
20
Resource B
Y
?
18
Resource C
Decision for
X
Decision for
Y
Total profit
$
Resources
Used
Resource A
Resource B
Resource C...
(b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal...
(b)
Use the formulas to calculate the slope and intercept.
(Round your answers to 3 decimal places.)
b1
6.02
b0
55.178
(c)
Use your estimated slope and intercept to make a worksheet to
calculate SSE, SSR, and SST.
(Leave no cells blank - be certain to
enter "0" wherever required. Negative values should be indicated by
a minus sign. Do not round intermediate calculations, but final
answers should be rounded to 3 decimal places.)
Hours Worked
(xi)
Weekly...
Below shows a sample of 5 pairs of data: x y 5 3 1 4 3...
Below shows a sample of 5 pairs of data:
x
y
5
3
1
4
3
5
8
6
3
1
The following are some summaries of the data:
∑ni=1xi=20,∑ni=1yi=19,∑ni=1(xi−x¯)=0,∑ni=1(yi−y¯)=0,∑i=1nxi=20,∑i=1nyi=19,∑i=1n(xi−x¯)=0,∑i=1n(yi−y¯)=0,
∑ni=1(xi−x¯)2=28,∑ni=1(yi−y¯)2=14.8,∑ni=1(xi−x¯)(yi−y¯)=9.∑i=1n(xi−x¯)2=28,∑i=1n(yi−y¯)2=14.8,∑i=1n(xi−x¯)(yi−y¯)=9.
Calculate the regression line. Provide an interpretation of the
intercept and slope coefficient. Round your answer to 4
decimal points.
a. Fill in the missing values in the table. (Leave no cells blank - be certain...
a. Fill in the missing values in the table.
(Leave no cells blank - be certain to enter 0 wherever
required. Do not round intermediate calculations and round your
answers to 2 decimal places, e.g., 32.16.)
Security
Expected Return
Standard Deviation
Correlation*
Beta
Firm A
.102
.39
.77
Firm B
.148
.58
1.32
Firm C
.168
.57
.43
The market portfolio
.12
.20
The risk-free asset
.05
Below is a regression using X = average price, Y = units sold, n = 20...
Below is a regression using
X = average price, Y = units sold, n =
20 stores.
R2
0.200
Std. Error
26.128
n
20
ANOVA
table
Source
SS
df
MS
F
p-value
Regression
3,080.89
1
3,080.89
4.51
.0478
Residual
12,288.31
18
682.68
Total
15,369.20
19
Regression output
confidence
interval
variables
coefficients
std.
error
t
(df = 18)
p-value
95% lower
95% upper
Intercept
614.9300
51.2343
12.002
.0000
...
Given are data for two variables, x and y. xi 6 11 15 18 20 yi...
Given are data for two variables, x and y.
xi
6
11
15
18
20
yi
7
7
13
21
30
(a)
Develop an estimated regression equation for these data. (Round
your numerical values to two decimal places.)
ŷ =
(b)Compute the residuals. (Round your answers to two decimal
places.)
xi
yi
Residuals
6
7
11
7
15
13
18
21
20
30
(c)Compute the standardized residuals. (Round your answers to
two decimal places.)
xi
yi
Standardized
Residuals
6
7...
1. The owner of a movie theater company would like to predict weekly gross revenue as...
1. The owner of a movie theater company would like to predict
weekly gross revenue as a function of advertising expenditures.
Historical data for a sample of eight weeks follow.
Weekly
Gross
Revenue
($1,000s)
Television
Advertising
($1,000s)
Newspaper
Advertising
($1,000s)
96
5
1.5
91
2
2
95
4
1.5
93
2.5
2.5
95
3
3.3
94
3.5
2.2
94
2.5
4.1
94
3
2.5
(a) Use α = 0.01 to test the hypotheses
H0:
β1 = β2 = 0
Ha:...
Consider the data. xi 2 6 9 13 20 yi 7 18 10 26 25 (a)...
Consider the data.
xi
2
6
9
13
20
yi
7
18
10
26
25
(a)
What is the value of the standard error of the estimate? (Round
your answer to three decimal places.)
(b)
Test for a significant relationship by using the t
test. Use α = 0.05.
State the null and alternative hypotheses.
H0: β0 = 0
Ha: β0 ≠
0H0: β1 ≥ 0
Ha: β1 <
0 H0:
β1 ≠ 0
Ha: β1 =
0H0: β0 ≠ 0...
Imagine a dataset where for every value of x, y is given by -2x. Calculate the...
Imagine a dataset where for every value of x, y is given by -2x.
Calculate the correlation between x and y. Round your answer to 3
decimal places
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 25 minutes ago
asked 25 minutes ago
asked 35 minutes ago
asked 37 minutes ago
asked 42 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago