excel assignment help

profileaxxxd.gh
444.xlsx

Question 1

Quiz 4 Due October 22, 2020 Question 1
A surveey of 750 likely voters in Ohio was conducted by the Rasmussen Poll just prior to the general
election. The state of the economy was thought to be an important determinant of how people would
vote. Among other things, the survey found that 165 of the respondants rated the economy as good
or excellent and 315 rated the economy as poor
Develop a point extimate of the proportion of likely voters in Ohio who rated the economy as good
or excellent.
Construct a 95% confidence interval of the proportion of likely voters in Ohio who rated the economy
as good or excellent.
Construct a 95% confidence interval of the proportion of likely voters in Ohio who rated the economy
as poor.

Question 2

Quiz 4 Question 2
Milage tests are conducted for a particular model of automobile. If 98% coonfidence interval with a margin of error
of 1 mile per gallon is desired, how many automobiles should be used in the test? Assume that the preliminary
milage tests indicate the standard deviation is 2.6 miles per gallon.