Making excel line graph from spss dataset?
I'm trying to make an excel graph from this dataset and really have no clue what to do. Excel graphs always give me a hard time and this is a complicated dataset. I want to make 4 separate line graphs, one for each attachment style, with week plotted on separate lines, day of week along the horizontal axis, and feeling loved on the vertical axis. Help!
What spreadsheet can handle more data than Excel?
How big is your spreadsheet and what are you doing with it? Do you (as a general practice) keep calculate off and never calculate more than one sheet at a time? Do you avoid inefficient functions like vlookup/match pairs? Are you iterating with circular references? How much VBA do you use? How many links to other files do you have? All these can have a big impact on how Excel handles lots of data, but if Excel is actually crashing either your sheet is gigantic or it uses a lot of functionality that work fine and 10mb files that crash excel when I try to update a link.Other options, depending on what you're trying to do, include:putting the data into a real databaseusing external software like Spotfire to visualize the datapushing complicated calculations to something like MATLAB and just keeping Excel for the front end
What is the difference between line graph and stacked line graph?
A line graph only has one line of data. To be more explicit, the independent variable, usually time, is marked on the x-axis, and the dependent variable, whatever it is you’re studying over time to monitor changes, is marked on the y-axis. Once all points are plotted, a single line is drawn through the points from left to right to show change over time.A stacked line graph will follow the same structure — x-axis, independent, y-axis, dependent, plot and connect — but will consist of more than one line plotted on the same graph. Each line represents a different “thing” that was studied. A good time to do this is when you want to visualize a stark comparison in data sets; say you are comparing cell phone performance over time. You might plot one line with iPhone performance each month, one line with Samsung performance each month, and a third line with LG performance each month (I heard Motorola is trying to get back in the game as well ;) ) All 3 lines would be on the SAME graph, making it easy for a viewer to draw quick conclusions about the data.
In Excel, how do I get the probability density function graph of a data set which might not have a normal distribution?
After creating histograms, it is common to try to fit various distributions to the data. The most common is the Normal distribution, which is completely defined by the mean and standard deviation. (See summary statistics for calculating the mean and standard deviation in Excel).AdvertisementThere is more to distribution fitting than just overlaying a distribution on top of the histogram. However, this page came about because I have often been asked specifically how to construct a Normal distribution curve in Excel.There are many ways to create the graph, using line charts, bar charts, area charts, and scatter plots. Some of the tricks for creating the charts (such as using thick error bars to create the area shading effect on scatter plots) are found in my article "Creating a Histogram in Excel". Also, you will need to scale the histogram before overlaying the distribution.Normal Distribution Chart TemplateScreenshot from the excel file. In the spreadsheet, the slider bar belowthe chart will move the shaded region (the cumulative probability).Instead of following a detailed tutorial, please just go ahead and download the example Excel file. The file does not contain any macros. If you have questions about what a Normal distribution is, please see the reference below.Download Now (.xls)In addition to graphing the Normal distribution curve, the normal distribution spreadsheet includes examples of the following:Generating a random number from a Normal distribution.Calculating cumulative probabilities.Shading a portion of the distribution (see below).The graph shown in the screen-shot above is particularly useful for showing the relationship between the probability density function and the cumulative probability. Both the label and the shaded region change after you move the slider.
What is the difference between a scatter plot and a line graph? Provide an example of each. Does one seem better than the other? In what ways is it better?
Scatter chart (Scatterplot) uses horizontal and vertical axis to plot data points. Basically, it shows how one variable affects another so you can see a relationship or a trend.Line chart, however, is a connection between various data points with a line. It also shows relationship among variables over time.Learn more about the Scater chartLearn more about the Line chart
When should I use excel instead of python for data analysis (and vice versa)?
Excel very well maybe the most powerful useful application of all time.I am consistently in awe of what so many non developers can do with excel. In the book "Data Smart"http://www.amazon.com/gp/aw/d/11...I recently learned how simple it was to implement real clustering algorithms in excel. I think that is amazing!Now just because you can do something doesn't mean you should.I think it is perfectly fine to learn how to explore and analyze data in excel. I even think it is "ok" to learn new techniques if excel is what you are most comfortable using. I have even been known to use excel from time to time to generate ten's of thousands of lines of SQL for quick and dirty things.At some point there are things that excel is just not the right tool for the job.It is not useful for any productionalized utility work . Serious data analysis needs to do utility work. Move files, get data, execute data transformations , derive new data and more. In addition to doing this kind of thing it is important to do it at scale. Excel finally exceeds 64k rows but it is not fun to watch grind.Learning something like python is a good next step to accomplishing those things. Even then one should not stop learning if one wants to be serious at data analysis. Python is great for a wide variety of data analysis. Matlib, project R, scipy and many more all in one tool kit just to name a few. That is powerful. Python is still not always the right tool for doing things at scale. It is a great swiss army knife and right now my favorite.To answer the question use excel for what it excels at. Taking data that is already in a csv like format and using a mouse as a primary tool to explore and understand the data. Extending this exploration with simple transformations of small data is also reasonable.Use other tools like python when you start getting to a point where size of data is impacting time to market of answers in a repeatable fashion, your questions are getting complex or there are a lot of utility activities being done.Investing in understanding more than one tool is always a good idea when wanting to be truly good at something. Of course everyone wants a one size fits all tool and marketing people will always tell you that you can have it so you will buy their product regardless of reality. It does not exist if you want to excel at more than 80% of any one domain.or...Only use excel when your problem space is in the bottom 80%.
Why can't SPSS be used with large data?
I'm going to guess that your problem is memory limitations.SPSS can handle as large a dataset as can fit on your disk (with an equal amount of free space to use as swap space). But it will try to fit the data into memory if it can - once it runs out of memory it starts writing to disk, and it's dramatically slower. So go to task manager and check how much free memory you have (if you're using Windows). If you have programs running that are using memory, close them.If your dataset has a lot of variables you're not using, drop some of them.Buy more memory (it's a lot cheaper than it used to be), and, if you can, get a faster hard disk (if you're running from an external hard disk, this can be slow). SPSS handles a million cases on my 32 bit computer, with 2 GB of RAM, without much difficulty.
How can I convert a data table into a mathematical function?
I am using the equation cited in my Geotechnical Engineering book that dates back to 1962 from Ahlvin and Ulery. Δσ = q (A' + B') where A' and B' are both calculated from tabulated tables as functions of z/R and r/R (where R is the radius of the circular loading, r is the horizontal distance from the center of the circular loading, and z is the depth below the soil) The Boussinesq’s equation only allows us to calculate the vertical stress at a point of some depth z under the CENTER of the circular loading, which is not very helpful for my problem (retaining wall design, for a class project) I am about to try SPSS, since my GF has it on her pc... Thanks alot for the help