Question

The Student Government Association at Middle Carolina University wanted to demonstrate the relationship between the number of beers a student drinks and his or her blood alcohol content (BAC). A random sample of 18 students participated in a study in which each participating student was randomly assigned a number of 12-ounce cans of beer to drink. Thirty minutes after they consumed their assigned number of beers, a member of the local sheriff’s office measured their blood alcohol content. The sample information is reported below.

Student	Beers	BAC	Student	Beers	BAC
1	6	0.10	10	3	0.07
2	7	0.09	11	3	0.05
3	7	0.09	12	7	0.08
4	4	0.10	13	1	0.04
5	5	0.10	14	4	0.07
6	3	0.07	15	2	0.06
7	3	0.10	16	7	0.12
8	6	0.12	17	2	0.05
9	6	0.09	18	1	0.02

  Click here for the Excel Data File

1. a-1. Choose a scatter diagram that best fits the data.
   

2.    A.

3. B.

4. C.

   
   

• A

• B

• C

2. Fill in the blanks. (Round your answers to 3 decimal places.)

x¯x¯
y¯y¯
Sx
Sy

1. c-1. Determine the coefficient of correlation and coefficient of determination. (Round your answer to 3 decimal places.)

1. c-2. Compute the value of the test statistic. (Round your answer to 2 decimal places.)

Answer 1

Please do the comment for any doubt or clarification. Please upvote if this helps you out. Thank You!

The given data is:

Beers	BAC
6	0.1
7	0.09
7	0.09
4	0.1
5	0.1
3	0.07
3	0.1
6	0.12
6	0.09
3	0.07
3	0.05
7	0.08
1	0.04
4	0.07
2	0.06
7	0.12
2	0.05
1	0.02

a-1)

1. Fill in the blanks. (Round your answers to 3 decimal places.)

x¯=Using Excel command ("=average(select Beers data)"	4.278
y¯=Using Excel command ("=Average(select BAC data)"	0.0789
Sx= Using Excel command "=stdev(select Beers data)"	2.1367
Sy=Using Excel command "=stdev(select BAC data)"	0.0274

c-1. Determine the coefficient of correlation and coefficient of determination. (Round your answer to 3 decimal places.)

Coefficient of correlation= 0.779

Coefficient of determination=0.607

c-2. Compute the value of the test statistic. (Round your answer to 2 decimal places.)

Test statistic=4.97

For part c-1 and c-2

Steps:

Using Excel<data<data analysis<regression

Regression Analysis
	r²	0.607
	r	0.779
	Std. Error	0.018
	n	18
	k	1
	Dep. Var.	BAC
ANOVA table
Source	SS	df	MS	F	p-value
Regression	0.0078	1	0.0078	24.66	.0001
Residual	0.0050	16	0.0003
Total	0.0128	17
Regression output				confidence interval
variables	coefficients	std. error	t (df=16)	p-value	95% lower	95% upper
Intercept	0.0361	0.01	3.78	0.00	0.02	0.06
Beers	0.0100	0.0020	4.966	.0001	0.0057	0.0143