Question

STATS QUESTION PLEASE ONLY ANSWER G, H, and I. I have everything else answered
50 Points Total Percentages of public school students in fourth grade in 1996 and in eighth grade in 2000 who were at or above the proficient level in mathematics were given in the article "Mixed Progress In Math” (USA Today, August 3, 2001). The following data for eight Western states were given: State Arizona (AZ) California (CA) Hawaii (HI) Montana (MT) New Mexico (NM) Oregon (OR) Utah (UT) Wyoming (WY) 4th Grade (1996) 15 11 16 22 13 21 23 19 8th Grade (2000) 21 18 16 37 13 32 26 25 a) Construct a scatterplot of the data. Use graph paper. Let each grid line equal exactly one unit. Clearly label your graph with an appropriate title that describes what the data points represent, and label the axes fully descriptively (6 points). Scale the graph appropriately and consistently (3 points). Label all data pairs with the state abbreviations and the percentages as ordered pairs (6 points) (Example: AZ (15,21)). Include the (x,y) point on your graph (2 points). b) (3 points) Use your calculator to find the equation of the least-squares linear regression line that summarizes the relationship between the x = 1996 fourth-grade math proficiency percentage and the y = 2000 eighth-grade math proficiency percentage. Write the regression equation below, in the correct form. Round the regression line coefficients to two decimal places. a y = a +bx ye -3.1368 +1.5221* -3.41152x c) (6 points) Place your least-squares linear regression line on the same graph as your data points. Label the line with the regression equation. Use the anchor points discussed in class. Label the anchor points with the coordinates. The line should be straight (use a straight edge), and positioned correctly relative to the scatterplot points. (0, -3.1368) (013.14) (1,-1.614) (1,-1.61) (21, 28.83) 2 1983)

Answer 1

g.

	B	C	D
	State	4th Grade	8th Grade
3	AZ	15	21
4	CA	11	18
5	HI	16	16
6	MT	22	37
7	NM	13	13
8	OR	21	32
9	UT	23	26
10	WY	19	25

Coefficient (r)	0.822258	=PEARSON(C3:C10,D3:D10)
N	8	=COUNT(D3:D10)
T Statistic	3.539022	=(G3*(SQRT(G4-2))/SQRT(1-G3^2))
DF	6	=G4-2
p-value	0.012233	=T.DIST.2T(G5,G6)

Since p-value is less than 0.05, we reject the Null Hypothesis that there is no correlation between 4th Grade marks and 8th grade marks

h. We can see the correlation coefficient is almost closed to 1. So there is a strong correlation between 4th grade and 8th grade Also from d above, the best guess for Nevada as calculated is 18.17.

i.If we assume correlation is not significant, then the best guess would be 14 as the coeeficient for 4th grade become 0 and only intercept remains.