Thane Company is interested in establishing the relationship…
Questions
Thаne Cоmpаny is interested in estаblishing the relatiоnship between electricity cоsts 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,900 $ 18,600 February 3,300 21,400 March 2,300 13,700 April 3,500 23,400 May 4,200 28,450 June 3,700 22,400 July 4,500 24,950 August 3,900 22,950 September 2,400 15,900 October 4,100 26,400 November 5,300 31,400 December 4,900 27,950 Summary Output Regression Statistics Multiple R 0.959 R Square 0.920 Adjusted R2 0.912 Standard Error 1,550.32 Observations 12.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 2,992.80 1,933.78 1.55 0.15 (1,315.92) 7,301.52 Machine-Hours 5.37 0.50 10.70 0.00 4.25 6.49 What is the percent of the total variance that can be explained by the regression?