Hi All, Can anybody Explain me how to Make Sales Forecast by using Regression Analysis ?
From India , Delhi
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?

From India , Patna
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

From India , Delhi

Attached Files (Download Requires Membership)
File Type: xls Data.xls (91.0 KB, 2824 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

From India , Delhi

Attached Files (Download Requires Membership)
File Type: xls Sale.xls (23.0 KB, 2224 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.
From India , Patna
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
From India , Madras

Attached Files (Download Requires Membership)
File Type: zip Sales Report 2011 one.zip (105.4 KB, 1830 views)

Hey mohammed this file is password protected can u plz assist me how to open this valuable file..?
From India , Bangalore
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
From India , Madras
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
From India , Madras

Attached Files (Download Requires Membership)
File Type: zip Sales Report 2012 one.zip (111.1 KB, 1068 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.

From India,

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server