A. Reject the null hypothesis; conclude Office XP is faster.*B. Fail to reject the null hypothesis; conclude Office XP is faster.C. Fail to reject the null hypothesis; conclude there is insufficient evidence for Office XP being faster.D. Reject the null hypothesis; conclude Office XP is not faster.E. There is insufficient information to decide whether Office XP is faster.A. Reject the null hypothesis; the true mean is higher this time.*B. Fail to reject the null hypothesis; there is insufficient evidence that true mean is higher this time.C. Reject the null hypothesis; there is insufficient evidence that true mean is higher this time.D. Fail to reject the null hypothesis; the true mean is now 74.E. Fail to reject the null hypothesis; the true mean is higher this time.A. 74.79 *B. 1.22C. 33.68D. 1.632E. 4.99A. The independent variables do not explain MPG.B. The dependent variables do not explain MPG.C. The independent variables explain MPG. *D. The independent variables have the same coefficients.E. Inconclusive since the group of variables appears to be homogeneous.B. The gas mileage is expected to increase by 3.82 MPG.C. The gas mileage is expected to decrease by 2.37 MPG.D. The gas mileage is expected to increase by 2.37 MPG.E. The gas mileage is expected to remain the same, at 33.76 MPG.B. The SUV is expected to yield 2.37 less miles per gallon of gas.*C. The sedan is expected to yield 33.76 MPG and the SUV 31.39 MPG.D. Both are expected to yield 33.76 miles per gallon of gas.E. The gas mileage of the SUV is expected to be lower by 3.90 MPG.A. There is no way to tell based on this output.B. 16.71%C. 91.27%D. 82.18%E. 83.29% *A. 22.3B. 19.2C. 19.9D. 21.5 *E. 33.8COURSE: MSCI 3710 Print Name:Final Exam Signature:Version B S.S.#:Fall 2002 Seat Number:Note: Whenever question(s) are connected you may be asked to assume a result (given a value) from the previous question but this result may or may not be correct. This is to prevent you from losing points on a second question because you made a mistake on a previous question.Instructions: Please print your name, social security number, and seat number on this exam. Also, put your signature on this exam. On your scantron PRINT your name, your version, and your seat number. To better protect your privacy also print your name on the back side of your scantron. You have 105 minutes to complete this exam. The exam is open book, open notes, and open mind. You may use any type of calculator but please show all your work on the exam and mark all answers on the scantron. Many of the questions follow the format of those in Adventures in Business Statistics. The remaining questions are either based on the Excel assignment or use an Adventures-like approach with problems nearly identical to those assigned in the textbook.  When you have completed the exam, please insert your scantron into the exam booklet and turn them into your instructor. No cheating. Good luck and we wish you well on the exam.1Use the information given in the following paragraph to answer the next three questions. (Kvanli Chapter 9)In May 2001, American Institutes for Research conducted a comparative evaluation of two applications, Office XP and Office 2000 and made the results publicly available. During the study, a group of users was confronted with 11 tasks and their completion times (in minutes) were recorded. The tables below present the average completion times for each of the 11 tasks and their statistical analysis. Is it true that completion times using Office XP were shorter?TaskOfficeXPOffice20001: Combine PowerPoint slides 02:30 03:002: Diagram in PowerPoint 01:00 04:173: Design template in PowerPoint 00:31 01:354: Another design template in PowerPoint 00:21 01:185: Fix formulas in Excel 04:22 04:536: Paste an Excel table into Word 00:50 03:427: Import Web info into Excel 01:08 07:318: Appointment reminders in Outlook 00:07 00:159: AutoCorrect options in Word 04:22 06:0510: Headings formatting in Word 03:20 04:2811: Merge info from e-mail into Word 01:35 06:38t-Test: Paired Two Sample for Means OfficeXPOffice2000Mean 01:50 03:58Variance 2.4657 5.2995Observations 11 11Pearson Correlation 0.5011Hypothesized Mean Difference 0df ------t Stat -3.4962P(T<=t) one-tail 0.0028t Critical one-tail 2.7638P(T<=t) two-tail 0.0057t Critical two-tail 3.1693 21. What are the decision and conclusion using a dependent samples t-test if the test is conducted at the 5% significance level?A. Reject the null hypothesis; conclude Office XP is faster.*B. Fail to reject the null hypothesis; conclude Office XP is faster.C. Fail to reject the null hypothesis; conclude there is insufficient evidence for Office XPbeing faster.D. Reject the null hypothesis; conclude Office XP is not faster.E. There is insufficient information to decide whether Office XP is faster.2. How many degrees of freedom do we have in the distribution of the test statistic?A. 22 B. 21 C. 11 D. 20 E. 10 *3. What is the critical value of the test statistic for this test if the test is conducted at the 1% significance level?A. 3.17 B. 2.76 * C. -3.50 D. 2.47 E. 5.303Use the information given in the paragraph below to answer the next five questions. (Kvanli Chapter 8)The historical mean score on MSCI 3710 mid-term exams is known to be 73 with a standard deviation of 16. The sample of 400 current mid-term exams gave a mean of 74. Do we have reason to believe that the true mean mid-term score is higher this time? Conduct the appropriate hypothesis test, at the 5% significance level.4. What are the null hypothesis and alternative hypothesis for this test?A. Ho:  = 73 vs. Ha:  ≠ 73B. Ho:  > 73 vs. Ha:  < 73C. Ho:  = 74 vs. Ha:  ≠ 74D. Ho:  < 74 vs. Ha:  > 74E. Ho:  < 73 vs. Ha:  > 73 *5. What is the test statistic to be used in this case?A. t B. z * C. X2D. p E. F6. The decision rule is to reject Ho if the computed test statistic is:A. > 2.326B. > 0.125C. > 2.576D. > 1.645 * E. > 1.967. What is the calculated value of the test statistic?A. 1.0 B. –1.25 C. 1.25 * D. –5.0 E. 5.08. Assuming the calculated value of the test statistic is 4.00, what is the conclusion of the test?A. Reject the null hypothesis; the true mean is higher this time.*B. Fail to reject the null hypothesis; there is insufficient evidence that true mean is higher this time.C. Reject the null hypothesis; there is insufficient evidence that true mean is higher this