3g) The estimated linear regression equation (with numbers rounded to 4 digits after decimal) between the variables is:

3c) The INDEPENDENT  VARIABLE/S in Problem is/are:

2j) Type in the Excel function along with inputs you can use to calculate the critical-value (at a 0.04 level of significance) in the box below. [1 point] Type in the critical-value that you would use for conducting the Hypothesis Test in this problem in the box below. [1 point]   Note: You become eligible to earn these points ONLY if you answer all the questions asked.

Problem 3 Description: [10 + 21 = 31 points] The regional transit authority of a southern city believes it can predict Annual Maintenance Cost it incurs for the buses it runs based on their length of service. The city collected the following sample data randomly. Perform an appropriate analysis on the following data at 0.02 level of significance and answer the following questions.   Bus Number Years in Service Annual Maintenance Cost ($1000s) 1 5 15.8 2 4 19.0 3 4 16.0 4 3 15.0 5 3 11.0 6 2 9.6 7 2 11.8 8 2 10.4 9 1 7.0 10 1 7.4   Note: You should be able to copy-paste the above table into an Excel worksheet. If you have any issues, type the numbers into the sheet yourself and perform the analysis.   3a) Generate report in Excel (round all the numbers to 4 digits after decimal using Increase/Decrease Decimal option) and Copy-Paste Excel Report in the box under this question. [10 points]. Your Honorlock recording must show you generate this report for you to earn points.   After generating the report, answer the following questions (Questions 2 through 21) below for another 21 points.   There is NO way to answer a lot of questions without generating Excel report. If anyone answers all the questions and generates report in the end, that can only happen if they cheated. Action will be taken against such students for academic integrity violation.   Note: You must answer all the questions below to earn points. Attaching an Excel report/file is not sufficient to earn points. To earn points, you must demonstrate your understanding for the topic and ability to answer specfic questions with the help of your analysis/report.   WARNING: Do not violate academic integrity ONLY ONE SYSTEM IS ALLOWED FOR THE EXAM. Any allowed resource on Canvas you use for the exam must be visible in your Honorlock recording. Using a second computer or other gadgets is a violation of Academic Integrity. I must see you working in Excel and answering questions in your Honorlock recording. If I don’t see you working using Excel functions and formulas in Excel in your Honorlock recording, that would be an academic integrity violation, and ZERO POINTS will be recorded as your grade. All academic integrity violations will be reported to USF for further disciplinary action, that could be receiving an “F” grade for the course to other severe actions such as dismissal from the program, … etc. So, please follow instructions and maintain academic integrity.  

3h) The correct Null Hypotheses to test for the statistical significance of Linear Regression between the variables in this problem is:

3q) What is the sample correlation coefficient (rounded to 4 digits after the decimal) between the two variables: Years in Service and Annual Maintenance Cost ($1000s)

Barnacles attach to a whale and gain transportation, while the whale is unaffected.

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 greater than $820 at 0.02 level of significance? 1n) What is the numerical value of the “Test Statistic” in this problem (approximated to two digits after the decimal)?

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 greater than $820 at 0.02 level of significance? 1u) What is the 98% Confidence Interval on Mu (rounded to two digits after the decimal) for this problem based on the information provided?  

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 greater than $820 at 0.02 level of significance? 1c) What does the parameter “Mu” stands for in this Hypothesis Testing problem?