StudentID X1 X2 X3 X4 X5 X6 X7 X8 Y 1 6 45 4 2 1 21 4 E 84.34 2 5 48 4 2 2 21 1 E 79.8 3 5 14 4 2 2 21 6 I 87.65 4 6 14 3 1 1 20 4 E 94.68 5 5 10 3 1 1 44 4 I 90.03 6 6 100 3 2 2 21 1 I 82.72 7 5 12 3 2 1 28 6 I 93.09 8 6 30 5 2 2 24 3 E 91.52 9 6 4 3 1 2 21 3 E 81.78 10 6 20 2 2 1 20 2 E 85.19 11 6 150 4 1 2 21 2 E 71.9 12 5 3 3 1 2 23 4 I 91.22 13 4 5 3 2 1 20 2 E 62.84 14 3 20 5 1 1 24 3 I 91.68 15 5 22 3 1 1 21 4 E 76.65 16 5 100 3 2 2 20 2 E 79.9 17 6 20 3 2 1 20 2 E 81.07 18 6 15 4 2 1 24 4 E 73.73 19 4 100 3 1 1 21 2 E 73.83 20 5 150 3 1 1 20 2 E 64.53 21 6 24 4 2 1 21 2 E 81.84 22 6 10 4 1 1 21 2 E 76.41 23 4 10 3 1 1 28 2 E 77.51 24 5 15 4 2 2 21 2 E 92.72 25 5 10 3 1 2 21 6 E 89.74 26 5 15 3 1 1 31 4 E 75.89 27 4 30 4 1 2 23 2 E 80.76 28 6 4 3 1 1 21 4 I 89.51 29 5 70 3 2 1 22 2 E 68.36 30 6 30 3 1 1 21 4 E 58.38 31 6 5 3 2 2 20 2 E 70.75 32 6 30 4 2 1 21 2 I 91.98 33 5 50 3 1 2 20 2 E 83.82 34 4 5 3 2 1 23 4 E 88.5 35 6 30 3 2 1 23 2 E 75.34 36 6 20 3 2 2 24 4 E 85.25 37 7 60 3 2 1 21 4 I 62.24 38 5 15 3 2 1 22 2 E 59.39 39 5 35 4 2 1 24 6 E 86.91 40 5 10 3 2 1 23 4 E 67.74 41 5 25 3 1 2 21 2 E 83.4 42 5 14 4 1 2 22 6 E 75.32 43 6 20 4 1 2 24 4 I 61.94 44 6 15 3 2 1 22 2 I 60.79 45 5 12.5 4 2 1 45 2 E 86.7 46 5 13 3 2 2 20 2 E 78.89 Definitions of variables/ Items used to measure the varia X1= How would you rate yourself with respect to your kno X2= How many hours per week do you use the Internet? X3= What is your classification? 1. Freshman 2. Sopho X4= Are you a first generation college student? 1. yes X5= Your gender: 1. male 2. female X6= Your age: ______________Years X7= Your ethnicity: 1. African 2. Anglo 3. Asian 4. H X8= Extravert (E) or Introvert (I) Personality Type of Stude Y= Course grade on a 100 point scale 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 5 14 5 14 5 3 5 15 6 5 6 23 4 20 4 7 6 10 3 40 6 7.5 5 30 4 28 6 52 7 24 5 22 4 20 5 15 6 8 6 20 7 40 7 50 3 30 4 3 6 10 4 20 6 40 6 28 5 15 6 10 6 4 5 8 6 50 6 30 6 24 4 50 4 25 5 5 5 15 3 10 5 20 6 27.5 7 40 4 4 3 4 4 3 4 3 4 2 4 3 4 3 3 4 4 4 4 4 3 4 2 3 3 3 5 3 4 3 4 3 4 3 3 3 4 3 3 4 2 4 3 1 2 2 1 2 2 2 2 2 2 2 2 1 2 2 1 2 2 2 1 2 1 2 2 2 2 1 1 1 2 2 2 1 1 2 2 1 2 1 2 2 2 1 2 1 1 2 2 1 1 1 1 1 1 2 1 2 1 1 2 1 2 1 1 1 2 1 1 2 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 1 1 22 21 21 22 21 20 21 23 22 22 22 24 23 33 21 26 21 23 21 22 29 49 21 20 20 20 24 24 22 30 27 26 23 21 21 21 23 22 22 27 20 23 26 4I 2I 4E 2E 4E 4E 6E 4I 2E 3I 2E 4E 2I 4E 4I 3E 2E 2E 2E 2E 4E 2E 2I 2E 4E 2E 2I 4I 2E 4E 2E 2E 4E 4E 2E 4E 4E 2E 4E 2I 6E 2E 4I 74.49 75.96 58.02 64.43 62.08 65.53 75.94 71.96 61.92 82.47 65.63 79.05 87.53 90 82.02 67.18 65.13 75.34 74.1 65.01 46.28 65.77 79.05 79.81 61.67 62.7 95.01 87.36 78.14 79.13 60.52 69.18 70.43 82.49 78.6 74.45 67.15 74.21 75.02 88.37 88.41 54.12 59.73 used to measure the variables elf with respect to your knowledge about computers? 1 (very poor) 2 3 4 5 6 7 (excellent) do you use the Internet? ________________hours per week 1. Freshman 2. Sophomore 3. Junior 4. Senior 5.Graduate ollege student? 1. yes 2. no 2. Anglo 3. Asian 4. Hispanic Personality Type of Student 5. Native American 6. Other ters? 1 (very poor) 2 3 4 5 6 7 (excellent) ours per week enior 5.Graduate merican 6. Other JSMCase 4 Prince Mean Chaser: King Menalaus: Princess Age: King Menalaus: Princess I-Net: King Menalaus: Along with many other students, prince Mean Chaser, princess Age and princess I-net are students at the college of business at TAMUCC. Often they hold conversations with their dady, King Menalaus of Troy, about their dad's favorite and their hardest subject--business statistics. King Menalaus is well known as a data driven decision maker and he takes pleasure in discovering knowledge about relationships among variables related to students and others who live in his kingdom. King Menalaus and his two daughters and one son had the following conversation recently. The mean score in a business statistics course for all students at TAMUCC is less than 70 out of 100. I am 99% sure about this, Daddy. So, my score of 67 is not all that low. I wish I could believe you. Can you help me believe you, Prince Mean Chaser? I think the average performance is 70 or higher out of 100. The older a student, the better the student performs in an assessment of statistical knowledge and skills. I am only 18 years old, Daddy, and this is why I scored 65% in business statistics. I am not old enough to do any better. I will disagree with you on this point, Princess Age, until you support your opinion with data-driven analysis. The more a student uses the Internet, the better the student performs in an assessment of statistical knowledge and skills. Since you allow me to spend only twenty five hours per week on the Internet, I scored only 68 in business statistics, Daddy. I will disagree with you on this point, Princess I-Net, until you support your opinion with data. Use data from JSMCase1 Excel file [in Module 1 folder], to test three hypotheses hidden in the conversation above. Use regression analysis to investigaete the relationship between age of a student, Internet usage of a student and performance of a student in an assessment of statistical knowledge and skills. Prince Mean Chaser, Princess Age and Princess I-net have hired you to help them and they have agreed to pay you 1000 dollars if you help honestly settle their dispute with their daddy. They do not want to win for the sake of winning by any means necessary, they want you to discover the honest truth about how reasonable their beliefs are. Which of their beliefs can be supported with 95% confidence? Which of their beliefs can be supported with 99% confidence? Use the hypothesis testing procedure described in chapters 9 and or 12, as appropriate, to do your analysis. Discuss your findings. Use scatter diagrams, correlation coefficient r and the regression procedure to honestly settle the dispute in the royal family about the relationship between age and performance in business statistics and Internet usage and performance in business statistics