Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In this final video, I want to show you how to take the charts that you create in SPSS and export them as HTML and as image files as either JPEG or PNG or some other format that you can then use to integrate into your word processor documents, into your presentations, or into your web pages, as a way of sharing the results of your analysis. For this example, I use the same data set, Searches.sav, and what I am going to do is I will just make two or three sample charts very quickly and then show how to export them. In this particular case, I'll make a bar chart.
I go into Graphs, and then the Chart Builder, then I am going to make a bar chart of regional variation and interest in SPSS, because that showed up in our regression results. So I am going to come down and get the Census Bureau Region, put that in the x-axis, and get SPSS and make that the variable as being charted here. I put arrow bars on it and click OK. And what I see is that the west has much, much lower interest in SPSS as a relative search term than the other three regions, which would explain the curious results of our output in the linear regression.
I am going to change these just for a moment, just a small amount. Really I think all I am going to do is change the colors. You can change them however you want. You can make individual bars of different colors. I will just press Close and close that. So there's one chart. Next thing, I am going to make a scatter plot. Go to Graphs, back to the Chart Builder. This time I will choose Scatter, and I will bring that up, and I am going to look at the association between Business Intelligence and interest in SPSS.
Now I'll hit OK and I have got a scatter plot there. I am going to clean it up slightly. I don't need all those decimal places. So I am going to number format and change those to zeros. I will do the same thing over here, and then what I am going to do is I am going to change those to solid red circles. Then I am going to add two lines because I can. There is a regression line, but what I am going to do with that regression line is actually going to change it what calls a Smoother that follows the pattern a little more closely.
Then I am going to change the color of that to Grey. And then I will also add a linear regression line. It's added a Quadratic. That's okay. I just change it to Linear. I can delete that, and I am going to change the color of the linear regression line. I will make it grey also, perhaps a darker grey, and there's my scatter plot. And now what I can do is I can take my charts and I can export them. Now it's easiest to just simply export everything in the output.
However, you may not want to have all of the texts and all the other information. So for instance, this right here is the Log. You see I click on that Log it's highlighted. I can delete that if I want. This is the title of the chart. We have something called notice that doesn't show up. It's there but it's hidden. I find it convenient sometimes to just come over here, and get everything I don't want and delete it. You can do that or you can leave it in. I will delete them for one and leave them in for the other. But what I am going to do now is I am going to save my output and then come to File, to Export.
And what you have is a lot of options here. You can export them as a Microsoft Word document. You can download them, as an Excel file, as a PDF straight into PowerPoint. Now I personally find the easiest way of dealing with these is to export them as an HTML file because what that does is it exports the entire output as a single HTML file, but it also downloads all the graphics as individual files. You can do JPEGS if you want. On the other hand, if you're going to be putting this up on the web, PNG files can be more helpful.
The entire output is a single HTML file and each chart is a separate PNG file. All I need to do now is tell it where I want to save things. I click on Browse and I created a folder already called SPS Output in HTML and PNG. So I am going to double-click on that and then I'll just call it Exported Output, press Save, and I will press OK. We have Exporting progress. There are times when that can take quite a while. This is a very short output. Now I'll show you if I go to the folder that I have created, SPSS output in HTML and PNG, I can double-click on that.
Then you see we have an HTML file here. I double-click on that. This has the entire results. See these, for instance, are the notes that say they don't show but they are there, and it has its graphics also. On the other hand, I also have each chart as a separate PNG file right here and I can open it with the Windows Photo Viewer and there it is. In that way, I can take these graphics and put them into whatever program I want, how I feel like and best present them.
That ends the final presentation on how to take the results of your analysis and get a way to present them to others that will make it easier for you to tell your analytic narrative, to make sense out of your results, to find surprises hopefully and insights that will give you an advantage in conducting your own work, and make it easier to sell your points to others.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.