Project Description
I need a sharp-looking Excel workbook that can run a reliable regression model on my data and return clear, actionable predictions. The core of the job is data analysis and reporting—not simple data entry—so I’m after someone comfortable turning raw numbers into insights directly inside Excel.
Here’s what I’m after:
• Build and document a regression analysis in Excel (native functions, Analysis ToolPak or Power Query—whatever you prefer as long as it stays inside the .xlsx environment).
• Include well-labeled inputs, assumptions and output sections so I can update the sheet with fresh data and instantly refresh the model.
• Provide concise interpretation of coefficients, R-squared, significance tests and any diagnostics you consider essential for a trustworthy predictive model.
• Visualize the results with charts that make trends and forecast accuracy obvious at a glance.
Once complete, I should be able to open the file, drop in new data and see updated predictions without touching any formulas. If that sounds straightforward to you, let me know how quickly you can turn it around and a brief outline of your approach.