Excel Essentials :Mastering Data Analysis in Excel (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

1. Slope of best-fit line
   ✔️ 0.12
   ❌ 0.11
   ❌ 0.15
   ❌ 0.18

2. R-squared
   ✔️ 0.20
   ❌ 0.18
   ❌ 0.22
   ❌ 0.24

3. Y-intercept
   ✔️ 0.35%
   ❌ 0.25%
   ❌ 0.45%
   ❌ 0.55%

4. Higher Sharpe Ratio
   ✔️ RSP
   ❌ SPY

5. Sharpe Ratio value
   ✔️ 0.56
   ❌ 0.53
   ❌ 0.50
   ❌ 0.48

6. Month of highest Amazon return
   ✔️ October 1, 2009
   ❌ September 1, 2010
   ❌ April 2, 2007
   ❌ July 3, 2006

7. Monthly return
   ✔️ 51.87%
   ❌ 22.9%
   ❌ 24.11%
   ❌ 43.27%

8. Duke Energy return that month
   ✔️ 3.04%
   ❌ 0.51%
   ❌ 1.13%
   ❌ 3.18%

9. Revenue-maximizing price
   ✔️ $12.50
   ❌ $5.00
   ❌ $13.50
   ❌ $25.00

10. Monthly revenue
    ✔️ $62,500
    ❌ $15,100
    ❌ $62,100
    ❌ $40,000

🧾 SUMMARY TABLE OF ALL ANSWERS