DATA HERE: https://file.io/YpHCTnBJKvnG

If can not download please visit this link: https://docs.google.com/spreadsheets/d/e/2PACX-1vR-SF4QDjFslEDs7-lmNGlpL4bMWffOgZrXZkrI9rNvHeQpHdEepXgLRFsj-uszZdURQrzqQWX5cHrH/pubhtml

Please explain this. Thank you

QUESTION

- Use Excel functions with appropriate row & col addressing modes ($) to translate the non-numeric categorical variables to the 3 auxiliary variables with 1's and 0's in new table, where the columns are arranged correctly to address the question.

- Run the regression tool on the worksheet that you will be turning in and specify the output location on the same worksheet.

- Organize both the table (input) and the regression report (output) so they are presentable.