LTI Launch X Dashboard X + V X -> C A learn.humber.ca/ultra/courses/_206700_1/outline/Iti/launchFrame?toolHref=https:~2F~2Flearn.humber.ca~2Fwebapps~2Fblackboard~2Fexecute~2Fblti~2FlaunchLink%3Fcourse_id%3D_206... Download CSV X Humber students urgently prepared a regression analysis report. Unfortunately, it was the final exam week, and students had very little time. At that moment, only first 10 daily observations were available. Also, the students had no time to find the regression equation, r , and R2 . The following picture is the draft that they prepared. 900 800 -700 600 Sales 500 400 300 20350 400 450 500 55 AdClicks 451560714_statisti..pdf receipt-1523.20225...txt Show all X 24C O ENG 1:05 PM Partly sunny IN 8/2/2022 4LTI Launch x u Dashboard x l + v 7 X ( $ C 0 learn.humber.ca/uItra/courses/_206700_lloutline/lti/launchFrame?toolHref:https:~2F~2Flearnhumberca~2Fwebapps~2Fblackboard~2Fexecute~2Fblti~2FlaunchLink%3Fcourse_id%3D_206... l5) $37 I l] o l (a) Check the draft. Select the most appropriate comment. 0 The choice of dependent and independent variables is correct, but the trend line is missing. 0 The draft looks incomplete as the students forgot to label the axes. Also, I would probably makethe points (Excel markers) bigger. O The roles of the selected variables are mixed up. AdClicks should be the independent variable 23, and Sales should be considered as the dependent variable y, not the other way around. 0 The choice of dependent and independent variables is wrong. The students must have taken AdClicks (not Day#) as the independent variable as, and Sales should be the dependent variable y. 0 None of the above. Please help the Humber College students. Using Excel and 30 daily recordings, please construct a scatter diagram to support or reject the idea of the management. Make sure that you do not repeat the possible mistakes that are described in question 1. Also, please include the regression equation and R2 in the scatter diagram along with the trend line. Based on the result, answer the following questions: [5' 451560714_staristr....pdr A receipiriszazozzsum A Shuwall x LTI Launch X Dashboard X + V X -> C a learn.humber.ca/ultra/courses/_206700_1/outline/Iti/launchFrame?toolHref=https:~2F~2Flearn.humber.ca~2Fwebapps~2Fblackboard~2Fexecute~2Fblti~2FlaunchLink%3Fcourse_id%3D_206... The coefficient of determination is R" = X The linear correlation coefficient is r = (c) Round your answers to 2 decimal places. The regression equation is (do not mix up bo and b1 ) y = (d) Express your answers in percent form (i.e. 3.00% instead of 0.03) and round to 2 decimal places. What percent of the variation in Sales can be explained by the variation in AdClicks? % What percent of the variation in Sales cannot be explained by the variation in AdClicks, but is due to other factors? % (e) Round vour answers to 2 decimal places. 451560714_statisti..pdf ~ receipt-1523.20225..txt Show all X 24 C ENG 1:06 PM Partly sunny IN 8/2/2022 4LTI Launch X Dashboard X + V X C A learn.humber.ca/ultra/courses/_206700_1/outline/Iti/launchFrame?toolHref=https:~2F~2Flearn.humber.ca~2Fwebapps~2Fblackboard~2Fexecute~2Fblti~2FlaunchLink%3Fcourse_id%3D_206... X (f) How much will the sales revenue amount be expected to change if the number of daily ad clicks increases by one click? Please note that the answer is expected in dollars, not in thousands. Select an answer (g) What would be the best predicted sales revenue amount if the number of daily ad clicks is 568? Please note that the answer is expected in dollars, not in thousands. LA (h) Would it be possible to use this regression model to predict the sales revenue amount if the number of daily ad clicks is 291 ? O The forecast would be reliable, as the regression equation from question (c) can be used to predict any Sales. O The forecast would be reliable. Just plug the given number of clicks into the regression equation. O The forecast would be reliable, and Sales is approximately 334.83. O The forecast would not be reliable, as 291 clicks is not within the sample x-range. O None of the above. 451560714_statisti..pdf receipt-1523.20225..txt Show all X 24 C O ENG 1:06 PM 2 IN 8/2/2022 4 Partly sunnyLTI Launch X Dashboard X + V X -> C A learn.humber.ca/ultra/courses/_206700_1/outline/Iti/launchFrame?toolHref=https:~2F~2Flearn.humber.ca~2Fwebapps~2Fblackboard~2Fexecute~2Fblti~2FlaunchLink%3Fcourse_id%3D_206... Round P -value to 8 decimal places or use scientific notation. X P -value = Round tat and Fat values to 3 decimal places. tst = F st = What is your conclusion? O At the 3% significance level, there is not sufficient sample evidence to support the claim that that there is the linear relationship between the sales revenue (Sales) and number of ad clicks (AdClicks) in the population of all daily observations. O At the 3% significance level, the sample data support the claim that there is the linear relationship between the sales revenue (Sales) and number of ad clicks (AdClicks) in the population of all daily observations. O None of the above. Do not forget to attach the original Excel file(s). 451560714_statisti..pdf receipt-1523.20225...txt Show all X 24 C ENG 1:06 PM Partly sunny O IN 8/2/2022 4