Problem 4 [25 points]: A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is different than $820 at 0.02 level of significance?   This Problem Description applies to all the Questions 1 through 25 below. Note: To make it convenient for you, I have copied this problem description into the questions below wherever you need it. That way you can limit scrolling up-and-down and it will save time for you.   You will earn these points ONLY  if I see you actually (and NOT pretend to) work on this problem in EXCEL in your Honorlock recording and your answers for the questions match with your answers with Excel functions in your Excel file. If I don’t see you work in Excel (wherever relevant) in the Honorlock recording, you will earn Zero points.

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is different than $820 at 0.02 level of significance? Which one of the following Excel functions can be used to compute the p-value?  For now, ignore the input values to the function and any adjustments to be made to the formula in this question. Just pick a formula from among the ones listed.

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is different than $820 at 0.02 level of significance? Based on the given problem description, it is safe to assume that the shape of the population distribution is ________________.

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is different than $820 at 0.02 level of significance? What is the appropriate Alternative Hypothesis (Ha) for this problem?

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is different than $820 at 0.02 level of significance? Are your decisions under the p-value, Critical-value, and Confidence Interval approaches to this Hypothesis Test, the same or different?  

A study was conducted to understand how American college students manage their finances. Each person in a representative sample of 600 college students was asked if they had one or more credit cards. If so, whether they paid their balance in full each month. There were 400 who did not pay balance in full each month. For this sample of 400 students, the sample mean credit card balance was reported to be $850. For purposes of this exercise, assume population standard deviation is $250. Is there convincing evidence that college students who do not pay their credit card balance in full each month have a mean balance that is different than $820 at 0.02 level of significance? Based on the problem description, the problem is a ________________.

43. BONUS! (1pt.) It’s been a AMAZING semester! I hope you learned TONS of biology even while being online! Have a great rest of your winter break and I wish you the best moving forward! =) To earn 2pts. EXTRA CREDIT, please tell me a “helpful tip” that I can relay to the incoming FALL 2026 BSC1010c students, on how to be successful in this course!   Thank you! =)

Download the exam and either print it or copy the problems down on paper. After you finish the exam, upload your work to a separate assignment “Exam 3 upload”. This should happen within 10 minutes after ending the Honorlock session. Exam 3  

Write a true statement using the frequency table above in terms of: sample size, portion of faculty with tattoos versus those without, portion of faculty with less than 2 tattoos, and mean number of faculty with tattoos. (2pts)

What is the equation of the line that goes through the points (-3, 5) and (2, 10)?