Question

THANKSGIVING SPECIAL!!! For this applied assignment we will be looking at the number of turkeys and bottles of wine sold each November, comparing the American northeast (i.e., our sample) to the total American averages (i.e., the population).

Every Thanksgiving, an average of 960,000 turkeys and 90,000 bottles of wine are sold per state. Importantly, the population variance/standard deviation is not known. Below is the number of turkeys and bottles of wine sold in each of the ten northeast states.

State	# of Turkeys	# Bottles of Wine
Maine	199,700	45,900
Vermont	93,800	25,500
New Hampshire	200,200	60,000
Massachusetts	1,020,100	294,250
Rhode Island	200,000	74,000
Connecticut	525,100	111,250
New York	2,962,500	780,600
Pennsylvania	1,920,200	480,000
New Jersey	1,341,600	355,400
Delaware	142,500	105,500

1. What is the strength and direction of the relationship between the number of turkeys and bottles of wine sold in the American northwest?
2. What is r-crit and r-obt for the hypothesis test stated in question #1? Is the hypothesis test significant or insignificant? Would you reject or fail to reject the null hypothesis assuming an alpha-level of 0.05?
3. If you were to use this relationship (and linear regression) to predict how many bottles of wine will be sold in a northeast state in 2018 given the number of turkeys sold in that state, how much more accurate would you be (in percent) compared to if you did not use the relationship to make this prediction (round to two decimal places)?

Answer 1

using excel>data >data analysis>regression

we have

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.994384
R Square	0.988799
Adjusted R Square	0.987399
Standard Error	27596.82
Observations	10
ANOVA
	df	SS	MS	F	Significance F
Regression	1	5.38E+11	5.38E+11	706.2471	4.32E-09
Residual	8	6.09E+09	7.62E+08
Total	9	5.44E+11
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	14472.83	11996.82	1.206388	0.26213	-13191.9	42137.55
# of Turkeys	0.254212	0.009566	26.57531	4.32E-09	0.232153	0.276271

1. the value of cofrrelation coefficient 0.99454

So there is strong and positive relationship between the number of turkeys and bottles of wine sold in the American northwest.

1. the is r-crit is 0.576 and r-obt is 0.9945 for the hypothesis test stated in question #1.

the hypothesis test is significant. we reject the null hypothesis assuming an alpha-level of 0.05.

1. If you were to use this relationship (and linear regression) to predict how many bottles of wine will be sold in a northeast state in 2018 given the number of turkeys sold in that state, 98.88% accurate would you be compared to if you did not use the relationship to make this prediction .