Using the Hypothesis
Test in Excel To Find
Out If Your Advertising
Really Worked
This article will explain how to use Excel to perform a Hypothesis Test to analyze an advertising campaign. Specifically, we will show how to use Excel to perform One-Tailed, Two-Sample, Paired Hypothesis Test of Mean to determine whether an advertising campaign improved really sales.
This Hypothesis Test tests the Null Hypothesis that the advertising campaign did not improve sales.
The advantages of statistical analysis in Excel to solve business statistics problems is that most problems can be solved in just one or two steps and there is no more need to look anything up on Normal Distribution tables.
Here is the problem:
Problem: Determine with 95% certainty whether an advertising campaign increased average daily sales to our large dealer network. Before and After samples of average daily sales were taken with at least 30 dealers.
Here is the Before and After data for all of the dealers:
Before we begin solving this problem, we need to know whether we are dealing with normally distributed data. If the data is not normally distributed, we have to use nonparametric statistical tests to solve this problem.
Always Test for Normality First
Normality tests should be performed on the before and after sales data. Both data sets must be normally distributed to perform the well-known hypothesis test that is based upon the underlying data being normally distributed. This blog has numerous articles about how to perform normality testing and nonparametric testing if the data is not normally distributed.
Determine What Type of Hypothesis
Test You Will Perform
1) Hypothesis Test of Mean or Proportion?
We know that this is a test of mean and not proportion because each individual sample taken can have a wide range of values: Any sales sample measurement from 90 to 250 is probably reasonable.
2) One or Two-Tailed Hypothesis Test?
We know that this is a one-tailed test because we are trying to determine if the "After Data" mean sales is larger than the "Before Data" mean sales, not whether the mean sales are merely different.
3) One or Two-Sample Hypothesis Test?
We know that two samples need to be taken because no data is initially available.
4) Paired or Unpaired Hypothesis Test?
This is paired data because each set of "Before" and "After" data came from the same object.
In this case, we are performing a One-Tailed, Two-Sample, Paired Hypothesis Test of Mean to determine whether an advertising campaign improved really sales. We will do this test in Excel. It is extremely important to establish the type of Hypothesis test. Each type of Hypothesis test uses a slightly (or very) different methodology and set of formulas.
In this case, the yellow-highlighted column represents the difference between the Before and After sample of each data pair. The Hypothesis test will be performed on that column of data.
Above is the data sample:
Paired Hypothesis Tests involve taking Before and After samples from the same large number (n is greater than 30) of objects and performing a Hypothesis test on the differences between the Before and After samples.
Initial Parameters Needed
Before we can begin the Hypothesis test, we need to calculate the following parameters of variable x:
Sample size - Use Excel function COUNT
Sample mean - Use Excel function AVERAGE
Sample standard deviation - Use Excel function STDEV
Sample standard error = (Sample standard deviation) / SQRT (Sample size)
Difference Data
We need to make the following calculations on the data that represents the difference between the Before and After data:
xavg = "Difference Data" sample average = 9.60
Sxavg = Sample standard error = 1.11
n = "Difference Data" Sample size = 30
α = Level of Significance = 0.05 because there is a 5% max chance of error allowed.
Therefore a 95% Level of Certainty Required
The Null Hypothesis normally states that both populations sampled are the same. If the mean sales from both the Before and After Data are the same, then their average difference = 0
For this one-tailed test, the Alternative Hypothesis states that the value of the distributed variable xavg is larger than the value of 0 stated in the Null Hypothesis,
Two-tailed test - (Value of variable) does not equal (Constant)
Step 2 - Map the Normal Curve
Step 3 - Map the Region of Certainty
b) p Value Test
*****************************************
Using the Hypothesis Test in Excel to Find Out If Your Advertising Worked
Strategically pitching and up selling: Sales is an absolute necessity. Any business needs them by snares or law breakers to turn its income cycle. data science course in pune
ReplyDeleteJust saying thanks will not just be sufficient, for the fantastic lucidity in your writing. I will instantly grab your articles to get deeper into the topic. And as the same way ExcelR also helps organisations by providing data science courses based on practical knowledge and theoretical concepts. It offers the best value in training services combined with the support of our creative staff to provide meaningful solution that suits your learning needs
ReplyDeleteThanks for sharing your valuable information to us, it is very useful.
ReplyDeletedigital marketing course
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
ReplyDeleteData science course in mumbai
Excelr is providing emerging & trending technology training, such as for data science, Machine learning, Artificial Intelligence, AWS, Tableau, Digital Marketing. Excelr is standing as a leader in providing quality training on top demanding technologies in 2019. Excelr`s versatile training is making a huge difference all across the globe. Enable ?business analytics? skills in you, and the trainers who were delivering training on these are industry stalwarts. Get certification on "
ReplyDeletebest data science course in hyderabad"and get trained with Excelr.
I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.
ReplyDeleteExcelR data analytics courses
I am a new user of this site so here i saw multiple articles and posts posted by this blog,I curious more interest in some of them hope you will give more information on this topics in your next articles.
ReplyDeleteData Scientist course
ReplyDeleteThere is obviously a lot to know about this. I think you made some good points in Features also. Keep working, great job!.... data science course Bangalore
You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
ReplyDeleteExcelR Data Analytics Course
Data Science Interview Questions
I want to say thanks to you. I have bookmark your site for future updates. ExcelR Data Scientist Course Pune
ReplyDeleteThis is a wonderful article. I really enjoyed reading this article. Thanks for sharing such detailed information.
ReplyDeleteData Science Course in Marathahalli
The information provided on the site is informative. Looking forward more such blogs. Thanks for sharing .
ReplyDeleteArtificial Inteligence course in Aurangabad
AI Course in Aurangabad
The web site is lovingly serviced and saved as much as date. So it should be, thanks for sharing this with us.
ReplyDeletedata science course
360DigiTMG
This comment has been removed by the author.
ReplyDeleteHi, Thanks for sharing wonderful blog post...
ReplyDeleteData Science Training In Hyderabad
You should have a great deal of pride recorded as a hard copy quality substance. I'm dazzled with the measure of strong data you have written in your article. I want to understand more.
ReplyDeleteSEO services in kolkata
Best SEO services in kolkata
SEO company in kolkata
Best SEO company in kolkata
Top SEO company in kolkata
Top SEO services in kolkata
SEO services in India
SEO copmany in India
Thank a lot. You have done excellent job. I enjoyed your blog . Nice efforts
ReplyDeleteData Science Certification in Bangalore
I really enjoyed reading this post, big fan. Keep up the good work andplease tell me when can you publish more articles or where can I read more on the subject?
ReplyDeleteData Science Training in Bangalore
I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
ReplyDeletebusiness analytics certification
ReplyDeleteReally impressed! Everything is very open and very clear clarification of issues. It contains truly facts. Your website is very valuable. Thanks for sharing.
cyber security course training in guduvanchery
Thanks for sharing nice information. I highlyrecommend you data science training Hyderabad
ReplyDeleteWhat a really awesome post this is. Truly, one of the best posts I've ever witnessed to see in my whole life. Wow, just keep it up.data science certification
ReplyDeleteVery nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, best data science courses in Hyderabad
ReplyDeleteWonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.
ReplyDelete360DigiTMG Machine Learning Course
Thanks for posting useful information.You have provided an nice article,
ReplyDeleteData Science Training in Hyderabad
I am here for the first time. I found this table and found it really useful and it helped me a lot. I hope to present something again and help others as you have helped me.
ReplyDelete360DigiTMG Data Science Certification
I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
ReplyDeleteclick here
Found your post interesting to read. I cant wait to see your post soon. Good Luck for the upcoming update. This article is really very interesting and effective, data science online training
ReplyDeleteThanks for provide great informatic and looking beautiful blog, really nice required information & the things i never imagined and i would request, wright more blog and blog post like that for us. Thanks you once again
ReplyDeleteAI Training in Hyderabad
This was certainly one of my preferred web journals. Each post distributed impressed me.
ReplyDeletedata science courses in delhi
Great blog with valuable information keep up the good work thank you.
ReplyDeleteData Analytics Course Online 360DigiTMG
Thank you very much for this interesting article. In fact, it is exceptional. You are looking for this type of notice later.
ReplyDeleteBusiness Analytics Course in Bangalore
I am stunned by the information that you have on this blog. It shows how well you fathom this subject.
ReplyDelete360DigiTMG data science course in malaysia
Very informative message! There is so much information here that can help any business get started with a successful social media campaign!
ReplyDeleteBusiness Analytics Course in Bangalore
I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.
ReplyDeletea href="https://www.excelr.com/data-analytics-certification-training-course-in-pune/"> Data Analytics Course in Pune/">You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!
I have express a few of the articles on your website now, and I really like your style of blogging. I added it to my favorite’s blog site list and will be checking back soon…
I have voiced some of the posts on your website now, and I really like your blogging style. I added it to my list of favorite blogging sites and will be back soon ... PMP Certification in Hyderabad
ReplyDeleteI really appreciate the writer's choice for choosing this excellent article information shared was valuable thanks for sharing.
ReplyDeleteData Science Training in Hyderabad
This type of very helpful article. Very interesting to see this article.
ReplyDeleteData Science Course In Bangalore With Placement
This post is very simple to read and appreciate without leaving any details out. Great work!
ReplyDeleteBest Institute for Data Science in Hyderabad
I have express a few of the articles on your website now, and I really like your style of blogging. I added it to my favorite’s blog site list and will be checking back soon…
ReplyDeletedata science course in Hyderabad
very happy to find a good place for many here in the post, the writing is just great, thanks for the post. Digital Marketing Course in Hyderabad
ReplyDeletethe ulterior motive of data science is fairly simple, though- to understand the hidden pattern and meaning in a large pile of data that can be simultaneously used to solve some real-life problem, help businesses tackle decision-making obstacles, understand and analyze the future behavior of people as per the data trends. data science course syllabus
ReplyDeleteJust saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates.
ReplyDeleteBest Data Science Courses in Hyderabad
I am glad that i found this page ,Thank you for the wonderful and useful posts and articles enjoyed reading it ,i would like to visit again.
ReplyDeleteData Science Course in Mumbai
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
ReplyDeleteData Science Course in Pune
This was among the best posts and episode from your team it let me learn many new things.
ReplyDeleteBest Institute for Data Science in Hyderabad
I have voiced some of the posts on your website now, and I really like your blogging style. I added it to my list of favorite blogging sites and will be back soon ...
ReplyDeleteData Science Institute Bangalore
Wow, amazing post! Really engaging, thank you.
ReplyDeletedata science malaysia
Wow, amazing post! Really engaging, thank you.
ReplyDeletedata science malaysia
Happy to chat on your blog, I feel like I can't wait to read more reliable posts and think we all want to thank many blog posts to share with us.
ReplyDeleteData Science In Bangalore
With so many books and articles appearing to usher in the field of making money online and further confusing the reader on the real way to make money.
ReplyDeleteData Science Institute in Bangalore
Very informative message! There is so much information here that can help any business get started with a successful social media campaign!
ReplyDeleteData Science Course in Pune
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
ReplyDelete<a href="https://360digitmg.com/india/artificial-intelligence-ai-and-deep-learning-in-pune
>artificial intelligence course in pune</a>
Mua vé máy bay tại Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ bao nhiêu
về việt nam từ mỹ
vé máy bay đà nẵng đi phú quốc
giá vé máy bay đà nẵng nha trang
vé máy bay hà nội sài gòn pacific airlines
Thanks for your nice post I really like it and appreciate it. My work is about Custom Vape Cartridge Boxes. If you need perfect quality boxes then you can visit our website.
ReplyDeleteReally impressed! Everything is a very open and very clear clarification of the issues. It contains true facts. Your website is very valuable. Thanks for sharing.
ReplyDeleteData Science Course in Lucknow
What an incredible message this is. Truly one of the best posts I have ever seen in my life. Wow, keep it up.
ReplyDeleteAI Courses in Bangalore
"Thank you very much for your information.
ReplyDeleteFrom,
"
data science certification
If you are looking for Illinois license plate sticker renewals online, you have to go to the right place. We have the fastest Illinois license plate sticker renewals in the state.
ReplyDeleteBest Data Science Courses in Bangalore
ReplyDeleteFinally I’m glad to check this blog because It’s a nice and informative blog.
Tally Training in Chennai
CCNA Training Institute in Chennai
SEO Training Institute in Chennai
Big Data Course in Chennai
Cloud Training in Chennai
Blue Prism Training Institute in Chennai
Great blog with valuable information.
ReplyDeleteDigital Marketing Course in Hyderabad
nice blog!! i hope you will share a blog on Data Science.
ReplyDeletedata science malaysia
The information you have posted is very useful. The sites you have referred was good. Thanks for sharing.
ReplyDeletedata science training in pune
I think about it is most required for making more on this get engaged.
ReplyDeletebusiness analytics course
I really enjoy reading and also appreciate your work.
ReplyDeletedata scientist online course
I don't have time to read your entire site right now, but I have bookmarked it and added your RSS feeds as well. I'll be back in a day or two. Thank you for this excellent site.
ReplyDeleteBest Data Science Courses in Bangalore
Great article. Thank you so much.
ReplyDeleteData Science Course Training in Lebanon
Excellent blog with valuable information. Thank You Much...
ReplyDeleteCloud Computing Course Training in Warangal
DevOps Training in Hyderabad
ReplyDelete
ReplyDeleteI was basically inspecting through the web filtering for certain data and ran over your blog. I am flabbergasted by the data that you have on this blog. It shows how well you welcome this subject. Bookmarked this page, will return for extra. data science course in jaipur
Thanks for updating us with the amazing article.
ReplyDeleteData Science Training in Pune
Loved the content! You have mentioned every aspect of the subject through this article, can you please write about "local seo for dentists"?
ReplyDeleteVery good message. I came across your blog and wanted to tell you that I really enjoyed reading your articles.
ReplyDeleteDigital Marketing Course in Bangalore
4 days Instructor-led Online Training PMP Certification Pune enroll soon
ReplyDeleteI really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people.
ReplyDeletedata analytics course in hyderabad
Hi, thanks for sharing nice article..
ReplyDeleteRTI Online Telangana
Really an awesome blog, I bookmarked your site for further blogs. Keep posting more blogs. Thank you.
ReplyDeleteData Science Training in Hyderabad
This is the first time I visit here. I found such a large number of engaging stuff in your blog, particularly its conversation. From the huge amounts of remarks on your articles, I surmise I am by all accounts not the only one having all the recreation here! Keep doing awesome. It has been important to compose something like this on my site and you have given me a thought.
ReplyDeletebusiness analytics course in hyderabad
ReplyDeleteReally, this article is truly one of the best in the article. And this one that I found quite fascinating and should be part of my collection. Very good work!.
Data Science Training in Amritsar
I see some amazingly important and kept up to length of your strength searching for in your on the site
ReplyDeletedata scientist training in malaysia
Data science is an emerging field, and all industries depend upon the data for running their businesses successfully.
ReplyDeletedata science training in shimla
It's late discovering this demonstration. At any rate, it's a thing to be acquainted with that there are such occasions exist. I concur with your Blog and I will have returned to investigate it more later on so please keep up your demonstration. data analyst course malaysia data analyst course malaysia
ReplyDeleteNatural Language Processing (NLP) is a branch of computer science that deals with Artificial Intelligence. It combines human language and computational linguistics with ML, deep learning models, and statistics to complete the writer's purpose. To know more about NLP, start your Data Science Course today with 360DigiTMG.
ReplyDeleteData Analytics Course in Calicut
360DigiTMG is the top-rated institute for Data Science in Bangalore and it has been awarded as the best training institute by Brand Icon. Click the link below to know about fee details.
ReplyDeleteData Science Training in Jodhpur
Companies are increasingly turning to data for decision-making and are depending on data professionals to do so. Develop strong logical and numerical aptitude and learn to work with R, Python, SQL, Hadoop, and statistical techniques like Linear Regression, Logistic Regression, etc. Sign up for the Data Scientist training in Bangalore, and gain expertise in using sophisticated analytical methods and statistical methods to prepare data for predictive and prescriptive modeling.
ReplyDeleteData Science Course in Bangalore
Are you planning to start Data Science Training Online, then enroll with 360DigiTMG to get trained by the world-class trainers with a well-designed curriculum, LMS Access, real-time projects, and assignments that will help you in upscaling your skills to grab the highest paid job.
ReplyDeleteData Science in Bangalore with Placement
Don’t let a pandemic affect your career growth, start your Data Science Online training today with 360DigiTMg and give your career the well-deserved boost it needs. Enroll now!
ReplyDeleteData Science Course in Delhi
Achieve success with the best Data Analytics Certification training delivered by the pioneers. Hands-on experience, Top industry trainers, World-class curriculum & Assignments. data analytics course in trichy
ReplyDeleteIt would help if you thought that the data scientists are the highest-paid employees in a company.
ReplyDeletedata science course in kochi
nice blog, thanks for the blogs, Matlab Training in Chennai at login360 centers around Matlab as one of the main specialized programming dialects and abilities today.
ReplyDeleteYou have amazing writing skills and you display them in every article. Keep it going!
ReplyDeleteChoose our Online Course Visit Cyber Security Bootcamp
This article will present a closer look at data science courses that give you a comprehensive look at the field. So let's get started.
ReplyDeletedata science course in borivali
Really impressed! Information shared was very helpful Your website is very valuable. Thanks for sharing.
ReplyDeleteFood Product Development Consultant
Enroll yourself in the Data Science training online program and reach the epitome of success
ReplyDeletedata science course in malaysia
Hi I have read a lot from this blog thank you for sharing this information. We provide all the essential topics in Web Development Course In Gurgaon for more information just log in to our website Web Development Course In Gurgaon
ReplyDeleteWith a distinctive curriculum and methodology, our Data Science certification programme enables you to secure a position in prestigious businesses. Use all the advantages to succeed as a champion.data science course institute in nagpur
ReplyDeleteThis post effectively highlights the role of data science in driving business decisions and improving outcomes.
ReplyDeleteData Science training In Faridabad
I found the section on statistical analysis and hypothesis testing in this article data analyst course fees in chennai
ReplyDeleteto be informative and well-explained.
This blog post provides a comprehensive and insightful overview of data science concepts and their applications. data science certification in chennai
ReplyDeleteThis article provides a comprehensive guide on using Excel for Hypothesis Testing in advertising analysis. It simplifies complex statistical concepts, making it accessible for data-driven decision-making. Invaluable resource!
ReplyDeleteData Analytics Courses in Nashik
This article likely explains how to use the hypothesis test in Excel to assess the effectiveness of advertising campaigns, a valuable resource for marketers and analysts looking to measure the impact of their strategies.
ReplyDeleteData Analytics Courses In Kochi
This comment has been removed by the author.
ReplyDeleteThis meticulous and clear guide on conducting a Hypothesis Test in Excel demonstrates a deep understanding of statistical analysis. The step-by-step explanation is commendable for simplifying complex concepts. Excellent work. I will surely visit this space again for more such informative articles.
ReplyDeleteData Analytics Courses In Dubai
Being a data analytics aspirant, this post has been a great help to me. I stumbled upon this article when I was looking for a pathway to become a certified data analyst looking for an accredited data analytics course. This site contains an extraordinary material collection that 360DigiTMG courses.
ReplyDeleteThis post's portion on feature selection and dimensionality reduction impressed me with its usefulness and clarity.
ReplyDeleteData Analytics Courses in Agra
The hypothesis testing is a valuable tool, but it should be used in conjunction with other metrics and insights to make well-informed decisions about your advertising strategies. Thank you for sharing your knowledge.
ReplyDeleteData Analytics Courses In Chennai
Thank you for providing in depth tutorial on how to use Excel to perform a Hypothesis Test to analyze an advertising campaign.
ReplyDeleteDigital Marketing Courses In Bhutan
thanks for providing such insightful information
ReplyDeleteDigital marketing business
Clear and informative guide! Your step-by-step explanation on using Excel for hypothesis testing in advertising analysis is invaluable. Thanks for sharing!
ReplyDeleteDigital marketing tips for small businesses
In a data-driven world, your blog post stands out as a valuable resource for those looking to evaluate the impact of their advertising strategies objectively. Thank you for sharing your expertise, and I look forward to implementing these insights in my own analytical endeavors. Digital marketing for business
ReplyDeleteAn excellent blog post, a must-read for all data analysts and sales teams. While numbers may not always tell the whole story or the exact truth, they are more often than not a very strong indicator to the final answer. Thanks for sharing.
ReplyDeleteInvestment banking analyst jobs
This comment has been removed by the author.
ReplyDeleteNicely explained. Thanks for sharing.
ReplyDeleteInvestment banking courses after 12th
Thanks for sharing this. I was looking for the Excel tutorial. It is great help for me.
ReplyDeleteInvestment banking courses in the world
Thanks! Very interesting to read. This is really very helpful. Best Data Science Course In Kerala By Digiperform
ReplyDeleteNice Post. Data Science Training in Pune
ReplyDeleteAn excellent blog post, a must-read for all data analysts and sales teams. While numbers may not always tell the whole story or the exact truth, they are more often than not a very strong indicator to the final answer. Thanks for sharing.
ReplyDeleteFinal Year Project Centers in Chennai
IEEE projects for cse
IT Staffing Companies in Bangalore
What a refreshing perspective! Your thoughtful analysis and clear writing style make complex subjects easy to grasp. Thank you for your dedication to quality content!
ReplyDeleteData science courses in Gujarat
I found this article incredibly enlightening. It presents the material in a logical and easy-to-follow way, which really helps in understanding the topic. I’m sure it will benefit a lot of people. Thanks for taking the time to create this.
ReplyDeleteData Analytics Courses in Delhi
In the blog post "Hypothesis Test in Excel – A Statistical Test in Just 5 Steps," Excel Master Series provides a clear and straightforward guide to performing hypothesis testing using Excel. The author simplifies the statistical concepts and breaks down the process into five easy-to-follow steps, making it accessible even for those new to statistics. The use of Excel for such tasks is particularly helpful for people without specialized statistical software. It's an excellent resource for anyone looking to conduct quick and effective hypothesis tests using Excel!
ReplyDeletedata analytics courses in dubai
Thanks for this insightful post! I loved how straightforward and to the point it was. You highlighted key information on hypothesis test in excel was intreasting. Looking forward for more content.
ReplyDeleteOnline Data Science Course
Great blog with valuable information.
ReplyDeleteData science Courses in Manchester
The post on Excel Master Series Blog about conducting hypothesis tests in Excel is incredibly useful! It breaks down the statistical concepts and provides clear steps for performing tests using Excel, making it accessible for users of all skill levels. The examples and explanations help demystify the process. Thanks for sharing such valuable insights for those looking to enhance their data analysis skills!
ReplyDeleteData science courses in Bangalore.
Using the hypothesis test in Excel to determine if your advertising efforts really worked is a powerful approach to assessing the effectiveness of your marketing campaigns. A hypothesis test helps you make data-driven decisions by comparing actual results to expected outcomes, allowing you to test if observed changes are statistically significant.
ReplyDeleteData science Courses in Germany