Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The manager of the main laboratory facility Urbanah Carter Werested in being able to predict the weed costs each month for the lab. The manager

image text in transcribed
image text in transcribed
The manager of the main laboratory facility Urbanah Carter Werested in being able to predict the weed costs each month for the lab. The manager believes that overhead with the use of a performed bued by Exce The botary performed at predetta The that some costa roman the methods oferumber of beds performed. The flow collected the following data for the first even months of the you Click her wed) Click the icon to view the data) Rand the Requirement 1. Desermine the con quelon line the output from the cel museon Pound te wortes de conce) y 14640 LIT Data Table Man Number of TestPerf wy 1.650 Total Labor Our Cash 32.100 52000 132.00 554.000 wy 4500 500 1700 117.500 315 900 Joly 1 - 1 Data Table A B D E TI F G 2. 1 SUMMARY OUTPUT 2 Regression Statistics 3 Multiple R 0.94799 4 R Square 0.898685 5 Adjusted R Square 0.878422 6 Standard Error 2562.300148 7 Observations 7 8 ANOVA df SS 10 Regression 1 291181661.19 11 Residual 5 32826910.24 9 D MS F Significance F 0.001152 291181661.19 44.351061 6565382.048 12 Total 6 324008571.43 13 Standard Error 1 Stat P-value Lower 95% Upper 95% Coefficients 8047 25 2947.351 2.730 0.041 470.840 15623,652 14 Intercept 15 X Variable 1 5.77 0.866 6.660 0.001 3.541 7.994 Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Gordon Roberts, Hamdi Driss

8th Canadian Edition

01259270114, 9781259270116

Students also viewed these Accounting questions