Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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

Key Concepts In Primary Science Audit And Subject Knowledge

Authors: Vivian Cooke, Colin Howard

1st Edition

1910391506, 978-1910391501

More Books

Students also viewed these Accounting questions

Question

Enhance the basic quality of your voice.

Answered: 1 week ago

Question

Describe the features of and process used by a writing team.

Answered: 1 week ago