250_Notes_6B_Rev

250_Notes_6B_Rev - 31.4 Residual 12 ### 5875454.94 Total 15...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ACCT 250 EXCEL EXAMPLE fa2dc733d64dc489b1fc4bcf026c5ea3be145a6e.xls PAGE 1 OF 1 Month Analyses Accounts Paychecks Cost 1 2 325 1,029 63,800 2 4 310 993 68,900 3 2 302 1,268 64,000 4 1 213 1,028 61,300 5 2 222 984 61,600 6 - 214 712 50,800 7 1 131 762 51,020 8 1 123 739 54,300 9 - 115 708 50,500 10 2 296 1,232 64,800 11 2 213 978 58,000 12 1 222 929 57,500 13 2 217 1,059 62,600 14 2 132 942 54,900 15 4 300 1,299 71,530 16 4 315 1,283 64,800 30 3,650 15,945 960,350 SUMMARY OUTPUT Regression Statistics Multiple R 0.94 R Square 0.89 Adjusted R S 0.86 Standard Erro 2423.93 Observations 16 ANOVA df SS MS F Significance F Regression 3 ### ###
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 31.4 Residual 12 ### 5875454.94 Total 15 ### Coefficients Standard Erro t Stat P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0% Intercept 39970.2 3849.96 10.38 31581.85 48358.54 31581.85 48358.54 Analyses 2008.33 774.14 2.59 0.02 321.62 3695.03 321.62 3695.03 Accounts 31.14 14.28 2.18 0.05 0.03 62.25 0.03 62.25 Paychecks 9.21 5.83 1.58 0.14-3.48 21.91-3.48 21.91 TC = 39,970.20 + (2,008.326 * Analyses) + (31.141 * Accounts) + (9.214 * Paychecks) Quantity Rate Cost Analyses 3 2,008.33 6,025 Accounts 200 31.14 6,228 Paychecks 1,000 9.21 9,214 Fixed 1 39,970.20 39,970 Total 61,437...
View Full Document

This note was uploaded on 04/18/2008 for the course ACCTG 250 taught by Professor Rabe during the Spring '08 term at Luther.

Ask a homework question - tutors are online