A tick feeds on the blood of a deer.

4p) What is the correct value of Adjusted Multiple Coefficient of Determination (rounded to 4 digits after the decimal) in this problem?

4n) Revise the model and generate the revised regression report (round all the numbers to 4 digits after decimal using Increase/Decrease Decimal option), and Copy-Paste the revised report in the box under this question. Visually conduct all the Hypothesis tests at 0.03 level of significance. No need to type in all the details of the hypothesis tests. Simply type in your conclusion based on your Hypothesis Test in a single sentence.  [5 points].  

Problem 4 Description: [10 + 23 = 33 points] Several universities believe SAT scores as well as their gender may be strong predictors of an incoming student’s potential success as freshman measured by their GPA, and they use these scores in making university admission decisions. The critical reading and mathematics components of the SAT are reported on a scale from 200 to 800. A state university collected the following data for a sample of students who recently completed their freshman year.  Perform appropriate analysis on the following data at 0.03 level of significance and answer the following questions.   Student Gender Reading Math Freshman GPA 1 Female 610 680 2.98 2 Female 700 610 3.31 3 Male 720 610 3.43 4 Male 660 590 2.68 5 Male 780 520 3.63 6 Female 690 600 2.49 7 Female 740 680 3.68 8 Female 730 750 4.00 9 Male 740 690 3.82 10 Male 740 720 4.00   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.   4a) 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 20) below for another 23 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 through cheating. 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.  

3l) Based on the report, the Correct Confidence Interval one should use to conduct the Hypothesis Test for the Statistical Significance of Linear Regression at 0.02 level is:

3e) The SAMPLE SIZE in this Problem is:

2g) What is the desired Type-I error value in this problem?

3d) The DEPENDENT VARIABLE in this Problem is:

Biology ROCKS!

Problem 2 Description [10 + 24 = 34 points]: The accompanying data resulted from a fabric flammability study. Four randomly selected specimens from three different fabrics were tested to determine their burn times. Perform appropriate analysis to determine which Fabric gives the best performance at 0.04 level of significance. Specimen Fabric 1 Fabric 2 Fabric 3 1 17.8 11.8 13.9 2 16.2 11 10.8 3 15.9 9.2 12.8 4 15.5 10 11.7                   2a) Copy-Paste your Excel Report in the box under this question. [10 points].   Answer the following questions (Questions 2 through 14) for the remaining 24 points.   Attaching an Excel report/file alone is not sufficient to earn all the points. You must demonstrate your understanding and ability for utilizing the report to answer specfic questions below to earn points.   You will earn these points ONLY  if I see you actually work (and NOT pretend to work) in EXCEL in your Honorlock recording and your answers for the questions match with your answers with your Excel report. If I do not see you work in Excel and if I do not see you use Excel functions and formulas (wherever relevant) in the Honorlock recording OR your answers in Excel and the Exam do not match, you will earn Zero points.