Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 = 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
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