Excel-Based Business Analytics Homework

I need Homework 3 for my Quantitative Business Analytics class completed exactly to the professor’s specifications. I will supply the template file HW3.docx; every answer must be typed in the “Answer:” area already set up under each question. All calculations have to be performed in Excel (or Google Sheets) with live formulas—no hard-typed math. For each question, once the calculation is finished: • Place the key numeric result in bold inside the Word file and include any required units. • Copy–paste the supporting Excel output—pivot table, regression summary, chart, or other analysis—using “Keep Source Formatting” so it appears exactly as in Excel. • Add one or two concise sentences that interpret what the pasted output shows. Deliverables: 1. The updated HW3.docx containing all answers, pasted outputs, and brief explanations. 2. The original Excel workbook(s) used to produce those answers, with formulas intact. Strict rules: Only Excel or Google Sheets may be used; no other analytics software and no AI tools. Failure to follow those constraints will void the submission, so please be sure every calculation can be traced directly to the spreadsheet.