Automate Workbook Regression Tasks in Excel
Budget: $30 – $250 USD
I have an Excel workbook that contains several task-specific tabs. Each tab lays out a short scenario, provides its own data set, and lists parameters for a regression analysis I need to run.
Your job is to open the file, work through every tab in order, and supply all requested results strictly with Excel functions or built-in analysis tools—no static numbers typed in. Every figure has to be traceable through a formula so I can audit the logic afterward.
Key points
• Stay inside Excel; VBA isn’t necessary.
• Use appropriate regression techniques exactly as the instructions on each sheet specify.
• Check that every question or prompt on every tab is answered before you return the workbook.
• Keep the workbook clean: formulas visible, intermediate work either on hidden helper sheets or clearly labeled.
Deliverable: the updated workbook with every task complete and all formulas intact, ready for me to review.
Your job is to open the file, work through every tab in order, and supply all requested results strictly with Excel functions or built-in analysis tools—no static numbers typed in. Every figure has to be traceable through a formula so I can audit the logic afterward.
Key points
• Stay inside Excel; VBA isn’t necessary.
• Use appropriate regression techniques exactly as the instructions on each sheet specify.
• Check that every question or prompt on every tab is answered before you return the workbook.
• Keep the workbook clean: formulas visible, intermediate work either on hidden helper sheets or clearly labeled.
Deliverable: the updated workbook with every task complete and all formulas intact, ready for me to review.