Infopreneur And Service Provider

service, provider

What’s up ? This is THE stephane ANDRE !!! I heard Olivier Roland’s tips and I learned some good stuff.

A personal trainer who is in the gym where I’m training ask me how to give courses online. But when he asked me this question, I noticed that he didn’t believe it or maybe it wouldn’t work with him. In the personal trainer business, there is part that is an intellectual service. What I mean is that there is a part of this job, which is to give people advice so they can improve.

All the skills that give advice can be turned into a product (information product). There is a huge challenge for personal trainers and service providers who trade their time for money. How to make more money (because there is a lot of competition) while a person can’t be in several places at the same time physically ?

Advice online

advice, online, keyboard, button

The trick is that instead of explaining the same thing to someone 1000 times, you write a book/ebook, you makes videos or your do an online training program. With these supports, it allows you to save time on repetitive tasks and automate a part of your income.

Some might think that this method doesn’t work with all types of service providers, but with the technologies evolution, it’s changing. We find online training program for salsa, golf, guitar, boxing, mma, auto mechanics, plumber, etc. do some research on Google or DuckDuckGo and see.

For example, you want to learn boxing. Traditionally, you have to go to a boxing club to learn and improve your technique with sparring. But you learn that there is an online boxing training program from Floyd Mayweather. In this training program, Floyd Mayweather shares his best tips and techniques to improves your boxing performance. Are you participating in this online training program or not? I think so, especially if you’re passionate about boxing.

If you have the budget to participate in Floyd Mayweather’s online boxing training program, you’ll be very motivated to do so. Even if Floyd isn’t near you to correct your technique, he has clearly good tips to share with your to improve your performance and your boxing technique.

This is why it’s important not to put barriers to explore new things, to put in place innovative projects because it’s doing things that we learn what works and what doesn’t work.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin’s bistro to eat Haitian food, click here.

Please follow, like and share:

Understand This Human Behavior To Boost Sales

human behavior

What’s up ? This is THE stephane ANDRE !!! I watched an Olivier Roland’s video  and I learned some good stuff.

There is human bias that needs to get around to get your company up to the next level. What’s interesting with marketing is that it exposes human behavior. Marketing allows us to understand good and bad human behavior

Lazy

This one of the most common human misbehavior. Take the example of a registration page for online training. There are 200 prospects interested in this training who gave you their emails to know the start date.

You divide the prospects into 2 groups, group A and B. For group A (100 prospects), you ask them to write their first names and emails and click on the OK button in the form to register. For group B (100 prospects), their first names and emails are already pre-filled in the form, just check the information and click on the OK button. In group B, there will be about 10% more registration compared to group A.

Which means that in group A, there are about 10% of prospects who don’t have enough energy or motivaton to write their first names and emails in the form.

Honest

honesty

This is one of the most common good human behaviors. Take the example of a guarantee of 30 days without conditions satisfied or refunded. Technically, there are plenty of people who could benefit from this guarantee by saying : « I’ll use this product for 29 days and I’ll ask for a refund ». Of course, there are people who do that, but it’s always surprising to see that it’s a small minority. It’s something nice to see.

Psychology

Unfortunately, there are limits in honesty and it’s necessary to understand some human bias to have a good company. Otherwise your company is in jeopardy.

In a detective tv show, there is a perone who is looking for the best detective for his problem. The hero of this tv show is a detective.

The person sees the hero and says : « I did some research and you’re the best in your field ».

The tell him : « You did some research, but what exactly did you do ? ».

The person answers : « It’s simple, I went to see all your competitors, I asked them who was the best detective and they all said it was them. Then I asked them who was the best second detective after them and they said it was you, that’s why I realized you were the best ».

Did you see the human bias in this example ? When you ask a pro who is the best, he’ll answer you : « Me ! ». The pro does this because he wants to sell, he has his personal pride and maybe he really believes he’s the number 1 compared to others.

Which shows that it’s difficult to have the most objective answer possible with this question. By understanding this human bias, you can use a question that gets around that. This question is : « Okay, it’s obvious you’re the best but who’s second best after you ? ». In the majority of cases, the answer is objective.

Price

price

Let’s take another example. An entrepreneur conducts a survey with his prospects to determine the selling price of a product. The question is : « What is the price you would pay to buy this product ? ». If you ask your prospects how they want to help them, they’ll be honest but when you talk about the selling price, it become complicated. When you ask the question about the selling price, they will always tell you a lower price compared to the price they could pay.

