Bloomberg Intelligence listed 50 companies to watch in 2018 (bloomberg.com/features/companies-to-watch-2018). Twelve of the companies are listed here with their total assets and 12-month sales. Let sales be the dependent variable and total assets the independent variable.Draw a scatter plotCompute the correlation coefficientDetermine the regression equationFor a company with $100 billion in assets, predict the 12- month sales. ACompanyAMDAlaskla AirAMC EntertainmentBoohoo.comCabot Oil & GasDanoneDiscovery CommunicationsDong EnergyDSVEngieEni SpAExperianBсtotal assets 12 month sales3.374.6210.76.99.810.2355.2252.1216.1520.56.14166.84134.477.694.190.5451.5825.116.599.1610.547268.134.34

We have given data on twelve of the companies listed here, along with their total assets and -month sales: CompanyTotal assets12 month salesAMD3.374.62Alaskla Air10.76.9AMC Entertainment9.814.19Boohoo.com0.2350.545Cabot Oil & Gas5.221.58Danone52.1225.11Discovery Communications16.156.59Dong Energy20.59.16DSV6.1410.54Engile166.8472Eni SpA134.4768.13Experian7.694.341. Let sales be the dependent variable and total assets be the independent variable.: 12 month sales: total assetsWe draw a scatter plot using Excel as follows:Enter the provided data into an Excel spreadsheet, with "Total Assets" in one column and "12-month Sales" in another.Then select the data range.Go to the "Insert" tab, click on "Insert Scatter (X,Y)" in the Charts group, then choose "Scatter".We will get the below scatter plot.Edit the axis title name and the title name of the chart.2. The formula to calculate the correlation coefficient is given by:The correlation coefficient is obtained using the Excel function: "=CORREL(A2:A13,B2:B13)".Correlation coefficient: .3. The regression equation:The regression equation is obtained using Excel's built-in regression analysis tool as follows:Go to the "Data" tab and click on "Data Analysis".Choose "Regression" and choose the "Input Y range" as Total Assets, and "Input X range" as 12-month Sales.Once you run the regression analysis, Excel will provide the regression equation in the output.The intercep: The slope: The regression equation can be written as follows:4. We predict the 12-month sales for a company with billion in assets using the regression equation obtained from the analysis as follows:Therefore, the predicted value of the 12-month sales is when a company has billion in assets.1. Scatter-plot2. Correlation coefficient: .3. The regression equation can be written as follows:4. The predicted value of the 12-month sales is when a company has billion in assets.