Application of Number Assignment

Only available on StudyMode
  • Download(s) : 59
  • Published : January 17, 2012
Open Document
Text Preview
Task One: Gather, present and interpret data for a purpose

The purpose of my task is to compare daily website traffic to the daily sales conversion rate over the month of June for a newly established sales campaign. With this information I can identify whether the projected conversion rate percentage has been forecast accurately. This information will also be used as the control sample data to base future sale trends on.

w/c |Visitors / Sales |Mon |Tues |Wed |Thurs |Fri |Sat |Sun |Week Total | |01/06/11 |V |- |- |5 |1 |4 |1 |4 |15 | | |S |- |- |2 |0 |1 |0 |2 |5 | |06/06/11 |V |3 |2 |1 |5 |1 |1 |1 |14 | | |S |2 |1 |0 |2 |0 |0 |0 |5 | |13/06/11 |V |5 |2 |4 |3 |1 |2 |0 |17 | | |S |2 |0 |2 |1 |0 |1 |0 |6 | |20/06/30 |V |3 |3 |7 |6 |4 |4 |0 |27 | | |S |1 |2 |3 |2 |0 |0 |0 |8 | |27/06/11 |V |1 |4 |6 |4 |- |- |- |15 | | |S |0 |2 |3 |0 |- |- |- |5 | | | | | | | |Total visitors |88 | | | | | | | |Total Sales |29 | |

Mean:

The average (mean) number of daily visitor traffic is 3

(total amount of data adds up to 88, then divided this total by the number of data sets, 30. 88 divided by 30, equals 2.93, which I rounded up to 3.)

The average (mean) number of daily sales is 1

(total amount of sales data adds up to 29, then divided this total by the number of data sets, 30. 29 divided by 30, equals 0.96, which I rounded up to 1.)

Median:

The average (median) number of daily visitor traffic is 3

0 |0 |1 |1 |1 |1 |1 |1 |1 |1 |2 |2 |2 |3 |3 |3 |3 |4 |4 |4 |4 |4 |4 |4 |5 |5 |5 |6 |6 |7 | |(Values arranged in ascending order, 3 is the value in the middle of the series)

The average (median) number of daily sales is 1

0 |0 |0 |0 |0 |0 |0 |0 |0 |0 |0 |0 |0 |0 |1 |1 |1 |1 |1 |2 |2 |2 |2 |2 |2 |2 |2 |2 |3 |3 | |(As there is an even number of data (30) there is not one number which falls exactly in the middle, so I take the two middle numbers 0 and 1, add them together, equals 1, which is the divided by two. In this case we get a median of 0.5, which I have rounded up to 1)

Mode:

The most common number of daily visitor traffic is 1

(This value occurs 8 times)

The most common number of daily sales is 0

(This value occurs 14 times)

Range:

Visitor traffic range is 7

(This is the highest value minus the lowest value, 7 – 0)

Daily sales range is 3

(This is the highest value minus the lowest value, 3 – 0)

Data Interpreted

Based on the mean and median average figures our current sales conversion rate is approximately 33%. The mode data suggests that we need to increase traffic as we are only receiving 1 visitor a day. The range suggests that we need to increase advertising budget on Wednesdays when we seem to get most traffic and sales. This will increase the traffic resulting in more sales.

Column Graph:

[pic]

Interpreting graph data:

It is evident that towards the end of the month that there was an increase in the amount of daily visitors. This could be as a result of the sales campaign marketing strategy. It should also be noted that although there was an increase in visitor traffic there was not an increase in sales. It could possibly mean that the marketing channels of the sales campaign is not targeted correctly and might need a different approach, however, more data will need to be collected to be certain.

Pie Graph

[pic]

[pic]

Interpreting graph data:

It is evident when comparing the two pie graphs that Monday to Thursday are the busiest periods of the week. Wednesdays are particularly busier when we receive the most visitors (26%) and make the most sales (35%). The sales made on Mondays, Tuesdays and Thursdays are even which implies stable trade on those days. For now we should continue to monitor the progress of sales and perhaps implement strategies to increase sales on Saturdays as the conversion rate appears to be lower.

Fractions

Day Trends
June 11 |Monday |Tuesday |Wednesday |Thursday |Friday |Saturday |Sunday |Total | |Visitors |12 |11...
tracking img