# Question

College Students Weekly Earnings in Dollars (n = 5)

(a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y?

(b) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. Use these sums to calculate the sample correlation coefficient. Check your work by using Excel's function = CORREL (array1,array2).

(c) Use Appendix D to find t.025 for a two-tailed test for zero correlation at α =.05.

(d) Calculate the t test statistic. Can you reject ρ = 0?

(e) Use Excel's function = T.DIST.2T (t,deg_freedom) to calculate the two-tail p-value.

(a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y?

(b) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. Use these sums to calculate the sample correlation coefficient. Check your work by using Excel's function = CORREL (array1,array2).

(c) Use Appendix D to find t.025 for a two-tailed test for zero correlation at α =.05.

(d) Calculate the t test statistic. Can you reject ρ = 0?

(e) Use Excel's function = T.DIST.2T (t,deg_freedom) to calculate the two-tail p-value.

## Answer to relevant Questions

Moviegoer Snack Spending (n = 10) (a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display ...A regression was performed using data on 32 NFL teams in 2003. The variables were Y = current value of team (millions of dollars) and X = total debt held by the team owners (millions of dollars). (a) Write the fitted ...Order Size and Shipping Cost (n = 12) (a) Use Excel's Data Analysis > Regression (or MegaStat or MINITAB) to obtain regression estimates. (b) Interpret the 95 percent confidence interval for the slope. Does it contain ...A sample of 74 Noodles & Company restaurants was used to perform a regression analysis with Y = % Annual Revenue Growth and X = % Revenue Due to Loyalty Card Use. Calculate the leverage statistic for the following three ...(a) Make a histogram (or normal probability plot) of the residuals and discuss its appearance. (b) Do you see evidence that your regression may violate the assumption of normal errors?Post your question

0