Mixed costs are very common in business and consist of fixed cost element and a variable cost element. Fixed costs are a recurring, constant cost that does not vary when business activity varies. Variable costs are added costs associated with each unit of business activity the organization experiences. The relationship can be characterized by the following equation:
Total costs = Fixed Cost + (cost per unit) x (number of units of business activity)
In a leading managerial accounting textbook, the authors discuss a hospital's total maintenance costs, and use regression analysis to estimate the fixed cost element of maintenance and the variable cost associated with the number of patient-days. The hospital's total maintenance costs and number of patient-days for seven months are listed in the following table and stored in the file (MixedCosts).
A. Using total maintenance costs as the dependent variable and patient-days as the independent variable, use the least-squares method to find the regression coeffiecients bo and b1.
B. Which regression coefficient represents fixed cost?
C. Which regression coefficient represents the variable cost per each patient-day?
D. Predict total maintenance costs for a month with 7,500 patient-days.© BrainMass Inc. brainmass.com October 16, 2018, 7:15 pm ad1c9bdddf
a) mean of patient days: ux=(5600+7100+5000+6500+7300+8000+6200)/7=6528.571
mean of costs: ...
A regression coefficient mixed costs at a hospital are examined.
Bio-Statistics: Select the Appropriate Statistical Test for Analysis of Hospital Costs
Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel.
1. Analyze your data and produce a summary describing the major findings of your analysis.
2. The variables that most affect hospital cost.
3. An overview of the P and F values in your Excel tables.
4. A discussion of the degrees of freedom and the sample size.
5. Discuss any significant relationships that present themselves in the Excel files produced from your statistical analysis
please be as detailed as possible.