Statistical Analysis of QA Website Performance and Web Analytics

This report presents a statistical analysis of QA's website performance over time, examining key metrics such as unique visits, revenue, profit, and pounds sold. The analysis covers an initial period, a pre-promotion period, a promotion period, and a post-promotion period. Charts and tables visualize trends in website visits, revenue, and profit. The report finds that while website visits were high during the promotion period, revenue and profit did not show a corresponding increase. The correlation between revenue and pounds sold is also analyzed, revealing a strong positive relationship. The report concludes with recommendations for QA to explore alternative advertising strategies and consider enabling online ordering to capitalize on website traffic. Desklib offers this and other solved assignments to aid students.

Statistics
Statistics visualization
Student name:
Tutor name:
1 | P a g e

Statistics
Executive summary
Just like any other business QA company in its operations faces competition from other
companies that are producing similar products. In order for it to increase sales by widening its
market, it established a website where clients could know more about the company. Various
records were kept about what happened in the website over a period of time. This information
was analyzed and presented in form of tables and graphs. The results showed that number of
unique visits to the website was high between February and March. However, revenue and the
number of pounds sold over the period seemed not to improve. This was evident as profits were
only high during the pre-promotion period after which it reduced. The research recommends to
the management of QA to come up with other advertising avenues other than the website to drive
sales. They should also allow customers to place orders through the website as the research has
established that there are many people who visit the website.
2 | P a g e

Statistics
Number 1
Summary statistics
Chart of Unique visits to QA website every week
May 25 - May 31
Jun 15 - Jun 21
Jul 6 - Jul 12
Jul 27 - Aug 2
Aug 17 - Aug 23
Sep 7 - Sep 13
Sep 28 - Oct 4
Oct 19 - Oct 25
Nov 9 - Nov 15
Nov 30 - Dec 6
Dec 21 - Dec 27
Jan 11 - Jan 17
Feb 1 - Feb 7
Feb 22 - Feb 28
Mar 15 - Mar 21
Apr 5 - Apr 11
Apr 26 - May 2
May 17 - May 23
Jun 7 - Jun 13
Jun 28 - Jul 4
Jul 19 - Jul 25
Aug 9 - Aug 15
0
500
1,000
1,500
2,000
2,500
3,000
3,500
4,000
Chart 1. of Unique Visits
Figure 1
The bar chart in figure 1 shows visits to QA website every week over the period shown. It can be
seen that the number of unique visits to the site was top most between February 1st and April 11th
2009. After this period the number took a reducing trend till august 15th 2009.
3 | P a g e

Statistics
Revenue over time per week
May 25 - May 31
Jun 22 - Jun 28
Jul 20 - Jul 26
Aug 17 - Aug 23
Sep 14 - Sep 20
Oct 12 - Oct 18
Nov 9 - Nov 15
Dec 7 - Dec 13
Jan 4 - Jan 10
Feb 1 - Feb 7
Mar 1 - Mar 7
Mar 29 - Apr 4
Apr 26 - May 2
May 24 - May 30
Jun 21 - Jun 27
Jul 19 - Jul 25
Aug 16 - Aug 22
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
Figure 2. Revenue over time per
week
Figure 2
The amount of revenue over the period every week as can be observed has almost a constant
distribution. No particular period is higher or lower than the other.
Profit over time per week
May 25 - May 31
Jun 22 - Jun 28
Jul 20 - Jul 26
Aug 17 - Aug 23
Sep 14 - Sep 20
Oct 12 - Oct 18
Nov 9 - Nov 15
Dec 7 - Dec 13
Jan 4 - Jan 10
Feb 1 - Feb 7
Mar 1 - Mar 7
Mar 29 - Apr 4
Apr 26 - May 2
May 24 - May 30
Jun 21 - Jun 27
Jul 19 - Jul 25
Aug 16 - Aug 22
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Fig. 3. Profit over time per week
Figure 3
It can be observed from figure 3 that the profit every week for the period has a generally
reducing trend from the beginning of the period to the end.
4 | P a g e

