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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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.

Ask a Question
ADVERTISEMENT