Mickypapneja
Management Consultant
+2 Others

PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Hi All, Can anybody Explain me how to Make Sales Forecast by using Regression Analysis ?
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hi Rajwan,
While searching online for regression analysis, I find it this link http://www.duke.edu/~rnau/regex.htm. Please check whether it works or not?
Hi Mickypapneja,
Thanks for Sending a Valuable Links.
Again I am sending you State Wise Sales For F.Y. - 2010-2011. Now i want to make Sales Forecast for FY-2011-2012. Please Let me know how to do it ?
Regards,
Rajwant

Attached Files
Membership is required for download. Create An Account First
File Type: xls Data.xls (91.0 KB, 2767 views)

sorry, Wrong File was attached.
Please assist me for making forecast by Using regression Analysis.
However, Attached file is having State Wise Sale for FY.-2010-2011 on which basis I want to prepare Forecast for FY.-2011-2012.
Regards,
Rajwant

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sale.xls (23.0 KB, 2170 views)

Hi Rajwant, I don’t have the deep knowledge of regression analysis. It may effect your result. So,its better to contact a Statistics head or analyst.
Sales for Retail Day to Day Sales is enclosed but file to be opened in Open Office.org as in exel the column wigth changes and the file size is more

Attached Files
Membership is required for download. Create An Account First
File Type: zip Sales Report 2011 one.zip (105.4 KB, 1793 views)

Hey mohammed this file is password protected can u plz assist me how to open this valuable file..?
Hi you need no password just type the establishment name next go to other sheet or click the month which you want to enter the sales and this will automatically give the graph and the average and the percentage of growth. If you cant enter the old or the past month full sale at least enter the total sales of that month in the first day so it can give the proper growth in the present month
Sales for Retail Day to Day Sales is enclosed but file to be opened in Open Office.org as in exel the column wigth changes and the file size is more very useful files to monitor day wise growth comparing to last month till date and average sales and average day wise growth only pertaining to single shop, establishment, branch - only needed to enter is the sale amount figure of that day

Attached Files
Membership is required for download. Create An Account First
File Type: zip Sales Report 2012 one.zip (111.1 KB, 1040 views)

Regression analysis is a statistical technique for quantifying the relationship between variables. In simple regression analysis, there is one dependent variable (e.g. sales) to be forecast and one independent variable. The values of the independent variable are typically those assumed to "cause" or determine the values of the dependent variable. Thus, if we assume that the amount of advertising dollars spent on a product determines the amount of its sales, we could use regression analysis to quantify the precise nature of the relationship between advertising and sales. For forecasting purposes, knowing the quantified relationship between the variables allows us to provide forecasting estimates.
The simplest regression analysis models the relationship between two variables uisng the following equation: Y = a + bX, where Y is the dependent variable and X is the independent variable. Notice that this simple equation denotes a "linear" relationship between X and Y. So this form would be appropriate if, when you plotted a graph of Y and X, you tended to see the points roughly form along a straight line (as compared to having a curvilinear relationship).
When you have several past concurrent observations of Y and X, regression analysis provides a means to calculate the values of a and b, which are assumed to be constant. Since you will then know a and b, if you can provide an estimate of X in some future period, you can calculate a future value of Y from the above equation.
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™