Statistics
Pounds over time per week
May 25 - May 31
Jun 22 - Jun 28
Jul 20 - Jul 26
Aug 17 - Aug 23
Sep 14 - Sep 20
Oct 12 - Oct 18
Nov 9 - Nov 15
Dec 7 - Dec 13
Jan 4 - Jan 10
Feb 1 - Feb 7
Mar 1 - Mar 7
Mar 29 - Apr 4
Apr 26 - May 2
May 24 - May 30
Jun 21 - Jun 27
Jul 19 - Jul 25
Aug 16 - Aug 22
0
5,000
10,000
15,000
20,000
25,000
30,000
35,000
Fig. 4. Lbs. Sold overtime per week
Figure 4
The amount of pounds sold over the period every week as can be observed has almost a constant
distribution. No particular period is higher or lower than the other.
Number 2
Descriptive of visits - initial period
Visits
Unique
visits Revenue Profit
Lbs.
Sold
Mean 1,055 976 608,250 200,233 18,737
Median 899 846 586,170 208,913 17,270
Std. dev
355.033
3
319.597213
9
155930.39
7
60691.5
5
5427.39
3
Minimu
m 626 594 274,568 62,580 8,633
Maximu
m 1,632 1,509 890,077 275,218 28,053
Table 1
Descriptive of visits – Pre-promotion period
Visits
Unique
visits Revenue Profit
Lbs.
Sold
Mean 563 517 534,314 159,932 18,441
Median 558 510 534,542 152,476 17,215
Std. dev 80.8711 70.9391422 150502.8 42682.6 5965.6
5 | P a g e

Statistics
8 6 2 8 3
Minimu
m 383 366 315,647 100,388 8,992
Maximu
m 795 734 951,216 273,175 31,969
Table 2
Descriptive of visits – Promotion period
Visits
Unique
visits Revenue Profit
Lbs.
Sold
Mean 1,814 1,739 456,399 131,930 17,113
Median 1,663 1,585 413,937 114,328 17,299
Std. dev
758.101
7 743.025339
161741.09
9
47776.8
5
6519.07
1
Minimu
m 1,000 930 268,160 81,841 7,814
Maximu
m 3,726 3,617 897,164 266,477 31,496
Table 3
Descriptive of visits – Post promotion period
Visits
Unique
visits Revenue Profit
Lbs.
Sold
Mean 857 801 371,728 111,046 14,578
Median 848 800 348,397 104,530 13,647
Std. dev
70.8885
5
72.3561475
5
145728.33
4
49065.2
7
5941.55
6
Minimu
m 772 709 133,967 32,825 3,826
Maximu
m 963 912 615,950 206,441 23,762
Table 4
Number 3
Mean
Means
Visits
Unique
visits
Revenu
e Profits
Lbs.
Sold
Initial 1,055 976 608,250 200,233 18,737
Pre-
promotion
562.952
4
516.809523
8
534313.
5 159932
18440.7
7
6 | P a g e

Statistics
Promotion 1,814 1,739 456,399 131,930 17,113
Post-
proportion
856.571
4
800.785714
3 371728
111045.
8
14577.7
9
Table 5
Number 4
Discussion
Initial period
Table 1 gives measures of central tendency and dispersion about the number of visits to QA
website. The mean visit was 1055 while the median was 899. The standard deviation was 355.03.
The maximum and the minimum visits were 626 and 1632 in that order. When it comes to
unique visits, the mean was 976 while the median was 846. The standard deviation was 319.597.
The maximum and the minimum visits were 694 and 1509 in that order. The mean revenue per
week was 608250 while the median was 586170. The standard deviation was 155930.397. The
maximum and the minimum visits were 274568 and 890077 in that order. The mean and median
profit for every week is 200233 and 208913 in that order. The mean number of pound sold was
18737 while the median was 17270. The standard deviation was 5427.39. The maximum and the
minimum visits were 8633 and 28053 in that order.
Pre-promotion period
Table 2 gives measures of central tendency and dispersion about the number of visits to QA
website. The mean visit was 553 while the median was 558. The standard deviation was 80.87.
The maximum and the minimum visits were 383 and 795 in that order. When it comes to unique
visits, the mean was 517 while the median was 510. The standard deviation was 70.93. The
maximum and the minimum visits were 366 and 734 in that order. The mean revenue per week
was 534314 while the median was 534542. The standard deviation was 150502.82. The
maximum and the minimum revenue were 274568 and 890077 in that order.
Promotion period
Table 3 gives measures of central tendency and dispersion about the number of visits to QA
website. The mean visit was 1814 while the median was 1663. The standard deviation was
7 | P a g e

