Let p represent the proportion of all MATH 1P98 students who feel stressed, meaning they responded either "a little stressed" or "very stressed". a. You should first summarize the survey results in a frequency distribution table. Use Excel to sort or filter the data so that you can get a count for each category. For this question, submit the completed frequency distribution table. (You do not need to include your Excel printout.)

Not very stressed= 76

A little stressed= 226

Very Stressed= 128

b. Find a point estimate for p. Express your answer with three decimal places.

Point estimate

p = 226+128/430

p = 354/430

p = 0.823

c. Check whether np 5 and nq 5. Show your calculations

p = 0.823, q = 1-0.823 = 0.177

np = 430(0.823) = 353.89 5

nq = 430(0.177) = 76.11 5

d. Find a 90% confidence interval for by hand. Express your answer with three decimal places. Show your work, including all calculations.

e. Interpret the 90% confidence interval you obtained in the context of the problem.

f. Find a 95% confidence for interval for using the Excel calculator. Express your answer with three decimal places. Include a printout of your Excel results.

g. Find a 98% confidence interval for using the Excel calculator. Express your answer with three decimal places. Include a printout of your Excel results.

h. Use your 90%, 95%, and 98% confidence intervals to describe what happens to the length of the confidence interval as the level of confidence increases.