# Question

College Students Weekly Earning in Dollars (n = 5)

(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy (the same worksheet you used in exercises 12.2 and 12.3).

(b) Use the formulas to calculate the slope and intercept.

(c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST.

(d) Use these sums to calculate the R2.

(e) To check your answers, make an Excel scatter plot of X and Y, select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.

(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy (the same worksheet you used in exercises 12.2 and 12.3).

(b) Use the formulas to calculate the slope and intercept.

(c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST.

(d) Use these sums to calculate the R2.

(e) To check your answers, make an Excel scatter plot of X and Y, select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.

## Answer to relevant Questions

Phone Hold Time For concert Tickets in Seconds (n = 5) (a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy (the same worksheet you used in exercises 12.2 and 12.3). (b) Use the formulas to calculate the slope and ...College Students Weekly Earning in Dollars (n = 5) (a) Perform a regression using MegaStat or Excel. (b) State the null and alternative hypotheses for a two-tailed test for a zero slope. (c) Report the p-value and the 95 ...Phone Hold Time for Concert Tickets in Seconds (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 ...An estimated regression for a random sample of vehicles is MPG = 49.22 – 0.081 Horse- power, where MPG is miles per gallon and Horsepower is the engine's horsepower. The standard error is se = 2.03. Suppose an engine has ...Annual Percent Return on Mutual Funds (n = 17) (a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Excel, MegaStat, or MINITAB to calculate the correlation ...Post your question

0