Dissertation Creation - The UK's original provider of custom dissertations and dissertation help...

Free Dissertations - Statistics Dissertations

2 Of The Total Sales Of The Yogurt, Followed By The Frequent Client, With ...

2 of the total sales of the yogurt, followed by the Frequent client, with 323.4 and then the Spender with 250.6. Again, the uncertain client adds 82.5 to the total sales, if this were during a special offer it would be in addition to the 97 for the special offer. (Note that this variable is only significant at 10%)
The regression results are shown below, with Best, Frequent and Spender variables statistically significant at all levels, Offers statistically significant at the 5% level and Uncertain at 10%:
Dependent Variable: TOTSALESYOG

Method: Least Squares

Sample: 1 16

Included observations: 16

Variable
Coefficient
Std. Error
t-Statistic
Prob.

OFFERS
97.90417
43.96980
2.226623
0.0478

BEST
480.2240
39.63384
12.11651
0.0000

FREQUENT
323.3665
39.63384
8.158847
0.0000

SPENDER
250.6415
39.63384
6.323925
0.0001

UNCERTAIN
82.49146
39.63384
2.081339
0.0616

R-squared
0.847965
 Mean dependent var
308.6569

Adjusted R-squared
0.792680
 S.D. dependent var
167.2610

S.E. of regression
76.15793
 Akaike info criterion
11.75380

Sum squared resid
63800.33
 Schwarz criterion
11.99524

Log likelihood
-89.03042
 F-statistic
15.33800

Durbin-Watson stat
2.149016
 Prob(F-statistic)
0.000179


The third product analysed is a Fruit Cocktail, which has a normal price of 0.95 per unit vs the offer price of 0.65. Analysing the raw data, all of the categories had the same average sale amount of 0.95 when it was at its normal price and increased it to 0.97 when it was on offer (assumes an average of 1.5 units per sale during the special offer).
FRUITOTSAL = 21.35083333*OFFERS + 240.9247917*BEST + 134.9797917*FREQUENT + 146.2372917*SPENDER + 68.37479167*UNCERTAIN
Total sales as a result of there being a special offer is 21.35. The lowest of all the products analysed. However, the way each category contributes to total sales differs from the products before. Here Spenders have a larger impact than Frequent buyers, with 146.2 of total sales vs 135 for Frequent. The Best category always has the largest impact on total sales with 240.9 and the Uncertain buyers the least with 68.4.
The regression results below show that all of the estimated parameters are statistically significant at all levels, except for Offers, which is statistically significant at the 5% level:
Dependent Variable: FRUITOTSAL

Method: Least Squares

Sample: 1 16

Included observations: 16

Variable
Coefficient
Std. Error
t-Statistic
Prob.

OFFERS
21.35083
8.399803
2.541826
0.0274

BEST
240.9248
7.571480
31.82004
0.0000

FREQUENT
134.9798
7.571480
17.82740
0.0000

SPENDER
146.2373
7.571480
19.31423
0.0000

UNCERTAIN
68.37479
7.571480
9.030572
0.0000

R-squared
0.963781
 Mean dependent var
152.

Please note: The above dissertation snippet was written by a student and then submitted to us to display and help others. Thanks to all the students who have submitted their work to us.