: INSTRUCTION: You must use Excel to do the statistical analysis. Your report must be a MS Word document with the graphs and output embedded in it. The final submission must be a PDF document. Question 1 One of the key determinants in successful distance education is the level of support given to students since that is assumed by many researchers to impact on student engagement and hence reduce the time to completion. A distance education institution wishes to investigate the effect that the level of support as well as academic level of achievement of students have on the percentage of full-time distance education students across different Bachelor's qualifications who complete their qualification within 3 years of study. In the data collected per qualification, the level of support is indicated by the average size of the small tutor groups that the students in a qualification are allocated to, while the academic level of achievement in a qualification is indicated by the average mark of all exam sittings for all the students across all the modules. The Excel file STA1506_2022_ASS5.xlsx gives the data collected for 50 different qualifications. - The column labelled Average academic achievement gives the average percentage mark across all exam sittings and all students for the qualification. - The column labelled Average tutor group size gives the average tutor group size across all the modules in the qualification. - The column labelled \% Completed in 3 years indicates what percentage of the students completed the qualification in 3 years of study. In this assignment you are asked to write a report on the findings according to the following guidelines. 1. Describe the data by means of numerical and graphical summaries. Include all relevant and appropriate numerical and graphical summaries of each variable, as well as summaries of the relationship between all pairs of variables. In addition to giving the numerical and graphical summaries, you must also interpret what they tell us. Remember to label any graphs appropriately. 2. Use regression analysis to develop an estimated linear regression equation that could be used to predict the percentage of students in a qualification who will complete their qualification within 3 years of study, given the average tutor group size in the qualification. 2 STA1506/015/0/2022 3. Use regression analysis to develop an estimated linear regression equation that could be used to predict the percentage of students in a qualification who will complete their qualification within 3 years of study, given the average academic achievement in the qualification. 4. Which of the two estimated linear regression equations provides the best fit? Justify your answers. For this estimated regression equation, discuss your findings and conclusions. 5. What conclusions and recommendations can you derive from your analysis? : INSTRUCTION: You must use Excel to do the statistical analysis. Your report must be a MS Word document with the graphs and output embedded in it. The final submission must be a PDF document. Question 1 One of the key determinants in successful distance education is the level of support given to students since that is assumed by many researchers to impact on student engagement and hence reduce the time to completion. A distance education institution wishes to investigate the effect that the level of support as well as academic level of achievement of students have on the percentage of full-time distance education students across different Bachelor's qualifications who complete their qualification within 3 years of study. In the data collected per qualification, the level of support is indicated by the average size of the small tutor groups that the students in a qualification are allocated to, while the academic level of achievement in a qualification is indicated by the average mark of all exam sittings for all the students across all the modules. The Excel file STA1506_2022_ASS5.xlsx gives the data collected for 50 different qualifications. - The column labelled Average academic achievement gives the average percentage mark across all exam sittings and all students for the qualification. - The column labelled Average tutor group size gives the average tutor group size across all the modules in the qualification. - The column labelled \% Completed in 3 years indicates what percentage of the students completed the qualification in 3 years of study. In this assignment you are asked to write a report on the findings according to the following guidelines. 1. Describe the data by means of numerical and graphical summaries. Include all relevant and appropriate numerical and graphical summaries of each variable, as well as summaries of the relationship between all pairs of variables. In addition to giving the numerical and graphical summaries, you must also interpret what they tell us. Remember to label any graphs appropriately. 2. Use regression analysis to develop an estimated linear regression equation that could be used to predict the percentage of students in a qualification who will complete their qualification within 3 years of study, given the average tutor group size in the qualification. 2 STA1506/015/0/2022 3. Use regression analysis to develop an estimated linear regression equation that could be used to predict the percentage of students in a qualification who will complete their qualification within 3 years of study, given the average academic achievement in the qualification. 4. Which of the two estimated linear regression equations provides the best fit? Justify your answers. For this estimated regression equation, discuss your findings and conclusions. 5. What conclusions and recommendations can you derive from your analysis