Statistics
758.10. The maximum and the minimum visits were 1000 and 3726 in that order. When it comes
to unique visits, the mean was 1739 while the median was 1585. The standard deviation was
743.02. The maximum and the minimum visits were 930 and 3617 in that order. The mean
revenue per week was 456399 while the median was 413937. The standard deviation was
161741.099. The maximum and the minimum visits were 268160 and 897164 in that order. The
mean and median profit for every week is 131930 and 114328 in that order. The mean number of
pound sold was 17113 while the median was 17229. The standard deviation was 6519.07. The
maximum and the minimum visits were 7814 and 28053 in that order.
Post-promotion period
Table 4 gives measures of central tendency and dispersion about the number of visits to QA
website. The mean visit was 857 while the median was 848. The standard deviation was 70.89.
The maximum and the minimum visits were 772 and 963 in that order. When it comes to unique
visits, the mean was 801 while the median was 800. The standard deviation was 72.35. The
maximum and the minimum visits were 709 and 912 in that order. The mean revenue per week
was 371728 while the median was 348397. The standard deviation was 145728.33. The
maximum and the minimum visits were 133967 and 615950 in that order. The mean and median
profit for every week is 111046 and 104530 in that order. The mean number of pound sold was
14578 while the median was 13647. The standard deviation was 5941.56. The maximum and the
minimum visits were 3826 and 23762 in that order.
Means
Table 5
It can be watched from table 5 that the average number of visits amid the initial, pre-promotion,
advancement and post advancement periods were 1055, 562.95, 1814 and 856.57. The cruel
number of interesting visits amid the beginning, pre-promotion, promotion and post
advancement periods were 976, 516.81, 1739 and 800.79. The cruel number of income amid the
beginning, pre-promotion, advancement and post promotion periods were 608250, 53431.5,
456339 and 371728. The average number of benefits at the initial, pre-promotion, promotion and
post-promotion periods were 200233, 159932, 131930 and 111045.8. In conclusion, the cruel
number of pounds sold amid the introductory, pre-promotion, advancement and post
advancement periods were 18737, 18440.77, 17113 and 14577.79
QUESTION FIVE
8 | P a g e

Statistics
Relationship between revenue and pounds sold.
Revenu
e
Lbs.
Sold
Revenue 1
Lbs.
Sold
0.86893 1
Table 6
The correlation between revenue and Lbs sold is 0.86 indicating a strong relationship.
Scatterplot: Revenue and pounds
0 5,000 10,000 15,000 20,000 25,000 30,000 35,000
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
f(x) = 24.5679059575216 x + 69380.9472593738
R² = 0.755038845893767
Scatterplot of revenue vs pounds sold
Pounds sold
Revenue
Figure 5
Number 6
Correlation
Visits Revenue
Visits 1
9 | P a g e

Statistics
Revenu
e
-0.0593 1
Table 7
Scatterplot: Revenue and visits
0 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
f(x) = − 15.970543633977 x + 512241.046258343
R² = 0.00352738952999587
Scatterplot of revenue and visits
Visits
Revenue
Figure 6
There is a negative a negative correlation between revenue and visits. The correlation coefficient
was -0.06. This means that the two variables are negatively correlated.
Number 7
Summary of results
The correlation between revenue and Lbs sold is 0.86 indicating a strong relationship.
There is a negative a negative correlation between revenue and visits. The correlation coefficient
was -0.06. This means that the two variables are negatively correlated.
10 | P a g e

Statistics
Question 8
a. Descriptive statistics for Lbs.
Results
Lbs. Sold
Mean
18681.5551
7
Median 17673
Standard
Deviation 6840.50794
Minimum 3826
Maximum 44740
Table 8
The descriptive statistics are as seen in the table above. The mean was 18681.56 and the median
was 17673. The standard deviation was 6840.51. The minimum Lbs. sold was 3826 while the
maximum Lbs sold was 44740.
11 | P a g e

Statistics
b. Histogram for Lbs. sold
Figure 7
c. The Lbs sold were normally distributed as can be observed from figure 7 above.
d. The empirical rule table
Results
Interval
Theoretical %
of data
Theoretical no. of
observations
Actual no. of
observations
Mean ± 1 standard
deviation 68% 197 201
Mean ± 2 standard
deviation 95% 276 276
Mean ± 3 standard
deviation 99% 287 288
Table 9. The values in the table have been rounded off to nearest whole number.
e. Refined analysis
Interval
Theoretical no. of
obs Actual no. of obs
12 | P a g e