There are 2 reasons :

  1. When a person ansers this question, she thinks : « If I tell him I’m willing to pay 100 dollars, he’ll sell it to me at $100. So, I’ll tell him $50 like that it will be cheaper ». It’s a behavior that all human beings do (me and you included).

  2. There are people who don’t know how much they would be willing to pay because they can’t see the product. When they see the product and see what it can improve in their life, they’ll decide whether to buy it or not.

To solve the problem of the 1st reason, ask the question this way : « As you’re one of the people who helped me to create this product, you’ll have a special price, but what do you think the price is that the rest of the world should pay ? ». With this question, the prospect knows that he is going to have a special price so he can give a more objective answer.

To solve the problem of the 2nd reason, there is only one way. It’s showing the product to prospects.

When you do a survey to prospects for the sale price, it’s very important that prospects understand that they’re going to have a special price. Ask the questions : « What price would you pay to buy this product ? » and «  As you’re one of the people who helped me to create this product, you’ll have a special price. But what do you think the price is that the rest of the world should pay ». You will be surprised by the different answers you will have. Test it !

Obviously, it’s not only with this question that you will determine your selling price, it will be just a clue. It’s very useful to understand human psychology otherwise you risk choosing a selling price really too low that should be and earn really less money.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin’s bistro to eat Haitian food, click here.

Please follow, like and share:

How To Have Too Many Clients

too many clients

What’s up ? This is THE stephane ANDRE !!! I watched an Olivier Roland’s video  and I learned some good stuff.

The trick is that you have to have more people who want to buy your product than products available. This trick is also valid for service.

This trick is that you have to develop your audience to make sure there are so many people who know you that it’s not possible for everyone to buy your products/services. Here is an example.

Imagine that you have a bakery. As there are several bakeries in the neighborhood, your turnover is limited because of the local radius. People don’t go kilometers (miles) to go to bakery, usually they go tho the bakery closest to home.

Social media for your company

social media

There is something to boost your audience/clients through the internet. It’s to develop your bakery’s presence on internet with a blog, a podcast or a YouTube channel. With a YouTube channel, you can show what you do every day with vlogs. You make a video when you get up at 4 in the morning to make breads and cakes, which means that you film the process (knead the dough, the oven, etc.). All these videos, you can publish them on YouTube, Facebook, Instagram and other video support.

To start, you will publish these videos to your local clientele, then to a national level and then to an international level. This is an important first step but it can be quickly copied. To differentiate yourself from other bakeries, it’s necessary that you have an extremely good cake with a secret recipe. You can make videos of this cake with a secret recipe but you don’t show the whole process, all the ingredients. It’s a cake with a secret recipe like Cola-Cola.

Tell a story about this secret recipe to make it mysterious. It must be a true story like : « It’s a recipe from my mother’s grandmother » or « It’s a recipe I accidentally created ». With this story, this storytelling, people of the neighborhood will know you better and you’ll become a local celebrity. And what’s interesting is that there will be people from other cities coming to your bakery because you’re the baker who has this great YouTube channel.

With a website, you can sell your breads ans cakes online in other cities. Because of your presence on internet, local newspapers will do an article about you because there is buzz. And you can display these articles in your bakery in a very visible place so that all clients can see them. All this will boost word of mouth.

2 options

options

After a while, you will not be able to satisfy the request and it’s at this moment where you have to ask yourself these 2 question :

  • Open another bakery. You will work more, earn more money and recognition.

  • Increase prices. You limit your time for the quality of life or the quality of your products because you’re an artisan.

In London, there is this Japanese restaurant, The Araki , which has 3 stars in the Michelin guide. There is a waiting list of several months to eat there. The Araki has one menu only of £300 and only 10 seats. It’s really interesting to read their « Booking Policy » .

I know that this can’t be applied in all professional fields but it gives you the possibility to have more clients.

Subscribe to my newsletter and share this article, if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin bistro to eat Haitian food, click here.

Please follow, like and share:

Become Insensitive To Haters

hater

What’s up ? This is THE stephane ANDRE !!! I watched an Olivier Roland’s video  and I learned some good stuff.

To be successful, it’s really necessary to have the ability to ignore haters, especially on internet.

Beginners are unaware of the emotional impact that haters can create and it can also scare people who want to start their company online. When you develop your internet presence, avoid haters is impossible.

Hater

