Hi

Please Help!!

Please show how to use excel toconstruct data in order to answer the following questions

Sule subj1 subj2 subj3 subj4 subj5 subj6 subj7 subj8 subj9 subj10 subj11 subj12 subj13 subj14 subj15 subj16 subj17 subj18 subj19 subj20 subj21 subj22 subj23 subj24 subj25 subj26 subj27 subj28 subj29 subj30 subj31 subj32 subj33 subj34 subj35 subj36 subj37 subj38 subj39 subj40 subj41 subj42 subj43 intDom domestic domestic domestic international domestic international domestic international domestic international domestic domestic international international domestic international domestic domestic domestic international international domestic international domestic domestic international international international international international domestic international international international international international international domestic international domestic domestic international international nquuizzes unitMark 15 36 39 1o 50 31 47 39 32 42 19 47 41 28 4o 50 58 55 26 45 43 38 46 56 50 49 14 22 34 46 54 56 42 22 33 24 32 18 5o 36 32 18 39 ageGroupCat 57.24 4 (more than 24) 50.75 1 (less than 19) 54.73 1 (less than 19) 55.91 3 (22-24) 78.71 1 (less than 19) 59.96 2 (1921) 74.43 3 (22-24) 78.49 1 (less than 19) 38.23 3 (22-24) 74.51 3 (22-24) 61.3 3 (22-24) 66.38 3 (2224) 80.45 3 (22-24) 69.93 1 (less than 19) 62.75 3 (22-24) 57.25 4 (more than 24) 75.36 2 (1921) 78.43 1 (less than 19) 62.54 1 (less than 19) 65.74 1 (less than 19) 71.8 2 (19-21) 67.15 3 (2224) 65.07 2 (19-21) 79.86 1 (less than 19) 94.16 2 (1921) 87.82 4 (more than 24) 43.49 1 (less than 19) 43.66 1 (less than 19) 77.57 2 (19-21) 77.6 2 (19-21) 88.89 4 (more than 24) 97.59 3 (22-24) 89.05 3 (22-24) 61.31 2 (19-21) 67.31 4 (more than 24) 44.75 1 (less than 19) 57.11 1 (less than 19) 55.77 3 (22-24) 72.89 4 (more than 24) 73.61 4 (more than 24) 73.9 4 (more than 24) 57.99 3 (2224) 55.05 3 (2224) subj44 subj45 subj46 subj47 subj48 subj49 subj50 subj51 subj52 subj53 subj54 subj55 subj56 subj57 subj58 subj59 subj60 subj61 subj62 subj63 subj64 subj65 subj66 subj67 subj68 subj69 subj70 subj71 subj72 subj73 subj74 subj75 subj76 subj77 subj78 subj79 subj80 subj81 subj82 subj83 subj84 subj85 subj86 subj87 international domestic domestic international international international domestic international domestic international domestic domestic domestic international domestic domestic domestic international domestic international domestic domestic domestic domestic international international domestic international international international domestic domestic international domestic domestic domestic domestic domestic international domestic domestic international domestic international 32 37 31 24 37 47 56 59 33 17 39 60 38 56 17 16 52 42 60 31 38 23 48 60 28 31 47 21 32 17 11 56 12 29 50 12 55 6O 34 35 32 36 26 56 78.83 4 (more than 24) 77.3 3 (2224) 83.11 4 (more than 24) 83.62 1 (less than 19) 69.2 4 (more than 24) 77.93 3 (2224) 83.69 2 (1921) 75.48 2 (1921) 63.37 4 (more than 24) 63.75 4 (more than 24) 64.88 4 (more than 24) 84.61 4 (more than 24) 66.34 3 (2224) 83.8 3 (22-24) 65.22 4 (more than 24) 48.37 3 (22-24) 84.26 2 (1921) 64.35 3 (22-24) 64.83 3 (2224) 65.76 1 (less than 19) 56.13 2 (19-21) 66.87 4 (more than 24) 83.81 2 (19-21) 75.55 3 (2224) 52.14 1 (less than 19) 59.51 3 (2224) 63.99 3 (22-24) 34.2 4 (more than 24) 66.66 2 (1921) 54.47 4 (more than 24) 63.1 3 (22-24) 74 3 (2224) 34.51 2 (19-21) 54.5 4 (more than 24) 62.23 1 (less than 19) 44.52 3 (2224) 96.25 3 (2224) 79.83 4 (more than 24) 66.91 2 (1921) 62.58 3 (22-24) 61.89 2 (1921) 69.08 4 (more than 24) 49.45 2 (19-21) 79.13 2 (19-21) subj88 subj89 subj90 subj91 subj92 subj93 subj94 subj95 subj96 subj97 subj98 subj99 subj100 subj101 subj102 subj103 subj104 subj105 subj106 subj107 subj108 subj109 subj110 subj111 subj112 subj113 subj114 subj115 subj116 subj117 international domestic international domestic domestic domestic domestic domestic domestic domestic domestic domestic domestic domestic international international domestic domestic domestic domestic international domestic international international domestic domestic domestic domestic domestic domestic 42 15 12 13 51 33 33 42 42 21 26 35 52 33 33 48 26 59 46 32 33 52 51 26 14 16 33 22 28 22 53.99 4 (more than 24) 54.35 2 (1921) 41.82 2 (19-21) 59.37 2 (1921) 74.46 3 (22-24) 53 4 (more than 24) 52.21 2 (1921) 66.39 2 (19-21) 68.8 1 (less than 19) 29.72 2 (1921) 52.05 4 (more than 24) 73.01 1 (less than 19) 68.38 4 (more than 24) 64.88 1 (less than 19) 45.03 3 (2224) 69.18 1 (less than 19) 55.46 4 (more than 24) 54.43 1 (less than 19) 53.14 3 (2224) 67.24 3 (22-24) 64.83 4 (more than 24) 69.91 3 (22-24) 88.1 2 (19-21) 55.93 1 (less than 19) 34.64 4 (more than 24) 51.03 4 (more than 24) 61.41 4 (more than 24) 57.52 3 (2224) 63.57 1 (less than 19) 57.15 3 (22-24) CONTINGENCY TABLE ageGroupCat intDom 1 (less than 1 2 (19-21) 3 (22-24) 4 (more than Sum domestic 12 13 24 19 international 68 12 13 12 12 49 Sum 24 26 36 31 117A random sample of 117 students enrolled in statistics units in recent semesters at Macquarie University has been selected to study use of practice quizzes and academic performance. Some of the variables recorded for each student are listed below. Variable Description subid Subject ID intDom domestic or international numQuizzes the number of practice quizzes attempted unitMark the final unit mark ageGroupCat the age of students Import the data set included in the file sample. cav in Excel. To do this, you need to click on the link above and save the data file in a convenient location on your PC (in your browser, File and Save). Next open Excel, click File in the Menu, select Open and navigate to the file you previously saved - or simply double-click on it, Excel should open automatically. Use Excel and/or probTool, and appropriate hypothesis tests, to address the following research question. Assume all the test assumptions are verified. Research question 1: We wish to investigate whether the age of students enrolled in statistics units in recent semesters at Macquarie University is distributed according to the table below. the age of students | 1 (less than 19) | 2 (19-21) | 3 (22-24) | 4 (more than 24) Percentage 10 40 30 20 QUESTIONS: Report the number of the degrees 3 of freedom [integer]: Report the value of the test statistic 2 [use at least 2dp]: Report the p-value [use at least 2 3dp]: X What is the decision of the test? There is no evidence that the proportions are different to those reported in the table. X