Submitted by: Submitted by pranitasingh
Views: 360
Words: 740
Pages: 3
Category: Business and Industry
Date Submitted: 04/21/2011 10:11 PM
MODERN TRADE: We are applying regression analysis to identify which factor has the maximum impact over the sales in MODERN trade. The factors that are taken as independent or explanatory variables are- advertisement; schemes and no. of outlets. Here sale is the dependent variable.
The regression equation is as follows-
Y = α+ β1X1+ β2X2+ β3X3+µ
Sales = α+ β1 (advertisement) + β2 (schemes) + β3 (outlets) + µ.
|modern trade |
|Year |Sales |advertisement |discount |outlets |
|2001 |58212000 |2000000 |1595510 |4 |
|2002 |65849520 |2200000 |1771188 |6 |
|2003 |72841560 |2398000 |2083751 |7 |
|2004 |80044800 |2625810 |2451472 |9 |
|2005 |89291400 |2888391.2 |2884085 |11 |
|2006 |96759960 |3177230 |3393041 |15 |
|2007 |140139120 |3463180.8 |3991813 |19 |
|2008 |182740800 |38094988.8 |4696250 |21 |
|2009 |243979560 |41904487.68 |5525000 |23 |
|2010 |274789680 |46094936.44 |6500000 |25 |
INTERPRETATION:
|Model Summary |
|Model |R |R Square |Adjusted R Square |Std. Error of the |
| | | | |Estimate |
|1 |.993a |.986 |.979 |1.129E7 |
|a. Predictors: (Constant), OUTLETS, ADVERTISEMENT, DISCOUNT...