A hater is a person who feels the irresistible urge to send you a message by email, comment or tweet to tell you :

  • You’re the stupidest and ugliest person in the world

  • Your content is the most insignificant thing since the creation of the planet earth

  • That he/she hopes that you don’t make children to not spread the evil on the planet earth and that you die quickly

These 3 things are what say haters in general.

The truth is, you can’t avoid that. Select one of your favorite artists, athletes or actors, check out one of his/her video on Youtube and read the comments. You can see the quality’s level of comments and it makes people lose faith in humanity. And it’s not just haters, there are also people who tell a lot of bullshit and insult each other.

A hater is a person who is bored and has no purpose in life, so that person is trying to create trouble in your community and psychologically impact you in a negative way. Fortunately on social media, it’s possible to ban haters.

Don’t be afraid

don't be afraid

I know many people who want to create a blog, a podcast or a Youtube channel but they’re afraid of having a bad buzz. I know a medical student who wants to create something to help students who are in 1st year of medical school but he still doesn’t do anything. This is the same situation as people who never drive because they are afraid of an accident or people who never take a plane.

It’s important to understand :

  • It’s extremely unlikely

  • Even if you have a bad buzz, you’ll survive

  • In any case, you will build a community that will support you.

When you look at the biggest bad buzz in history, it’s rare to see that the sales falls caused the bankruptcy of the company (or maybe you know a case I don’t know). Sometimes there are people who have been a bit traumatized by a bad buzz but in the majority of cases, there is little damage.

The best revenge you can have for haters is to have a good life. To be afraid of the haters that make you afraid to act, that you’re paralyzing, it’s showing to the world that it’s you who are leaving intimidated by something that is very unlikely to happen.

Keyboard warrior

keyboard type

Haters are also called « Keyboard warrior » because generally haters allow themselves to make type of criticism about people on internet but they are unable to do in real life, face to face. They’re comfortable behind their keyboard because they suffer no consequence.

So don’t be intimidated by the keyboard warriors and what I recommend you to do, it’s to keep a bottle of champagne to celebrate your first hater. It’s important to know that having haters is a necessary step in your success. Having your first hater is a sign that you’re on the right track because you’re disturbing someone.

keyboard warrior

Constructive criticism

Among this ton of negative comments (95%), there are also critics who can help you improve. To identify these critics, you must ask yourself this question : « What is the intention of this criticism ? Do I feel that the person wants to help me ? ».

If you feel that the criticism of the person is to help you, you can analyze the criticism and see if you can do something that interest you. If not, you can ban the person. Unfortunately, you’ll see that the majority of critics are not made to help you.

Remember that about haters :

  1. They’re inevitable

  2. They’re a sign of your success. Everyone has haters, even the people you admire the most

  3. They’re keyboard warriors. They say things that he/she doesn’t allow himself/herself to say in real life, face to face.

  4. Keep a bottle of champagne for the day you’ll have yor first hater

  5. To identify constructive criticism, ask yourself this question : « Is there a positive intention in this criticism to improve myself ? ».

Subscribe to my newsletters and share this article if you think it can help someone you know.

-Steph

Please follow, like and share:

Chi-Square Test With More Than 2 Categories

tableau chi square test

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

In this article, we will do a Chi-square test with more than 2 categories. We will use the A/B test « Country » which has 3 categories which corresponds to 3 countries : German, Spain and France. Select « Gender Actual » tab, make a copy with a right-click and select « Duplicate ».

tableau chi square test

Name the tab « Gender Actual (2) » by « Country Actual ».

tableau chi square test

In « Dimensions », move the variable « Geography » over « Gender » in « Columns » to replace « Gender » with « Geography ».

tableau chi square test

tableau chi square test

Here’s how to do an A/B statistical test when there are 3 categories. We’ll start with the classic method and then I’ll show you another way to do Chi-square test with any number of categories.

Let’s start with the classical method. In this case, there are 3 categories so we can’t use the online tool of the previous article. In the previous article we used an online tool with only 2 categories « Sample1 » and « Sample2 ». That’s why we’re going to use another online tool, click here  .

tableau chi square test

In this online tool, we can enter the values without using the total values. That is, we enter only the number of observations in each category. We simply need to enter the values that are on our A/B test. And I’m going to show you how to turn our A/B test into a table. In this way, it will be easier to enter the values in the online tool without making any mistakes.

Go to the « Show me » tool at the top right.

