Question: 5. Regression Analysis Method (Assignment No. 1) Y=a+bx Where, y = Working capital (dependent variable) a=intercept of the least square b=slope of the regression line

 5. Regression Analysis Method (Assignment No. 1) Y=a+bx Where, y =

5. Regression Analysis Method (Assignment No. 1) Y=a+bx Where, y = Working capital (dependent variable) a=intercept of the least square b=slope of the regression line x=Sales (independent variable) For determining the values 'a' and 'b'two normal equations are used which can be solved simultaneously: The sales and working capital figures of Revilla Ltd. for a period of 5 years are given as follows: Year Sales (in '000) 2013 Working Capital ('000) 12 15 20 2014 60 80 120 130 160 2015 21 2016 2017 23 You are required to forecast the working capital requirements of the company for the year 2020 taking the estimated sales of 200. The relationship between sales working capital can be represented by: y = a +bx Year X2 Sales (in '000) (x) 60 WC ('000) (y) 12 2015 80 15 120 2016 2017 2018 2019 130 160 20 21 23

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!