Question

E 0.9400279 1800 Presidential Election Electoral Votes 25 B D Population(thousands) Electoral Votes Correlation coefficient 251 9 64 3 163 4 221 4 342 10 423 16 184 6 211 7 589 12 478 12 20 15 State 2 CT 3 DE GA 5 KY 6 MD MA 8 NH 9 NJ 10 NY 11 NC 12 PA 13 RI 14 SC 15 TN 16 VT 17 VA 18 Electoral Votes . 10 . 5 15 4 0 8 0 602 66 346 106 154 808 100 200 700 800 900 300 400 500 600 State Population(thousands) 4 21 • Series1 (346,8), (106,3) Slope= y2-y1/x2-x1 Slope= (3)-(8)/(106)-(346)= 1/48 Regression Line Equation: y=1/48x+19/24

1. Use the regression equation to calculate the number of Electoral votes that a state with a population of 1,000,000 would have. Since our units of population are in thousands, substitute x=1000 into the formula, find the value of y and round to the nearest whole number (since it is measuring electoral votes). Do this in Excel using what you know about Excel formulas.

2. Is this meaningful as a state population? Why or why not?

3. Discuss, briefly, what the value of the correlation coefficient (and the scatter plot) reveals about the relationship between population and electoral votes. (in other words, is it a strong or weak correlation, and why?)

4. Many states did not exist in 1800. Find three states which had no electoral votes in 1800 and write down the first presidential election in which they voted. (You will probably need to look this up on the internet)

Answer 1

1. y = 1/48x + 19/24

Now, x = 1000 and as it is in thousands

so, y = 1000/48 + 19/24= 12.625 electoral votes

In excel:

=A2/48+19/24

where A2 = 1000 (x)

2. Yes, it is meaningful because higher the population , higher should be the no. of votes or electoral votes that one can cast and to add to that coefficient of x is positive and from scatter plot, we see upward positive relationship.

For a 1000 people in population , there are 1000/48 = 20.83 votes.

3. Correlation = 0.94 (very high i.e, close to 1 , strong , positive) and this relationship is represented by scatterplot as the line is upward and straight line.

4. I have no idea about your country you can just google the stated that got established after 1800 (any 3) and google them seperately once you know the names and I am sure wikipedia page will tell u the first presidential election time period.

Please rate my answer and comment for doubt.