Question

The popularity of computer, video, online, and virtual reality games has raised concerns about their ability to negatively impact youth. The data in this exercise are based on a recent survey of 14- to 18- year- olds in Connecticut high schools. Suppose the following are the grade distributions of boys who have and have not played video games.

	Grade average
	A's and B's	C's	D's and F's
Played games	719	468	196
Never played games	191	148	72

The null hypothesis "no relationship" says that in the population of all 14- to 18- year-old boys in Connecticut, the proportions who have each grade average are the same for those who play and don't play video games.

Find the expected counts (±±0.01) if this hypothesis is true and display them in a two-way table.

	A's and B's	C's	D's and F's
Played games	???	???	???
Never played games	???	???	???

hint

Expected counts are Eij=(row total)i(column total)/total. Remember, expected values do not have to be values of the variable, so there will be decimal places here!

Answer 1

I have answered the question below using excel and have attached the image below.

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer:

Using the formula

	A's and B's	C's	D's and F's
Played games	719	468	196	1383
Never played games	191	148	72	411
	910	616	268	1794

Expected counts are Eij=(row total)i(column total)/total.

	A's and B's	C's	D's and F's	Sum
Played games	701.52	474.88	206.60	1383
Never played games	208.48	141.12	61.40	411
Sum	910	616	268	1794