Regression Readout of the Data Analysis Toolpak - Excel: Videos & Practice Problems

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

$\left(A\right)$ Get the regression readout and create a residual plot with the data. Is correlation positive or negative?

• A. Positive
• B. Negative

Answer: (A)

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

$\left(B\right)$ Find $r$.

• A. 0.857
• B. -0.857
• C. 0.735
• D. -0.735

Answer: (A)

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

(C) Find $R^2$.

• A. 0.857
• B. 0.735
• C. 0.926
• D. 0.850

Answer: (B)

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

$\left(D\right)$ Find $s_e$.

• A. 5.61
• B. 2.37
• C. 37.67
• D. 6.14

Answer: (A)

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

$\left(E\right)$ Find the equation for the regression line.

• A. $y=-1.77x+41.82$
• B. $y=1.77x-41.82$
• C. $y=1.77x+41.8$
• D. $y=-1.77x-41.82$

Answer: (C)

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

$\left(F\right)$ Create a 99% CI for the $y$-intercept of the regression line.

• A. (36.9, 46.7)
• B. (1.15, 2.39)
• C. (35.17, 48.47)
• D. (1.31, 2.23)

Answer: (C)

The creators of a program that promises to improve typing speed collect data on the time spent on the program (in hrs) and typing speed (in wpm) of a random sample of 25 users to see if there is linear correlation between the two variables. Use the Data Analysis Toolpak to answer the questions below.

$\left(G\right)$ If you performed a 2-tailed hypothesis test for $\beta$, the slope of the pop. regression line, what would the test statistic be? What would the $P$-value be? Can we conclude that the two variables are linearly correlated?

• A. $t$: 17.7$P$-val: 17.7 × 10^-15Yes
• B. $t$: 17.7$P$-val: 17.7 × 10^-15No
• C. $t$: 7.98$P$-val: 4.43 × 10^-8No
• D. $t$: 7.98$P$-val: 4.43 × 10^-8Yes

Answer: (D)