ASSIGNMENT ON WEB ANALYSIS.
NAME ABDUL HAQ
GROUP B
MBA (1.5) FINANCE
Introduction
The following date are taken from Quality Alloys Company which is about web analysis.
Company is trying to lunch a website and promote it through different web sites. The following
date were taken in four time period initial time period, pre promotion ,promotion and post
promotion time period.to see sites performance that which one sites is useful for coming
promotions.differnt variables have been used for it to analysis which are visits, unique visits,
average pages views, revenue ,profit etc.They are the four column charts for visits over time,
unique visits, revenue profit, and lbs. sold over time respectively.
Chat.1 column for visits, uniqe visits, reveue, profit and lbs. Sold over time respectively.
35000000
30000000
25000000
20000000
15000000
10000000
5000000
0
visits unique vists revenue profit lbs slod
Series 1 Column2 Column1
Visits
Unique visits 65287
Revenue 32699058
profit 9959290
Lbs. sold 1144579
The following are the summarized statistics for visits, unique visits, revenue, profit, and pound sold.
Mean, min, max, stdev for initial, pre-promotion, promotion and post promotion periods.
Table 1. VISIT AND FINANCIAL SUMMARY MEASURES-INITIAL PERIOD
Visits Unique Visits Revenue Profit Lbs. Sold
Mean 1055 976 608250 200233 18737
Median 899 846 586170 208913 17270
Std.dev. 355.03 391.59 155930.4 60691.55 5427.39
minimum 626 594 274568 62580 8633
maximum 1632 1509 890077 275218 28053
Table 2. VISIT AND FINANCIAL SUMMARY MEASURES-FOR PRE PROMOTION PERIOD
Visits Unique Visits Revenue Profit Lbs. Sold
Mean 562.95 516.80 534314 159932 18441
Median 558 510 534542 152476 17215
Std.dev. 80.87 70.93 150502.8 42682.68 5965.63
minimum 383 366 315647 100388 8992
maximum 795 734 951216 273175 31969
Table 3. VISIT AND FINANCIAL SUMMARY MEASURES- PROMOTION PERIOD
Visits Unique Visits Revenue Profit Lbs. Sold
Mean 1814 1739 456399 131930 17113
Median 1663 1585 413937 114328 17299
Std.dev. 758.102 734.02 161741.1 47776.85 6519.07
minimum 1000 930 268160 81841 7814
maximum 3726 3617 897164 266477 31496
Table 4. VISIT AND FINANCIAL SUMMARY MEASURES-POST PROMOTION PERIOD
Visits Unique Visits Revenue Profit Lbs. Sold
Mean 856.571 800.78 371728 111046 14578
Median 847.5 800 348397 104530 13647
Std.dev. 70.88 72.35 145728.3 49065.27 4941.556
minimum 772 709 133967 32825 3826
maximum 963 912 615950 206950 23762
Q 3.column chat of the mean visits over the four periods.
Chat.2
column chat of the mean visits over the four periods.
608250 855671
1000000 534314
456399
371728
800000 18737 14578
200233 18441 17113
600000 131930
159932 111046
l…
400000 p…
976
516.8
200000 1739 r…
1055 800.78
562.95
0 1814 u…
initial
pre promo v…
promotion
post prom
visits unique visits revenue profit lbs.sold
Analysis
The above chat show that an initial period revenue were higher and the number of visits, unique visits
although not too much higher. During this period profit were higher than the other periods. This also
mean that QA generate more profit during this period.
Q5. SCATTER DIAGRAM BETWEEN REVENUE AND LBS SOLD
Chat.3
Lbs. Sold
1000000
900000
800000
700000
600000
500000
400000
300000
200000
100000
0
$0 $10 $20 $30 $40 $50 $60 $70 $80
CORRELATION between revenue and lbs. sold
Correlation 0.86893
Q6.SCATTER DIGRAM BETWEEN REVENUE VS VISTS
Chat 4
Revenue
$1,000,000
$900,000
$800,000
$700,000
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
$0
0 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000
Correlation between revenue and visits.
correlation -0.05939
Q7 summarized above.
The above scatter diagram show that the revenue and pound sold are 86% correlated which show that
when pound sold increase the revenue also increase. There are 86% probability that revenue will increase.
On other hand if we look correlation between revenue and number of weekly visits is totally opposite to
the above which means that they are not co related with each other. -0.05 correlation show that there is –
5% chances that when number of visits increase the revenue will also increase.
Q8.the following are summary of pound of materials sold per week from January 3, 2004 through week of
July 19, 2010.
Table 5
Mean 18,682
Median 17,673
Stud dev 6840.508
Min 3,826
Max 44,740
Q=9 analysis outside for number of daily visits to the QA website over the period MAY 25, 2008-
AUGUST 29, 2009.
Daily visits
Table6
Mean 150.2835
Standard error
Median 122
Mode 91
Stud dev 98.16949
Variance 9637.249
kurtosis 5.86199
skewness 2.166972
Range 627
Min 37
Max 664
sum 69431
count 462
ALL TRAFFIC SOURCE Table and graph
Table 7
All traffic sources
Referring sites 38754
Search engines 20964
Direct traffic 9709
other 4
Graph 5
ALL TRAFFIC SOURCE
referring search engines direct traffic other
Top Ten Referring Site
Table 8
googleads.g.doubleclick.net 15626
pagead2.googlesyndication.com 8044
sedoparking.com 3138
globalspec.com 693
searchportal.information.com 582
freepatentsonline.com 389
thomasnet.com 379
mu.com 344
mail.google.com 337
psicofxp.com 310
Graph 6
Top Ten Referring Sites
googleads.g.doubleclick.net pagead2.googlesyndication.com sedoparking.com
globalspec.com searchportal.information.com freepatentsonline.com
thomasnet.com mu.com
Psicofxp.com
