Question

A student wants to see if the weight of a paperback book and the number of pages in the book are related. She guesses that the weight of the book will be a predictor of the number of pages it has. She randomly sampled 14 books from the library, test her claim at a 0.05 level of significance.

weight in ounces	number of pages
18	99
12	49
8	102
47	143
20	84
3	54
33	113
9	43
30	88
21	43
29	53
23	103
40	129
22	57

The correlation coefficient:

r= (round to 3 decimal places)

The equation y=a+bx is: (round to 3 decimal places)

y=____+ ____x

The hypotheses are:

H0:ρ=0H0:ρ=0 (no linear relationship)
HA:ρ≠0HA:ρ≠0 (linear relationship) (claim)

Since αα is 0.05 the critical value is -2.179 and 2.179

The test value is:  (round to 3 decimal places)

The p-value is:  (round to 3 decimal places)

Answer 1

how to do regression analysis in excel:

On the Data tab, in the Analysis group, click the Data Analysis button.

Select Regression and click OK.

enter the x and y data.

excel output for the regression analysis for the data given below.

from the output we get

correlation coefficient=0.671

equation is y=1.67x+0.251

test statistic is 3.132

p-value is 0.00865

Since p value <0.05, we reject the null hypothesis.