tableau chi square test

Click on « text tables »

tableau chi square test

tableau chi square test

Click on « Swap Rows ans Columns » button.

tableau chi square test

tableau chi square test

Cool, now you have a table arranged in exactly the same way as the online tool.

In the online tool, we will select 2 rows and 3 columns.

tableau chi square test

As we have 3 categories and 2 possible results, we enter our values exactly as in the table we just created on Tableau.

tableau chi square test

Perfect, our table is ready. You can click on the « Calculate » button.

tableau chi square test

tableau chi square test

As you can see, we observe the same thing as the other online tool. There is our indicator « p » value which is less than 5%. Which means there is a meaning.

tableau chi square test

This statistical significance means that these results are valid for the total number of the bank’s clients and not just for the sample of 10 000 clients. We observe similar differences with A/B test « Country » whose results are based solely on the sample of 10 000 clients. We can conclude that in the total number of the bank’s clients, it’s the clients in Germany who are more likely to leave the bank. This is how we do things cleanly.

You saw, this online tool limited by 5 by 5 tables so you can’t use this tool when you have 6 categories or more. But fortunately it’s possible to do Chi-square test with any number of categories. It’s a special method and for you to understand that, I’ll give you a theoretical explanation.

Here we have 3 countries : German, Spain and France.

tableau chi square test

What we’re trying to compare is the clients number leaving the bank in each of these countries.

tableau chi square test

With our basic A/B test based on a sample of 10 000 clients, we obtained 16% for France, 32% for Germany and 17% for Spain. Now the question is : « Do we observe the same results on the total clients number of the bank ? », it means : « In general, does the country have a significant effect on the clients number leaving bank ? ». Germany has the largest number of clients leaving the bank so the idea is : « Why would we need to compare the 3 countries at the same time ? ».

tableau chi square test

If we do an A/B test statistical test with Germany and France and we get a significant difference in the clients number leaving the bank between these 2 countries, then that would mean that in general, the country has a significant effect on the clients number who bank. Indeed, if we find by comparing Germany and France that the Germans are more likely to leave the bank than the French, we can consider that Spain will not change anything. Germans will always be more likely to leave the bank than the French. Maybe there will be a different relationship between Germany and Spain but there will always be a statistically significant difference between France and Germany with a larger number of clients leaving the bank in Germany than France.

Here is a way to confirm that this logic is true. There is a test and the participants of this test are German, Spanish and French. Imagine that this test was done without looking at what is happening in Spain. Now you get the result and you ask yourself the question : « Would the results changed if you added Spain ? ». The answer is « no » because there is no interdependence between Germany, Spain and France. That is, the decision to leave the bank in France and Germany doesn’t depend on Spain. And therefore, it’s quite correct to separate the categories by putting 1 aside to compare the 2 others. And as now we have 2 categories, we can do a Chi-square test with the online tool that we used in the previous article.

So let’s go back to our worksheet and put a country aside to compare only 2 countries. Select « Country » tab.

tableau chi square test

What we observe is that the difference between Spain and France is very small, so it wouldn’t be interesting to do a Chi-square test between Spain and France. It’s more interesting to do a Chi-square test between Germany and France and to prove that there is a statistically significant difference between these 2 countries. This will be enough to conclude that the country has a statistically significant impact on the clients number who leave the bank.

Selects « Country Actual » tab.

tableau chi square test

We will use the online tool of the previous article, click here  .

We will make a copy of « Country Actual » to have a bar chart with absolute values. Select « Country Actual », right-click and select « Duplicate ».

tableau chi square test

In « Show Me », select « horizontal bars ».

tableau chi square test

tableau chi square test

Removes « SUM (Number of Records )» from « Columns » and removes « Exited » and « Geography » from « Rows ».

tableau chi square test

tableau chi square test

In « Dimensions », move « Geography » in « Columns ».

tableau chi square test

tableau chi square test

In « Measures », move « Number of Records » to « Rows ».

tableau chi square test

tableau chi square test

In « Measures », move « SUM(Number of Records) » in « Label ».

tableau chi square test

tableau chi square test

In « Dimensions », move « Exited » in « Label ».

tableau chi square test

tableau chi square test

In « Dimensions », move « Exited » in « Colors ».

tableau chi square test

tableau chi square test

We also need total absolute values, which means the total number of men and women. There is a very fast way to get that. Right-click on the vertical axis and select « Add Reference Line ».

