Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 6 Burmer Co. has accumulated data o use in preparing its annual profit plan for the upcoming year. The most behavior pattern of the

image text in transcribed
image text in transcribed
QUESTION 6 Burmer Co. has accumulated data o use in preparing its annual profit plan for the upcoming year. The most behavior pattern of the maintenance costs must be determined Data regarding the machine hours and maintenance costs for the last year and the results of the regression analysis are as follows Month Maintenance Cost Machine Hours Jan 15.040 emainder of original data omated 551,830 6.260 Average S22 sum Avtal assistant has run regression analyses on the data and obtained the following out using Excel SEGRESSION ANALYSIS Y Dependen Variables Maintenance Co Independent Variable Maintenance Hours Regression Statistic 0.99210214 R Square Adjusted Square 4606617 Standard Error 47,0629563 Observacions 12 ANOVA er 35 MS F Significance Regression 612142486971322786257 0.000000000000146 Residual 10 22149 21856 2214 22 11 679349107 Tour Click to Schoont Clio Alarm @ so # 3 $ 4 % 5 7 2 6 Q W E R . Y A S D F G H cops lock Z N. M Question Completion Status: A staff assistant has run regression analyses on the data and obtained the following output using Excel REGRESSION ANALYSIS: Y (Dependent) Variable = Maintenance Cost: X (Independent) Variable = Maintenance Hours Regression Statistics R 0.998210294 R Square 0.996423791 Adjusted R Square 0.99606617 Standard Error 47.0629563 Observations 12 ANOVA Regression Residual Total ds SS MS F Significance F 1 6171342.448 6171342 2786.257 0.000000000000144 10 22149.21856 2214.922 11 6193491.667 Coefficients Standard Error Stat p-value Lower 95% Upper 95% 783.7782188 68.34114772 11.46861 4.47E-07 631.504653 936.051785 6.777102456 0.12839066 52.78501 1.44E-13 6.491030239 7.06317467 Intercept Hours The p-value is a measure of: The linearity in the data. The accuracy of the regression predictions The reliability of the independent variable. The precision of the regression

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The Budget Bible Budgeting Made Simple

Authors: Jessica Charise Brant, Adrienne Homet Hand

979-8218059880

More Books

Students also viewed these Accounting questions

Question

Differentiate between criminal action and civil action.

Answered: 1 week ago

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago

Question

Explain the testing process of accounting 2?

Answered: 1 week ago