The following questions pertain to the excel

37.The following questions pertain to the excel solution which follows. They include question# 37-43.A Tasty Sub shop franchise consisting of 10 shops wishes to predict its sales. It has decided to use population size in close proximity to the shops. Below are the population size in thousands and the annual sales in thousands.Yearly RevenueY Population size X527.120.8548.727.5767.232.3722.937.2826.339.6810.545.11040.749.91033.655.41090.361.71235.864.6The following are the results of the regression analysis:SUMMARY OUTPUTRegression StatisticsMultiple R0.968793376R Square0.938560605Adjusted R Square0.930880681Standard Error61.70515431Observations10ANOVAdfSSMSFSignificance FRegression1465316.3004465316.3004122.20961643.99584E-06Residual830460.208553807.526069Total9495776.509CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept183.305131864.274084152.8519291130.02141544635.08882808331.521435535.08882808331.5214355X Variable 115.595597061.41074758411.054845833.99584E-0612.342407318.8487868212.342407318.84878682 Yearly revenue is the dependent variable independent variable statistically significant variable slope of the regression equationQuestion 38.38.Is the regression equation statistically significant at alpha=.05? Yes NoQuestion 39.39. How do you know?Because: R2 = .9386 Syx=61.7052 P-value = 3.99584E-06 P-value=0.0124Question 40.40. What is the regression equation? =183.3051 + 64.271x =183.305 +15.5956x =15.5956+ 1.4107x = a +bxQuestion 41.41. If the population of a single shop’s area is 20,000 (20 in thousands) What is an estimate of the shop’s sales( In thousands)? $311.91 $628.80 $384.96 $495.21Question 42.42. The association between X and Y is Low because Syx=61.7052 High because = .9384 High because r= .9688 High because t stat =11.0548Question 43.43. What percentage of sales is attributable to population 93.86% 96.88% 61.705% 12.34%