tableau chi square test

Then in « Value », click on the drop-down on the right and select « Sum » to have the total sum of the observations.

tableau chi square test

And in « Scope », you select « Per Cell » option to specify that you want the total sums for each category, male and female.

tableau chi square test

Now, we have the total sum at the top of the bars. We will modify labels to have the absolute values. In « Label », we will change « Computation » to « Value » and click on the « OK » button.

tableau chi square test

tableau chi square test

tableau chi square test

Here’s how to enter the data :

For « Sample1 » in #success, you enter 810 because there are 810 people who left the bank. For « Sample1 » in #trials, you enter 5014 because there are 5014 people in total.

For « Sample2 » in #success, you enter 814 because there are 814 people who left the bank. For « Sample2 » in #trials, you enter 2509 because there are 2509 people in total.

tableau chi square test

Here is the verdict : « Sample2 is more successful ». « Sample2 » corresponds to German’s clients and #success is :« yes, the client left the bank ». This verdict means that of all the clients from German are more likely to leave the bank than clients from France. And look, there is something important, it’s « p<0.001 ». This means that the « p » is strictly less than 0.001. As you can see, « p » value is very small, which concludes that the tests are statistically significant.

Ooh, there’s another thing I wanted to show you with the tab « age » with the 2 bar charts in parallel.

tableau chi square test

As you can see, there are many categories (more than 5) because each category corresponds to a 5-year ago group with clients of the bank aged from 15 to 90 years old. This is a lot of comparison but it would be a good exercise for you to find what are the 2 categories to compare that shows that there is a significant statistic difference.

I give you a hint, compare slices from 50 to 54 years old or from 35 to 39 years olds. In fact, you should compare all peer categories where you observe difference on this basic A/B test. Do a basic A/B test with absolutes values. Then do a Chi-square test to check if the difference is statistically significant, I mean, if the result is valid for the total number of bank’s clients.

This is a way to statistically validate the insights we see onTableau. You see, it’s not very difficult and it’s effective. Here is a way to find insights on Tableau and validate them.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

Please follow, like and share:

Validate Data Mining In Tableau With A Chi-Square Test

validate validation

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

In this article we will start using statistics. Don’t worry we’ll do something simple, we’ll use the Chi-square test in a basic way. There is a special section to learn how to do statistics at an advanced level.

I’ll explain why we’re going to learn how to use the Chi-square test. The results we have with theses 2 bar charts are good. We see on theses 2 bar charts that age has a significant impact on the rate of client leaving the bank. We also see in which age groups the clients leaves the bank the most and which age groups the clients leave the bank the least. With that we have good insights.

In the A/B test « Gender », we can see that there is a correlation between the male and female sex and the choice to leave the bank. But as I said before, this A/B test is basic. The results of a basic A/B test visually shows us what is probably happenning in reality but we aren’t 100% sure of these results. To validate these results, we need do to use statistical tests like Chi-square test.

Doing a report based on basic A/B test is very risky and you can have completely false insights. I don’t advise you to do it (unless you want to leave your job). It’s for this reason that using Chi-square will help us to have strong insights.

Chi-square will allow us to know if our results are statistically significant. Our results are based on a sample of 10 000 clients and Chi-square test will tell us if these results are due to chance effects or if these results can represent all the client of the bank.

For example in our A/B test « Gender », we observed that in our sample of 10 000 clients, women are more likely to leave the bank compared to men.

tableau data mining science chi square test a/b test

Now, we aren’t sure if the results of this sample represent the behavior of all the bank’s clients.

To use basic Chi-square test, we use an online tool. Click here  .

tableau data mining science chi square test a/b test

On internet, there are plenty of websites to do a Chi-square test but we’ll use this one so that you can understand how it works. To do a Chi-square test, we need to use absolute values and in our A/B test we have percentage.

Let’s go back to Tableau. We’ll create a new tab with a version of A/B test with absolute values. In this way, we keep the A/B test with the percentages. Do a right-click on the « Gender » tab and select « Duplicate ».

tableau data mining science chi square test a/b test

Name the new tab « Gender Actual » to specify that it’s absolute values.

tableau data mining science chi square test a/b test

