About this document

Excel: Estimating Costs with Regression by Windi is a document available to read on EtoBox.

This document discusses using Microsoft Excel to perform least-squares regression analysis to estimate the fixed and variable costs of Brentline Hospital based on patient-day data. It provides step-by-step instructions for creating a scatterplot graph in Excel and using the trendline feature to calculate the regression line that minimizes the sum of squared errors. The regression analysis estimates the hospital

Author

Windi

Language

EN