Please read very carefully what I am asking for.

Please provide step-by-step answers for the questions below b., c., d., with Excel formulas/Excel Data Analysis, and math formulas. Also, if possible provide Minitab instructions to solve these questions. Please provide also answers rounded to decimal places like asked in the questions.

Bloomberg Intelligence listed 50 companies to watch in 2018. Twelve of the companies are listed here with their total assets and 12-month sales.

Bloomberg Intelligence listed 50 companies to watch in 2018 (www.bloomberg.com/features/companies-to-watch-2018). Twelve of the companies are listed here with their total assets and 12-month sales. Total Assests 12-Month Sales Total Assests 12-Month Sales Company ($ billions) ($ billions) Company ($ billions) ($ billions) Eni SpA 134. 47 68 . 13 AMC Entertainment 9 . 81 4. 19 Discovery Communications 16.15 6.59 DSV 6.14 10 .54 Dong Energy 20.5 9.16 Alaska Air 10.7 6.9 AMD 3.37 4. 62 Boohoo. com 0. 235 0 . 545 Cabot Oil & Gas 5. 22 1 . 58 Danone 52 . 12 25 .11 Engie 166. 84 72 Experian 7. 69 4. 34Let sales be the dependent variable and total assets the independent variable. [Do not round intermediate calculations. Round your answers to 4 decimal places.) "he coefcient of correlation is "he regression equation, with the coefcients, is j? = d. Fora company with $100 billion in assets, predict the 12-month sales is