Homework Help is Here – Start Your Trial Now!
Business
Accounting
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:   Month Machine Hours Electricity Costs January 2,500 $ 18,400   February 2,900   21,000   March 1,900   13,500   April 3,100   23,000   May 3,800   28,250   June 3,300   22,000   July 4,100   24,750   August 3,500   22,750   September 2,000   15,500   October 3,700   26,000   November 4,700   31,000   December 4,200   27,750        Summary Output Regression Statistics Multiple R 0.965 R Square 0.932 Adjusted R2 0.925 Standard Error 1,425.18 Observations 12.00     Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 3,726.88 1,682.82 2.21 0.05 (22.69) 7,476.45 Machine Hours 5.77 0.49 11.7 0.00 4.67 6.87   The percent of the total variance that can be explained by the regression is:   Multiple Choice   98.2%.   93.2%.   92.5%.   96.5%.

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:   Month Machine Hours Electricity Costs January 2,500 $ 18,400   February 2,900   21,000   March 1,900   13,500   April 3,100   23,000   May 3,800   28,250   June 3,300   22,000   July 4,100   24,750   August 3,500   22,750   September 2,000   15,500   October 3,700   26,000   November 4,700   31,000   December 4,200   27,750        Summary Output Regression Statistics Multiple R 0.965 R Square 0.932 Adjusted R2 0.925 Standard Error 1,425.18 Observations 12.00     Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 3,726.88 1,682.82 2.21 0.05 (22.69) 7,476.45 Machine Hours 5.77 0.49 11.7 0.00 4.67 6.87   The percent of the total variance that can be explained by the regression is:   Multiple Choice   98.2%.   93.2%.   92.5%.   96.5%.

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

 

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:
  

Month Machine Hours Electricity Costs
January 2,500 $ 18,400  
February 2,900   21,000  
March 1,900   13,500  
April 3,100   23,000  
May 3,800   28,250  
June 3,300   22,000  
July 4,100   24,750  
August 3,500   22,750  
September 2,000   15,500  
October 3,700   26,000  
November 4,700   31,000  
December 4,200   27,750  
 

  

Summary Output
Regression Statistics
Multiple R 0.965
R Square 0.932
Adjusted R2 0.925
Standard Error 1,425.18
Observations 12.00

 

  Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 3,726.88 1,682.82 2.21 0.05 (22.69) 7,476.45
Machine Hours 5.77 0.49 11.7 0.00 4.67 6.87

  
The percent of the total variance that can be explained by the regression is:

 

Multiple Choice
  •  

    98.2%.

  •  
    93.2%.
  •  

    92.5%.

  •  

    96.5%.

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS