Answered step by step
Verified Expert Solution
Question
1 Approved Answer
it's in excell Cost Behavior Excel Assignment Manufacturing Activity Activity Activity Year Overhead Driver 1 Driver 2 Driver 3 2004 3,907,798 2.643 258 33,728 2005
it's in excell
Cost Behavior Excel Assignment Manufacturing Activity Activity Activity Year Overhead Driver 1 Driver 2 Driver 3 2004 3,907,798 2.643 258 33,728 2005 2,462,601 2.965 41929,687 2006 3,847,844 2,111 649 25,168 2007 2,063,935 3,062 193 17,369 2008 5,403,216 5,537 577 19,652 2009 3,733,094 1,760 615 35,599 2010 3,570,411 6,757 761 50,425 2011 4,562 443 3,549 540 43,178 2012 4,976,550 6,508 898 42,029 2013 4,141,884 3,727 826 21,650 2014 6,477,383 1,861 980 40,324 2015 1,869,712 2,521 662 39,154 2016 2,089,899 3,752 296 50,757 2017 4,384,399 2,113 70930,512 2018 1,272,778 2,549 942 17,394 2019 1,466,634 1,972 249 15,600 Instructions: Remember to answer all 7 requirements below in the yellow space provided. Submit answers in Top Ha points. See the cost behavior example, lecture notes, and lecture slides for help if you get stuck along the way Requirements: 1) Use Excel to regress Manufacturing Overhead on Activity Driver 1 and Activity Driver 2. Label your new tab "Moc Hint You regress a dependent variable on an independent variable(s). 2) Use Excel to regress Manufacturing Overhead on Activity Driver 1 Label your new tab "Model 2" 3) Une Excel to regress Manufacturing Overhead on Activity Driver 2. Label your new tab "Model 3". 4) Which is the best model? Why? Make sure to write out the regression equation for the best model 5) In step 4. you selected the best model. Now use your statistical output to interpret this model? Hint: What does the model tell you about the relationships between the variables? 6) Activity Driver 1-525 and Activity Driver 2 - 3.100. what is the expected Manufacturing Overhead? Expected Manufacturing Overhead = 7) Build a 90% Confidence Interval for the expected Manufacturing Overhead. 90% Confidence Inverval =Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started