 Hello everybody and welcome to tonight's Facebook live. We are right here tonight focusing on exports and I wanted to take you on a little bit of a different journey this evening Particularly the reason that I wanted to do that is we have got more information now on the and on the Project research projects that you're going to have to be focusing on and particularly for those of you in leaving cert and of course the thing is that I want to help you to Achieve the best that you possibly can get with that. So tonight what I'm going to do is I'm going to take it through not just A spotlight on exports like I've said, but I'm actually going to take you through the research process in order For you to be able to find out the information And as before I've been telling you where to find it now I'm going to take you through from the very beginning how to find it But also how to analyze it now The reason that I've opened up this page here is that if you click on the blog And I'm just going to close this down here if I click on the blog. I just wanted to take you through obviously And for those of you who are familiar with this, uh, you will know exactly what's here But just before we get into the export side of things Over here and you can see that we've got a range of individual news stories that are happening And that is just if any of you want to you know Just get a quick check in on what's important in the in the economy broadly So we've got the corona virus, uh, which is affecting a variety of things. Of course most importantly people's health But also it's having a knock on effect on the environment or not Sorry, not just the environment for the economy. Uh, and then we have got a range of other things like, um What's going on in the us? Uh, we have from, um, the wall street journal We also have different sectoral in headlines and so on But in addition, I wanted to bring you down here to say if you scroll down a little bit You will also have The uh, the facebook live recordings and their associated resources. So for example, I delivered one on housing Last month and I delivered one on, uh, brexit the month before I also wrote some pieces as well just about, um, a couple of couple of different points Around foreign exchange and a couple of other things that are in the syllabus But particularly I wanted to let you know the previous Sessions, they're all here. Okay. So all you need to do is just click here for example I'm going to compare to this one for example on housing And then within here, uh, you will see all of the information Um all of the resources and the links and everything else as well as recording of the video itself Okay So just wanted to let you know all of that's there All of that is there as resource for you and you can check in on that at any stage the other thing I wanted to let you know Is that on the scroll over here on the facebook page itself Uh, when I click here on the facebook page itself, uh, if you like the page Okay, so if you click here on like you will then automatically see any posts that are up there And of course particularly the events of the next month's Facebook live is going to be about the gender pay gap. It's one of the issues that comes up Again again, um, it comes up again and again I have to say in the syllabus in various different ways Whether it's the stg's which are the sustainable development goals or whether it comes in under chapter three Which is all about uh equality and social issues and the stakeholders within the economy and so on so Um, so you can see here that one is going to take place on the 25th of March But uh, if you simply like the page, excuse me If you simply like the page then you will get the updates, uh as well Okay, so just wanted to let you know all of the previous ones are all in positive economics.ie Okay positive economics.ie And of all the future ones are going to be on the positive economist facebook page So if you click like then you will uh, you'll be able to be notified for those Okay, so moving on tonight, I wanted to take it through exports and uh, there is so much we could talk about within exports But within the syllabus we have two key things to look at. Okay. What we want to look at are The changes in exports and who our trading partners are and what we're exporting as a nation But then the other thing that we wanted to talk about as well is Balance payments. So how does the way in which Ireland interacts with the world on a financial basis? Is money coming into the country? Is money leaving the country when you take into consideration? exports and otherwise, okay, so so as I mentioned When you are looking at the project the project is going to be worth 20 of your overall leaving start mark. Okay So when we take into consideration, what is being looked for there? And we have got some us three authors Brian O'Connor, Trudy Murray and myself We have now got some notification around what's going to be involved So I want to help you now every single time that you tune into a video like this I want to take you through some element of the process To help you prepare for that project. So then when it comes to you working on this And and you'll only be starting on this by the way in September But the reason I'm doing starting this now is that when you look back on the recordings of these videos You'd be able to go through the the research process because that is going to be a key part of your overall result In the project, which of course feeds into the overall result for the leaving search So, uh, right when we think of exports, um When you're researching anything right and this this is the same for you doing a leaving search research project Or me preparing for a brief for a client. Okay very same Is the first thing we need to ask is what do we want to know? Like when we talk about exports What really do we want to know? Okay? So what I do generally is that I set up an extensive spreadsheet with those Questions that I want to write. So when it comes to exports here are the three things that I would like to know So I would like to know when it comes to exports And I'm going to add in imports. I'll spend more time on exports by the way Uh, because the reason I spend less time on imports is to analyze them is the very same process Three key questions. I would like to know first of all have they increased year Slash oh slash why okay now in every case of when you're working with me Which you all are right now digitally whether you're live right now or whether you are Tuning in and looking at this after that I've recorded. Okay. So every time that you work with me I want to make sure that you understand Exactly all the acronyms and acronyms are things like these right where you don't write out the word So what I'm going to do is over here. I'm just going to write down y or y y or y Means year over year In other words, if I'm compared if I'm comparing one year in comparison to another So what I'd like to know is about exports have they increased year over year and I would like to ask that of exports imports and The whether it's the star plus star plus or Uh deficit now if you don't know what that word means yet, don't worry. I'll explain it to you in a little while okay, so Here's what I want to know have the exports and imports have the increased year over year Uh, so have the increased year over year and I want to ask that question of exports Imports the surface of deficit now the next question I would like to ask is where right so where Are we exporting? to and importing from And specifically I want to know a couple of things within that I want to know. What is our largest export? Country partner country partner. I want to know my largest export country Country in terms of growth Okay, and largest export country partner. I'm going to say in terms of about in terms of amount Now the answers to these questions are important But what's also important is the actual amount of information that's available to me because maybe I won't be able to find this Very easily so and and you won't know that when you're at the start of a process like this You are not going going to know that at all So it's going to be important for you to be able to figure out The information that's available to you, but also it's important to figure out what what you can get And uh, and I'm going to show you how to do both. Okay. So all right. So let's move on then I would also like to know the largest. I'm basically going to copy and paste these right largest import country import I m p or t Okay, and same And the same here. So I also want to look at the largest import country in terms of growth also, right Now that we have done both of those Now, let's see how we get on um So this is my second key question and my third question the third thing that i'm looking for Is I would like to know, uh, what okay, so what are we exporting? What are we exporting? So when I say what I mean, what are the largest sectors? Another word for sector is an industry So what are we exporting and what again? I want to know the largest change So I want to know the largest category that we're exporting and the largest change category So I'm going to document that. Okay, so largest largest category category uh in terms of amount And I also want to know the largest category In terms of change Change as well. I'd also like to know that too. Okay, so um, right now that we have done that I'm pretty pretty, you know, I'm pretty happy now that I that I know what I want to look for And this makes the research process so much easier now when you're when you're like real-time economists Like when you're actually an economist where you're working with a client So I'm just going to give you an example of some of the things that I'm working on right now. Okay So right now I am working on Um, a brief around the economics Of wellness in the workplace, for example, and that is that is what we would call microeconomics. The reason I'm saying that is companies are interested in In what they can do for staff that will make a difference to their productivity And to their overall happiness. So that's not well, how do we make Ireland more export ready? Or how do we grow the number of businesses in Ireland instead? That is something on a micro basis So that's one thing that I'm working on another thing that I'm working on is the way in which women invest in comparison to me And that is a forming part of international women's day. So I'm working on that for a client as well And then what I just finished up on Uh was another project that I was working on for a client whereby I was in New Zealand three weeks ago and I my job there was to work with a range of different organizations who work with different bodies in Ireland and The objective of that was to figure out how we can build the trade and other relationships between Ireland and New Zealand And then all of those require research and all of those require exactly what i'm doing with you right here That's that's precisely what what I have to do is that I have to start off by asking What exactly do I want to know in some cases the client doesn't know The client doesn't actually know what questions to ask what they want as a report or they want an output So in your case the client if you want to call it that is the leaving cert And uh in your case when it comes to your research projects What you will be given is you will be given a list of topics by and By the government and you will have to choose what I have to build Your research report around it So you will do you will follow this exact process now before anything happens to this information Let me quickly save it right so what's really important when you're putting something together is to say things as you go along So i'm just going to go up here to i'm just going to save this here and Let me put this in here. So i'm just going to put this for export data uh research project All right Now of course the next thing is why where am I going to get this information? So over here on the right hand side I'm going to put anything That is an acronym or any term that i've come across and that needs an explanation If you hear me saying anything that you don't understand Please do comment. Please do comment. Let me know and I will make sure to to document things then As we go along for you. That's that's of course what what it's all about. Okay all right now And first of all, where are we going to get our information about have the increase here over here? Now what I haven't specified here is which year? So I don't know how much as I mentioned. I don't know what data is actually going to be available to me So in order to be able to answer this question Let me now go and find some data and put some numbers in here. Right. So for a start I'm going to go on to the cso website. It is the central statistics office And therefore it is also my central port of call often if i'm researching anything to do with the irish macro economy I will start here And if I scroll down Let me take a look here to see what what's jumping up at me I see the goods exports and imports and these are for december 2019 Now the thing is we all know that exports when you take into consideration all of exports It's not just goods, but services as well. So let's start off with goods exports, right? So i'm going to click here And in here, there's the answer to my first question Is january to december in 2018? I can see the change in my exports I can see the change in my imports and I can see they're in a surplus and I can see the change in my surplus so let me now take this information and and Let me answer it according to the questions that I set out to ask myself So first of all have exports increased Uh, sorry. Have they changed year over year? Yes, they have these numbers are not identical And uh, specifically the my exports are up eight and a half percent. So i'm going to go back and put that number in So have they increased year over year? Yes, this has by eight and a half percent Now excel is an absolutely brilliant product But you have to know how to use it and how to use it quickly So i'm going to put in here that this is a percentage and look what happens Look what happens is automatically this changes into eight hundred and fifty percent, which isn't correct, of course So if I now put in eight point five after a format edit now look what happens It now jumps to where it's rounded up Again, that's not good enough. So I want to click this and there we go So part of what you're going to have to learn how to do is format information within excel so that you can use The information quickly but also accurately because it's not accurate to say that exports increased in ireland I'm going to say 2019 in 2019 Remember, this is year over year. So I know it's now implicit that if I'm looking at the 2019 figures That this is year over year that this is up in the whole in the whole year. I know that this is comparing to 2018 Okay, so next one Um, have they increased year over year? in terms of my In terms of my my imports. Well, actually my imports Actually fell by three percent. So ireland imported less in 2019 than imported in 2018 So let me go over there and I'm going to go so I'm going to put in here Now I'm not going to make the same mistake here. I'm going to format it And I'm going to add on my decimal point. Okay. Now what I'm going to say is minus three And there you go minus three point zero percent is in here. And then the last thing am I in a surplus or deficit now? I'm going to delete Surplus or I'm going to delete deficit. I just want to have that. It's a surplus and I'm going to also delete My question mark because of course I've now answered my question. So my surplus actually changed To it's up 30 percent, which is huge. Again, I'm going to do the same thing And the same thing here up 30 percent now to be up 30 percent is a huge amount So of course the natural now the inquisitive economist then says why Like why why why is it that our exports are rising? And why is it that our imports are falling? And and what's driving this? Okay. Now depending on the level of detail that you might want in your project What I might put in here now are I'm just going to put in the amounts for 2019 Go to put them in so that I have a record of them The one thing you don't want to keep doing is keep going forwards and backwards and forwards and backwards getting information So I'm just going to copy and paste these quickly. So my exports for 2019 are right here Okay, and my imports for 2019 are here And so you can see here I'm doing this really quickly because I have it all set up And finally my surplus is 63 billion Euro, okay, so what I'm going to do here now is I'm going to format paint Right here. So I have the same font and it's important that I have my my unit so I'm gonna Euro And for million I'm just gonna put a million actually so don't be remembering anything And the last thing I'm going to do is format this in excel to change this to euro Okay, now we're good to go right. I don't need these extra decimal points. I'm going to take those out Okay, now here we go good to go. I have my information So now let's move on right. Let's move on out to our second question That is where are we exporting to and importing from? um So I think this is personally I find this really interesting and I tell you why Is the answers to these questions inform so many things right so so so many things They the reason that there was such a big deal about brexit in Ireland for the past four years is the fact that we export so much to the UK and It's not just That we export to the UK. It's what we export to the UK So I want to show you briefly. All right. Do you know what's really fantastic on the cso website? I'm just going to bring it up here at the visualization tools, right? But what I wanted to show you there's there's a couple that I wanted to show in particular one uh just going to um now How do we move that on? Let me go back again Because uh what you can find here Yeah Yeah, this sort of look far right. Let me go down. Yes, this one was it Yeah, this one. So here in the case of brexit you can see Ireland and the UK in the numbers, but particularly if we look at the one that we're talking about tonight You could trade in goods and what you can see here is that when it came to our goods 1.9 billion So 23 like almost quarter of our goods When it came to imports uh in 2019 came in from the UK, right? And I can download that by the way if if I was downloading this To put into my research report you can see here that I don't want to be copying and pasting anything I can download them here very easily So you can see how our trading good has risen over time But also when you look at our exports now, it's interesting the fact that we actually we know export 10 percent 10 percent of our goods go to the UK In comparison to the rest of the world So over here you see this is why This is this is what really caused a lot of a lot of trouble I will continue to by the way is that what about these companies who we're selling here now what you don't know What you don't know what you can tell from here But I can tell you from all the work I've done around brexit Is who are those companies that are exporting that 10 percent? A lot of them are small businesses And it's not easy for a small business to start exporting into another country You can't just you know create a sales team in France or America or Argentina or Australia In fact, I just picked three countries there that began with a that was totally accidental But the point here is that it's not easy to do this So that actually can have quite a difficult that that that can be quite a difficult thing to do So, you know, that's why answering the question about where do we trade into is what's really important And similarly when we get on to services I'll do the same there But there's a huge huge amount of interaction between Ireland and the UK And if there was any any trade barriers or anything that you study within that chapter on protectionism Anything like that or even not even protectionism But simply a change in the exchange rate like I wrote about in an article for you earlier on in the year All sorts of things like that. They all matter. They all really really really matter So that's why all of these things are of such interest So, let's let's go back to our let's go back to our question here. So our question is Who where are we exporting to? So let's think geography, right? Who's the largest export country partner? And who is the which country have we grown the most in in the past year, right? Let's go and find out. So first of all, I'm going to scroll down And I'm going to keep on scrolling and I'm going to keep on scrolling and I'm going to keep on scrolling And all of these are All of these relate to what but here's who, right? So this is interesting now is that specifically when it comes to the UK Well, no, Great Britain and let me specify what that is. So England is England, right? It's it's the country England Britain is our is England and Wales Great Britain is Scotland England and Wales. So this is the island of Great Britain This does not include Northern Ireland. So exports to Great Britain in 2019 were 13 billion, which is a decrease So it's that they're down minus 4% And compared to 2018. So that's telling us that exports into the UK have fallen now What I don't know what I don't know is whether we exported less Or because of the exchange rate, we actually got less money as a result Now if you if you kind of quite remember what I'm talking about there, it don't understand me. That's okay That's okay. I have a blog post to explain all that And where that is is I'm just going to go back here and just mention it So when I scroll down here, just going to close that again if I scroll down here I am going to refer to it right here How much does it cost to change money from euro to another currency? So here is where you can you can read all about it here For example, and that's where you can talk. That's where we talk about how much it costs to change to change currency and so on like that Okay, so That is all that's yeah, that's that's all back there in the positive economics blog Right now it also says imports from Great Britain were were what they were now We actually increased our imports again I don't know whether that's because we bought more Or due to a change in currency And it could also be of course since the sterling declined Since the referendum our euros now go further. So because we've bought more or sorry because the sterling Is actually worth a lower amount than it was before That might mean that we've bought more More actual goods or it could mean it could mean more in terms of value So that that I don't know but the point is is that I don't have to know as an economist It's not my job to know absolutely every piece of information because I will never ever finish if you try to find out everything everything about your project In advance of you submitting your research report. It'll just take too long, right? It just really internally will take too long So what we need to know is what we need to know and if there are things that we don't know Well, then we have to acknowledge that as well. Um, but we have to know that we we can't do everything So when when we go down here This is the information that I've got is that the EU accounted for 72 billion of total exports in 2019 And this is an increase of 1.9 billion now 40 percent if I don't think we're going to have a bigger I don't I don't think we're going to have a bigger um A bigger percentage than this but you may say to me What's chosen hold on now hang on a second here the EU isn't a country, correct? However, based on what I have This is the data that I have to work with Now I can go looking for more data, but based on this I the question that I set out to achieve was who is our largest exporting country partner So is that what I'm going to go with and and mentioning the 48 percent or will I go further? So then it says exports to non-EU countries And then it goes on to imports and imports 5.5 billion To the EU in december Now 5.5 billion In december let's compare 5.5 now that was sorry that was december The thing is based on the information I have right here There's my answer. Aha. There's my answer. The reason that I can't go down any further is look at this information Look at this information here. This information looks at the year This information down here looks at the month now. I specifically want the year So here is my answer. The usa was our largest export destination in 2019 Accounting for 46 billion or 31 percent of our total exports. So the answer is the us And I'm going to put in both the percentage on the percentage is easier to remember. So in 2019 The answer is the us So I'm going to say united states united states states Okay, uh, over here. I'm going to say the amount was 46 Again, I'm just going to I'm going to copy out of this There we go. Okay, so I'm going to take this x and v Uh, over here. So this is the amount in million and um Uh, this is now The proportion of our exports that went to the us Uh was 31 percent 31 percent Now I have in format of that. Let me do that Okay, it's 31 percent And over here. I must format that which is practically done for me, but all the same And I'm going to format paint that And the country is the us Now, um, you may have heard That the uk or britain is our largest trading Partner and you may say well, hold on now What do you mean our largest trading trading partner when it comes to this? Well, let's go and see Because how much did we sell into britain? Great exports driven worth 13 Billion You see this is I have to say I'm I'm always intrigued by this. It's completely snomer Yes, the uk is our largest trading partner But largest trading partner refers to both exports and imports However, our largest export partner is actually us and look at the look at the difference Is that we exported 46 billion last year to the us in comparison? To great britain when we exported 13 now, um, therefore About three and a half times for every one euro that went to the went to great britain 350 went to the us So that is another interesting fact that I might put in yeah if I wanted to Um Now let's also see where the growth happened So this is the eu accounted for 48 percent and this represented the three percent growth exports to non-eu countries Grew by 14 percent Okay, that's not quite telling me what I want though is it? It's not quite telling me Um, it's not quite telling me. So actually this data set isn't complete Uh for what I want. So we're going to have to leave this blank for a little while Okay, we we come back and we'll take a look at it But over here it's going to be very easy to do this because I have all the information for imports So when I look here at imports it tells me So first of all imports, uh, there were 52 billion from the eu in 2019 representing 59 percent of the massive So and of course remember the eu uh at the time in 2019, uh, the uk was part of that So imports from non-eu countries. I can see here a total of 36 billion a decrease of minus four percent And I see here the decrease was minus three percent And let me go Up further And we see how about imports Imports from great britain Were 18 billion an increase of two percent in comparison. So actually it's quite likely Based on what I'm looking at here. It's quite likely that here was my fastest growing region But you know what? I'm not happy I'm not happy with that data set because I haven't enough information and again I'm doing this intentionally I'm doing all of this intentionally to point out that you may not always get the what you're looking for immediately So what what I know now is that we I can't quite fill in the rest of this information for a little while Okay, I need to go further and I will I will I'm going to show you where to find more information But let's move on to the third question and the third question. What are we exporting? Excuse me and just at this point, I just want to say if anybody has any questions, um, please do send them in I will I will get to them Later on when I when I take a look at the the comments that that come in but if you have any questions at all Please do put them in Um, I'm more than happy to answer them, of course What please do put put them in and and of course the other thing is if any of you want to send me in your email If you want me to email you the the recording with the resources in the link on the blog afterwards Please do please do that as well, of course Because that is a very simple way that I can I can get the information across to you. All right So what are we exporting? So what's our large largest category in terms of amount and what's our largest category in terms of In terms of change. So in other words, what are we exporting? So I'm going to go back here now to my data set going to go right back up here to the top And I can see here goods imports goods exports all that's very interesting however Um, let's take a look here at this section. So the unadjusted value Of goods exports for december 2019 was 11.6 billion representing a decrease of 223 now Oh, wow, okay I think we have our answer here exports of electrical machinery apparatus and appliances increased By 54 percent In december again, we're back to all of these are december and december This isn't the type of information i'm looking for. I want i'm going to have to go further than that In fact, it's actually up here preliminary figures for 2019 show the goods exports were valued at 152 billion And I can also see that this is here. Uh, this is an increase of eight percent of We can see that as well So the largest category of exports was medical and pharmaceutical products now here we go. This is what i'm looking for copy over here and paste Okay, so this time i'm going to say a sector our industry Now that there's slightly different things but for the in terms of the leaving start they mean broadly the same thing, right? Again, i'm going to copy and paste this down here. I shouldn't have taken country Because that isn't the same thing. Okay, so i'm just gonna We want to form a page this Right, so the 33 percent so for every euro right for every euro that is going out in exports out of the country 33 cent of that is pharmaceutical And when we look at where I think nine of the 10 largest pharmaceutical companies in the world are based in arlett and primarily the based in cork So that's where an awful lot of this comes from Exports of these goods account for a third of all exports and that was almost 50 million Isn't that incredible? Isn't that an incredible amount of money? So I can see here. Um, there we go. I have my amount Of my amount here That's all okay now Can I find the largest category here in terms of change because I know they've gone up by seven percent But I don't really Don't really know any more than that. Um, so it says the largest category this represents up seven percent in value Yeah, I just I just I just haven't got enough information there Oh, hold on now Down here is where I can figure out the next section and that is what is the largest growth And here we go. I can find it here in figure two selected export growth rates So when I look at all of these I can see clearly here The greatest growth has been in machinery and transport equipment. So that's the answer to my second question machinery and transport transport equipment equipment okay and the Uh, I the the growth of this area Last year 18.42 percent 18.42 percent So you see why I would have been wrong if I had written down the number that uh, that we found for pharma So if we look at medical and pharmaceutical products, they were up seven percent So that wouldn't have been the largest category in terms of change It really wouldn't have been at all. Can I find the amount though machinery and transport equipment? Let me I'm just simply going to go. I'm going to start with this machinery and transport Equipment, okay Here we go imports. There we go. Um biggest product Categories imported and no that's not 20 Uh That's now what we want No, can't I don't think I can find the information here. So let me go further. I I'm gonna I'm gonna have to go I'm gonna have to go further than that Right, so when you when you take all of this into consideration, then I'm missing The largest export country in terms of growth And I'm missing the amount that we actually exported of the machinery and transport equipment Now what I had jumped over here was the largest import partner and largest import country So the reason I did that is I wanted to show you this infographic and interactive infographic that If we scroll on down here. Look look at this. I love love this, right? Look at what I can do here is that I can see where we're importing in terms of millions And particularly where we're importing a lot a lot of our goods. So if I was to scroll in If I was to scroll in here and I was to look around here where it's really really blue Where it's really really blue is where we're exporting a lot. So right 718 million there However, when we go to france, uh, france were importing one and a half billion Germany 716 million But when we go to the uk are specifically great britain and again, that is england france outside england wales and scotland you can see that we're importing 1.812 billion, right? So i'm guessing i'm guessing that great britain is our largest import partner Now i'm not going to go back up here and start around for this information again Because what I want to do now is now that we've gone through the basics I want to show you where to find the detail. So down here I can look at a table of goods imports and export summary analysis Classified commodity and classified by country. So what I'm going to do is I'm going to click on The country and as you can see here now, I've got them all right. I have got them all So here is where it would have been easier to find my information But this looks a lot more overwhelming. So all I'm going to do here is I'm going to scroll down here Look at the imports and I'm going to look at who did we import the most from in In january to december 2019 now, I'm guessing I'm only guessing up here because of the colors I'm guessing it's the uk But you see how easy it is to guess here because I can use this interactive I can use this interactive too. So as I scroll down here, let's take it up with the uk united kingdom Is 20.3 billion Now that's the united kingdom as opposed to great britain Remember the united kingdom includes northern ireland. So let me just see here, right? So we've got 18 billion, but I'd rather put down the united kingdom because that would be more accurate So I'm just going to put this of course it is country. So I'm going to I'm going to I think this may be it In terms of amount I'm going to put it in here Okay, I'm going to put in there So let me go back and see 20.3. Is there anywhere that's higher than that, right? So the euro zone is higher, but that's a currency block The eu is higher, of course, which includes the uk. Let me go up there. Is there anywhere else that's close to 20.3 billion? There's 18.6, but that's great britain. There's 11 billion. That's france 7 billion. That's germany 1.6 billion. That is belgium Let me go outside of the eu 5 billion into china 1.1 billion into japan 2 billion into switzerland 13 billion into the u.s. But nowhere comes close to this now Do you understand why people say the uk is our largest trading partner is when you add up exports and imports when you put the two together That is how you get that's that's how you get that figure. So 20.308. Okay, there we go That is of course in euro There we go and our country is The united kingdom United kingdom Okay, and do i know what percentage that is i don't think i can get it from here I know i don't think it is so what i'm going to do is i'm going to make it up Right, so i'm just going to go back up to our total exports total exports completely Our total exports way up here is 152 billion so now this is the first time i'm going to introduce a formula So what i'm going to do is i'm going to say equals right so watch watch my screen up here brackets i'm going to divide this By our total exports And i can see now that our total sorry our total imports apologies is 13 percent So 13 percent of all ah sure i got the wrong figure didn't i i got the wrong figure Let me do that again. So equal to our imports divided imports from the uk Divided by our imports in total Is over here And you can see our we have 23 percent 23 percent of our imports So you might say didn't we see that figure already? Yes, we did but where did we see it where we saw it was I'll go back down here I saw you we saw it in the infographic This was the infographic that I showed you a while ago. Here it is see there it is this is where we can actually see um our uh our imports sorry Yeah, our imports uh are 23.8 percent in comparison to the rest of the world so But of course, this is on a different data set. So you would have to link that back Uh to say that here's where you got where you got your source But in this case i'm not going to do that because uh, I worked it out myself Largest import country in terms of growth now. Will we be able to find this? Hmm Let me see. So if I go back down here and I look at our largest import Let me scroll on down here Let me scroll on down here Does it actually say anything? Remember we're not going to look at this information because it's only december Can we find and we find out about our imports? Do we actually have a change? And it says imports from none of you countries When we looked at this and we said right minus four percent and minus eight percent So I think the best thing we should do here is again go back to our raw data And what we could do here is we could look at the change So when I look at these figures broadly, let's see which ones went up. So this went down slightly up Down slightly up way down Way down down slightly up Up quite significantly actually Um, okay, there's a contender this one went up Um, this one went down So you can see that this this could be quite a laborious job So what I would do here now, I just want to see if we have a fast way of doing this And one thing that we could do Is that we could actually open this in excel, right? If we oh, no, this is for December 2019 Okay, maybe that's not the best route to go um A simple way To actually do to do this would be to compare Or to compare each one of those those imports So I don't quite see the information here, right? Let's google it then so and that would be now by the way I have done all of this already the way in which I am going through this process is the very very same way as I would if I hadn't looked through this already So I'm just trying to take it through the tips and tricks about how to actually conduct this research in a in a cohesive way So what I'm going to ask here is Which country Increased its exports to Ireland The most Last year now if I ask this question, I'm unlikely to find the answer That is because it's very very hard when you structure this way. Google does does know what what do you actually say? So instead a better way to go would be irons import data 2019 you see keywords matter it really really really matters now as I scroll down here I'm actually being looped back right back to where I started So therefore there actually isn't There actually isn't a quick way of doing this so as a result of that That's not going to work. I'm going to have to go back and I'm going to have to figure all of this information out myself Around who where do we grow our imports from most? So for the sake of brevity tonight what I'm going to do is I'm just going to put in the uk um Because let me go down here to great britain. Yeah, so I'm just going to put put this figure in for the sake of brevity I'm gonna gonna put this in and I will work all of that out and I will put the excel spreadsheet I'm going to embed it into the blog post so that you can see But the point is is that I wanted to take you if you want to find out information you may have to dig deeper You may not find the information that you want if you google it Maybe easily found but then the last thing is if that's not the case you simply have to go the hard way Okay, so for the sake of brevity. That's that's what I'm going to do. I'm going to put in here 2% is the growth So 2% is the growth And of course the same thing happens here 2% is the growth how much um Was the change in exports 383 million? Okay, so 383 million now um Yep, that's fine And largest import country terms of growth again. I'm going to say united kingdom here Okay now as we as we approach the As we come towards the the end of our webinar or the end of our facebook live You can see that we've we've answered quite a significant amount of what we wanted Which is that we can see here. We now know that exports have increased We now know that imports have decreased We know that our surplus and by the way surplus. Let me put it over here in my vocabulary I want to move this back over here. Okay uh, so surplus surplus means that our exports are greater than our imports Okay So I can see that I have my terminology over here So I can see that our largest export partner Is 31 percent to the uk Our sorry to the us and I haven't quite figured out yet Which is our largest export country in terms of growth? Where did our growth actually come from last year? I didn't quite quite figure figure that out. Um, so I'm going to have to do the same Down here is that I'm going to have to figure out. Okay. Well when I compared this data set to this data set Which one actually grew the most where was our fastest growing growing partner? And again, I'm going to be putting that in into our into the excel spreadsheet Uh so that you couldn't you can find that out But the point is again, you won't always find what you what you want And that's the whole purpose of research is is that you're able to figure that out along the way now Very very very same thing applies to services right the very very same thing applies to services Rather than take it to exactly the same thing. What I'm going to do is that I'm going to put this Uh, I'm going to put it up here I'm going to show you where to find that so if I go to cso.ie And then I go down here to statistics. It doesn't jump out at you like the like the goods exports and imports Doesn't jump out of you there. So what I'm going to do is I'm going to show you exactly where to find it and that is in under external trade And then after that It is down here in international trade and services and you would just do the very same you would just do the very very same Um, all you would basically go through the data set so I'm now interesting point here And this is a point that I wanted to make sure that that I got tonight And that is that you will not always find the most recent Sorry, you'll always find the most recent data, but it may not be as recent as you might like it to be so That's why in the case of international trade and services Uh, we are looking at let me scroll down here. See I can do the same thing. I can say it right have my Uh international trade and services. Have they increased or have they decreased? Have they how have they changed? And I can also go through where and I can go down through why and by the way I will do all of that in the blog post for you tonight So that you will have all of that information But again the purpose of tonight is to show you how to actually go about finding all of that information Again, you have the interactive graphics here. So we have all of what we need and if we don't have it Scroll down here and I can look for example into exports and imports of services classified by geographic location and then when I come down here I can look into Both the sector up here at the top and uh the country over here now that can be quite intimidating that information can look like Whoa, there's a lot there. That's that's completely fine. That's completely normal But that is what we together you Your teachers and me we that is what we will help you through right throughout as you are working on your research project And that is what I'm going to be working on During each of these uh facebook lives as well Now, I also want to mention that there are two types of research one is primary one is secondary what I've gone through