To have the absolute values, move « Number of Records » in « Measures » to the « Marks » area and put it over top of « SUM(Number of Records ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Move « Number of Records » in « Measures » to « Rows » over « SUM(Number of Records ».

tableau data mining science chi square test a/b test

Cool, we have our absolute values.

tableau data mining science chi square test a/b test

We also need total absolute values, which means the total number of men and women. There is a very fast way to get that. Right-click on the vertical axis and select « Add Reference Line ».

tableau data mining science chi square test a/b test

Then in « Value », click on the drop-down on the right and select « Sum » to have the total sum of the observations.

tableau data mining science chi square test a/b test

And in « Scope », you select « Per Cell » option to specify that you want the total sums for each category, male and female.

tableau data mining science chi square test a/b test

Now, we have the total sum at the top of the bars. We will modify labels to have the absolute values. In « Label », we will change « Computation » to « Value » and click on the « OK » button.

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Perfect, we have the total amount of observation at the top of each bar : 4543 women and 5457 men. We have what we need to use our online tool.

tableau data mining science chi square test a/b test

OK, I’ll explain how this tool works. « Sample1 » and « Sample2 » correspond to the independent variable « Gender ». You choose in which order you enter the data, « Sample1 » for men or the opposite. In our case, we use « Sample1 » for women and « Sample2 » for men.

« #success » corresponds to the result Y=1, which means in our case « yes, the client left the bank ».

« #trials » is the total number of observations, which means the total number of women in « Sample1 » and the total number of men « Sample2 ».

That’s how you enter the data :

  • For « Sample1 » in #success, you enter 1139 because there are 1139 women who left the bank. For « Sample1 » in #trials, you enter 4543 because there are 4543 women in total.

 

  • For « Sample2 » in #success, you enter 898 because there are 898 men who left the bank. For « Sample2 » in #trials, you enter 5457 because there are 5457 men in total.

tableau data mining science chi square test a/b test

Here is the verdict : « Sample1 is more successful ». « Sample1 » corresponds to women and #success is :« yes, the client left the bank ». This verdict means that of all the bank’s client, women are more likely to leave the bank than men. And look, there is something important, it’s « p<0.001 ». This means that the « p » is strictly less than 0.001.

tableau data mining science chi square test a/b test

« p » is the value that indicates whether an independent variable has a statistically significant effect on a dependent variable. In our case, the independent variable is « Gender » and the dependent variable is « Exited », which is : « yes, the client left the bank ». So « p » is strictly less than 0.001, which means that the independent variable « Gender » has a statistically significant effect on the dependent variable « Exited ». This shows us that out of the total number of bank’s clients, women are more likely to leave the bank than men.

This is how we use Chi-square test with this online tool. This is the same principle on all online tools that you can find on Google or DuckDuckGo . You can repeat these instructions that I gave you with other tools, you will get the same results.

It’s cool with the Chi-square we validated the A/B test and to specify that this A/B test is validated, we’ll color the tab in green.

Right-click on the tab, select « Color » and select « Green ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Perfect, now we’ll validate another A/B test. Selects « HasCreditCard » tab.

tableau data mining science chi square test a/b test

We’re going to create an A/B test « HasCreditCard » only with absolute values. To save time, right-click on « Gender Actual » tab and select « Duplicate ».

tableau data mining science chi square test a/b test

We’ll remove the green color on the tab « Gender Actual (2) ». Right-click on the tab and select « Color » and « None ».

tableau data mining science chi square test a/b test

You rename the tab « HasCreditCard Actual ».

tableau data mining science chi square test a/b test

Move the variable « HasCrCard » over « Gender » in « Columns ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Excellent, everything is ready to do a Chi-square test. We’ll remove « Exited » labels to better see the absolutes values. Make a click and drag out.

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Perfect, let’s go back to our online tool. In this case, « Sample1 » is « no », which means client who don’t have credit card and « Sample2 » for « yes », which means clients who have a credit card.

That’s how you enter the data :

  • For « Sample1 » in #success, you enter 613 because there are 613 clients who left the bank. For « Sample1 » in #trials, you enter 2945 because there are 2945 clients who don’t have a credit card.
  • For « Sample2 » in #success, you enter 1424 because there are 1424 clients who left the bank. For « Sample2 » in #trials, you enter 7055 because there are 7055 clients who have a credit card.

tableau data mining science chi square test a/b test

Let’s look at the verdict, it’s « No significant difference ». « p » value is very high, it’s above 5%. This confirms that the independent variable « HasCrCard » has no statistically significant effect on the dependent variable « Exited ». That was the conclusion we had made when we had done the A/B test with percentages.

We had seen that there was 21% of « Exited » (clients who left the bank) in the category « no » and 20% in the category « yes ». With these results we concluded that most likely the variable « HasCrCard » had no impact on the rate of clients who left the bank. Chi-square test confirms our conclusion and we can put the tab « HasCrCard » in green to say that it’s OK.

Right-click on the tab « HasCreditCard » => « Color » => « Green ».

tableau data mining science chi square test a/b test

tableau data mining science chi square test a/b test

Excellent, now, you can do a statistical A/B test with 2 categories. Soon, we will do statistical A/B tests with more than 2 categories.

Share this article if you think it can help someone you know. Thank you.

-Steph

Please follow, like and share:

When Your Internet Company Is Not Working

internet company

I watched an Olivier Roland’s video  and I learned good stuff.

Here are some tips to improve your situation if you want to have an internet company or you already have an internet company. These principles are basically intended for infopreneurs, it means selling information products (ebook and online training) but over time all companies should use these principles to boost their reputations.

In an internet company, there are 3 pillars : traffic, authority and relation.

Traffic

This is the number of people who visit your website and your entire ecosystem (social media – instagram, youtube, facebook, snapchat, twitter, etc.).

Authorities

This is the way your audience sees you as an expert. You can be an excellent expert and not know how to communicate, so your audience sees your expertise at a level below your actual expertise. And it can also have the opposite situation where your audience sees your expertise at a level higher than your real expertise. In this case, you’re a crook !

Relation

This is the level where your audience appreciates you as a human being rather than a company.

Pillars check

What is interesting to do is to note where you think you are in the 3 pillars (traffic, authority and relation) from 1 to 10. « 1 » is the person who has just started and « 10 », is the person who is one of the best infopreneurs in the world like Gary Vaynerchuk  or Casey Neistat .

Don’t hesitate to ask people you know to have a more objective point of view. The ideal is a close friend who is really interested in your company and who understands what you’re doing. Ask this friend : « What rating would you give me between 1 and 10 ? Go ahead, be frank, you don’t need to spare my ego ! ». With an outside eye, it will help you find the problem.

Problems

problem

Perception

It’s possible that you have a huge traffic on your website but if people don’t perceive you as an expert who has enough experience to help them and they don’t like you (they perceive you more like a salesman as a human being), they will not buy your products and services.

Conversion rate

This concerns the conversion rate between your traffic and the people who sign up for your email list. People who sign up for your email list are people who are really interested in what you’re doing and who want receive the free gift you are offering (ebook or exclusive video). People who subscribe to your email list have given you permission to contact them through their email knowing they can unsubscribe at any time.

What it interesting to do is to note where you think to be in your conversion rate from 1 to 10 ? For example, when there are 100 people visiting your website, how many are subscribed to your email list ? If you rate is 0, you’re not offering any interesting gifts or you’re not making a call to action for your email list. In these cases, you have to work on it to offer a better free gift or tell people that they can sign up for your email list.

We must know that today, email remains the most effective way to contact people and it will remain so for a long time. Attention, that doesn’t mean that when you send an email thanking for the loyalty of your subscribers or a promotional email for a product/service, you shouldn’t also talk about that in your ecosystem (social media) with a video, a picture, a post on different platforms.

It’s important to know that if you’re doing content marketing and your company is based on the free content you create, you need at least a 5% conversion rate. If you do below that, you have work to do to improve your conversion rate.

Solutions

solution

Product/service

It’s possible that you don’t have a product or service to sell or like me at the beginning, I sold a product but there are only 5 people who bought it. In this case, you can do a survey with the people who are on your email list to find out what is the problem they would like to settle as quickly as possible. With this method, you’ll soon be able to create a profitable product because you solve the main problem of you audience. Attention, it’s necessary that you have 1000 people subscribed on your email list to make this survey.

Coaching

This is one of the simplest ways you can make money. It doesn’t matter if you have more than 1000 people on your email list. When we start an internet company, it’s the easiest thing to do. You offer your skills as a service to your audience. With a small audience, a good authority and a good relation, you’ll have people who will be interested to work with you by doing coaching sessions on Skype, for example.

Ebook

If you’re a person who likes to write (like me), you can create an ebook that you can sell between USD 17.- and 27.- to start earning some money.

Action

We could talk about this for hours because every situation is different. I don’t know your situation but by following these advices, you will be able to improve your company’s situation, so ACTION.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

Please follow, like and share: