Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

Posted on 2013-05-13
Medium Priority
301 Views
Hi Guys,
Im trying to figure out from my intranet traffic and news letter sign ups, the sign up ratio between Cellphone and Desktop in Excel.

I need a formula that calculates for every X cellphone visits I get 1 newsletter signup and for every X desktop visits I get 1 newsletter signup.

I would have something like this "Every 10 cellphones visits = 1 newsletter signup" and "Every 5 Desktop = 1 newsletter signup"

Do I simply divide cellphones and desktop signups  by intranetvisits ?

Thanks
jay

Week1            Week2            Week3            Week4
CellPhones      110                       90                    113                     134
Desktops              234                      300            310                     320
Total SignUp      344                      390            423                     454

IntranetVisits 2040            2400            2521            2701
0
Question by:jay_eire
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 37

Expert Comment

ID: 39162296
Yes. For example you have 234/110 = 2.127 desktops per cell phone for week 1.
0

LVL 24

Expert Comment

ID: 39162301
For week 1, 234/110 = 2.12 which means 2.12 desktop signups for every cellphone signup
0

LVL 23

Expert Comment

ID: 39162303
I would think you need something like:

=B2/10+B3/5

where B2 is Cellphones for Week1 and B3 is Desktops for Week1,

You can copy formula across the other weeks.
0

LVL 37

Expert Comment

ID: 39162304
Note that if you keep your units it makes sense mathematically.
For example 2040 visits/344 signups = 5.9 visits/1 signup or 5.9 visits for every 1 signup.
0

LVL 24

Expert Comment

ID: 39162312
For week 1, 110/234 = 0.47 which means 0.47 cellphone signups for every desktop signup

The total number of intranet visits is irrelevant for your purposes.

Use these calculations fo a nice pie chart in excel
234/344 = 0.68 = 68% Desktop
110/344 = 0.32 = 32% Cellphone
0

LVL 27

Accepted Solution

aburr earned 2000 total points
ID: 39162355
desktop newsletter signup / desktop visits = success rate for desktop
0

LVL 7

Author Comment

ID: 39162497
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaacâ€¦
###### Suggested Courses
Course of the Month12 days, 9 hours left to enroll